I have a problem with the connection pool in Sql Server 2008 R2 (OS - Windows Server 2008 R2 X64). I periodically see this in the Sql server error logs:
Event ID: 18056
Description: The client was unable to reuse the session with SPID 157, which was reset to connect to the Pool. The failure identifier is 29. This error may have been caused by an earlier operation not completed. Check error logs for failed operations immediately before this error message.
SQL 2008 and SQL 2008 R2 Error ID: RedoLoginException, 29
We switched to SQL Server 2008 R2 CU4 running Windows Server 2008 R2, and the problem continues. SQL Server is having a problem communicating with one of its domain controllers when this happens.
When this happens, the SQL Server Agent throws the following errors:
[382] Logon to server 'DBINST01\DBINST01' failed (JobManager) [382] Logon to server 'DBINST01\DBINST01' failed (ConnUpdateJobActivity_NextScheduledRunDate) [298] SQLServer Error: 258, Unable to complete login process due to delay in prelogin response [SQLSTATE 08001] [298] SQLServer Error: 258, TCP Provider: Timeout error [258]. [SQLSTATE 08001]
We checked the error logs for previous errors, but the only error we can see is the error in the log files. What can cause this error and how can I study it?
source share