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 2005 Forums
 SQL Server Administration (2005)
 when i want connect it ,it takes this error,,pleas

Author  Topic 

rega83
Starting Member

6 Posts

Posted - 2013-03-04 : 09:57:55
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: 121)
"



James K
Master Smack Fu Yak Hacker

3873 Posts

Posted - 2013-03-04 : 10:04:00
Is that servername "b" just an example that you are using, or is it the real server name you are using? Try (local) including the brackets if you are trying to connect from the same box where SQL Server is installed.
Go to Top of Page

rega83
Starting Member

6 Posts

Posted - 2013-03-04 : 13:12:48
i tried (local)but it took same problem,,please what can i do?
Go to Top of Page

James K
Master Smack Fu Yak Hacker

3873 Posts

Posted - 2013-03-04 : 13:42:23
Go through this blog. Walks you step by step to figure out what you need to fix.
Go to Top of Page

rega83
Starting Member

6 Posts

Posted - 2013-03-04 : 14:05:40
i read it but i didn't understand it,,please tell me by yourself
Go to Top of Page

James K
Master Smack Fu Yak Hacker

3873 Posts

Posted - 2013-03-04 : 14:47:06
I don't know if I can explain it better than they have done there.

I would suggest these initial steps though:

1. Log on the box on which the SQL Server is installed, start up SSMS and try to connect to the database engine using (local) for the servername. Depending on how the server was set up you may need to use Windows Authentication or SQL Authentication.

2. If that does not work, see if SQL Server is running. To do that, run services.msc and look for SQL Server. It should be running.

If you are able to connect locally (i.e., by logging in on the server box), but not able to connect from a remote workstation, then it is a connectivity problem that you have to figure out using the steps described in that article.
Go to Top of Page

rega83
Starting Member

6 Posts

Posted - 2013-03-04 : 14:56:37
i opened services.msc but i didn't find sql server
Go to Top of Page

James K
Master Smack Fu Yak Hacker

3873 Posts

Posted - 2013-03-04 : 15:08:12
That means you don't have SQL Server installed. What did you install? Did you install only the client tools?
Go to Top of Page

rega83
Starting Member

6 Posts

Posted - 2013-03-04 : 15:15:27
i installed sql server perfectly,,it was same problem for sql server 2008
Go to Top of Page

James K
Master Smack Fu Yak Hacker

3873 Posts

Posted - 2013-03-04 : 15:25:29
If you don't see SQL Server in Services.msc, that certainly means you don't have SQL Server installed. Do you see anything in services.msc that has a name that starts with SQL?

How did you install? Did you install from a DVD, or did you download it from Microsoft? If you downloaded it, what is the link you used?
Go to Top of Page

rega83
Starting Member

6 Posts

Posted - 2013-03-04 : 15:36:54
i installed from dvd,,we use this version in office on windows server 2008 does not have problem ,but i use windows 7 i dont know what is problem with me
Go to Top of Page
   

- Advertisement -