读书人

An error has occurred while establi

发布时间: 2014-01-28 21:16:39 作者: rapoo

用ASP.NET 2.0访问SQL Server时,报错如下
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

数据源连接串都是正确的,其他工作站都可连接此数据库服务器,并且本机用查询分析器能够访问此SQL Server.但在页面中使用ADP.NET方式连接总是超时,请问如何解决?

------解决方法--------------------------------------------------------
1.http://support.microsoft.com/kb/914277
------解决方法--------------------------------------------------------
1.防火墙的对你主机IP的限制
2.SQL 2005 TCP/IP的配置!
------解决方法--------------------------------------------------------
连的是2005还是2000?
如果是2000,最好把机器上的sql2005关掉

        

读书人网 >.NET

热点推荐