(provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

Question

1.80/5 (2 votes)

See more:

SQL-Server-2008R2

HI ,

I have developed a web application(asp.net3.5) with DB sqlserver2008. SO i have deployed in the Production server of windows2008 . Now Named Pipes Provider error -40 is coming

<add name="AdminConnectionString" connectionstring="server=(local); Database =databasename; User ID=sa;Password=aaaassa" providername="System.Data.SqlClient">

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)

Locally its working fine.

Kindly let me know how to configure the asp.net application and sqlserver ... i tried windowsNT\Network server authentication also ..

same error is coming always..

thanks in advance
Martin.

Posted 21-Sep-14 1:41am

Roberts Techie

Add a Solution

1 solution

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)

Kornfeld Eliyahu Peter · Answer 1 · 2014-09-21T01:52:00

Solution 1

According to the error message your SQL not configured to receive connections over the network...
Please check and change the configuration according this - http://msdn.microsoft.com/en-us/library/ms191464.aspx[^]

Posted 21-Sep-14 1:52am

Kornfeld Eliyahu Peter

Comments

Roberts Techie 21-Sep-14 8:46am

Yes its same server for asp.net website (iis7.0) and for sqlserver 2008 . even then we need network configuration for sqlserver.

regards,
martin

Kornfeld Eliyahu Peter 21-Sep-14 8:50am

In that case you may have Named Pipes disabled! Use SQL Server Configuration Manager to check and change...

Roberts Techie 21-Sep-14 10:22am

thanks a lot

Roberts Techie 21-Sep-14 10:31am

even if i disable the named pipes the same error is coming ....any further solutions. please

Roberts Techie 22-Sep-14 7:18am

hi the problem still persists,and i found the exact problem its not at the environment . eveythings is set now .I restored a backup to a new database and if i connect the problem coming , if i generate script from restored DB and running without data in another new database and connecting to the same is working .. can you plz tell what will be the exact problem and i found one database level user is there as below

CREATE USER [appointment_bee] WITHOUT LOGIN WITH DEFAULT_SCHEMA=[dbo]

kindly let me know whats the problem ..