（提供者：命名管道提供程序，错误：40 - 无法打开与SQL Server的连接） [英] (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
问题描述
HI，
我用DB sqlserver2008开发了一个Web应用程序（asp.net3.5）。我已经部署在windows2008的生产服务器中。现在命名管道提供程序错误-40即将到来
< add name =AdminConnectionStringconnectionstring =server =（local）; Database = databasename; User ID = sa ; Password = aaaassaprovidername =System.Data.SqlClient>
建立与SQL Server的连接时发生网络相关或特定于实例的错误。服务器未找到或无法访问。验证实例名称是否正确，以及SQL Server是否配置为允许远程连接。 （提供者：命名管道提供程序，错误：40 - 无法打开与SQL Server的连接）
本地工作正常。
请告诉我如何配置asp.net应用程序和sqlserver ...我试过windowsNT \Network服务器身份验证也..
总是会出现相同的错误..
提前感谢
Martin。
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.
推荐答案
根据错误消息，您的SQL未配置为通过网络接收连接...
请根据此检查并更改配置 - http://msdn.microsoft.com/en-us/library/ms191464.aspx [<一个href =http://msdn.microsoft.com/en-us/library/ms191464.aspxtarget =_ blanktitle =New Window> ^ ]
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[^]
这篇关于（提供者：命名管道提供程序，错误：40 - 无法打开与SQL Server的连接）的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
