数据库连接问题,加急!!!!

[xcrow713]

用SQL工具可以连接服务器上的数据库,但是程序运行就会抛出这样的错,连接字符串正确,防火墙已关闭,其他人的机器都正常:
System.ServiceModel.FaultException`1[NCS.IConnect.Common.ServiceException]: 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) (Fault Detail is equal to An ExceptionDetail, likely created by IncludeExceptionDetailInFaults=true, whose value is: System.Data.SqlClient.SqlException: 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) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject) at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignor...).

[烈火焚身]

up

[xcrow713]

没人知道吗,我把SQL卸载了重装

[mextb1860]

sql可能有问题.

[xhan2000]

估计用的sql2005

看看sql的tcp/ip服务协议启动没

[asdfgh_5982]

provider: Named Pipes Provider, error: 40 错误点在这里,

应该是sql客户端连接协议中named piped和tcp/ip协议没有启用

[xcrow713]

启用了

[chengqscjh]

是否是权限的问题,连接不上或不让访问

[liaolezhong]

我想说你应该装的杀毒软件是 金山。他对程序有不好的位置。你可以把杀毒软件卸下。试下。。
报错说 服务器连接错误。检查下服务器。

[xcrow713]

我直接用SQL访问是没有问题的,就是程序运行的时候就不行,杀毒软件也不是金山

[xcrow713]

没人知道啊

[yagebu1983]

你在本地直接访问数据库试试！！！