1

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

Improve this question
3
  • what did you input? Try connecting to localhost with Windows authentication Commented Aug 26, 2014 at 16:18
  • Enable the Named Pipes and TCP/IP in the Protocols section, and then restart the service. I believe it will work after that. Commented Aug 26, 2014 at 16:21
  • Have you tried enabling Named Pipes in Protocols of MSSQLSERVER08? Also, is the instance running? Commented Aug 26, 2014 at 16:21

3 Answers 3

Reset to default
3

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)
Improve this answer
Sign up to request clarification or add additional context in comments.

2 Comments

For future reference, does ".\" represent local?
@user1526283: . or (local) or localhost all refer to the local machine. Or you can also specify your machine name as the server name (plus any instance, if present)
2

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

Improve this answer

3 Comments

I am using SQL Server 2008 Developer Edition
@user1526283:- Did you check that the service is started?
Yes, SQL Server and SQL Server Browser are both running.
-1

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.

Improve this answer

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.