Connection problem in Sql

Question

1.00/5 (2 votes)

See more:

hi,
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).. anyone have a solution???

Posted 26-Sep-14 3:13am

Rajan from Thiruvananthapuram

Updated 26-Sep-14 3:14am

v2

Add a Solution

Comments

[no name] 26-Sep-14 9:15am

check ur connection string..

Rajan from Thiruvananthapuram 26-Sep-14 9:16am

This is not a connection string problem

[no name] 26-Sep-14 9:28am

so. question is not clear please explain..

[no name] 26-Sep-14 9:30am

How do you know that? The error message clearly tells you that the server cannot be found.

Leo Chapiro 26-Sep-14 9:15am

Unclear or incomplete

ali khanna 26-Sep-14 9:24am

Ensure the SQL services are properly running. you can try restarting the SQl services

Rajan from Thiruvananthapuram 26-Sep-14 9:38am

how to restart the sql services??

aarif moh shaikh 27-Sep-14 7:52am

Go to control panel ---> Administrative Tool ---> Services
Here Find SQL Server (MSSQLSERVER)

Restart it

aarif moh shaikh 27-Sep-14 7:38am

Check you connection String as well as Connection Time out also... Thanks

4 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CPallini · Answer 1 · 2014-09-26T03:23:00

Solution 1

Did you Google for[^]?

Posted 26-Sep-14 3:23am

CPallini

King Fisher · Answer 2 · 2014-09-26T03:26:00

Solution 2

getting while Connect the Server?

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/[^]

Posted 26-Sep-14 3:26am

King Fisher

Comments

Rajan from Thiruvananthapuram 26-Sep-14 9:37am

i already referred that site.. but the same error occurred..

King Fisher 27-Sep-14 0:05am

Then check your Event Viewer. if any issue occured

RajeeshMenoth · Answer 3 · 2014-09-26T03:30:00

Solution 3

Try this..

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible.[^]

Posted 26-Sep-14 3:30am

RajeeshMenoth

Prasanth Radhakrishanan · Answer 4 · 2014-09-26T03:30:00

check these things
1. Make sure your database engine is configured to accept remote connections(I you are using centralized database)
•Start > All Programs > SQL Server 2005 > Configuration Tools > SQL Server Surface Area Configuration
•Click on Surface Area Configuration for Services and Connections
•Select the instance that is having a problem > Database Engine > Remote Connections
•Enable local and remote connections
•Restart instance

2. Check the SQL Server service account
•If you are not using a domain account as a service account (for example if you are using NETWORK SERVICE), you may want to switch this first before proceeding

3.If you are using a named SQL Server instance, make sure you are using that instance name in your connection strings in your ASweb P.NET application
•Usually the format needed to specify the database server is machinename\instancename
•Check your connection string as well