connecting to sql server 2008 management studio

when I connect to sql server 2008 management studio, the first screen asks me
server type: database engine
server name: (local)
authentication: windows authentication


I get error

TITLE: Connect to Server
------------------------------

Cannot connect to (local).

------------------------------
ADDITIONAL INFORMATION:

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 2)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=2&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------
LVL 1
rgb192Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Andrei HetelConnect With a Mentor MrCommented:
Please check this article: http://blog.sqlauthority.com/2009/05/21/sql-server-fix-error-provider-named-pipes-provider-error-40-could-not-open-a-connection-to-sql-server-microsoft-sql-server-error/

Enabling TCP/IP would be the next logical step, it seems that is trying to connect using named pipes.

0
 
skrgaCommented:
Check if SQL Server (MSSQLSERVER) service is running (start > Run > services.msc)
0
 
Andrei HetelMrCommented:
Is SQL Server service started?
0
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

 
skrgaCommented:
@Andrei74 - We answered same thing in same time :-) (in some cultures people would get wed for this) :-)
0
 
Andrei HetelMrCommented:
@skrga Indeed :) Too funny!
0
 
rgb192Author Commented:
yes sql server is started
0
 
rgb192Author Commented:
thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.