Solved

connecting to sql server 2008 management studio

Posted on 2011-02-16
7
288 Views
Last Modified: 2012-06-27
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
------------------------------
0
Comment
Question by:rgb192
  • 3
  • 2
  • 2
7 Comments
 
LVL 5

Expert Comment

by:skrga
ID: 34908599
Check if SQL Server (MSSQLSERVER) service is running (start > Run > services.msc)
0
 
LVL 1

Expert Comment

by:Andrei Hetel
ID: 34908607
Is SQL Server service started?
0
 
LVL 5

Expert Comment

by:skrga
ID: 34908723
@Andrei74 - We answered same thing in same time :-) (in some cultures people would get wed for this) :-)
0
VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

 
LVL 1

Expert Comment

by:Andrei Hetel
ID: 34908969
@skrga Indeed :) Too funny!
0
 

Author Comment

by:rgb192
ID: 34909276
yes sql server is started
0
 
LVL 1

Accepted Solution

by:
Andrei Hetel earned 500 total points
ID: 34909343
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
 

Author Closing Comment

by:rgb192
ID: 35020412
thanks
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question