很诡异的error: 40报错
本帖最后由 TY1921 于 2013-01-14 17:09:52 编辑
1，数据库正常，其他SQL 2005 客户端能够连接
2，远程访问正常，同目录下，新建PHP页面，能够连接到该实例：
$conn=mssql_connect("192.168.0.7\CZH","sa","********");
mssql_select_db("Chezhihui",$conn);
//1.测试连接
if(!$conn){
echo "连接失败";
}
else{
echo "连接成功";
}
<connectionStrings>
<add name="ConnString"
connectionString="user id=sa;password=********;data source=192.168.0.7\CZH;persist security info=True;"
providerName="System.Data.SqlClient" />
</connectionStrings>
[SqlException (0x80131904): 在与 SQL Server 建立连接时出现与网络相关的或特定于实例的错误。未找到或无法访问服务器。请验证实例名称是否正确并且 SQL Server 已配置为允许远程连接。 (provider: 命名管道提供程序, error: 40 - 无法打开到 SQL Server 的连接)]
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +4845255
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +194
System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject) +4858557
System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject) +90
System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart) +342
System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +221
System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +189
System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +185
System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) +31
System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) +433
System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) +66
System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +499
System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +65
System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +117
System.Data.SqlClient.SqlConnection.Open() +122
Ky.SQLServerDAL.SqlHelper.PrepareCommand(SqlCommand cmd, SqlConnection conn, SqlTransaction trans, CommandType cmdType, String cmdText, SqlParameter[] cmdParms) in E:\打包文件\车之惠\车之惠\Ky.SQLServerDAL\Ky\SQLServerDAL\SqlHelper.cs:220
Ky.SQLServerDAL.SqlHelper.ExecuteTable(String connectionString, CommandType cmdType, String cmdText, SqlParameter[] commandParameters) in E:\打包文件\车之惠\车之惠\Ky.SQLServerDAL\Ky\SQLServerDAL\SqlHelper.cs:184
Ky.SQLServerDAL.CommonModel.InfoModel.GetModel(Int32 modelId) in E:\打包文件\车之惠\车之惠\Ky.SQLServerDAL\Ky\SQLServerDAL\CommonModel\InfoModel.cs:94
Ky.BLL.CommonModel.B_InfoModel.GetModel(Int32 modelId) in E:\打包文件\车之惠\车之惠\Ky.BLL\Ky\BLL\CommonModel\B_InfoModel.cs:63
Info.Page_Load(Object sender, EventArgs e) in E:\打包文件\车之惠\车之惠\web\Info.aspx.cs:58
System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +14
System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +35
System.Web.UI.Control.OnLoad(EventArgs e) +99
System.Web.UI.Control.LoadRecursive() +50
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +627
