SQL Server 2000 SP4与数据链接池问题

欢迎您访问我爱IT技术网，今天小编为你分享的编程技术是：【SQL Server 2000 SP4与数据链接池问题】，下面是详细的分享！

SQL Server 2000 SP4与数据链接池问题

今天远程连接一台xp sp2上的SQL，报错信息如下：

以下为引用的内容： 　　Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached. 　　Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. 　　Exception Details: System.InvalidOperationException: Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached. 　　Source Error: 　　Line 2503: cmd.CommandType=CommandType.StoredProcedure; 　　Line 2504: 　　Line 2505: connection.Open(); 　　Line 2506: SqlCommandBuilder.DeriveParameters(cmd); 　　Line 2507: connection.Close();

但是，我的连接字符串中已经设置了，最大链接池=200，应该是不可能全部被占用的。

当把链接池设置去掉，就报：

以下为引用的内容： 　　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) 　　Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. 　　Exception Details: 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) 　　Source Error: 　　Line 2503: cmd.CommandType=CommandType.StoredProcedure; 　　Line 2504: 　　Line 2505: connection.Open(); 　　Line 2506: SqlCommandBuilder.DeriveParameters(cmd); 　　Line 2507: connection.Close();

这下子，问题就明朗了，典型的没有打 Sql2000 sp4 的问题，打上sp4问题解决，差点被误导。

以上所分享的是关于SQL Server 2000 SP4与数据链接池问题，下面是编辑为你推荐的有价值的用户互动：

　　相关问题：sql server 2000 安装sp4补丁后会影响连接数据库的...

　　答：不会， 补丁只是将数据库内部稳定性提高了 等，对外部提供的接口等并没有调整。 >>详细

　　相关问题：sql2000数据库在升级sp4补丁后软件连接数据库失败

　　答：数据库能正常启动吗？ 启动了没有？ 一般来说，sp4不会出现这个问题的。有一种可能性，你原先的密码是空密码，而sp4似乎不再支持空密码，你检查一下。 >>详细

　　相关问题：连接sqlserver2000数据库问题

　　答：首先.确认的你用户名及帐号是否正确.. User ID=sa;Password=sa 第二.确认sql服务器打了sp4补丁 第三.确认开放的端口是1433 我这有一个vbs测试sql服务器能否连接上的脚本: On Error Resume Next strConn="Provider=sqloledb;Data Source=127.0.0.... >>详细