Link to home
Get AccessLog in
Avatar of rgb192
rgb192Flag for United States of America

asked on

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
------------------------------
Avatar of skrga
skrga
Flag of Croatia image

Check if SQL Server (MSSQLSERVER) service is running (start > Run > services.msc)
Is SQL Server service started?
@Andrei74 - We answered same thing in same time :-) (in some cultures people would get wed for this) :-)
@skrga Indeed :) Too funny!
Avatar of rgb192

ASKER

yes sql server is started
ASKER CERTIFIED SOLUTION
Avatar of Andrei Hetel
Andrei Hetel
Flag of Romania image

Link to home
membership
This content is only available to members.
To access this content, you must be a member of Experts Exchange.
Get Access
Avatar of rgb192

ASKER

thanks