1

I had been using SQL server 2005 without any problem but now when i opened it and tried to connect it am getting this error---

TITLE: Connect to Server

Cannot connect to POONAM-C586A95C\SQLEXPRESS.

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: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1)

Why am I getting this error and how can I remove it?

Improve this question
2
  • Expand on "but now when i opened it and tried to connect". Do you mean from SQL Server Management studio or your application? Commented May 16, 2011 at 12:06
  • First i tried connecting through an application on visual web developer and got the same error. then i tried connecting directly from sql server 2005 server management studio and got the same error yet again. Commented May 16, 2011 at 12:15

4 Answers 4

Reset to default
1
  1. Check SQL Server is running on the target machine. - If not start the Services using Services.msc
  2. Check whether you have proper access rights to connect to the machine. - If not contact you system admin for access rights.
  3. Check the server allows remote connections. - You can enable it by Right clicking on the server node and check for the specific settings.

UPDATE:

Check this link : SQL SERVER – FIX : ERROR : (provider: Named Pipes Provider, error: 40 – Could not open a connection to SQL Server) (Microsoft SQL Server, Error: )

Improve this answer
Sign up to request clarification or add additional context in comments.

16 Comments

Its on the same machine from which I am connecting it. It was working perfectly fine. Its just now that its suddenly giving this error.
Please check the authentication settings. Try to connect with Windows.
I connect with windows authentication only.
Even I checked it out. It says...1) SQL Server should be up and running. Go to All Programs >> Microsoft SQL Server 2008 >> Configuration Tools >> SQL Server Configuration Manager >> SQL Server Services, and check if SQL Server service status is “Running”. I checked it and state of sql server and sql server browser is stopped. What should I do to bring it to running state?
I even added sqlservr exe file to the exceptions in the firewall but i dont think that could hav been a problem b'coz it was working perfectly without any changes in the firewall setting.
|
0

> Even I checked it out. It says...1) SQL Server should be up and running. Go to All Programs >> Microsoft SQL Server 2008 >> Configuration Tools >> SQL Server Configuration Manager >> SQL Server Services, and check if SQL Server service status is “Running”. I checked it and state of sql server and sql server browser is stopped. What should I do to bring it to running state? –

Right click the services and select Start to start them. If they don't start, run Event Viewer to see what causes the error.

If they start up and you still can't connect, try using the address .\SQLEXPRESS - if this works, your computer name might have changed, check this by looking at the properties of My Computer

Improve this answer

1 Comment

I had to reinstall SQL Server. Problem got solved after that only. Thanks for your concern.:)
0

I had the same problem. I went to SQL configuration manager. Start -> Programs -> Microsoft SQL Server 2016 -> SQL Server Configuration Manager.

Then I checked SQL Services. Find your data base instance and start the service. While I'm there, I also clicked on the SQL Server Agent to ensure TCP is enabled for the database instance as well. This fixed all connection issues for me.

Improve this answer

Comments

0

If your services are running and still facing this error then Just Check the Trust server Certificate Checkbox, which is present above connect button, this works for me.

Improve this answer

Comments

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.