今天远程连接一台xp sp上的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: SystemInvalidOperationException: 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 : cmdCommandType = CommandTypeStoredProcedure;
Line :
Line : connectionOpen();
Line : SqlCommandBuilderDeriveParameters(cmd);
Line : connectionClose();
但是我的连接字符串中已经设置了最大链接池=应该是不可能全部被占用的
当把链接池设置去掉就报
An error has occurred while establishing a connection to the server When connecting to SQL Server 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: 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: SystemDataSqlClientSqlException: An error has occurred while establishing a connection to the server When connecting to SQL Server 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: Could not open a connection to SQL Server)
Source Error:
Line : cmdCommandType = CommandTypeStoredProcedure;
Line :
Line : connectionOpen();
Line : SqlCommandBuilderDeriveParameters(cmd);
Line : connectionClose();
这下子问题就明朗了典型的没有打 Sql sp 的问题打上sp问题解决差点被误导
