今天遠程連接一台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問題解決差點被誤導
From:http://tw.wingwit.com/Article/program/SQLServer/201311/22376.html
