April 9, 2008 at 4:28 am
Hi,
I recently see this error occur often at different times on SQL server Agent Log. Please see the log extract as given below.
1) there is no sign of the SQL server shutting down ( SQL server Error log is fine)
2) The SQL services run fine without any issues.
3) During this time any application connecting to the SQL server too fails stating SQL server does not exist or cannot connect to database.
Does any one have a solution to it?
2008-03-31 06:25:29 - ? [100] Microsoft SQLServerAgent version 8.00.760 (x86 unicode retail build) : Process ID
2008-03-31 06:25:29 - ? [100] Microsoft SQLServerAgent version 8.00.760 (x86 unicode retail build) : Process ID 5684
2008-03-31 06:25:29 - ? [101] SQL Server version 8.00.760 (0 connection limit)
2008-03-31 06:25:29 - ? [102] SQL Server ODBC driver version 3.86.3959
2008-03-31 06:25:29 - ? [103] NetLib being used by driver is DBMSSHRN.DLL; Local host server is
2008-03-31 06:25:29 - ? [310] 4 processor(s) and 2046 MB RAM detected
2008-03-31 06:25:29 - ? [339] Local computer is running Windows NT 5.2 (3790) Service Pack 2
2008-03-31 06:25:29 - ! [364] The Messenger service has not been started - NetSend notifications will not be sent
2008-03-31 06:25:29 - ? [129] SQLSERVERAGENT starting under Windows NT service control
2008-03-31 06:25:29 - + [260] Unable to start mail session (reason: No mail profile defined)
2008-03-31 06:25:29 - + [396] An idle CPU condition has not been defined - OnIdle job schedules will have no effect
2008-03-31 06:26:37 - ! [298] SQLServer Error: 17, SQL Server does not exist or access denied. [SQLSTATE 08001]
2008-03-31 06:26:37 - ! [298] SQLServer Error: 2, ConnectionOpen (Connect()). [SQLSTATE 01000]
2008-03-31 06:26:37 - ! [382] Logon to server '(local)' failed (SubSystemStepHistoryLogger)
2008-03-31 06:26:51 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE HYT00]
2008-03-31 06:26:51 - ! [382] Logon to server ' ' failed (ConnAttemptCachableOp)
2008-03-31 06:29:08 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE HYT00]
2008-03-31 06:29:08 - ! [382] Logon to server '(local)' failed (SubSystemStepHistoryLogger)
2008-03-31 06:30:43 - ! [298] SQLServer Error: 17, SQL Server does not exist or access denied. [SQLSTATE 08001]
2008-03-31 06:30:43 - ! [298] SQLServer Error: 2, ConnectionOpen (Connect()). [SQLSTATE 01000]
2008-03-31 06:30:59 - ! [298] SQLServer Error: 17, SQL Server does not exist or access denied. [SQLSTATE 08001]
2008-03-31 06:30:59 - ! [298] SQLServer Error: 2, ConnectionOpen (Connect()). [SQLSTATE 01000]
2008-03-31 06:31:00 - ! [298] SQLServer Error: 17, SQL Server does not exist or access denied. [SQLSTATE 08001]
2008-03-31 06:31:00 - ! [298] SQLServer Error: 2, ConnectionOpen (Connect()). [SQLSTATE 01000]
2008-03-31 06:31:03 - ! [298] SQLServer Error: 17, SQL Server does not exist or access denied. [SQLSTATE 08001]
2008-03-31 06:31:03 - ! [298] SQLServer Error: 2, ConnectionOpen (Connect()). [SQLSTATE 01000]
2008-03-31 06:31:03 - ! [382] Logon to server '(local)' failed (SubSystemStepHistoryLogger)
2008-03-31 06:31:15 - ! [298] SQLServer Error: 17, SQL Server does not exist or access denied. [SQLSTATE 08001]
2008-03-31 06:31:15 - ! [298] SQLServer Error: 10048, ConnectionOpen (Connect()). [SQLSTATE 01000]
2008-03-31 06:31:15 - ! [382] Logon to server ' ' failed (ConnAttemptCachableOp)
2008-03-31 06:31:16 - ! [298] SQLServer Error: 17, SQL Server does not exist or access denied. [SQLSTATE 08001]
2008-03-31 06:31:16 - ! [298] SQLServer Error: 10048, ConnectionOpen (Connect()). [SQLSTATE 01000]
2008-03-31 06:31:16 - ! [382] Logon to server ' ' failed (ConnAttemptCachableOp)
2008-03-31 06:31:31 - ! [298] SQLServer Error: 17, SQL Server does not exist or access denied. [SQLSTATE 08001]
2008-03-31 06:31:31 - ! [298] SQLServer Error: 10048, ConnectionOpen (Connect()). [SQLSTATE 01000]
2008-03-31 06:31:31 - ! [382] Logon to server ' ' failed (ConnAttemptCachableOp)
2008-03-31 06:32:49 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE HYT00]
2008-03-31 06:32:49 - ! [382] Logon to server '(local)' failed (SubSystemStepHistoryLogger)
2008-03-31 06:34:54 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE HYT00]
2008-03-31 06:34:54 - ! [382] Logon to server '(local)' failed (SubSystemStepHistoryLogger)
2008-03-31 06:38:38 - ! [298] SQLServer Error: 17, SQL Server does not exist or access denied. [SQLSTATE 08001]
2008-03-31 06:38:38 - ! [298] SQLServer Error: 2, ConnectionOpen (Connect()). [SQLSTATE 01000]
2008-03-31 06:38:38 - ! [382] Logon to server '(local)' failed (SubSystemStepHistoryLogger)
2008-03-31 06:40:07 - ! [298] SQLServer Error: 17, SQL Server does not exist or access denied. [SQLSTATE 08001]
2008-03-31 06:40:07 - ! [298] SQLServer Error: 2, ConnectionOpen (Connect()). [SQLSTATE 01000]
2008-03-31 06:40:07 - ! [382] Logon to server '(local)' failed (SubSystemStepHistoryLogger)
2008-03-31 06:40:33 - ! [298] SQLServer Error: 17, SQL Server does not exist or access denied. [SQLSTATE 08001]
2008-03-31 06:40:33 - ! [298] SQLServer Error: 2, ConnectionOpen (Connect()). [SQLSTATE 01000]
2008-03-31 06:40:33 - ! [382] Logon to server '(local)' failed (JobManager)
2008-03-31 06:40:34 - ! [298] SQLServer Error: 17, SQL Server does not exist or access denied. [SQLSTATE 08001]
2008-03-31 06:40:34 - ! [298] SQLServer Error: 2, ConnectionOpen (Connect()). [SQLSTATE 01000]
2008-03-31 06:40:34 - ! [382] Logon to server '(local)' failed (JobManager)
2008-03-31 06:40:35 - ! [298] SQLServer Error: 17, SQL Server does not exist or access denied. [SQLSTATE 08001]
2008-03-31 06:40:35 - ! [298] SQLServer Error: 2, ConnectionOpen (Connect()). [SQLSTATE 01000]
2008-03-31 06:40:35 - ! [382] Logon to server '(local)' failed (JobManager)
2008-03-31 06:40:39 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE HYT00]
2008-03-31 06:40:39 - ! [382] Logon to server ' ' failed (ConnAttemptCachableOp)
2008-03-31 06:41:13 - ! [298] SQLServer Error: 17, SQL Server does not exist or access denied. [SQLSTATE 08001]
2008-03-31 06:41:13 - ! [298] SQLServer Error: 2, ConnectionOpen (Connect()). [SQLSTATE 01000]
2008-03-31 06:41:13 - ! [382] Logon to server '(local)' failed (JobManager)
2008-03-31 06:41:14 - ! [298] SQLServer Error: 17, SQL Server does not exist or access denied. [SQLSTATE 08001]
2008-03-31 06:41:14 - ! [298] SQLServer Error: 2, ConnectionOpen (Connect()). [SQLSTATE 01000]
2008-03-31 06:42:11 - ! [298] SQLServer Error: 17, SQL Server does not exist or access denied. [SQLSTATE 08001]
2008-03-31 06:42:11 - ! [298] SQLServer Error: 2, ConnectionOpen (Connect()). [SQLSTATE 01000]
2008-03-31 06:42:11 - ! [382] Logon to server '(local)' failed (SubSystemStepHistoryLogger)
2008-03-31 06:42:43 - ! [298] SQLServer Error: 17, SQL Server does not exist or access denied. [SQLSTATE 08001]
2008-03-31 06:42:43 - ! [298] SQLServer Error: 10048, ConnectionOpen (Connect()). [SQLSTATE 01000]
2008-03-31 06:42:43 - ! [382] Logon to server ' ' failed (ConnAttemptCachableOp)
2008-03-31 06:45:57 - ! [298] SQLServer Error: 17, SQL Server does not exist or access denied. [SQLSTATE 08001]
2008-03-31 06:45:57 - ! [298] SQLServer Error: 2, ConnectionOpen (Connect()). [SQLSTATE 01000]
2008-03-31 06:45:57 - ! [382] Logon to server ' ' failed (ConnAttemptCachableOp)
2008-03-31 06:46:06 - ! [298] SQLServer Error: 17, SQL Server does not exist or access denied. [SQLSTATE 08001]
2008-03-31 06:46:06 - ! [298] SQLServer Error: 2, ConnectionOpen (Connect()). [SQLSTATE 01000]
2008-03-31 06:47:56 - ? [131] SQLSERVERAGENT service stopping due to a stop request from a user, process, or the OS...
2008-03-31 06:48:12 - + [188] Scheduler engine timed out (after 15 seconds) waiting for 1 jobs(s) to stop
2008-03-31 06:48:14 - ! [298] SQLServer Error: 17, SQL Server does not exist or access denied. [SQLSTATE 08001]
2008-03-31 06:48:14 - ! [298] SQLServer Error: 2, ConnectionOpen (Connect()). [SQLSTATE 01000]
2008-03-31 06:48:14 - ! [382] Logon to server ' ' failed (ConnAttemptCachableOp)
2008-03-31 06:48:26 - ! [240] 1 engine thread(s) failed to stop after 30 seconds of waiting
2008-03-31 06:48:26 - ! [311] Thread 'JobInvocationEngine' (ID 4388) is still running
2008-03-31 06:48:27 - + [098] SQLServerAgent terminated (forcefully)
Thanks,
Vijay
April 9, 2008 at 1:52 pm
Looks like some job is causing troubles.
Have you an overview of that jobs/programs... are accessing the server at those times?
Does it occur daily? (perhaps a profiler trace might help to find the command that causes the pain)
Is there a form of backup/maintenance/optimalisation going on?
Are you using sql logins or windows authentication?
Removed any logins?
April 11, 2008 at 1:42 pm
Have you an overview of that jobs/programs... are accessing the server at those times?
[Vijay]-There are replication jobs that run on the server that is being not accessible. There are some backup jobs that fail when the server is not accessible.
Does it occur daily? (perhaps a profiler trace might help to find the command that causes the pain)
[Vijay]-Yes it occurs daily, but randomly at different times.
Is there a form of backup/maintenance/optimalisation going on?
[Vijay] Not always, only the transaction log backup that runs every 10 mins. Otherwise, there is no maintenance/backup/optimisation happening. It started to happen only since we moved the setup to a new server with Windows 2003 R2, SP2, SQL server 2000, SP3 setup.
Are you using sql logins or windows authentication?
[Vijay]-We use SQL login authentication.
Removed any logins?
[Vijay]-Not at all.
April 11, 2008 at 2:09 pm
Maybe this article will help
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply