Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Problem startiing SQL Server

Author  Topic 

jpl458
Starting Member

7 Posts

Posted - 2011-01-17 : 15:13:41
I downloaded SQL Server 2008 R2 Express and installed it on a new PC running Windows 7. When i first opened Management studio I got a window stating that a folder or something could not be found, and that I should go to settings and do some action. I cant get that message to reappear. Now, if I try to connect to the server from Management studio I get the following message.

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was no 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 open a connection to SQL Server) (Microsoft SQL Server error: 2)

I installed SQL Server on a couple of other server and never saw this before.

Any help would be appreciated.

Thanks in advance.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-01-17 : 16:43:42
Here's how to troubleshoot it: http://weblogs.sqlteam.com/tarad/archive/2008/05/23/60609.aspx

You likely just need to start the service though.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

jpl458
Starting Member

7 Posts

Posted - 2011-01-18 : 13:27:09
I got lucky and figured it out. It was simply a matter of getting the correct server name in the Connect to Server dialogue box.
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-01-18 : 14:21:29


Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
   

- Advertisement -