Cannot connect to local instance of SQL Server 2008

1
votes

I'm attempting to connect to an instance of SQL Server 2008 (Developer Edition) in SQL Server Management Studio but am receiving the following error:

Login Window

SQL Server Management Studio Error Message

In SQL Server Configuraton Manager, all services are running and logged in as LocalSystem.

SQL Server Services

I have set the SQL Native client 10.0 configutarion to enable Shared Memory, TCP/IP, and Named Pipes. I have also set SQL Serer Network Configuration to enable Shared Memory.

SQL Native Client 10.0 Configuration(32 bit)SQL Natiev Client 10.0 ConfigurationSQL Server Network Configuration

3
sqlsql-serversql-server-2008
what did you input? Try connecting to localhost with Windows authentication - Alex Szabo
Enable the Named Pipes and TCP/IP in the Protocols section, and then restart the service. I believe it will work after that. - entropic
Have you tried enabling Named Pipes in Protocols of MSSQLSERVER08? Also, is the instance running? - mrtig

3 Answers

3
votes

The default (unnamed) instance uses MSSQLSERVER as its service name - so it seems your instance is actually called MSSQLSERVER08.

Therefore, you need to use 

.\MSSQLSERVER08

or 

(local)\MSSQLSERVER08

as your server name for connecting...

Note:

all these things refer to the local machine in the context of connecting to a SQL Server installed on that machine:

  • .
  • (local)
  • localhost
  • or your actual machine name (whatever it might be)
2
votes

For SQL Express use .\MSSQLSERVER08 as your server name. Try to enable TCP/IP, Shared Memory and Named Pipes from all programs

Also check if the service is started:

enter image description here

-1
votes

Restart the SQL Server services. Then try to connect.

OR

If you have Installed SQL server with named instance, browse for for the server name.