May 6, 2015 at 1:07 pm
SQL Server Agent generates these errors intermittently and the jobs that are running fail. They are maintenance plans - transaction log backups most of the time.
[382] Logon to server 'XNYTSQL002P\NYTSQL002P' failed (SubSystemStepHistoryLogger)
[298] SQLServer Error: 258, Unable to complete login process due to delay in prelogin response [SQLSTATE 08001]
[165] ODBC Error: 0, Login timeout expired [SQLSTATE HYT00]
[298] SQLServer Error: 258, TCP Provider: Timeout error [258]. [SQLSTATE 08001]
[382] Logon to server 'XNYTSQL002P\NYTSQL002P' failed (ConnUpdateStartExecutionDate)
[298] SQLServer Error: 258, Unable to complete login process due to delay in prelogin response [SQLSTATE 08001]
[165] ODBC Error: 0, Login timeout expired [SQLSTATE HYT00]
[298] SQLServer Error: 258, TCP Provider: Timeout error [258]. [SQLSTATE 08001]
May 6, 2015 at 1:32 pm
This is SQL Server 2008 R2 Enterprise Ed 64Gig memory SP2
May 7, 2015 at 12:36 pm
Can someone help me with this please?
May 7, 2015 at 2:07 pm
take a look at below kb
https://support.microsoft.com/en-us/kb/2543687/en-us
issue could be coding inside your application. Can users make connections normally ?
May 7, 2015 at 2:11 pm
Yes they have no problems. It only happens when I run transaction log backups or database backups.
May 7, 2015 at 2:14 pm
Also most of the users connect via an application server so the connections are not broken once they connect. Individual users do not login in and out of the server.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply