Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 SQL08- new install missing the DB

Author  Topic 

notshai
Starting Member

8 Posts

Posted - 2011-06-07 : 11:41:27
On OS 08R2 x64, i installed SQL08 standard.

I followed the default installation menu.
I modified only the directory path from the default to E:/....
I added a domain user when asked.
I named the DB i want "DBONE"

when i launch management studio there is no DB in the drop down.
the DB name i entered in the installation DOES show up, but under "Integration services" node.
when i navigate to the "E:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA" i see tempdb and other files, but not DBONE. however i cant see a local DB to go to tempdb.

do i need to reinstall?
am i missing something?
i added sql management studio to the 2008 firewall.

notshai
Starting Member

8 Posts

Posted - 2011-06-07 : 11:56:35
seems like entering a "." instead of [localhost] worked.
the management studio opened the normal way and i can ses the DB's.

i dont get it.
Go to Top of Page
   

- Advertisement -