CODEWITHSUNDEEP
sql-serverwindows-server-2008-r2ssms
Eric
Eric

Reputation: 2231

SQL Server 2008 Management Studio Not Showing Database

I've got a fresh install of Windows Server 2008 R2 SP1 and just installed SQL Server 2008 R2, including SQL Server 2008 R2 Management Studio.

When I go into Management Studio, it does NOT show the SQL Server instance that was created during setup. It only has (local) and won't let me connect to it at all.

Any ideas?

Upvotes: 1

Views: 15945

Answers (3)

ssaltman
ssaltman

Reputation: 3713

Another solution that worked for me:

enter "localhost" as the server (computer-name\MSSQLSERVER failed)

Not sure why but the name "MSSQLSERVER" as shown in Configuration Manager is not the name shown when I log in via Management Studio. The name in Management Studio is SQL Server 9.0.5000 which corresponds to SQL Server 2005 SP4 (which is correct in my case).

Upvotes: 0

Eric
Eric

Reputation: 2231

Problem solved. Management studio requires <computer name>/<instance name> under the "Server" section. I was only entering in the instance name.

Upvotes: 1

BizApps
BizApps

Reputation: 6130

First check if SQL Server 2008 instance is installed show on your SQL Configuration Manager.

If it doesn't exist you need to re install you sql server 2008 r2 and follow these steps on this link below:

SQL SERVER – 2008 – Step By Step Installation Guide With Images

And it exist just add server name : yourpcname

Best Regards

Upvotes: 1

Related Questions