CODEWITHSUNDEEP
sqlsql-serversql-server-2008
joshua-philpott
joshua-philpott

Reputation: 213

Cannot connect to local instance of SQL Server 2008

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 Configuration SQL Server Network Configuration

Upvotes: 1

Views: 280

Answers (3)

Ashutosh Kumar Jha
Ashutosh Kumar Jha

Reputation: 21

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.

Upvotes: -1

Rahul Tripathi
Rahul Tripathi

Reputation: 172378

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

Upvotes: 2

marc_s
marc_s

Reputation: 754230

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)

Upvotes: 3

Related Questions