Hello,
For some reason a couple of our jobs have been failing lately. We get
the following msg on the details of the job. Any ideas? Thanks in advance.
Msg:
Unable to connect to SQL Server 'COMPUTERNAME\INSTANCENAME'. The step
failed.
1. Is this the same server where the jobs are running?
2. Have you checked your SQL Agent logs for any more information on these
error messages?
3. Can you connect to this named isntance using Query analyser, SEM, etc?
4. Was this sql server "moved" from another box, or any such thing?
Thanks,
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.
|||Vikram,
1. Yes
2. See below output
3. Yes
4. We did upgrade the sql box a couple of months ago. We created scripts
and ran them against the new instance. The seem to be ran fine from Query
analyser. It's not the same job that fails everytime either it seems to be
random.
jake
2004-06-16 08:19:24 - ? [393] Waiting for SQL Server to recover databases...
2004-06-16 08:21:22 - ? [100] Microsoft SQLServerAgent version 8.00.760 (x86
unicode retail build) : Process ID
2004-06-16 08:21:23 - ? [100] Microsoft SQLServerAgent version 8.00.760 (x86
unicode retail build) : Process ID 1596
2004-06-16 08:21:23 - ? [101] SQL Server computername\DBSERVER version
8.00.760 (0 connection limit)
2004-06-16 08:21:23 - ? [102] SQL Server ODBC driver version 3.85.1025
2004-06-16 08:21:23 - ? [103] NetLib being used by driver is DBMSLPCN.DLL;
Local host server is computername\DBSERVER
2004-06-16 08:21:23 - ? [310] 1 processor(s) and 992 MB RAM detected
2004-06-16 08:21:23 - ? [339] Local computer is computername running Windows
NT 5.2 (3790)
2004-06-16 08:21:23 - ! [364] The Messenger service has not been started -
NetSend notifications will not be sent
2004-06-16 08:21:23 - ? [129] SQLAgent$DBSERVER starting under Windows NT
service control
2004-06-16 08:21:23 - ? [392] Using MAPI32.DLL from C:\WINDOWS\SYSTEM32
(version 1.0.2536.0)
2004-06-16 08:21:23 - ? [196] Attempting to start mail session using profile
'Outlook'...
2004-06-16 08:21:25 - ? [353] Mail session started (using MAPI1)
2004-06-16 08:21:25 - + [396] An idle CPU condition has not been defined -
OnIdle job schedules will have no effect
2004-06-17 05:19:32 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-06-17 05:19:32 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-06-18 02:04:11 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-06-18 05:21:14 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-06-18 05:21:15 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-06-19 05:13:16 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-06-20 05:15:57 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-06-20 05:15:57 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-06-20 05:20:23 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-06-21 02:14:18 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-06-21 02:14:18 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-06-21 05:16:45 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-06-21 05:16:45 - ! [382] Logon to server 'computername\DBSERVER' failed
(SaveAllSchedules)
2004-06-21 05:17:53 - ! [298] SQLServer Error: 17, SQL Server does not exist
or access denied. [SQLSTATE 08001]
2004-06-21 05:17:53 - ! [298] SQLServer Error: 53, ConnectionOpen
(Connect()). [SQLSTATE 01000]
2004-06-21 08:04:08 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-06-21 08:04:08 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-06-22 02:18:02 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-06-22 05:18:36 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-06-22 05:20:39 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-06-22 05:20:39 - ! [382] Logon to server 'computername\DBSERVER' failed
(SaveAllSchedules)
2004-06-22 07:01:32 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-06-23 02:17:10 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-06-23 02:17:15 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-06-23 02:19:15 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-06-23 07:30:41 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-06-23 08:19:30 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-06-23 08:19:30 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-06-24 05:15:41 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-06-24 05:15:41 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-06-24 05:16:53 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-06-24 05:16:53 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-06-25 02:08:23 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-06-25 02:08:23 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-06-25 02:09:27 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-06-25 02:09:32 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-06-25 02:18:07 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-06-26 05:27:36 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-06-26 05:29:40 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-06-26 05:29:40 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-06-28 02:03:04 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-06-28 05:16:25 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-06-28 08:50:06 - ? [131] SQLAgent$DBSERVER service stopping due to a
stop request from a user, process, or the OS...
2004-06-28 08:50:07 - ? [358] Mail session ended
2004-06-28 08:50:09 - ? [098] SQLServerAgent terminated (normally)
"Vikram Jayaram [MS]" <vikramj@.online.microsoft.com> wrote in message
news:N8GBxNPXEHA.328@.cpmsftngxa10.phx.gbl...
> 1. Is this the same server where the jobs are running?
> 2. Have you checked your SQL Agent logs for any more information on these
> error messages?
> 3. Can you connect to this named isntance using Query analyser, SEM, etc?
> 4. Was this sql server "moved" from another box, or any such thing?
> Thanks,
> Vikram Jayaram
> Microsoft, SQL Server
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.
>
|||Vikram,
1. Yes
2. See below output
3. Yes
4. We did upgrade the sql box a couple of months ago. We created scripts
and ran them against the new instance. The seem to be ran fine from Query
analyser. It's not the same job that fails everytime either it seems to be
random.
jake
2004-06-16 08:19:24 - ? [393] Waiting for SQL Server to recover databases...
2004-06-16 08:21:22 - ? [100] Microsoft SQLServerAgent version 8.00.760 (x86
unicode retail build) : Process ID
2004-06-16 08:21:23 - ? [100] Microsoft SQLServerAgent version 8.00.760 (x86
unicode retail build) : Process ID 1596
2004-06-16 08:21:23 - ? [101] SQL Server computername\DBSERVER version
8.00.760 (0 connection limit)
2004-06-16 08:21:23 - ? [102] SQL Server ODBC driver version 3.85.1025
2004-06-16 08:21:23 - ? [103] NetLib being used by driver is DBMSLPCN.DLL;
Local host server is computername\DBSERVER
2004-06-16 08:21:23 - ? [310] 1 processor(s) and 992 MB RAM detected
2004-06-16 08:21:23 - ? [339] Local computer is computername running Windows
NT 5.2 (3790)
2004-06-16 08:21:23 - ! [364] The Messenger service has not been started -
NetSend notifications will not be sent
2004-06-16 08:21:23 - ? [129] SQLAgent$DBSERVER starting under Windows NT
service control
2004-06-16 08:21:23 - ? [392] Using MAPI32.DLL from C:\WINDOWS\SYSTEM32
(version 1.0.2536.0)
2004-06-16 08:21:23 - ? [196] Attempting to start mail session using profile
'Outlook'...
2004-06-16 08:21:25 - ? [353] Mail session started (using MAPI1)
2004-06-16 08:21:25 - + [396] An idle CPU condition has not been defined -
OnIdle job schedules will have no effect
2004-06-17 05:19:32 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-06-17 05:19:32 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-06-18 02:04:11 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-06-18 05:21:14 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-06-18 05:21:15 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-06-19 05:13:16 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-06-20 05:15:57 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-06-20 05:15:57 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-06-20 05:20:23 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-06-21 02:14:18 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-06-21 02:14:18 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-06-21 05:16:45 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-06-21 05:16:45 - ! [382] Logon to server 'computername\DBSERVER' failed
(SaveAllSchedules)
2004-06-21 05:17:53 - ! [298] SQLServer Error: 17, SQL Server does not exist
or access denied. [SQLSTATE 08001]
2004-06-21 05:17:53 - ! [298] SQLServer Error: 53, ConnectionOpen
(Connect()). [SQLSTATE 01000]
2004-06-21 08:04:08 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-06-21 08:04:08 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-06-22 02:18:02 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-06-22 05:18:36 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-06-22 05:20:39 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-06-22 05:20:39 - ! [382] Logon to server 'computername\DBSERVER' failed
(SaveAllSchedules)
2004-06-22 07:01:32 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-06-23 02:17:10 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-06-23 02:17:15 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-06-23 02:19:15 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-06-23 07:30:41 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-06-23 08:19:30 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-06-23 08:19:30 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-06-24 05:15:41 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-06-24 05:15:41 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-06-24 05:16:53 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-06-24 05:16:53 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-06-25 02:08:23 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-06-25 02:08:23 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-06-25 02:09:27 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-06-25 02:09:32 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-06-25 02:18:07 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-06-26 05:27:36 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-06-26 05:29:40 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-06-26 05:29:40 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-06-28 02:03:04 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-06-28 05:16:25 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-06-28 08:50:06 - ? [131] SQLAgent$DBSERVER service stopping due to a
stop request from a user, process, or the OS...
2004-06-28 08:50:07 - ? [358] Mail session ended
2004-06-28 08:50:09 - ? [098] SQLServerAgent terminated (normally)
"Vikram Jayaram [MS]" <vikramj@.online.microsoft.com> wrote in message
news:N8GBxNPXEHA.328@.cpmsftngxa10.phx.gbl...
> 1. Is this the same server where the jobs are running?
> 2. Have you checked your SQL Agent logs for any more information on these
> error messages?
> 3. Can you connect to this named isntance using Query analyser, SEM, etc?
> 4. Was this sql server "moved" from another box, or any such thing?
> Thanks,
> Vikram Jayaram
> Microsoft, SQL Server
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.
>
Showing posts with label failing. Show all posts
Showing posts with label failing. Show all posts
Monday, February 27, 2012
Help with multiple jobs failing
Hello,
For some reason a couple of our jobs have been failing lately. We get
the following msg on the details of the job. Any ideas? Thanks in advance.
Msg:
Unable to connect to SQL Server 'COMPUTERNAME\INSTANCENAME'. The step
failed.1. Is this the same server where the jobs are running?
2. Have you checked your SQL Agent logs for any more information on these
error messages?
3. Can you connect to this named isntance using Query analyser, SEM, etc?
4. Was this sql server "moved" from another box, or any such thing?
Thanks,
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.|||Vikram,
1. Yes
2. See below output
3. Yes
4. We did upgrade the sql box a couple of months ago. We created scripts
and ran them against the new instance. The seem to be ran fine from Query
analyser. It's not the same job that fails everytime either it seems to be
random.
jake
2004-06-16 08:19:24 - ? [393] Waiting for SQL Server to recover databases...
2004-06-16 08:21:22 - ? [100] Microsoft SQLServerAgent version 8.00.760 (x86
unicode retail build) : Process ID
2004-06-16 08:21:23 - ? [100] Microsoft SQLServerAgent version 8.00.760 (x86
unicode retail build) : Process ID 1596
2004-06-16 08:21:23 - ? [101] SQL Server computername\DBSERVER version
8.00.760 (0 connection limit)
2004-06-16 08:21:23 - ? [102] SQL Server ODBC driver version 3.85.1025
2004-06-16 08:21:23 - ? [103] NetLib being used by driver is DBMSLPCN.DLL;
Local host server is computername\DBSERVER
2004-06-16 08:21:23 - ? [310] 1 processor(s) and 992 MB RAM detected
2004-06-16 08:21:23 - ? [339] Local computer is computername running Windows
NT 5.2 (3790)
2004-06-16 08:21:23 - ! [364] The Messenger service has not been started -
NetSend notifications will not be sent
2004-06-16 08:21:23 - ? [129] SQLAgent$DBSERVER starting under Windows NT
service control
2004-06-16 08:21:23 - ? [392] Using MAPI32.DLL from C:\WINDOWS\SYSTEM32
(version 1.0.2536.0)
2004-06-16 08:21:23 - ? [196] Attempting to start mail session using profile
'Outlook'...
2004-06-16 08:21:25 - ? [353] Mail session started (using MAPI1)
2004-06-16 08:21:25 - + [396] An idle CPU condition has not been defined -
OnIdle job schedules will have no effect
2004-06-17 05:19:32 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-06-17 05:19:32 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-06-18 02:04:11 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-06-18 05:21:14 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-06-18 05:21:15 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-06-19 05:13:16 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-06-20 05:15:57 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-06-20 05:15:57 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-06-20 05:20:23 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-06-21 02:14:18 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-06-21 02:14:18 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-06-21 05:16:45 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-06-21 05:16:45 - ! [382] Logon to server 'computername\DBSERVER' failed
(SaveAllSchedules)
2004-06-21 05:17:53 - ! [298] SQLServer Error: 17, SQL Server does not exist
or access denied. [SQLSTATE 08001]
2004-06-21 05:17:53 - ! [298] SQLServer Error: 53, ConnectionOpen
(Connect()). [SQLSTATE 01000]
2004-06-21 08:04:08 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-06-21 08:04:08 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-06-22 02:18:02 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-06-22 05:18:36 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-06-22 05:20:39 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-06-22 05:20:39 - ! [382] Logon to server 'computername\DBSERVER' failed
(SaveAllSchedules)
2004-06-22 07:01:32 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-06-23 02:17:10 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-06-23 02:17:15 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-06-23 02:19:15 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-06-23 07:30:41 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-06-23 08:19:30 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-06-23 08:19:30 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-06-24 05:15:41 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-06-24 05:15:41 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-06-24 05:16:53 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-06-24 05:16:53 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-06-25 02:08:23 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-06-25 02:08:23 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-06-25 02:09:27 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-06-25 02:09:32 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-06-25 02:18:07 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-06-26 05:27:36 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-06-26 05:29:40 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-06-26 05:29:40 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-06-28 02:03:04 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-06-28 05:16:25 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-06-28 08:50:06 - ? [131] SQLAgent$DBSERVER service stopping due to a
stop request from a user, process, or the OS...
2004-06-28 08:50:07 - ? [358] Mail session ended
2004-06-28 08:50:09 - ? [098] SQLServerAgent terminated (normally)
"Vikram Jayaram [MS]" <vikramj@.online.microsoft.com> wrote in message
news:N8GBxNPXEHA.328@.cpmsftngxa10.phx.gbl...
> 1. Is this the same server where the jobs are running?
> 2. Have you checked your SQL Agent logs for any more information on these
> error messages?
> 3. Can you connect to this named isntance using Query analyser, SEM, etc?
> 4. Was this sql server "moved" from another box, or any such thing?
> Thanks,
> Vikram Jayaram
> Microsoft, SQL Server
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.
>
For some reason a couple of our jobs have been failing lately. We get
the following msg on the details of the job. Any ideas? Thanks in advance.
Msg:
Unable to connect to SQL Server 'COMPUTERNAME\INSTANCENAME'. The step
failed.1. Is this the same server where the jobs are running?
2. Have you checked your SQL Agent logs for any more information on these
error messages?
3. Can you connect to this named isntance using Query analyser, SEM, etc?
4. Was this sql server "moved" from another box, or any such thing?
Thanks,
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.|||Vikram,
1. Yes
2. See below output
3. Yes
4. We did upgrade the sql box a couple of months ago. We created scripts
and ran them against the new instance. The seem to be ran fine from Query
analyser. It's not the same job that fails everytime either it seems to be
random.
jake
2004-06-16 08:19:24 - ? [393] Waiting for SQL Server to recover databases...
2004-06-16 08:21:22 - ? [100] Microsoft SQLServerAgent version 8.00.760 (x86
unicode retail build) : Process ID
2004-06-16 08:21:23 - ? [100] Microsoft SQLServerAgent version 8.00.760 (x86
unicode retail build) : Process ID 1596
2004-06-16 08:21:23 - ? [101] SQL Server computername\DBSERVER version
8.00.760 (0 connection limit)
2004-06-16 08:21:23 - ? [102] SQL Server ODBC driver version 3.85.1025
2004-06-16 08:21:23 - ? [103] NetLib being used by driver is DBMSLPCN.DLL;
Local host server is computername\DBSERVER
2004-06-16 08:21:23 - ? [310] 1 processor(s) and 992 MB RAM detected
2004-06-16 08:21:23 - ? [339] Local computer is computername running Windows
NT 5.2 (3790)
2004-06-16 08:21:23 - ! [364] The Messenger service has not been started -
NetSend notifications will not be sent
2004-06-16 08:21:23 - ? [129] SQLAgent$DBSERVER starting under Windows NT
service control
2004-06-16 08:21:23 - ? [392] Using MAPI32.DLL from C:\WINDOWS\SYSTEM32
(version 1.0.2536.0)
2004-06-16 08:21:23 - ? [196] Attempting to start mail session using profile
'Outlook'...
2004-06-16 08:21:25 - ? [353] Mail session started (using MAPI1)
2004-06-16 08:21:25 - + [396] An idle CPU condition has not been defined -
OnIdle job schedules will have no effect
2004-06-17 05:19:32 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-06-17 05:19:32 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-06-18 02:04:11 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-06-18 05:21:14 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-06-18 05:21:15 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-06-19 05:13:16 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-06-20 05:15:57 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-06-20 05:15:57 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-06-20 05:20:23 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-06-21 02:14:18 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-06-21 02:14:18 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-06-21 05:16:45 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-06-21 05:16:45 - ! [382] Logon to server 'computername\DBSERVER' failed
(SaveAllSchedules)
2004-06-21 05:17:53 - ! [298] SQLServer Error: 17, SQL Server does not exist
or access denied. [SQLSTATE 08001]
2004-06-21 05:17:53 - ! [298] SQLServer Error: 53, ConnectionOpen
(Connect()). [SQLSTATE 01000]
2004-06-21 08:04:08 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-06-21 08:04:08 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-06-22 02:18:02 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-06-22 05:18:36 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-06-22 05:20:39 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-06-22 05:20:39 - ! [382] Logon to server 'computername\DBSERVER' failed
(SaveAllSchedules)
2004-06-22 07:01:32 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-06-23 02:17:10 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-06-23 02:17:15 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-06-23 02:19:15 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-06-23 07:30:41 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-06-23 08:19:30 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-06-23 08:19:30 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-06-24 05:15:41 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-06-24 05:15:41 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-06-24 05:16:53 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-06-24 05:16:53 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-06-25 02:08:23 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-06-25 02:08:23 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-06-25 02:09:27 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-06-25 02:09:32 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-06-25 02:18:07 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-06-26 05:27:36 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-06-26 05:29:40 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-06-26 05:29:40 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-06-28 02:03:04 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-06-28 05:16:25 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-06-28 08:50:06 - ? [131] SQLAgent$DBSERVER service stopping due to a
stop request from a user, process, or the OS...
2004-06-28 08:50:07 - ? [358] Mail session ended
2004-06-28 08:50:09 - ? [098] SQLServerAgent terminated (normally)
"Vikram Jayaram [MS]" <vikramj@.online.microsoft.com> wrote in message
news:N8GBxNPXEHA.328@.cpmsftngxa10.phx.gbl...
> 1. Is this the same server where the jobs are running?
> 2. Have you checked your SQL Agent logs for any more information on these
> error messages?
> 3. Can you connect to this named isntance using Query analyser, SEM, etc?
> 4. Was this sql server "moved" from another box, or any such thing?
> Thanks,
> Vikram Jayaram
> Microsoft, SQL Server
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.
>
Help with multiple jobs failing
Hello,
For some reason a couple of our jobs have been failing lately. We get
the following msg on the details of the job. Any ideas? Thanks in advance.
Msg:
Unable to connect to SQL Server 'COMPUTERNAME\INSTANCENAME'. The step
failed.1. Is this the same server where the jobs are running?
2. Have you checked your SQL Agent logs for any more information on these
error messages?
3. Can you connect to this named isntance using Query analyser, SEM, etc?
4. Was this sql server "moved" from another box, or any such thing?
Thanks,
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.|||Vikram,
1. Yes
2. See below output
3. Yes
4. We did upgrade the sql box a couple of months ago. We created scripts
and ran them against the new instance. The seem to be ran fine from Query
analyser. It's not the same job that fails everytime either it seems to be
random.
jake
2004-06-16 08:19:24 - ? [393] Waiting for SQL Server to recover database
s...
2004-06-16 08:21:22 - ? [100] Microsoft SQLServerAgent version 8.00.760
(x86
unicode retail build) : Process ID
2004-06-16 08:21:23 - ? [100] Microsoft SQLServerAgent version 8.00.760
(x86
unicode retail build) : Process ID 1596
2004-06-16 08:21:23 - ? [101] SQL Server computername\DBSERVER version
8.00.760 (0 connection limit)
2004-06-16 08:21:23 - ? [102] SQL Server ODBC driver version 3.85.1025
2004-06-16 08:21:23 - ? [103] NetLib being used by driver is DBMSLPCN.DL
L;
Local host server is computername\DBSERVER
2004-06-16 08:21:23 - ? [310] 1 processor(s) and 992 MB RAM detected
2004-06-16 08:21:23 - ? [339] Local computer is computername running Win
dows
NT 5.2 (3790)
2004-06-16 08:21:23 - ! [364] The Messenger service has not been started
-
NetSend notifications will not be sent
2004-06-16 08:21:23 - ? [129] SQLAgent$DBSERVER starting under Windows N
T
service control
2004-06-16 08:21:23 - ? [392] Using MAPI32.DLL from C:\WINDOWS\SYSTEM32
(version 1.0.2536.0)
2004-06-16 08:21:23 - ? [196] Attempting to start mail session using pro
file
'Outlook'...
2004-06-16 08:21:25 - ? [353] Mail session started (using MAPI1)
2004-06-16 08:21:25 - + [396] An idle CPU condition has not been defined
-
OnIdle job schedules will have no effect
2004-06-17 05:19:32 - ! [165] ODBC Error: 0, Timeout expired [SQLSTA
TE
HYT00]
2004-06-17 05:19:32 - ! [382] Logon to server 'computername\DBSERVER' fa
iled
(ConnAttemptCachableOp)
2004-06-18 02:04:11 - ! [165] ODBC Error: 0, Timeout expired [SQLSTA
TE
HYT00]
2004-06-18 05:21:14 - ! [165] ODBC Error: 0, Timeout expired [SQLSTA
TE
HYT00]
2004-06-18 05:21:15 - ! [382] Logon to server 'computername\DBSERVER' fa
iled
(ConnAttemptCachableOp)
2004-06-19 05:13:16 - ! [165] ODBC Error: 0, Timeout expired [SQLSTA
TE
HYT00]
2004-06-20 05:15:57 - ! [165] ODBC Error: 0, Timeout expired [SQLSTA
TE
HYT00]
2004-06-20 05:15:57 - ! [382] Logon to server 'computername\DBSERVER' fa
iled
(ConnAttemptCachableOp)
2004-06-20 05:20:23 - ! [165] ODBC Error: 0, Timeout expired [SQLSTA
TE
HYT00]
2004-06-21 02:14:18 - ! [165] ODBC Error: 0, Timeout expired [SQLSTA
TE
HYT00]
2004-06-21 02:14:18 - ! [382] Logon to server 'computername\DBSERVER' fa
iled
(ConnAttemptCachableOp)
2004-06-21 05:16:45 - ! [165] ODBC Error: 0, Timeout expired [SQLSTA
TE
HYT00]
2004-06-21 05:16:45 - ! [382] Logon to server 'computername\DBSERVER' fa
iled
(SaveAllSchedules)
2004-06-21 05:17:53 - ! [298] SQLServer Error: 17, SQL Server does not e
xist
or access denied. [SQLSTATE 08001]
2004-06-21 05:17:53 - ! [298] SQLServer Error: 53, ConnectionOpen
(Connect()). [SQLSTATE 01000]
2004-06-21 08:04:08 - ! [165] ODBC Error: 0, Timeout expired [SQLSTA
TE
HYT00]
2004-06-21 08:04:08 - ! [382] Logon to server 'computername\DBSERVER' fa
iled
(ConnAttemptCachableOp)
2004-06-22 02:18:02 - ! [165] ODBC Error: 0, Timeout expired [SQLSTA
TE
HYT00]
2004-06-22 05:18:36 - ! [165] ODBC Error: 0, Timeout expired [SQLSTA
TE
HYT00]
2004-06-22 05:20:39 - ! [165] ODBC Error: 0, Timeout expired [SQLSTA
TE
HYT00]
2004-06-22 05:20:39 - ! [382] Logon to server 'computername\DBSERVER' fa
iled
(SaveAllSchedules)
2004-06-22 07:01:32 - ! [165] ODBC Error: 0, Timeout expired [SQLSTA
TE
HYT00]
2004-06-23 02:17:10 - ! [165] ODBC Error: 0, Timeout expired [SQLSTA
TE
HYT00]
2004-06-23 02:17:15 - ! [382] Logon to server 'computername\DBSERVER' fa
iled
(ConnAttemptCachableOp)
2004-06-23 02:19:15 - ! [165] ODBC Error: 0, Timeout expired [SQLSTA
TE
HYT00]
2004-06-23 07:30:41 - ! [165] ODBC Error: 0, Timeout expired [SQLSTA
TE
HYT00]
2004-06-23 08:19:30 - ! [165] ODBC Error: 0, Timeout expired [SQLSTA
TE
HYT00]
2004-06-23 08:19:30 - ! [382] Logon to server 'computername\DBSERVER' fa
iled
(ConnAttemptCachableOp)
2004-06-24 05:15:41 - ! [165] ODBC Error: 0, Timeout expired [SQLSTA
TE
HYT00]
2004-06-24 05:15:41 - ! [382] Logon to server 'computername\DBSERVER' fa
iled
(ConnAttemptCachableOp)
2004-06-24 05:16:53 - ! [165] ODBC Error: 0, Timeout expired [SQLSTA
TE
HYT00]
2004-06-24 05:16:53 - ! [382] Logon to server 'computername\DBSERVER' fa
iled
(ConnAttemptCachableOp)
2004-06-25 02:08:23 - ! [165] ODBC Error: 0, Timeout expired [SQLSTA
TE
HYT00]
2004-06-25 02:08:23 - ! [382] Logon to server 'computername\DBSERVER' fa
iled
(ConnAttemptCachableOp)
2004-06-25 02:09:27 - ! [165] ODBC Error: 0, Timeout expired [SQLSTA
TE
HYT00]
2004-06-25 02:09:32 - ! [382] Logon to server 'computername\DBSERVER' fa
iled
(ConnAttemptCachableOp)
2004-06-25 02:18:07 - ! [165] ODBC Error: 0, Timeout expired [SQLSTA
TE
HYT00]
2004-06-26 05:27:36 - ! [165] ODBC Error: 0, Timeout expired [SQLSTA
TE
HYT00]
2004-06-26 05:29:40 - ! [165] ODBC Error: 0, Timeout expired [SQLSTA
TE
HYT00]
2004-06-26 05:29:40 - ! [382] Logon to server 'computername\DBSERVER' fa
iled
(ConnAttemptCachableOp)
2004-06-28 02:03:04 - ! [165] ODBC Error: 0, Timeout expired [SQLSTA
TE
HYT00]
2004-06-28 05:16:25 - ! [165] ODBC Error: 0, Timeout expired [SQLSTA
TE
HYT00]
2004-06-28 08:50:06 - ? [131] SQLAgent$DBSERVER service stopping due to
a
stop request from a user, process, or the OS...
2004-06-28 08:50:07 - ? [358] Mail session ended
2004-06-28 08:50:09 - ? [098] SQLServerAgent terminated (normally)
"Vikram Jayaram [MS]" <vikramj@.online.microsoft.com> wrote in message
news:N8GBxNPXEHA.328@.cpmsftngxa10.phx.gbl...
> 1. Is this the same server where the jobs are running?
> 2. Have you checked your SQL Agent logs for any more information on these
> error messages?
> 3. Can you connect to this named isntance using Query analyser, SEM, etc?
> 4. Was this sql server "moved" from another box, or any such thing?
> Thanks,
> Vikram Jayaram
> Microsoft, SQL Server
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.
>|||Did you ever figure out what caused this? I had the same problem a few days
ago. I restarted the server and that stopped the errors but I would like to
know the cause.
For some reason a couple of our jobs have been failing lately. We get
the following msg on the details of the job. Any ideas? Thanks in advance.
Msg:
Unable to connect to SQL Server 'COMPUTERNAME\INSTANCENAME'. The step
failed.1. Is this the same server where the jobs are running?
2. Have you checked your SQL Agent logs for any more information on these
error messages?
3. Can you connect to this named isntance using Query analyser, SEM, etc?
4. Was this sql server "moved" from another box, or any such thing?
Thanks,
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.|||Vikram,
1. Yes
2. See below output
3. Yes
4. We did upgrade the sql box a couple of months ago. We created scripts
and ran them against the new instance. The seem to be ran fine from Query
analyser. It's not the same job that fails everytime either it seems to be
random.
jake
2004-06-16 08:19:24 - ? [393] Waiting for SQL Server to recover database
s...
2004-06-16 08:21:22 - ? [100] Microsoft SQLServerAgent version 8.00.760
(x86
unicode retail build) : Process ID
2004-06-16 08:21:23 - ? [100] Microsoft SQLServerAgent version 8.00.760
(x86
unicode retail build) : Process ID 1596
2004-06-16 08:21:23 - ? [101] SQL Server computername\DBSERVER version
8.00.760 (0 connection limit)
2004-06-16 08:21:23 - ? [102] SQL Server ODBC driver version 3.85.1025
2004-06-16 08:21:23 - ? [103] NetLib being used by driver is DBMSLPCN.DL
L;
Local host server is computername\DBSERVER
2004-06-16 08:21:23 - ? [310] 1 processor(s) and 992 MB RAM detected
2004-06-16 08:21:23 - ? [339] Local computer is computername running Win
dows
NT 5.2 (3790)
2004-06-16 08:21:23 - ! [364] The Messenger service has not been started
-
NetSend notifications will not be sent
2004-06-16 08:21:23 - ? [129] SQLAgent$DBSERVER starting under Windows N
T
service control
2004-06-16 08:21:23 - ? [392] Using MAPI32.DLL from C:\WINDOWS\SYSTEM32
(version 1.0.2536.0)
2004-06-16 08:21:23 - ? [196] Attempting to start mail session using pro
file
'Outlook'...
2004-06-16 08:21:25 - ? [353] Mail session started (using MAPI1)
2004-06-16 08:21:25 - + [396] An idle CPU condition has not been defined
-
OnIdle job schedules will have no effect
2004-06-17 05:19:32 - ! [165] ODBC Error: 0, Timeout expired [SQLSTA
TE
HYT00]
2004-06-17 05:19:32 - ! [382] Logon to server 'computername\DBSERVER' fa
iled
(ConnAttemptCachableOp)
2004-06-18 02:04:11 - ! [165] ODBC Error: 0, Timeout expired [SQLSTA
TE
HYT00]
2004-06-18 05:21:14 - ! [165] ODBC Error: 0, Timeout expired [SQLSTA
TE
HYT00]
2004-06-18 05:21:15 - ! [382] Logon to server 'computername\DBSERVER' fa
iled
(ConnAttemptCachableOp)
2004-06-19 05:13:16 - ! [165] ODBC Error: 0, Timeout expired [SQLSTA
TE
HYT00]
2004-06-20 05:15:57 - ! [165] ODBC Error: 0, Timeout expired [SQLSTA
TE
HYT00]
2004-06-20 05:15:57 - ! [382] Logon to server 'computername\DBSERVER' fa
iled
(ConnAttemptCachableOp)
2004-06-20 05:20:23 - ! [165] ODBC Error: 0, Timeout expired [SQLSTA
TE
HYT00]
2004-06-21 02:14:18 - ! [165] ODBC Error: 0, Timeout expired [SQLSTA
TE
HYT00]
2004-06-21 02:14:18 - ! [382] Logon to server 'computername\DBSERVER' fa
iled
(ConnAttemptCachableOp)
2004-06-21 05:16:45 - ! [165] ODBC Error: 0, Timeout expired [SQLSTA
TE
HYT00]
2004-06-21 05:16:45 - ! [382] Logon to server 'computername\DBSERVER' fa
iled
(SaveAllSchedules)
2004-06-21 05:17:53 - ! [298] SQLServer Error: 17, SQL Server does not e
xist
or access denied. [SQLSTATE 08001]
2004-06-21 05:17:53 - ! [298] SQLServer Error: 53, ConnectionOpen
(Connect()). [SQLSTATE 01000]
2004-06-21 08:04:08 - ! [165] ODBC Error: 0, Timeout expired [SQLSTA
TE
HYT00]
2004-06-21 08:04:08 - ! [382] Logon to server 'computername\DBSERVER' fa
iled
(ConnAttemptCachableOp)
2004-06-22 02:18:02 - ! [165] ODBC Error: 0, Timeout expired [SQLSTA
TE
HYT00]
2004-06-22 05:18:36 - ! [165] ODBC Error: 0, Timeout expired [SQLSTA
TE
HYT00]
2004-06-22 05:20:39 - ! [165] ODBC Error: 0, Timeout expired [SQLSTA
TE
HYT00]
2004-06-22 05:20:39 - ! [382] Logon to server 'computername\DBSERVER' fa
iled
(SaveAllSchedules)
2004-06-22 07:01:32 - ! [165] ODBC Error: 0, Timeout expired [SQLSTA
TE
HYT00]
2004-06-23 02:17:10 - ! [165] ODBC Error: 0, Timeout expired [SQLSTA
TE
HYT00]
2004-06-23 02:17:15 - ! [382] Logon to server 'computername\DBSERVER' fa
iled
(ConnAttemptCachableOp)
2004-06-23 02:19:15 - ! [165] ODBC Error: 0, Timeout expired [SQLSTA
TE
HYT00]
2004-06-23 07:30:41 - ! [165] ODBC Error: 0, Timeout expired [SQLSTA
TE
HYT00]
2004-06-23 08:19:30 - ! [165] ODBC Error: 0, Timeout expired [SQLSTA
TE
HYT00]
2004-06-23 08:19:30 - ! [382] Logon to server 'computername\DBSERVER' fa
iled
(ConnAttemptCachableOp)
2004-06-24 05:15:41 - ! [165] ODBC Error: 0, Timeout expired [SQLSTA
TE
HYT00]
2004-06-24 05:15:41 - ! [382] Logon to server 'computername\DBSERVER' fa
iled
(ConnAttemptCachableOp)
2004-06-24 05:16:53 - ! [165] ODBC Error: 0, Timeout expired [SQLSTA
TE
HYT00]
2004-06-24 05:16:53 - ! [382] Logon to server 'computername\DBSERVER' fa
iled
(ConnAttemptCachableOp)
2004-06-25 02:08:23 - ! [165] ODBC Error: 0, Timeout expired [SQLSTA
TE
HYT00]
2004-06-25 02:08:23 - ! [382] Logon to server 'computername\DBSERVER' fa
iled
(ConnAttemptCachableOp)
2004-06-25 02:09:27 - ! [165] ODBC Error: 0, Timeout expired [SQLSTA
TE
HYT00]
2004-06-25 02:09:32 - ! [382] Logon to server 'computername\DBSERVER' fa
iled
(ConnAttemptCachableOp)
2004-06-25 02:18:07 - ! [165] ODBC Error: 0, Timeout expired [SQLSTA
TE
HYT00]
2004-06-26 05:27:36 - ! [165] ODBC Error: 0, Timeout expired [SQLSTA
TE
HYT00]
2004-06-26 05:29:40 - ! [165] ODBC Error: 0, Timeout expired [SQLSTA
TE
HYT00]
2004-06-26 05:29:40 - ! [382] Logon to server 'computername\DBSERVER' fa
iled
(ConnAttemptCachableOp)
2004-06-28 02:03:04 - ! [165] ODBC Error: 0, Timeout expired [SQLSTA
TE
HYT00]
2004-06-28 05:16:25 - ! [165] ODBC Error: 0, Timeout expired [SQLSTA
TE
HYT00]
2004-06-28 08:50:06 - ? [131] SQLAgent$DBSERVER service stopping due to
a
stop request from a user, process, or the OS...
2004-06-28 08:50:07 - ? [358] Mail session ended
2004-06-28 08:50:09 - ? [098] SQLServerAgent terminated (normally)
"Vikram Jayaram [MS]" <vikramj@.online.microsoft.com> wrote in message
news:N8GBxNPXEHA.328@.cpmsftngxa10.phx.gbl...
> 1. Is this the same server where the jobs are running?
> 2. Have you checked your SQL Agent logs for any more information on these
> error messages?
> 3. Can you connect to this named isntance using Query analyser, SEM, etc?
> 4. Was this sql server "moved" from another box, or any such thing?
> Thanks,
> Vikram Jayaram
> Microsoft, SQL Server
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.
>|||Did you ever figure out what caused this? I had the same problem a few days
ago. I restarted the server and that stopped the errors but I would like to
know the cause.
Sunday, February 19, 2012
Help with jobs failing
Hello,
I posted this message on 6/28 and am still looking for some help. I
apologize for the repost, however we cannot figure out the issue. For some
reason a couple of our jobs have been failing lately. We get the following
msg on the details of the job. Any ideas? This happens to jobs randomly.
Sometimes the jobs will work fine and other times we get the failed msg.
Thanks in advance.
Msg:
Unable to connect to SQL Server 'COMPUTERNAME\DBSERVER' . The step
failed.
SQLAGENT.OUT File
2004-08-23 16:31:30 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-08-23 16:31:30 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-08-23 16:32:15 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-23 16:32:15 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-08-23 16:32:15 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-23 16:32:15 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-08-23 16:32:16 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-23 16:32:16 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-08-23 16:32:16 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-23 16:32:16 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-08-24 03:01:52 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-24 03:01:52 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-08-24 03:01:52 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-24 03:01:52 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-24 03:01:52 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-08-24 03:31:36 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-24 03:31:36 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-08-24 04:01:46 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-24 04:01:54 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-24 04:02:02 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-24 04:02:02 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-08-24 04:02:02 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-24 04:02:02 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-08-24 04:03:02 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-24 04:03:02 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-08-24 05:31:11 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-24 05:31:11 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-08-24 05:31:11 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-24 05:31:11 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-08-24 05:31:11 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-24 05:31:11 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-08-24 06:03:37 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-24 06:03:42 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-24 06:03:43 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-24 06:04:24 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-24 06:04:24 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-08-24 06:04:52 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-24 06:04:52 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-08-24 06:05:07 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-24 06:05:07 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-08-24 06:05:25 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-24 06:05:25 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-08-24 06:05:30 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-24 06:05:37 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-24 06:05:43 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-08-24 06:08:02 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-24 06:08:02 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-08-24 06:35:02 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-24 06:35:07 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-08-24 06:35:07 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-24 06:35:12 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-08-24 06:36:05 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-24 06:36:05 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-08-24 06:36:06 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-24 06:36:06 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-08-24 07:01:37 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-24 07:01:37 - ! [382] Logon to server 'computername\DBSERVER' failed
(JobManager)
2004-08-24 07:01:46 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-24 07:01:46 - ! [382] Logon to server 'computername\DBSERVER' failed
(JobManager)
2004-08-24 07:01:57 - ! [298] SQLServer Error: 17, SQL Server does not exist
or access denied. [SQLSTATE 08001]
2004-08-24 07:01:57 - ! [298] SQLServer Error: 53, ConnectionOpen
(Connect()). [SQLSTATE 01000]
2004-08-24 07:01:57 - ! [382] Logon to server 'computername\DBSERVER' failed
(JobManager)
2004-08-24 07:03:31 - ! [298] SQLServer Error: 17, SQL Server does not exist
or access denied. [SQLSTATE 08001]
2004-08-24 07:03:31 - ! [298] SQLServer Error: 53, ConnectionOpen
(Connect()). [SQLSTATE 01000]
2004-08-24 07:03:31 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-08-24 07:05:17 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-24 07:05:17 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-08-24 07:05:17 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-25 03:01:51 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-25 03:31:47 - ! [298] SQLServer Error: 17, SQL Server does not exist
or access denied. [SQLSTATE 08001]
2004-08-25 03:31:47 - ! [298] SQLServer Error: 53, ConnectionOpen
(Connect()). [SQLSTATE 01000]
2004-08-25 04:01:08 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-25 04:01:08 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-08-25 04:31:51 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-25 04:31:51 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-08-25 04:31:51 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-25 04:31:51 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-08-25 05:00:20 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-25 05:14:05 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-25 06:58:22 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-25 06:58:23 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-08-25 06:59:26 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-25 07:31:42 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-25 07:31:42 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
What does the job do? Is it connection to a remote workstation that has
hard disks which hibernate? Are there jobs running on that workstation that
prevent a user to connect? Does that workstation do windows updates at
night and possibly self-reboots? More details are needed.
Jake wrote:
> Hello,
> I posted this message on 6/28 and am still looking for some help.
> I apologize for the repost, however we cannot figure out the issue.
> For some reason a couple of our jobs have been failing lately. We get
> the following msg on the details of the job. Any ideas? This happens
> to jobs randomly. Sometimes the jobs will work fine and other times
> we get the failed msg. Thanks in advance.
> Msg:
> Unable to connect to SQL Server 'COMPUTERNAME\DBSERVER' . The step
> failed.
> SQLAGENT.OUT File
> 2004-08-23 16:31:30 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-23 16:31:30 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-23 16:32:15 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-23 16:32:15 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-23 16:32:15 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-23 16:32:15 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-23 16:32:16 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-23 16:32:16 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-23 16:32:16 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-23 16:32:16 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-24 03:01:52 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-24 03:01:52 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-24 03:01:52 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-24 03:01:52 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-24 03:01:52 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-24 03:31:36 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-24 03:31:36 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-24 04:01:46 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-24 04:01:54 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-24 04:02:02 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-24 04:02:02 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-24 04:02:02 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-24 04:02:02 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-24 04:03:02 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-24 04:03:02 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-24 05:31:11 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-24 05:31:11 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-24 05:31:11 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-24 05:31:11 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-24 05:31:11 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-24 05:31:11 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-24 06:03:37 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-24 06:03:42 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-24 06:03:43 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-24 06:04:24 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-24 06:04:24 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-24 06:04:52 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-24 06:04:52 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-24 06:05:07 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-24 06:05:07 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-24 06:05:25 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-24 06:05:25 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-24 06:05:30 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-24 06:05:37 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-24 06:05:43 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-24 06:08:02 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-24 06:08:02 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-24 06:35:02 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-24 06:35:07 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-24 06:35:07 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-24 06:35:12 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-24 06:36:05 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-24 06:36:05 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-24 06:36:06 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-24 06:36:06 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-24 07:01:37 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-24 07:01:37 - ! [382] Logon to server 'computername\DBSERVER'
> failed (JobManager)
> 2004-08-24 07:01:46 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-24 07:01:46 - ! [382] Logon to server 'computername\DBSERVER'
> failed (JobManager)
> 2004-08-24 07:01:57 - ! [298] SQLServer Error: 17, SQL Server does
> not exist or access denied. [SQLSTATE 08001]
> 2004-08-24 07:01:57 - ! [298] SQLServer Error: 53, ConnectionOpen
> (Connect()). [SQLSTATE 01000]
> 2004-08-24 07:01:57 - ! [382] Logon to server 'computername\DBSERVER'
> failed (JobManager)
> 2004-08-24 07:03:31 - ! [298] SQLServer Error: 17, SQL Server does
> not exist or access denied. [SQLSTATE 08001]
> 2004-08-24 07:03:31 - ! [298] SQLServer Error: 53, ConnectionOpen
> (Connect()). [SQLSTATE 01000]
> 2004-08-24 07:03:31 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-24 07:05:17 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-24 07:05:17 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-24 07:05:17 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-25 03:01:51 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-25 03:31:47 - ! [298] SQLServer Error: 17, SQL Server does
> not exist or access denied. [SQLSTATE 08001]
> 2004-08-25 03:31:47 - ! [298] SQLServer Error: 53, ConnectionOpen
> (Connect()). [SQLSTATE 01000]
> 2004-08-25 04:01:08 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-25 04:01:08 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-25 04:31:51 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-25 04:31:51 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-25 04:31:51 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-25 04:31:51 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-25 05:00:20 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-25 05:14:05 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-25 06:58:22 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-25 06:58:23 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-25 06:59:26 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-25 07:31:42 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-25 07:31:42 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
|||Eric,
Thanks for the response.
"Eric Sabine" <mopar41@.hyotyt_mail_nounderscores.com> wrote in message
news:OTFKf1riEHA.4044@.tk2msftngp13.phx.gbl...
> What does the job do?
The jobs do multiple things. There isn't a specific job that keeps failing,
it's random. Most of out jobs are either moving data from one database to
another.
Is it connection to a remote workstation that has
> hard disks which hibernate?
The sql jobs are executing against the databases that are on the same server
as the sql agent trying to run the job. It's all one box.
>Are there jobs running on that workstation that prevent a user to connect?
Users are still able to connect via query anlyzer, website, etc... it's just
the jobs that are failing.
Does that workstation do windows updates at night and possibly self-reboots?
No it has the download automatically but not to install automatically. This
is a win2k3 box. SQL2k, SP3a
More details are needed.
>
>
> Jake wrote:
>
I posted this message on 6/28 and am still looking for some help. I
apologize for the repost, however we cannot figure out the issue. For some
reason a couple of our jobs have been failing lately. We get the following
msg on the details of the job. Any ideas? This happens to jobs randomly.
Sometimes the jobs will work fine and other times we get the failed msg.
Thanks in advance.
Msg:
Unable to connect to SQL Server 'COMPUTERNAME\DBSERVER' . The step
failed.
SQLAGENT.OUT File
2004-08-23 16:31:30 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-08-23 16:31:30 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-08-23 16:32:15 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-23 16:32:15 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-08-23 16:32:15 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-23 16:32:15 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-08-23 16:32:16 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-23 16:32:16 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-08-23 16:32:16 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-23 16:32:16 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-08-24 03:01:52 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-24 03:01:52 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-08-24 03:01:52 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-24 03:01:52 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-24 03:01:52 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-08-24 03:31:36 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-24 03:31:36 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-08-24 04:01:46 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-24 04:01:54 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-24 04:02:02 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-24 04:02:02 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-08-24 04:02:02 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-24 04:02:02 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-08-24 04:03:02 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-24 04:03:02 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-08-24 05:31:11 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-24 05:31:11 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-08-24 05:31:11 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-24 05:31:11 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-08-24 05:31:11 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-24 05:31:11 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-08-24 06:03:37 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-24 06:03:42 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-24 06:03:43 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-24 06:04:24 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-24 06:04:24 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-08-24 06:04:52 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-24 06:04:52 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-08-24 06:05:07 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-24 06:05:07 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-08-24 06:05:25 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-24 06:05:25 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-08-24 06:05:30 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-24 06:05:37 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-24 06:05:43 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-08-24 06:08:02 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-24 06:08:02 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-08-24 06:35:02 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-24 06:35:07 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-08-24 06:35:07 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-24 06:35:12 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-08-24 06:36:05 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-24 06:36:05 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-08-24 06:36:06 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-24 06:36:06 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-08-24 07:01:37 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-24 07:01:37 - ! [382] Logon to server 'computername\DBSERVER' failed
(JobManager)
2004-08-24 07:01:46 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-24 07:01:46 - ! [382] Logon to server 'computername\DBSERVER' failed
(JobManager)
2004-08-24 07:01:57 - ! [298] SQLServer Error: 17, SQL Server does not exist
or access denied. [SQLSTATE 08001]
2004-08-24 07:01:57 - ! [298] SQLServer Error: 53, ConnectionOpen
(Connect()). [SQLSTATE 01000]
2004-08-24 07:01:57 - ! [382] Logon to server 'computername\DBSERVER' failed
(JobManager)
2004-08-24 07:03:31 - ! [298] SQLServer Error: 17, SQL Server does not exist
or access denied. [SQLSTATE 08001]
2004-08-24 07:03:31 - ! [298] SQLServer Error: 53, ConnectionOpen
(Connect()). [SQLSTATE 01000]
2004-08-24 07:03:31 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-08-24 07:05:17 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-24 07:05:17 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-08-24 07:05:17 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-25 03:01:51 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-25 03:31:47 - ! [298] SQLServer Error: 17, SQL Server does not exist
or access denied. [SQLSTATE 08001]
2004-08-25 03:31:47 - ! [298] SQLServer Error: 53, ConnectionOpen
(Connect()). [SQLSTATE 01000]
2004-08-25 04:01:08 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-25 04:01:08 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-08-25 04:31:51 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-25 04:31:51 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-08-25 04:31:51 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-25 04:31:51 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-08-25 05:00:20 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-25 05:14:05 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-25 06:58:22 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-25 06:58:23 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-08-25 06:59:26 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-25 07:31:42 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-25 07:31:42 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
What does the job do? Is it connection to a remote workstation that has
hard disks which hibernate? Are there jobs running on that workstation that
prevent a user to connect? Does that workstation do windows updates at
night and possibly self-reboots? More details are needed.
Jake wrote:
> Hello,
> I posted this message on 6/28 and am still looking for some help.
> I apologize for the repost, however we cannot figure out the issue.
> For some reason a couple of our jobs have been failing lately. We get
> the following msg on the details of the job. Any ideas? This happens
> to jobs randomly. Sometimes the jobs will work fine and other times
> we get the failed msg. Thanks in advance.
> Msg:
> Unable to connect to SQL Server 'COMPUTERNAME\DBSERVER' . The step
> failed.
> SQLAGENT.OUT File
> 2004-08-23 16:31:30 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-23 16:31:30 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-23 16:32:15 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-23 16:32:15 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-23 16:32:15 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-23 16:32:15 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-23 16:32:16 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-23 16:32:16 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-23 16:32:16 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-23 16:32:16 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-24 03:01:52 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-24 03:01:52 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-24 03:01:52 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-24 03:01:52 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-24 03:01:52 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-24 03:31:36 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-24 03:31:36 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-24 04:01:46 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-24 04:01:54 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-24 04:02:02 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-24 04:02:02 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-24 04:02:02 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-24 04:02:02 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-24 04:03:02 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-24 04:03:02 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-24 05:31:11 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-24 05:31:11 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-24 05:31:11 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-24 05:31:11 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-24 05:31:11 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-24 05:31:11 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-24 06:03:37 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-24 06:03:42 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-24 06:03:43 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-24 06:04:24 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-24 06:04:24 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-24 06:04:52 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-24 06:04:52 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-24 06:05:07 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-24 06:05:07 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-24 06:05:25 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-24 06:05:25 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-24 06:05:30 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-24 06:05:37 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-24 06:05:43 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-24 06:08:02 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-24 06:08:02 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-24 06:35:02 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-24 06:35:07 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-24 06:35:07 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-24 06:35:12 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-24 06:36:05 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-24 06:36:05 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-24 06:36:06 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-24 06:36:06 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-24 07:01:37 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-24 07:01:37 - ! [382] Logon to server 'computername\DBSERVER'
> failed (JobManager)
> 2004-08-24 07:01:46 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-24 07:01:46 - ! [382] Logon to server 'computername\DBSERVER'
> failed (JobManager)
> 2004-08-24 07:01:57 - ! [298] SQLServer Error: 17, SQL Server does
> not exist or access denied. [SQLSTATE 08001]
> 2004-08-24 07:01:57 - ! [298] SQLServer Error: 53, ConnectionOpen
> (Connect()). [SQLSTATE 01000]
> 2004-08-24 07:01:57 - ! [382] Logon to server 'computername\DBSERVER'
> failed (JobManager)
> 2004-08-24 07:03:31 - ! [298] SQLServer Error: 17, SQL Server does
> not exist or access denied. [SQLSTATE 08001]
> 2004-08-24 07:03:31 - ! [298] SQLServer Error: 53, ConnectionOpen
> (Connect()). [SQLSTATE 01000]
> 2004-08-24 07:03:31 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-24 07:05:17 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-24 07:05:17 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-24 07:05:17 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-25 03:01:51 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-25 03:31:47 - ! [298] SQLServer Error: 17, SQL Server does
> not exist or access denied. [SQLSTATE 08001]
> 2004-08-25 03:31:47 - ! [298] SQLServer Error: 53, ConnectionOpen
> (Connect()). [SQLSTATE 01000]
> 2004-08-25 04:01:08 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-25 04:01:08 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-25 04:31:51 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-25 04:31:51 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-25 04:31:51 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-25 04:31:51 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-25 05:00:20 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-25 05:14:05 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-25 06:58:22 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-25 06:58:23 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-25 06:59:26 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-25 07:31:42 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-25 07:31:42 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
|||Eric,
Thanks for the response.
"Eric Sabine" <mopar41@.hyotyt_mail_nounderscores.com> wrote in message
news:OTFKf1riEHA.4044@.tk2msftngp13.phx.gbl...
> What does the job do?
The jobs do multiple things. There isn't a specific job that keeps failing,
it's random. Most of out jobs are either moving data from one database to
another.
Is it connection to a remote workstation that has
> hard disks which hibernate?
The sql jobs are executing against the databases that are on the same server
as the sql agent trying to run the job. It's all one box.
>Are there jobs running on that workstation that prevent a user to connect?
Users are still able to connect via query anlyzer, website, etc... it's just
the jobs that are failing.
Does that workstation do windows updates at night and possibly self-reboots?
No it has the download automatically but not to install automatically. This
is a win2k3 box. SQL2k, SP3a
More details are needed.
>
>
> Jake wrote:
>
Help with jobs failing
Hello,
I posted this message on 6/28 and am still looking for some help. I
apologize for the repost, however we cannot figure out the issue. For some
reason a couple of our jobs have been failing lately. We get the following
msg on the details of the job. Any ideas? This happens to jobs randomly.
Sometimes the jobs will work fine and other times we get the failed msg.
Thanks in advance.
Msg:
Unable to connect to SQL Server 'COMPUTERNAME\DBSERVER' . The step
failed.
SQLAGENT.OUT File
2004-08-23 16:31:30 - ! [382] Logon to server 'computername\DBSERVER' fa
iled
(ConnAttemptCachableOp)
2004-08-23 16:31:30 - ! [382] Logon to server 'computername\DBSERVER' fa
iled
(ConnAttemptCachableOp)
2004-08-23 16:32:15 - ! [165] ODBC Error: 0, Timeout expired [SQLSTA
TE
HYT00]
2004-08-23 16:32:15 - ! [382] Logon to server 'computername\DBSERVER' fa
iled
(ConnAttemptCachableOp)
2004-08-23 16:32:15 - ! [165] ODBC Error: 0, Timeout expired [SQLSTA
TE
HYT00]
2004-08-23 16:32:15 - ! [382] Logon to server 'computername\DBSERVER' fa
iled
(ConnAttemptCachableOp)
2004-08-23 16:32:16 - ! [165] ODBC Error: 0, Timeout expired [SQLSTA
TE
HYT00]
2004-08-23 16:32:16 - ! [382] Logon to server 'computername\DBSERVER' fa
iled
(ConnAttemptCachableOp)
2004-08-23 16:32:16 - ! [165] ODBC Error: 0, Timeout expired [SQLSTA
TE
HYT00]
2004-08-23 16:32:16 - ! [382] Logon to server 'computername\DBSERVER' fa
iled
(ConnAttemptCachableOp)
2004-08-24 03:01:52 - ! [165] ODBC Error: 0, Timeout expired [SQLSTA
TE
HYT00]
2004-08-24 03:01:52 - ! [382] Logon to server 'computername\DBSERVER' fa
iled
(ConnAttemptCachableOp)
2004-08-24 03:01:52 - ! [165] ODBC Error: 0, Timeout expired [SQLSTA
TE
HYT00]
2004-08-24 03:01:52 - ! [165] ODBC Error: 0, Timeout expired [SQLSTA
TE
HYT00]
2004-08-24 03:01:52 - ! [382] Logon to server 'computername\DBSERVER' fa
iled
(ConnAttemptCachableOp)
2004-08-24 03:31:36 - ! [165] ODBC Error: 0, Timeout expired [SQLSTA
TE
HYT00]
2004-08-24 03:31:36 - ! [382] Logon to server 'computername\DBSERVER' fa
iled
(ConnAttemptCachableOp)
2004-08-24 04:01:46 - ! [165] ODBC Error: 0, Timeout expired [SQLSTA
TE
HYT00]
2004-08-24 04:01:54 - ! [165] ODBC Error: 0, Timeout expired [SQLSTA
TE
HYT00]
2004-08-24 04:02:02 - ! [165] ODBC Error: 0, Timeout expired [SQLSTA
TE
HYT00]
2004-08-24 04:02:02 - ! [382] Logon to server 'computername\DBSERVER' fa
iled
(ConnAttemptCachableOp)
2004-08-24 04:02:02 - ! [165] ODBC Error: 0, Timeout expired [SQLSTA
TE
HYT00]
2004-08-24 04:02:02 - ! [382] Logon to server 'computername\DBSERVER' fa
iled
(ConnAttemptCachableOp)
2004-08-24 04:03:02 - ! [165] ODBC Error: 0, Timeout expired [SQLSTA
TE
HYT00]
2004-08-24 04:03:02 - ! [382] Logon to server 'computername\DBSERVER' fa
iled
(ConnAttemptCachableOp)
2004-08-24 05:31:11 - ! [165] ODBC Error: 0, Timeout expired [SQLSTA
TE
HYT00]
2004-08-24 05:31:11 - ! [382] Logon to server 'computername\DBSERVER' fa
iled
(ConnAttemptCachableOp)
2004-08-24 05:31:11 - ! [165] ODBC Error: 0, Timeout expired [SQLSTA
TE
HYT00]
2004-08-24 05:31:11 - ! [382] Logon to server 'computername\DBSERVER' fa
iled
(ConnAttemptCachableOp)
2004-08-24 05:31:11 - ! [165] ODBC Error: 0, Timeout expired [SQLSTA
TE
HYT00]
2004-08-24 05:31:11 - ! [382] Logon to server 'computername\DBSERVER' fa
iled
(ConnAttemptCachableOp)
2004-08-24 06:03:37 - ! [165] ODBC Error: 0, Timeout expired [SQLSTA
TE
HYT00]
2004-08-24 06:03:42 - ! [165] ODBC Error: 0, Timeout expired [SQLSTA
TE
HYT00]
2004-08-24 06:03:43 - ! [165] ODBC Error: 0, Timeout expired [SQLSTA
TE
HYT00]
2004-08-24 06:04:24 - ! [165] ODBC Error: 0, Timeout expired [SQLSTA
TE
HYT00]
2004-08-24 06:04:24 - ! [382] Logon to server 'computername\DBSERVER' fa
iled
(ConnAttemptCachableOp)
2004-08-24 06:04:52 - ! [165] ODBC Error: 0, Timeout expired [SQLSTA
TE
HYT00]
2004-08-24 06:04:52 - ! [382] Logon to server 'computername\DBSERVER' fa
iled
(ConnAttemptCachableOp)
2004-08-24 06:05:07 - ! [165] ODBC Error: 0, Timeout expired [SQLSTA
TE
HYT00]
2004-08-24 06:05:07 - ! [382] Logon to server 'computername\DBSERVER' fa
iled
(ConnAttemptCachableOp)
2004-08-24 06:05:25 - ! [165] ODBC Error: 0, Timeout expired [SQLSTA
TE
HYT00]
2004-08-24 06:05:25 - ! [382] Logon to server 'computername\DBSERVER' fa
iled
(ConnAttemptCachableOp)
2004-08-24 06:05:30 - ! [165] ODBC Error: 0, Timeout expired [SQLSTA
TE
HYT00]
2004-08-24 06:05:37 - ! [165] ODBC Error: 0, Timeout expired [SQLSTA
TE
HYT00]
2004-08-24 06:05:43 - ! [382] Logon to server 'computername\DBSERVER' fa
iled
(ConnAttemptCachableOp)
2004-08-24 06:08:02 - ! [165] ODBC Error: 0, Timeout expired [SQLSTA
TE
HYT00]
2004-08-24 06:08:02 - ! [382] Logon to server 'computername\DBSERVER' fa
iled
(ConnAttemptCachableOp)
2004-08-24 06:35:02 - ! [165] ODBC Error: 0, Timeout expired [SQLSTA
TE
HYT00]
2004-08-24 06:35:07 - ! [382] Logon to server 'computername\DBSERVER' fa
iled
(ConnAttemptCachableOp)
2004-08-24 06:35:07 - ! [165] ODBC Error: 0, Timeout expired [SQLSTA
TE
HYT00]
2004-08-24 06:35:12 - ! [382] Logon to server 'computername\DBSERVER' fa
iled
(ConnAttemptCachableOp)
2004-08-24 06:36:05 - ! [165] ODBC Error: 0, Timeout expired [SQLSTA
TE
HYT00]
2004-08-24 06:36:05 - ! [382] Logon to server 'computername\DBSERVER' fa
iled
(ConnAttemptCachableOp)
2004-08-24 06:36:06 - ! [165] ODBC Error: 0, Timeout expired [SQLSTA
TE
HYT00]
2004-08-24 06:36:06 - ! [382] Logon to server 'computername\DBSERVER' fa
iled
(ConnAttemptCachableOp)
2004-08-24 07:01:37 - ! [165] ODBC Error: 0, Timeout expired [SQLSTA
TE
HYT00]
2004-08-24 07:01:37 - ! [382] Logon to server 'computername\DBSERVER' fa
iled
(JobManager)
2004-08-24 07:01:46 - ! [165] ODBC Error: 0, Timeout expired [SQLSTA
TE
HYT00]
2004-08-24 07:01:46 - ! [382] Logon to server 'computername\DBSERVER' fa
iled
(JobManager)
2004-08-24 07:01:57 - ! [298] SQLServer Error: 17, SQL Server does not e
xist
or access denied. [SQLSTATE 08001]
2004-08-24 07:01:57 - ! [298] SQLServer Error: 53, ConnectionOpen
(Connect()). [SQLSTATE 01000]
2004-08-24 07:01:57 - ! [382] Logon to server 'computername\DBSERVER' fa
iled
(JobManager)
2004-08-24 07:03:31 - ! [298] SQLServer Error: 17, SQL Server does not e
xist
or access denied. [SQLSTATE 08001]
2004-08-24 07:03:31 - ! [298] SQLServer Error: 53, ConnectionOpen
(Connect()). [SQLSTATE 01000]
2004-08-24 07:03:31 - ! [382] Logon to server 'computername\DBSERVER' fa
iled
(ConnAttemptCachableOp)
2004-08-24 07:05:17 - ! [165] ODBC Error: 0, Timeout expired [SQLSTA
TE
HYT00]
2004-08-24 07:05:17 - ! [382] Logon to server 'computername\DBSERVER' fa
iled
(ConnAttemptCachableOp)
2004-08-24 07:05:17 - ! [165] ODBC Error: 0, Timeout expired [SQLSTA
TE
HYT00]
2004-08-25 03:01:51 - ! [165] ODBC Error: 0, Timeout expired [SQLSTA
TE
HYT00]
2004-08-25 03:31:47 - ! [298] SQLServer Error: 17, SQL Server does not e
xist
or access denied. [SQLSTATE 08001]
2004-08-25 03:31:47 - ! [298] SQLServer Error: 53, ConnectionOpen
(Connect()). [SQLSTATE 01000]
2004-08-25 04:01:08 - ! [165] ODBC Error: 0, Timeout expired [SQLSTA
TE
HYT00]
2004-08-25 04:01:08 - ! [382] Logon to server 'computername\DBSERVER' fa
iled
(ConnAttemptCachableOp)
2004-08-25 04:31:51 - ! [165] ODBC Error: 0, Timeout expired [SQLSTA
TE
HYT00]
2004-08-25 04:31:51 - ! [382] Logon to server 'computername\DBSERVER' fa
iled
(ConnAttemptCachableOp)
2004-08-25 04:31:51 - ! [165] ODBC Error: 0, Timeout expired [SQLSTA
TE
HYT00]
2004-08-25 04:31:51 - ! [382] Logon to server 'computername\DBSERVER' fa
iled
(ConnAttemptCachableOp)
2004-08-25 05:00:20 - ! [165] ODBC Error: 0, Timeout expired [SQLSTA
TE
HYT00]
2004-08-25 05:14:05 - ! [165] ODBC Error: 0, Timeout expired [SQLSTA
TE
HYT00]
2004-08-25 06:58:22 - ! [165] ODBC Error: 0, Timeout expired [SQLSTA
TE
HYT00]
2004-08-25 06:58:23 - ! [382] Logon to server 'computername\DBSERVER' fa
iled
(ConnAttemptCachableOp)
2004-08-25 06:59:26 - ! [165] ODBC Error: 0, Timeout expired [SQLSTA
TE
HYT00]
2004-08-25 07:31:42 - ! [165] ODBC Error: 0, Timeout expired [SQLSTA
TE
HYT00]
2004-08-25 07:31:42 - ! [382] Logon to server 'computername\DBSERVER' fa
iled
(ConnAttemptCachableOp)What does the job do? Is it connection to a remote workstation that has
hard disks which hibernate? Are there jobs running on that workstation that
prevent a user to connect? Does that workstation do windows updates at
night and possibly self-reboots? More details are needed.
Jake wrote:
> Hello,
> I posted this message on 6/28 and am still looking for some help.
> I apologize for the repost, however we cannot figure out the issue.
> For some reason a couple of our jobs have been failing lately. We get
> the following msg on the details of the job. Any ideas? This happens
> to jobs randomly. Sometimes the jobs will work fine and other times
> we get the failed msg. Thanks in advance.
> Msg:
> Unable to connect to SQL Server 'COMPUTERNAME\DBSERVER' . The step
> failed.
> SQLAGENT.OUT File
> 2004-08-23 16:31:30 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-23 16:31:30 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-23 16:32:15 - ! [165] ODBC Error: 0, Timeout expired [SQLS
TATE
> HYT00]
> 2004-08-23 16:32:15 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-23 16:32:15 - ! [165] ODBC Error: 0, Timeout expired [SQLS
TATE
> HYT00]
> 2004-08-23 16:32:15 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-23 16:32:16 - ! [165] ODBC Error: 0, Timeout expired [SQLS
TATE
> HYT00]
> 2004-08-23 16:32:16 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-23 16:32:16 - ! [165] ODBC Error: 0, Timeout expired [SQLS
TATE
> HYT00]
> 2004-08-23 16:32:16 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-24 03:01:52 - ! [165] ODBC Error: 0, Timeout expired [SQLS
TATE
> HYT00]
> 2004-08-24 03:01:52 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-24 03:01:52 - ! [165] ODBC Error: 0, Timeout expired [SQLS
TATE
> HYT00]
> 2004-08-24 03:01:52 - ! [165] ODBC Error: 0, Timeout expired [SQLS
TATE
> HYT00]
> 2004-08-24 03:01:52 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-24 03:31:36 - ! [165] ODBC Error: 0, Timeout expired [SQLS
TATE
> HYT00]
> 2004-08-24 03:31:36 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-24 04:01:46 - ! [165] ODBC Error: 0, Timeout expired [SQLS
TATE
> HYT00]
> 2004-08-24 04:01:54 - ! [165] ODBC Error: 0, Timeout expired [SQLS
TATE
> HYT00]
> 2004-08-24 04:02:02 - ! [165] ODBC Error: 0, Timeout expired [SQLS
TATE
> HYT00]
> 2004-08-24 04:02:02 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-24 04:02:02 - ! [165] ODBC Error: 0, Timeout expired [SQLS
TATE
> HYT00]
> 2004-08-24 04:02:02 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-24 04:03:02 - ! [165] ODBC Error: 0, Timeout expired [SQLS
TATE
> HYT00]
> 2004-08-24 04:03:02 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-24 05:31:11 - ! [165] ODBC Error: 0, Timeout expired [SQLS
TATE
> HYT00]
> 2004-08-24 05:31:11 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-24 05:31:11 - ! [165] ODBC Error: 0, Timeout expired [SQLS
TATE
> HYT00]
> 2004-08-24 05:31:11 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-24 05:31:11 - ! [165] ODBC Error: 0, Timeout expired [SQLS
TATE
> HYT00]
> 2004-08-24 05:31:11 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-24 06:03:37 - ! [165] ODBC Error: 0, Timeout expired [SQLS
TATE
> HYT00]
> 2004-08-24 06:03:42 - ! [165] ODBC Error: 0, Timeout expired [SQLS
TATE
> HYT00]
> 2004-08-24 06:03:43 - ! [165] ODBC Error: 0, Timeout expired [SQLS
TATE
> HYT00]
> 2004-08-24 06:04:24 - ! [165] ODBC Error: 0, Timeout expired [SQLS
TATE
> HYT00]
> 2004-08-24 06:04:24 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-24 06:04:52 - ! [165] ODBC Error: 0, Timeout expired [SQLS
TATE
> HYT00]
> 2004-08-24 06:04:52 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-24 06:05:07 - ! [165] ODBC Error: 0, Timeout expired [SQLS
TATE
> HYT00]
> 2004-08-24 06:05:07 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-24 06:05:25 - ! [165] ODBC Error: 0, Timeout expired [SQLS
TATE
> HYT00]
> 2004-08-24 06:05:25 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-24 06:05:30 - ! [165] ODBC Error: 0, Timeout expired [SQLS
TATE
> HYT00]
> 2004-08-24 06:05:37 - ! [165] ODBC Error: 0, Timeout expired [SQLS
TATE
> HYT00]
> 2004-08-24 06:05:43 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-24 06:08:02 - ! [165] ODBC Error: 0, Timeout expired [SQLS
TATE
> HYT00]
> 2004-08-24 06:08:02 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-24 06:35:02 - ! [165] ODBC Error: 0, Timeout expired [SQLS
TATE
> HYT00]
> 2004-08-24 06:35:07 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-24 06:35:07 - ! [165] ODBC Error: 0, Timeout expired [SQLS
TATE
> HYT00]
> 2004-08-24 06:35:12 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-24 06:36:05 - ! [165] ODBC Error: 0, Timeout expired [SQLS
TATE
> HYT00]
> 2004-08-24 06:36:05 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-24 06:36:06 - ! [165] ODBC Error: 0, Timeout expired [SQLS
TATE
> HYT00]
> 2004-08-24 06:36:06 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-24 07:01:37 - ! [165] ODBC Error: 0, Timeout expired [SQLS
TATE
> HYT00]
> 2004-08-24 07:01:37 - ! [382] Logon to server 'computername\DBSERVER'
> failed (JobManager)
> 2004-08-24 07:01:46 - ! [165] ODBC Error: 0, Timeout expired [SQLS
TATE
> HYT00]
> 2004-08-24 07:01:46 - ! [382] Logon to server 'computername\DBSERVER'
> failed (JobManager)
> 2004-08-24 07:01:57 - ! [298] SQLServer Error: 17, SQL Server does
> not exist or access denied. [SQLSTATE 08001]
> 2004-08-24 07:01:57 - ! [298] SQLServer Error: 53, ConnectionOpen
> (Connect()). [SQLSTATE 01000]
> 2004-08-24 07:01:57 - ! [382] Logon to server 'computername\DBSERVER'
> failed (JobManager)
> 2004-08-24 07:03:31 - ! [298] SQLServer Error: 17, SQL Server does
> not exist or access denied. [SQLSTATE 08001]
> 2004-08-24 07:03:31 - ! [298] SQLServer Error: 53, ConnectionOpen
> (Connect()). [SQLSTATE 01000]
> 2004-08-24 07:03:31 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-24 07:05:17 - ! [165] ODBC Error: 0, Timeout expired [SQLS
TATE
> HYT00]
> 2004-08-24 07:05:17 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-24 07:05:17 - ! [165] ODBC Error: 0, Timeout expired [SQLS
TATE
> HYT00]
> 2004-08-25 03:01:51 - ! [165] ODBC Error: 0, Timeout expired [SQLS
TATE
> HYT00]
> 2004-08-25 03:31:47 - ! [298] SQLServer Error: 17, SQL Server does
> not exist or access denied. [SQLSTATE 08001]
> 2004-08-25 03:31:47 - ! [298] SQLServer Error: 53, ConnectionOpen
> (Connect()). [SQLSTATE 01000]
> 2004-08-25 04:01:08 - ! [165] ODBC Error: 0, Timeout expired [SQLS
TATE
> HYT00]
> 2004-08-25 04:01:08 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-25 04:31:51 - ! [165] ODBC Error: 0, Timeout expired [SQLS
TATE
> HYT00]
> 2004-08-25 04:31:51 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-25 04:31:51 - ! [165] ODBC Error: 0, Timeout expired [SQLS
TATE
> HYT00]
> 2004-08-25 04:31:51 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-25 05:00:20 - ! [165] ODBC Error: 0, Timeout expired [SQLS
TATE
> HYT00]
> 2004-08-25 05:14:05 - ! [165] ODBC Error: 0, Timeout expired [SQLS
TATE
> HYT00]
> 2004-08-25 06:58:22 - ! [165] ODBC Error: 0, Timeout expired [SQLS
TATE
> HYT00]
> 2004-08-25 06:58:23 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-25 06:59:26 - ! [165] ODBC Error: 0, Timeout expired [SQLS
TATE
> HYT00]
> 2004-08-25 07:31:42 - ! [165] ODBC Error: 0, Timeout expired [SQLS
TATE
> HYT00]
> 2004-08-25 07:31:42 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)|||Eric,
Thanks for the response.
"Eric Sabine" <mopar41@.hyotyt_mail_nounderscores.com> wrote in message
news:OTFKf1riEHA.4044@.tk2msftngp13.phx.gbl...
> What does the job do?
The jobs do multiple things. There isn't a specific job that keeps failing,
it's random. Most of out jobs are either moving data from one database to
another.
Is it connection to a remote workstation that has
> hard disks which hibernate?
The sql jobs are executing against the databases that are on the same server
as the sql agent trying to run the job. It's all one box.
>Are there jobs running on that workstation that prevent a user to connect?
Users are still able to connect via query anlyzer, website, etc... it's just
the jobs that are failing.
Does that workstation do windows updates at night and possibly self-reboots?
No it has the download automatically but not to install automatically. This
is a win2k3 box. SQL2k, SP3a
More details are needed.
>
>
> Jake wrote:
>
I posted this message on 6/28 and am still looking for some help. I
apologize for the repost, however we cannot figure out the issue. For some
reason a couple of our jobs have been failing lately. We get the following
msg on the details of the job. Any ideas? This happens to jobs randomly.
Sometimes the jobs will work fine and other times we get the failed msg.
Thanks in advance.
Msg:
Unable to connect to SQL Server 'COMPUTERNAME\DBSERVER' . The step
failed.
SQLAGENT.OUT File
2004-08-23 16:31:30 - ! [382] Logon to server 'computername\DBSERVER' fa
iled
(ConnAttemptCachableOp)
2004-08-23 16:31:30 - ! [382] Logon to server 'computername\DBSERVER' fa
iled
(ConnAttemptCachableOp)
2004-08-23 16:32:15 - ! [165] ODBC Error: 0, Timeout expired [SQLSTA
TE
HYT00]
2004-08-23 16:32:15 - ! [382] Logon to server 'computername\DBSERVER' fa
iled
(ConnAttemptCachableOp)
2004-08-23 16:32:15 - ! [165] ODBC Error: 0, Timeout expired [SQLSTA
TE
HYT00]
2004-08-23 16:32:15 - ! [382] Logon to server 'computername\DBSERVER' fa
iled
(ConnAttemptCachableOp)
2004-08-23 16:32:16 - ! [165] ODBC Error: 0, Timeout expired [SQLSTA
TE
HYT00]
2004-08-23 16:32:16 - ! [382] Logon to server 'computername\DBSERVER' fa
iled
(ConnAttemptCachableOp)
2004-08-23 16:32:16 - ! [165] ODBC Error: 0, Timeout expired [SQLSTA
TE
HYT00]
2004-08-23 16:32:16 - ! [382] Logon to server 'computername\DBSERVER' fa
iled
(ConnAttemptCachableOp)
2004-08-24 03:01:52 - ! [165] ODBC Error: 0, Timeout expired [SQLSTA
TE
HYT00]
2004-08-24 03:01:52 - ! [382] Logon to server 'computername\DBSERVER' fa
iled
(ConnAttemptCachableOp)
2004-08-24 03:01:52 - ! [165] ODBC Error: 0, Timeout expired [SQLSTA
TE
HYT00]
2004-08-24 03:01:52 - ! [165] ODBC Error: 0, Timeout expired [SQLSTA
TE
HYT00]
2004-08-24 03:01:52 - ! [382] Logon to server 'computername\DBSERVER' fa
iled
(ConnAttemptCachableOp)
2004-08-24 03:31:36 - ! [165] ODBC Error: 0, Timeout expired [SQLSTA
TE
HYT00]
2004-08-24 03:31:36 - ! [382] Logon to server 'computername\DBSERVER' fa
iled
(ConnAttemptCachableOp)
2004-08-24 04:01:46 - ! [165] ODBC Error: 0, Timeout expired [SQLSTA
TE
HYT00]
2004-08-24 04:01:54 - ! [165] ODBC Error: 0, Timeout expired [SQLSTA
TE
HYT00]
2004-08-24 04:02:02 - ! [165] ODBC Error: 0, Timeout expired [SQLSTA
TE
HYT00]
2004-08-24 04:02:02 - ! [382] Logon to server 'computername\DBSERVER' fa
iled
(ConnAttemptCachableOp)
2004-08-24 04:02:02 - ! [165] ODBC Error: 0, Timeout expired [SQLSTA
TE
HYT00]
2004-08-24 04:02:02 - ! [382] Logon to server 'computername\DBSERVER' fa
iled
(ConnAttemptCachableOp)
2004-08-24 04:03:02 - ! [165] ODBC Error: 0, Timeout expired [SQLSTA
TE
HYT00]
2004-08-24 04:03:02 - ! [382] Logon to server 'computername\DBSERVER' fa
iled
(ConnAttemptCachableOp)
2004-08-24 05:31:11 - ! [165] ODBC Error: 0, Timeout expired [SQLSTA
TE
HYT00]
2004-08-24 05:31:11 - ! [382] Logon to server 'computername\DBSERVER' fa
iled
(ConnAttemptCachableOp)
2004-08-24 05:31:11 - ! [165] ODBC Error: 0, Timeout expired [SQLSTA
TE
HYT00]
2004-08-24 05:31:11 - ! [382] Logon to server 'computername\DBSERVER' fa
iled
(ConnAttemptCachableOp)
2004-08-24 05:31:11 - ! [165] ODBC Error: 0, Timeout expired [SQLSTA
TE
HYT00]
2004-08-24 05:31:11 - ! [382] Logon to server 'computername\DBSERVER' fa
iled
(ConnAttemptCachableOp)
2004-08-24 06:03:37 - ! [165] ODBC Error: 0, Timeout expired [SQLSTA
TE
HYT00]
2004-08-24 06:03:42 - ! [165] ODBC Error: 0, Timeout expired [SQLSTA
TE
HYT00]
2004-08-24 06:03:43 - ! [165] ODBC Error: 0, Timeout expired [SQLSTA
TE
HYT00]
2004-08-24 06:04:24 - ! [165] ODBC Error: 0, Timeout expired [SQLSTA
TE
HYT00]
2004-08-24 06:04:24 - ! [382] Logon to server 'computername\DBSERVER' fa
iled
(ConnAttemptCachableOp)
2004-08-24 06:04:52 - ! [165] ODBC Error: 0, Timeout expired [SQLSTA
TE
HYT00]
2004-08-24 06:04:52 - ! [382] Logon to server 'computername\DBSERVER' fa
iled
(ConnAttemptCachableOp)
2004-08-24 06:05:07 - ! [165] ODBC Error: 0, Timeout expired [SQLSTA
TE
HYT00]
2004-08-24 06:05:07 - ! [382] Logon to server 'computername\DBSERVER' fa
iled
(ConnAttemptCachableOp)
2004-08-24 06:05:25 - ! [165] ODBC Error: 0, Timeout expired [SQLSTA
TE
HYT00]
2004-08-24 06:05:25 - ! [382] Logon to server 'computername\DBSERVER' fa
iled
(ConnAttemptCachableOp)
2004-08-24 06:05:30 - ! [165] ODBC Error: 0, Timeout expired [SQLSTA
TE
HYT00]
2004-08-24 06:05:37 - ! [165] ODBC Error: 0, Timeout expired [SQLSTA
TE
HYT00]
2004-08-24 06:05:43 - ! [382] Logon to server 'computername\DBSERVER' fa
iled
(ConnAttemptCachableOp)
2004-08-24 06:08:02 - ! [165] ODBC Error: 0, Timeout expired [SQLSTA
TE
HYT00]
2004-08-24 06:08:02 - ! [382] Logon to server 'computername\DBSERVER' fa
iled
(ConnAttemptCachableOp)
2004-08-24 06:35:02 - ! [165] ODBC Error: 0, Timeout expired [SQLSTA
TE
HYT00]
2004-08-24 06:35:07 - ! [382] Logon to server 'computername\DBSERVER' fa
iled
(ConnAttemptCachableOp)
2004-08-24 06:35:07 - ! [165] ODBC Error: 0, Timeout expired [SQLSTA
TE
HYT00]
2004-08-24 06:35:12 - ! [382] Logon to server 'computername\DBSERVER' fa
iled
(ConnAttemptCachableOp)
2004-08-24 06:36:05 - ! [165] ODBC Error: 0, Timeout expired [SQLSTA
TE
HYT00]
2004-08-24 06:36:05 - ! [382] Logon to server 'computername\DBSERVER' fa
iled
(ConnAttemptCachableOp)
2004-08-24 06:36:06 - ! [165] ODBC Error: 0, Timeout expired [SQLSTA
TE
HYT00]
2004-08-24 06:36:06 - ! [382] Logon to server 'computername\DBSERVER' fa
iled
(ConnAttemptCachableOp)
2004-08-24 07:01:37 - ! [165] ODBC Error: 0, Timeout expired [SQLSTA
TE
HYT00]
2004-08-24 07:01:37 - ! [382] Logon to server 'computername\DBSERVER' fa
iled
(JobManager)
2004-08-24 07:01:46 - ! [165] ODBC Error: 0, Timeout expired [SQLSTA
TE
HYT00]
2004-08-24 07:01:46 - ! [382] Logon to server 'computername\DBSERVER' fa
iled
(JobManager)
2004-08-24 07:01:57 - ! [298] SQLServer Error: 17, SQL Server does not e
xist
or access denied. [SQLSTATE 08001]
2004-08-24 07:01:57 - ! [298] SQLServer Error: 53, ConnectionOpen
(Connect()). [SQLSTATE 01000]
2004-08-24 07:01:57 - ! [382] Logon to server 'computername\DBSERVER' fa
iled
(JobManager)
2004-08-24 07:03:31 - ! [298] SQLServer Error: 17, SQL Server does not e
xist
or access denied. [SQLSTATE 08001]
2004-08-24 07:03:31 - ! [298] SQLServer Error: 53, ConnectionOpen
(Connect()). [SQLSTATE 01000]
2004-08-24 07:03:31 - ! [382] Logon to server 'computername\DBSERVER' fa
iled
(ConnAttemptCachableOp)
2004-08-24 07:05:17 - ! [165] ODBC Error: 0, Timeout expired [SQLSTA
TE
HYT00]
2004-08-24 07:05:17 - ! [382] Logon to server 'computername\DBSERVER' fa
iled
(ConnAttemptCachableOp)
2004-08-24 07:05:17 - ! [165] ODBC Error: 0, Timeout expired [SQLSTA
TE
HYT00]
2004-08-25 03:01:51 - ! [165] ODBC Error: 0, Timeout expired [SQLSTA
TE
HYT00]
2004-08-25 03:31:47 - ! [298] SQLServer Error: 17, SQL Server does not e
xist
or access denied. [SQLSTATE 08001]
2004-08-25 03:31:47 - ! [298] SQLServer Error: 53, ConnectionOpen
(Connect()). [SQLSTATE 01000]
2004-08-25 04:01:08 - ! [165] ODBC Error: 0, Timeout expired [SQLSTA
TE
HYT00]
2004-08-25 04:01:08 - ! [382] Logon to server 'computername\DBSERVER' fa
iled
(ConnAttemptCachableOp)
2004-08-25 04:31:51 - ! [165] ODBC Error: 0, Timeout expired [SQLSTA
TE
HYT00]
2004-08-25 04:31:51 - ! [382] Logon to server 'computername\DBSERVER' fa
iled
(ConnAttemptCachableOp)
2004-08-25 04:31:51 - ! [165] ODBC Error: 0, Timeout expired [SQLSTA
TE
HYT00]
2004-08-25 04:31:51 - ! [382] Logon to server 'computername\DBSERVER' fa
iled
(ConnAttemptCachableOp)
2004-08-25 05:00:20 - ! [165] ODBC Error: 0, Timeout expired [SQLSTA
TE
HYT00]
2004-08-25 05:14:05 - ! [165] ODBC Error: 0, Timeout expired [SQLSTA
TE
HYT00]
2004-08-25 06:58:22 - ! [165] ODBC Error: 0, Timeout expired [SQLSTA
TE
HYT00]
2004-08-25 06:58:23 - ! [382] Logon to server 'computername\DBSERVER' fa
iled
(ConnAttemptCachableOp)
2004-08-25 06:59:26 - ! [165] ODBC Error: 0, Timeout expired [SQLSTA
TE
HYT00]
2004-08-25 07:31:42 - ! [165] ODBC Error: 0, Timeout expired [SQLSTA
TE
HYT00]
2004-08-25 07:31:42 - ! [382] Logon to server 'computername\DBSERVER' fa
iled
(ConnAttemptCachableOp)What does the job do? Is it connection to a remote workstation that has
hard disks which hibernate? Are there jobs running on that workstation that
prevent a user to connect? Does that workstation do windows updates at
night and possibly self-reboots? More details are needed.
Jake wrote:
> Hello,
> I posted this message on 6/28 and am still looking for some help.
> I apologize for the repost, however we cannot figure out the issue.
> For some reason a couple of our jobs have been failing lately. We get
> the following msg on the details of the job. Any ideas? This happens
> to jobs randomly. Sometimes the jobs will work fine and other times
> we get the failed msg. Thanks in advance.
> Msg:
> Unable to connect to SQL Server 'COMPUTERNAME\DBSERVER' . The step
> failed.
> SQLAGENT.OUT File
> 2004-08-23 16:31:30 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-23 16:31:30 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-23 16:32:15 - ! [165] ODBC Error: 0, Timeout expired [SQLS
TATE
> HYT00]
> 2004-08-23 16:32:15 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-23 16:32:15 - ! [165] ODBC Error: 0, Timeout expired [SQLS
TATE
> HYT00]
> 2004-08-23 16:32:15 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-23 16:32:16 - ! [165] ODBC Error: 0, Timeout expired [SQLS
TATE
> HYT00]
> 2004-08-23 16:32:16 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-23 16:32:16 - ! [165] ODBC Error: 0, Timeout expired [SQLS
TATE
> HYT00]
> 2004-08-23 16:32:16 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-24 03:01:52 - ! [165] ODBC Error: 0, Timeout expired [SQLS
TATE
> HYT00]
> 2004-08-24 03:01:52 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-24 03:01:52 - ! [165] ODBC Error: 0, Timeout expired [SQLS
TATE
> HYT00]
> 2004-08-24 03:01:52 - ! [165] ODBC Error: 0, Timeout expired [SQLS
TATE
> HYT00]
> 2004-08-24 03:01:52 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-24 03:31:36 - ! [165] ODBC Error: 0, Timeout expired [SQLS
TATE
> HYT00]
> 2004-08-24 03:31:36 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-24 04:01:46 - ! [165] ODBC Error: 0, Timeout expired [SQLS
TATE
> HYT00]
> 2004-08-24 04:01:54 - ! [165] ODBC Error: 0, Timeout expired [SQLS
TATE
> HYT00]
> 2004-08-24 04:02:02 - ! [165] ODBC Error: 0, Timeout expired [SQLS
TATE
> HYT00]
> 2004-08-24 04:02:02 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-24 04:02:02 - ! [165] ODBC Error: 0, Timeout expired [SQLS
TATE
> HYT00]
> 2004-08-24 04:02:02 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-24 04:03:02 - ! [165] ODBC Error: 0, Timeout expired [SQLS
TATE
> HYT00]
> 2004-08-24 04:03:02 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-24 05:31:11 - ! [165] ODBC Error: 0, Timeout expired [SQLS
TATE
> HYT00]
> 2004-08-24 05:31:11 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-24 05:31:11 - ! [165] ODBC Error: 0, Timeout expired [SQLS
TATE
> HYT00]
> 2004-08-24 05:31:11 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-24 05:31:11 - ! [165] ODBC Error: 0, Timeout expired [SQLS
TATE
> HYT00]
> 2004-08-24 05:31:11 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-24 06:03:37 - ! [165] ODBC Error: 0, Timeout expired [SQLS
TATE
> HYT00]
> 2004-08-24 06:03:42 - ! [165] ODBC Error: 0, Timeout expired [SQLS
TATE
> HYT00]
> 2004-08-24 06:03:43 - ! [165] ODBC Error: 0, Timeout expired [SQLS
TATE
> HYT00]
> 2004-08-24 06:04:24 - ! [165] ODBC Error: 0, Timeout expired [SQLS
TATE
> HYT00]
> 2004-08-24 06:04:24 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-24 06:04:52 - ! [165] ODBC Error: 0, Timeout expired [SQLS
TATE
> HYT00]
> 2004-08-24 06:04:52 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-24 06:05:07 - ! [165] ODBC Error: 0, Timeout expired [SQLS
TATE
> HYT00]
> 2004-08-24 06:05:07 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-24 06:05:25 - ! [165] ODBC Error: 0, Timeout expired [SQLS
TATE
> HYT00]
> 2004-08-24 06:05:25 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-24 06:05:30 - ! [165] ODBC Error: 0, Timeout expired [SQLS
TATE
> HYT00]
> 2004-08-24 06:05:37 - ! [165] ODBC Error: 0, Timeout expired [SQLS
TATE
> HYT00]
> 2004-08-24 06:05:43 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-24 06:08:02 - ! [165] ODBC Error: 0, Timeout expired [SQLS
TATE
> HYT00]
> 2004-08-24 06:08:02 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-24 06:35:02 - ! [165] ODBC Error: 0, Timeout expired [SQLS
TATE
> HYT00]
> 2004-08-24 06:35:07 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-24 06:35:07 - ! [165] ODBC Error: 0, Timeout expired [SQLS
TATE
> HYT00]
> 2004-08-24 06:35:12 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-24 06:36:05 - ! [165] ODBC Error: 0, Timeout expired [SQLS
TATE
> HYT00]
> 2004-08-24 06:36:05 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-24 06:36:06 - ! [165] ODBC Error: 0, Timeout expired [SQLS
TATE
> HYT00]
> 2004-08-24 06:36:06 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-24 07:01:37 - ! [165] ODBC Error: 0, Timeout expired [SQLS
TATE
> HYT00]
> 2004-08-24 07:01:37 - ! [382] Logon to server 'computername\DBSERVER'
> failed (JobManager)
> 2004-08-24 07:01:46 - ! [165] ODBC Error: 0, Timeout expired [SQLS
TATE
> HYT00]
> 2004-08-24 07:01:46 - ! [382] Logon to server 'computername\DBSERVER'
> failed (JobManager)
> 2004-08-24 07:01:57 - ! [298] SQLServer Error: 17, SQL Server does
> not exist or access denied. [SQLSTATE 08001]
> 2004-08-24 07:01:57 - ! [298] SQLServer Error: 53, ConnectionOpen
> (Connect()). [SQLSTATE 01000]
> 2004-08-24 07:01:57 - ! [382] Logon to server 'computername\DBSERVER'
> failed (JobManager)
> 2004-08-24 07:03:31 - ! [298] SQLServer Error: 17, SQL Server does
> not exist or access denied. [SQLSTATE 08001]
> 2004-08-24 07:03:31 - ! [298] SQLServer Error: 53, ConnectionOpen
> (Connect()). [SQLSTATE 01000]
> 2004-08-24 07:03:31 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-24 07:05:17 - ! [165] ODBC Error: 0, Timeout expired [SQLS
TATE
> HYT00]
> 2004-08-24 07:05:17 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-24 07:05:17 - ! [165] ODBC Error: 0, Timeout expired [SQLS
TATE
> HYT00]
> 2004-08-25 03:01:51 - ! [165] ODBC Error: 0, Timeout expired [SQLS
TATE
> HYT00]
> 2004-08-25 03:31:47 - ! [298] SQLServer Error: 17, SQL Server does
> not exist or access denied. [SQLSTATE 08001]
> 2004-08-25 03:31:47 - ! [298] SQLServer Error: 53, ConnectionOpen
> (Connect()). [SQLSTATE 01000]
> 2004-08-25 04:01:08 - ! [165] ODBC Error: 0, Timeout expired [SQLS
TATE
> HYT00]
> 2004-08-25 04:01:08 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-25 04:31:51 - ! [165] ODBC Error: 0, Timeout expired [SQLS
TATE
> HYT00]
> 2004-08-25 04:31:51 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-25 04:31:51 - ! [165] ODBC Error: 0, Timeout expired [SQLS
TATE
> HYT00]
> 2004-08-25 04:31:51 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-25 05:00:20 - ! [165] ODBC Error: 0, Timeout expired [SQLS
TATE
> HYT00]
> 2004-08-25 05:14:05 - ! [165] ODBC Error: 0, Timeout expired [SQLS
TATE
> HYT00]
> 2004-08-25 06:58:22 - ! [165] ODBC Error: 0, Timeout expired [SQLS
TATE
> HYT00]
> 2004-08-25 06:58:23 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-25 06:59:26 - ! [165] ODBC Error: 0, Timeout expired [SQLS
TATE
> HYT00]
> 2004-08-25 07:31:42 - ! [165] ODBC Error: 0, Timeout expired [SQLS
TATE
> HYT00]
> 2004-08-25 07:31:42 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)|||Eric,
Thanks for the response.
"Eric Sabine" <mopar41@.hyotyt_mail_nounderscores.com> wrote in message
news:OTFKf1riEHA.4044@.tk2msftngp13.phx.gbl...
> What does the job do?
The jobs do multiple things. There isn't a specific job that keeps failing,
it's random. Most of out jobs are either moving data from one database to
another.
Is it connection to a remote workstation that has
> hard disks which hibernate?
The sql jobs are executing against the databases that are on the same server
as the sql agent trying to run the job. It's all one box.
>Are there jobs running on that workstation that prevent a user to connect?
Users are still able to connect via query anlyzer, website, etc... it's just
the jobs that are failing.
Does that workstation do windows updates at night and possibly self-reboots?
No it has the download automatically but not to install automatically. This
is a win2k3 box. SQL2k, SP3a
More details are needed.
>
>
> Jake wrote:
>
Help with jobs failing
Hello,
I posted this message on 6/28 and am still looking for some help. I
apologize for the repost, however we cannot figure out the issue. For some
reason a couple of our jobs have been failing lately. We get the following
msg on the details of the job. Any ideas? This happens to jobs randomly.
Sometimes the jobs will work fine and other times we get the failed msg.
Thanks in advance.
Msg:
Unable to connect to SQL Server 'COMPUTERNAME\DBSERVER' . The step
failed.
SQLAGENT.OUT File
2004-08-23 16:31:30 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-08-23 16:31:30 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-08-23 16:32:15 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-23 16:32:15 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-08-23 16:32:15 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-23 16:32:15 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-08-23 16:32:16 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-23 16:32:16 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-08-23 16:32:16 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-23 16:32:16 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-08-24 03:01:52 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-24 03:01:52 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-08-24 03:01:52 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-24 03:01:52 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-24 03:01:52 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-08-24 03:31:36 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-24 03:31:36 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-08-24 04:01:46 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-24 04:01:54 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-24 04:02:02 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-24 04:02:02 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-08-24 04:02:02 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-24 04:02:02 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-08-24 04:03:02 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-24 04:03:02 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-08-24 05:31:11 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-24 05:31:11 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-08-24 05:31:11 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-24 05:31:11 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-08-24 05:31:11 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-24 05:31:11 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-08-24 06:03:37 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-24 06:03:42 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-24 06:03:43 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-24 06:04:24 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-24 06:04:24 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-08-24 06:04:52 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-24 06:04:52 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-08-24 06:05:07 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-24 06:05:07 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-08-24 06:05:25 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-24 06:05:25 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-08-24 06:05:30 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-24 06:05:37 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-24 06:05:43 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-08-24 06:08:02 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-24 06:08:02 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-08-24 06:35:02 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-24 06:35:07 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-08-24 06:35:07 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-24 06:35:12 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-08-24 06:36:05 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-24 06:36:05 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-08-24 06:36:06 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-24 06:36:06 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-08-24 07:01:37 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-24 07:01:37 - ! [382] Logon to server 'computername\DBSERVER' failed
(JobManager)
2004-08-24 07:01:46 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-24 07:01:46 - ! [382] Logon to server 'computername\DBSERVER' failed
(JobManager)
2004-08-24 07:01:57 - ! [298] SQLServer Error: 17, SQL Server does not exist
or access denied. [SQLSTATE 08001]
2004-08-24 07:01:57 - ! [298] SQLServer Error: 53, ConnectionOpen
(Connect()). [SQLSTATE 01000]
2004-08-24 07:01:57 - ! [382] Logon to server 'computername\DBSERVER' failed
(JobManager)
2004-08-24 07:03:31 - ! [298] SQLServer Error: 17, SQL Server does not exist
or access denied. [SQLSTATE 08001]
2004-08-24 07:03:31 - ! [298] SQLServer Error: 53, ConnectionOpen
(Connect()). [SQLSTATE 01000]
2004-08-24 07:03:31 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-08-24 07:05:17 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-24 07:05:17 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-08-24 07:05:17 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-25 03:01:51 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-25 03:31:47 - ! [298] SQLServer Error: 17, SQL Server does not exist
or access denied. [SQLSTATE 08001]
2004-08-25 03:31:47 - ! [298] SQLServer Error: 53, ConnectionOpen
(Connect()). [SQLSTATE 01000]
2004-08-25 04:01:08 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-25 04:01:08 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-08-25 04:31:51 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-25 04:31:51 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-08-25 04:31:51 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-25 04:31:51 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-08-25 05:00:20 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-25 05:14:05 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-25 06:58:22 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-25 06:58:23 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-08-25 06:59:26 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-25 07:31:42 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-25 07:31:42 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)What does the job do? Is it connection to a remote workstation that has
hard disks which hibernate? Are there jobs running on that workstation that
prevent a user to connect? Does that workstation do windows updates at
night and possibly self-reboots? More details are needed.
Jake wrote:
> Hello,
> I posted this message on 6/28 and am still looking for some help.
> I apologize for the repost, however we cannot figure out the issue.
> For some reason a couple of our jobs have been failing lately. We get
> the following msg on the details of the job. Any ideas? This happens
> to jobs randomly. Sometimes the jobs will work fine and other times
> we get the failed msg. Thanks in advance.
> Msg:
> Unable to connect to SQL Server 'COMPUTERNAME\DBSERVER' . The step
> failed.
> SQLAGENT.OUT File
> 2004-08-23 16:31:30 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-23 16:31:30 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-23 16:32:15 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-23 16:32:15 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-23 16:32:15 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-23 16:32:15 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-23 16:32:16 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-23 16:32:16 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-23 16:32:16 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-23 16:32:16 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-24 03:01:52 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-24 03:01:52 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-24 03:01:52 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-24 03:01:52 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-24 03:01:52 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-24 03:31:36 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-24 03:31:36 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-24 04:01:46 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-24 04:01:54 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-24 04:02:02 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-24 04:02:02 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-24 04:02:02 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-24 04:02:02 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-24 04:03:02 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-24 04:03:02 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-24 05:31:11 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-24 05:31:11 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-24 05:31:11 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-24 05:31:11 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-24 05:31:11 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-24 05:31:11 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-24 06:03:37 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-24 06:03:42 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-24 06:03:43 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-24 06:04:24 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-24 06:04:24 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-24 06:04:52 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-24 06:04:52 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-24 06:05:07 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-24 06:05:07 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-24 06:05:25 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-24 06:05:25 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-24 06:05:30 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-24 06:05:37 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-24 06:05:43 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-24 06:08:02 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-24 06:08:02 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-24 06:35:02 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-24 06:35:07 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-24 06:35:07 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-24 06:35:12 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-24 06:36:05 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-24 06:36:05 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-24 06:36:06 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-24 06:36:06 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-24 07:01:37 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-24 07:01:37 - ! [382] Logon to server 'computername\DBSERVER'
> failed (JobManager)
> 2004-08-24 07:01:46 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-24 07:01:46 - ! [382] Logon to server 'computername\DBSERVER'
> failed (JobManager)
> 2004-08-24 07:01:57 - ! [298] SQLServer Error: 17, SQL Server does
> not exist or access denied. [SQLSTATE 08001]
> 2004-08-24 07:01:57 - ! [298] SQLServer Error: 53, ConnectionOpen
> (Connect()). [SQLSTATE 01000]
> 2004-08-24 07:01:57 - ! [382] Logon to server 'computername\DBSERVER'
> failed (JobManager)
> 2004-08-24 07:03:31 - ! [298] SQLServer Error: 17, SQL Server does
> not exist or access denied. [SQLSTATE 08001]
> 2004-08-24 07:03:31 - ! [298] SQLServer Error: 53, ConnectionOpen
> (Connect()). [SQLSTATE 01000]
> 2004-08-24 07:03:31 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-24 07:05:17 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-24 07:05:17 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-24 07:05:17 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-25 03:01:51 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-25 03:31:47 - ! [298] SQLServer Error: 17, SQL Server does
> not exist or access denied. [SQLSTATE 08001]
> 2004-08-25 03:31:47 - ! [298] SQLServer Error: 53, ConnectionOpen
> (Connect()). [SQLSTATE 01000]
> 2004-08-25 04:01:08 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-25 04:01:08 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-25 04:31:51 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-25 04:31:51 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-25 04:31:51 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-25 04:31:51 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-25 05:00:20 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-25 05:14:05 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-25 06:58:22 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-25 06:58:23 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-25 06:59:26 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-25 07:31:42 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-25 07:31:42 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)|||Eric,
Thanks for the response.
"Eric Sabine" <mopar41@.hyotyt_mail_nounderscores.com> wrote in message
news:OTFKf1riEHA.4044@.tk2msftngp13.phx.gbl...
> What does the job do?
The jobs do multiple things. There isn't a specific job that keeps failing,
it's random. Most of out jobs are either moving data from one database to
another.
Is it connection to a remote workstation that has
> hard disks which hibernate?
The sql jobs are executing against the databases that are on the same server
as the sql agent trying to run the job. It's all one box.
>Are there jobs running on that workstation that prevent a user to connect?
Users are still able to connect via query anlyzer, website, etc... it's just
the jobs that are failing.
Does that workstation do windows updates at night and possibly self-reboots?
No it has the download automatically but not to install automatically. This
is a win2k3 box. SQL2k, SP3a
More details are needed.
>
>
> Jake wrote:
> > Hello,
> >
> > I posted this message on 6/28 and am still looking for some help.
> > I apologize for the repost, however we cannot figure out the issue.
> > For some reason a couple of our jobs have been failing lately. We get
> > the following msg on the details of the job. Any ideas? This happens
> > to jobs randomly. Sometimes the jobs will work fine and other times
> > we get the failed msg. Thanks in advance.
> >
> > Msg:
> > Unable to connect to SQL Server 'COMPUTERNAME\DBSERVER' . The step
> > failed.
> >
> > SQLAGENT.OUT File
> > 2004-08-23 16:31:30 - ! [382] Logon to server 'computername\DBSERVER'
> > failed (ConnAttemptCachableOp)
> > 2004-08-23 16:31:30 - ! [382] Logon to server 'computername\DBSERVER'
> > failed (ConnAttemptCachableOp)
> > 2004-08-23 16:32:15 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> > HYT00]
> > 2004-08-23 16:32:15 - ! [382] Logon to server 'computername\DBSERVER'
> > failed (ConnAttemptCachableOp)
> > 2004-08-23 16:32:15 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> > HYT00]
> > 2004-08-23 16:32:15 - ! [382] Logon to server 'computername\DBSERVER'
> > failed (ConnAttemptCachableOp)
> > 2004-08-23 16:32:16 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> > HYT00]
> > 2004-08-23 16:32:16 - ! [382] Logon to server 'computername\DBSERVER'
> > failed (ConnAttemptCachableOp)
> > 2004-08-23 16:32:16 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> > HYT00]
> > 2004-08-23 16:32:16 - ! [382] Logon to server 'computername\DBSERVER'
> > failed (ConnAttemptCachableOp)
> > 2004-08-24 03:01:52 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> > HYT00]
> > 2004-08-24 03:01:52 - ! [382] Logon to server 'computername\DBSERVER'
> > failed (ConnAttemptCachableOp)
> > 2004-08-24 03:01:52 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> > HYT00]
> > 2004-08-24 03:01:52 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> > HYT00]
> > 2004-08-24 03:01:52 - ! [382] Logon to server 'computername\DBSERVER'
> > failed (ConnAttemptCachableOp)
> > 2004-08-24 03:31:36 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> > HYT00]
> > 2004-08-24 03:31:36 - ! [382] Logon to server 'computername\DBSERVER'
> > failed (ConnAttemptCachableOp)
> > 2004-08-24 04:01:46 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> > HYT00]
> > 2004-08-24 04:01:54 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> > HYT00]
> > 2004-08-24 04:02:02 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> > HYT00]
> > 2004-08-24 04:02:02 - ! [382] Logon to server 'computername\DBSERVER'
> > failed (ConnAttemptCachableOp)
> > 2004-08-24 04:02:02 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> > HYT00]
> > 2004-08-24 04:02:02 - ! [382] Logon to server 'computername\DBSERVER'
> > failed (ConnAttemptCachableOp)
> > 2004-08-24 04:03:02 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> > HYT00]
> > 2004-08-24 04:03:02 - ! [382] Logon to server 'computername\DBSERVER'
> > failed (ConnAttemptCachableOp)
> > 2004-08-24 05:31:11 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> > HYT00]
> > 2004-08-24 05:31:11 - ! [382] Logon to server 'computername\DBSERVER'
> > failed (ConnAttemptCachableOp)
> > 2004-08-24 05:31:11 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> > HYT00]
> > 2004-08-24 05:31:11 - ! [382] Logon to server 'computername\DBSERVER'
> > failed (ConnAttemptCachableOp)
> > 2004-08-24 05:31:11 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> > HYT00]
> > 2004-08-24 05:31:11 - ! [382] Logon to server 'computername\DBSERVER'
> > failed (ConnAttemptCachableOp)
> > 2004-08-24 06:03:37 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> > HYT00]
> > 2004-08-24 06:03:42 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> > HYT00]
> > 2004-08-24 06:03:43 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> > HYT00]
> > 2004-08-24 06:04:24 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> > HYT00]
> > 2004-08-24 06:04:24 - ! [382] Logon to server 'computername\DBSERVER'
> > failed (ConnAttemptCachableOp)
> > 2004-08-24 06:04:52 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> > HYT00]
> > 2004-08-24 06:04:52 - ! [382] Logon to server 'computername\DBSERVER'
> > failed (ConnAttemptCachableOp)
> > 2004-08-24 06:05:07 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> > HYT00]
> > 2004-08-24 06:05:07 - ! [382] Logon to server 'computername\DBSERVER'
> > failed (ConnAttemptCachableOp)
> > 2004-08-24 06:05:25 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> > HYT00]
> > 2004-08-24 06:05:25 - ! [382] Logon to server 'computername\DBSERVER'
> > failed (ConnAttemptCachableOp)
> > 2004-08-24 06:05:30 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> > HYT00]
> > 2004-08-24 06:05:37 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> > HYT00]
> > 2004-08-24 06:05:43 - ! [382] Logon to server 'computername\DBSERVER'
> > failed (ConnAttemptCachableOp)
> > 2004-08-24 06:08:02 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> > HYT00]
> > 2004-08-24 06:08:02 - ! [382] Logon to server 'computername\DBSERVER'
> > failed (ConnAttemptCachableOp)
> > 2004-08-24 06:35:02 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> > HYT00]
> > 2004-08-24 06:35:07 - ! [382] Logon to server 'computername\DBSERVER'
> > failed (ConnAttemptCachableOp)
> > 2004-08-24 06:35:07 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> > HYT00]
> > 2004-08-24 06:35:12 - ! [382] Logon to server 'computername\DBSERVER'
> > failed (ConnAttemptCachableOp)
> > 2004-08-24 06:36:05 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> > HYT00]
> > 2004-08-24 06:36:05 - ! [382] Logon to server 'computername\DBSERVER'
> > failed (ConnAttemptCachableOp)
> > 2004-08-24 06:36:06 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> > HYT00]
> > 2004-08-24 06:36:06 - ! [382] Logon to server 'computername\DBSERVER'
> > failed (ConnAttemptCachableOp)
> > 2004-08-24 07:01:37 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> > HYT00]
> > 2004-08-24 07:01:37 - ! [382] Logon to server 'computername\DBSERVER'
> > failed (JobManager)
> > 2004-08-24 07:01:46 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> > HYT00]
> > 2004-08-24 07:01:46 - ! [382] Logon to server 'computername\DBSERVER'
> > failed (JobManager)
> > 2004-08-24 07:01:57 - ! [298] SQLServer Error: 17, SQL Server does
> > not exist or access denied. [SQLSTATE 08001]
> > 2004-08-24 07:01:57 - ! [298] SQLServer Error: 53, ConnectionOpen
> > (Connect()). [SQLSTATE 01000]
> > 2004-08-24 07:01:57 - ! [382] Logon to server 'computername\DBSERVER'
> > failed (JobManager)
> > 2004-08-24 07:03:31 - ! [298] SQLServer Error: 17, SQL Server does
> > not exist or access denied. [SQLSTATE 08001]
> > 2004-08-24 07:03:31 - ! [298] SQLServer Error: 53, ConnectionOpen
> > (Connect()). [SQLSTATE 01000]
> > 2004-08-24 07:03:31 - ! [382] Logon to server 'computername\DBSERVER'
> > failed (ConnAttemptCachableOp)
> > 2004-08-24 07:05:17 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> > HYT00]
> > 2004-08-24 07:05:17 - ! [382] Logon to server 'computername\DBSERVER'
> > failed (ConnAttemptCachableOp)
> > 2004-08-24 07:05:17 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> > HYT00]
> > 2004-08-25 03:01:51 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> > HYT00]
> > 2004-08-25 03:31:47 - ! [298] SQLServer Error: 17, SQL Server does
> > not exist or access denied. [SQLSTATE 08001]
> > 2004-08-25 03:31:47 - ! [298] SQLServer Error: 53, ConnectionOpen
> > (Connect()). [SQLSTATE 01000]
> > 2004-08-25 04:01:08 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> > HYT00]
> > 2004-08-25 04:01:08 - ! [382] Logon to server 'computername\DBSERVER'
> > failed (ConnAttemptCachableOp)
> > 2004-08-25 04:31:51 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> > HYT00]
> > 2004-08-25 04:31:51 - ! [382] Logon to server 'computername\DBSERVER'
> > failed (ConnAttemptCachableOp)
> > 2004-08-25 04:31:51 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> > HYT00]
> > 2004-08-25 04:31:51 - ! [382] Logon to server 'computername\DBSERVER'
> > failed (ConnAttemptCachableOp)
> > 2004-08-25 05:00:20 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> > HYT00]
> > 2004-08-25 05:14:05 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> > HYT00]
> > 2004-08-25 06:58:22 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> > HYT00]
> > 2004-08-25 06:58:23 - ! [382] Logon to server 'computername\DBSERVER'
> > failed (ConnAttemptCachableOp)
> > 2004-08-25 06:59:26 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> > HYT00]
> > 2004-08-25 07:31:42 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> > HYT00]
> > 2004-08-25 07:31:42 - ! [382] Logon to server 'computername\DBSERVER'
> > failed (ConnAttemptCachableOp)
>
I posted this message on 6/28 and am still looking for some help. I
apologize for the repost, however we cannot figure out the issue. For some
reason a couple of our jobs have been failing lately. We get the following
msg on the details of the job. Any ideas? This happens to jobs randomly.
Sometimes the jobs will work fine and other times we get the failed msg.
Thanks in advance.
Msg:
Unable to connect to SQL Server 'COMPUTERNAME\DBSERVER' . The step
failed.
SQLAGENT.OUT File
2004-08-23 16:31:30 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-08-23 16:31:30 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-08-23 16:32:15 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-23 16:32:15 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-08-23 16:32:15 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-23 16:32:15 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-08-23 16:32:16 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-23 16:32:16 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-08-23 16:32:16 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-23 16:32:16 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-08-24 03:01:52 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-24 03:01:52 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-08-24 03:01:52 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-24 03:01:52 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-24 03:01:52 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-08-24 03:31:36 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-24 03:31:36 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-08-24 04:01:46 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-24 04:01:54 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-24 04:02:02 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-24 04:02:02 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-08-24 04:02:02 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-24 04:02:02 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-08-24 04:03:02 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-24 04:03:02 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-08-24 05:31:11 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-24 05:31:11 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-08-24 05:31:11 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-24 05:31:11 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-08-24 05:31:11 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-24 05:31:11 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-08-24 06:03:37 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-24 06:03:42 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-24 06:03:43 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-24 06:04:24 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-24 06:04:24 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-08-24 06:04:52 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-24 06:04:52 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-08-24 06:05:07 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-24 06:05:07 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-08-24 06:05:25 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-24 06:05:25 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-08-24 06:05:30 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-24 06:05:37 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-24 06:05:43 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-08-24 06:08:02 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-24 06:08:02 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-08-24 06:35:02 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-24 06:35:07 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-08-24 06:35:07 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-24 06:35:12 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-08-24 06:36:05 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-24 06:36:05 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-08-24 06:36:06 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-24 06:36:06 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-08-24 07:01:37 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-24 07:01:37 - ! [382] Logon to server 'computername\DBSERVER' failed
(JobManager)
2004-08-24 07:01:46 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-24 07:01:46 - ! [382] Logon to server 'computername\DBSERVER' failed
(JobManager)
2004-08-24 07:01:57 - ! [298] SQLServer Error: 17, SQL Server does not exist
or access denied. [SQLSTATE 08001]
2004-08-24 07:01:57 - ! [298] SQLServer Error: 53, ConnectionOpen
(Connect()). [SQLSTATE 01000]
2004-08-24 07:01:57 - ! [382] Logon to server 'computername\DBSERVER' failed
(JobManager)
2004-08-24 07:03:31 - ! [298] SQLServer Error: 17, SQL Server does not exist
or access denied. [SQLSTATE 08001]
2004-08-24 07:03:31 - ! [298] SQLServer Error: 53, ConnectionOpen
(Connect()). [SQLSTATE 01000]
2004-08-24 07:03:31 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-08-24 07:05:17 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-24 07:05:17 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-08-24 07:05:17 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-25 03:01:51 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-25 03:31:47 - ! [298] SQLServer Error: 17, SQL Server does not exist
or access denied. [SQLSTATE 08001]
2004-08-25 03:31:47 - ! [298] SQLServer Error: 53, ConnectionOpen
(Connect()). [SQLSTATE 01000]
2004-08-25 04:01:08 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-25 04:01:08 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-08-25 04:31:51 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-25 04:31:51 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-08-25 04:31:51 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-25 04:31:51 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-08-25 05:00:20 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-25 05:14:05 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-25 06:58:22 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-25 06:58:23 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)
2004-08-25 06:59:26 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-25 07:31:42 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
HYT00]
2004-08-25 07:31:42 - ! [382] Logon to server 'computername\DBSERVER' failed
(ConnAttemptCachableOp)What does the job do? Is it connection to a remote workstation that has
hard disks which hibernate? Are there jobs running on that workstation that
prevent a user to connect? Does that workstation do windows updates at
night and possibly self-reboots? More details are needed.
Jake wrote:
> Hello,
> I posted this message on 6/28 and am still looking for some help.
> I apologize for the repost, however we cannot figure out the issue.
> For some reason a couple of our jobs have been failing lately. We get
> the following msg on the details of the job. Any ideas? This happens
> to jobs randomly. Sometimes the jobs will work fine and other times
> we get the failed msg. Thanks in advance.
> Msg:
> Unable to connect to SQL Server 'COMPUTERNAME\DBSERVER' . The step
> failed.
> SQLAGENT.OUT File
> 2004-08-23 16:31:30 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-23 16:31:30 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-23 16:32:15 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-23 16:32:15 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-23 16:32:15 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-23 16:32:15 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-23 16:32:16 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-23 16:32:16 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-23 16:32:16 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-23 16:32:16 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-24 03:01:52 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-24 03:01:52 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-24 03:01:52 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-24 03:01:52 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-24 03:01:52 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-24 03:31:36 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-24 03:31:36 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-24 04:01:46 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-24 04:01:54 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-24 04:02:02 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-24 04:02:02 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-24 04:02:02 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-24 04:02:02 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-24 04:03:02 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-24 04:03:02 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-24 05:31:11 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-24 05:31:11 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-24 05:31:11 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-24 05:31:11 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-24 05:31:11 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-24 05:31:11 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-24 06:03:37 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-24 06:03:42 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-24 06:03:43 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-24 06:04:24 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-24 06:04:24 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-24 06:04:52 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-24 06:04:52 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-24 06:05:07 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-24 06:05:07 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-24 06:05:25 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-24 06:05:25 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-24 06:05:30 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-24 06:05:37 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-24 06:05:43 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-24 06:08:02 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-24 06:08:02 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-24 06:35:02 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-24 06:35:07 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-24 06:35:07 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-24 06:35:12 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-24 06:36:05 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-24 06:36:05 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-24 06:36:06 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-24 06:36:06 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-24 07:01:37 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-24 07:01:37 - ! [382] Logon to server 'computername\DBSERVER'
> failed (JobManager)
> 2004-08-24 07:01:46 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-24 07:01:46 - ! [382] Logon to server 'computername\DBSERVER'
> failed (JobManager)
> 2004-08-24 07:01:57 - ! [298] SQLServer Error: 17, SQL Server does
> not exist or access denied. [SQLSTATE 08001]
> 2004-08-24 07:01:57 - ! [298] SQLServer Error: 53, ConnectionOpen
> (Connect()). [SQLSTATE 01000]
> 2004-08-24 07:01:57 - ! [382] Logon to server 'computername\DBSERVER'
> failed (JobManager)
> 2004-08-24 07:03:31 - ! [298] SQLServer Error: 17, SQL Server does
> not exist or access denied. [SQLSTATE 08001]
> 2004-08-24 07:03:31 - ! [298] SQLServer Error: 53, ConnectionOpen
> (Connect()). [SQLSTATE 01000]
> 2004-08-24 07:03:31 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-24 07:05:17 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-24 07:05:17 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-24 07:05:17 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-25 03:01:51 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-25 03:31:47 - ! [298] SQLServer Error: 17, SQL Server does
> not exist or access denied. [SQLSTATE 08001]
> 2004-08-25 03:31:47 - ! [298] SQLServer Error: 53, ConnectionOpen
> (Connect()). [SQLSTATE 01000]
> 2004-08-25 04:01:08 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-25 04:01:08 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-25 04:31:51 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-25 04:31:51 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-25 04:31:51 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-25 04:31:51 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-25 05:00:20 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-25 05:14:05 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-25 06:58:22 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-25 06:58:23 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)
> 2004-08-25 06:59:26 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-25 07:31:42 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> HYT00]
> 2004-08-25 07:31:42 - ! [382] Logon to server 'computername\DBSERVER'
> failed (ConnAttemptCachableOp)|||Eric,
Thanks for the response.
"Eric Sabine" <mopar41@.hyotyt_mail_nounderscores.com> wrote in message
news:OTFKf1riEHA.4044@.tk2msftngp13.phx.gbl...
> What does the job do?
The jobs do multiple things. There isn't a specific job that keeps failing,
it's random. Most of out jobs are either moving data from one database to
another.
Is it connection to a remote workstation that has
> hard disks which hibernate?
The sql jobs are executing against the databases that are on the same server
as the sql agent trying to run the job. It's all one box.
>Are there jobs running on that workstation that prevent a user to connect?
Users are still able to connect via query anlyzer, website, etc... it's just
the jobs that are failing.
Does that workstation do windows updates at night and possibly self-reboots?
No it has the download automatically but not to install automatically. This
is a win2k3 box. SQL2k, SP3a
More details are needed.
>
>
> Jake wrote:
> > Hello,
> >
> > I posted this message on 6/28 and am still looking for some help.
> > I apologize for the repost, however we cannot figure out the issue.
> > For some reason a couple of our jobs have been failing lately. We get
> > the following msg on the details of the job. Any ideas? This happens
> > to jobs randomly. Sometimes the jobs will work fine and other times
> > we get the failed msg. Thanks in advance.
> >
> > Msg:
> > Unable to connect to SQL Server 'COMPUTERNAME\DBSERVER' . The step
> > failed.
> >
> > SQLAGENT.OUT File
> > 2004-08-23 16:31:30 - ! [382] Logon to server 'computername\DBSERVER'
> > failed (ConnAttemptCachableOp)
> > 2004-08-23 16:31:30 - ! [382] Logon to server 'computername\DBSERVER'
> > failed (ConnAttemptCachableOp)
> > 2004-08-23 16:32:15 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> > HYT00]
> > 2004-08-23 16:32:15 - ! [382] Logon to server 'computername\DBSERVER'
> > failed (ConnAttemptCachableOp)
> > 2004-08-23 16:32:15 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> > HYT00]
> > 2004-08-23 16:32:15 - ! [382] Logon to server 'computername\DBSERVER'
> > failed (ConnAttemptCachableOp)
> > 2004-08-23 16:32:16 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> > HYT00]
> > 2004-08-23 16:32:16 - ! [382] Logon to server 'computername\DBSERVER'
> > failed (ConnAttemptCachableOp)
> > 2004-08-23 16:32:16 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> > HYT00]
> > 2004-08-23 16:32:16 - ! [382] Logon to server 'computername\DBSERVER'
> > failed (ConnAttemptCachableOp)
> > 2004-08-24 03:01:52 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> > HYT00]
> > 2004-08-24 03:01:52 - ! [382] Logon to server 'computername\DBSERVER'
> > failed (ConnAttemptCachableOp)
> > 2004-08-24 03:01:52 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> > HYT00]
> > 2004-08-24 03:01:52 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> > HYT00]
> > 2004-08-24 03:01:52 - ! [382] Logon to server 'computername\DBSERVER'
> > failed (ConnAttemptCachableOp)
> > 2004-08-24 03:31:36 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> > HYT00]
> > 2004-08-24 03:31:36 - ! [382] Logon to server 'computername\DBSERVER'
> > failed (ConnAttemptCachableOp)
> > 2004-08-24 04:01:46 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> > HYT00]
> > 2004-08-24 04:01:54 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> > HYT00]
> > 2004-08-24 04:02:02 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> > HYT00]
> > 2004-08-24 04:02:02 - ! [382] Logon to server 'computername\DBSERVER'
> > failed (ConnAttemptCachableOp)
> > 2004-08-24 04:02:02 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> > HYT00]
> > 2004-08-24 04:02:02 - ! [382] Logon to server 'computername\DBSERVER'
> > failed (ConnAttemptCachableOp)
> > 2004-08-24 04:03:02 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> > HYT00]
> > 2004-08-24 04:03:02 - ! [382] Logon to server 'computername\DBSERVER'
> > failed (ConnAttemptCachableOp)
> > 2004-08-24 05:31:11 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> > HYT00]
> > 2004-08-24 05:31:11 - ! [382] Logon to server 'computername\DBSERVER'
> > failed (ConnAttemptCachableOp)
> > 2004-08-24 05:31:11 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> > HYT00]
> > 2004-08-24 05:31:11 - ! [382] Logon to server 'computername\DBSERVER'
> > failed (ConnAttemptCachableOp)
> > 2004-08-24 05:31:11 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> > HYT00]
> > 2004-08-24 05:31:11 - ! [382] Logon to server 'computername\DBSERVER'
> > failed (ConnAttemptCachableOp)
> > 2004-08-24 06:03:37 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> > HYT00]
> > 2004-08-24 06:03:42 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> > HYT00]
> > 2004-08-24 06:03:43 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> > HYT00]
> > 2004-08-24 06:04:24 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> > HYT00]
> > 2004-08-24 06:04:24 - ! [382] Logon to server 'computername\DBSERVER'
> > failed (ConnAttemptCachableOp)
> > 2004-08-24 06:04:52 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> > HYT00]
> > 2004-08-24 06:04:52 - ! [382] Logon to server 'computername\DBSERVER'
> > failed (ConnAttemptCachableOp)
> > 2004-08-24 06:05:07 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> > HYT00]
> > 2004-08-24 06:05:07 - ! [382] Logon to server 'computername\DBSERVER'
> > failed (ConnAttemptCachableOp)
> > 2004-08-24 06:05:25 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> > HYT00]
> > 2004-08-24 06:05:25 - ! [382] Logon to server 'computername\DBSERVER'
> > failed (ConnAttemptCachableOp)
> > 2004-08-24 06:05:30 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> > HYT00]
> > 2004-08-24 06:05:37 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> > HYT00]
> > 2004-08-24 06:05:43 - ! [382] Logon to server 'computername\DBSERVER'
> > failed (ConnAttemptCachableOp)
> > 2004-08-24 06:08:02 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> > HYT00]
> > 2004-08-24 06:08:02 - ! [382] Logon to server 'computername\DBSERVER'
> > failed (ConnAttemptCachableOp)
> > 2004-08-24 06:35:02 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> > HYT00]
> > 2004-08-24 06:35:07 - ! [382] Logon to server 'computername\DBSERVER'
> > failed (ConnAttemptCachableOp)
> > 2004-08-24 06:35:07 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> > HYT00]
> > 2004-08-24 06:35:12 - ! [382] Logon to server 'computername\DBSERVER'
> > failed (ConnAttemptCachableOp)
> > 2004-08-24 06:36:05 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> > HYT00]
> > 2004-08-24 06:36:05 - ! [382] Logon to server 'computername\DBSERVER'
> > failed (ConnAttemptCachableOp)
> > 2004-08-24 06:36:06 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> > HYT00]
> > 2004-08-24 06:36:06 - ! [382] Logon to server 'computername\DBSERVER'
> > failed (ConnAttemptCachableOp)
> > 2004-08-24 07:01:37 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> > HYT00]
> > 2004-08-24 07:01:37 - ! [382] Logon to server 'computername\DBSERVER'
> > failed (JobManager)
> > 2004-08-24 07:01:46 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> > HYT00]
> > 2004-08-24 07:01:46 - ! [382] Logon to server 'computername\DBSERVER'
> > failed (JobManager)
> > 2004-08-24 07:01:57 - ! [298] SQLServer Error: 17, SQL Server does
> > not exist or access denied. [SQLSTATE 08001]
> > 2004-08-24 07:01:57 - ! [298] SQLServer Error: 53, ConnectionOpen
> > (Connect()). [SQLSTATE 01000]
> > 2004-08-24 07:01:57 - ! [382] Logon to server 'computername\DBSERVER'
> > failed (JobManager)
> > 2004-08-24 07:03:31 - ! [298] SQLServer Error: 17, SQL Server does
> > not exist or access denied. [SQLSTATE 08001]
> > 2004-08-24 07:03:31 - ! [298] SQLServer Error: 53, ConnectionOpen
> > (Connect()). [SQLSTATE 01000]
> > 2004-08-24 07:03:31 - ! [382] Logon to server 'computername\DBSERVER'
> > failed (ConnAttemptCachableOp)
> > 2004-08-24 07:05:17 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> > HYT00]
> > 2004-08-24 07:05:17 - ! [382] Logon to server 'computername\DBSERVER'
> > failed (ConnAttemptCachableOp)
> > 2004-08-24 07:05:17 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> > HYT00]
> > 2004-08-25 03:01:51 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> > HYT00]
> > 2004-08-25 03:31:47 - ! [298] SQLServer Error: 17, SQL Server does
> > not exist or access denied. [SQLSTATE 08001]
> > 2004-08-25 03:31:47 - ! [298] SQLServer Error: 53, ConnectionOpen
> > (Connect()). [SQLSTATE 01000]
> > 2004-08-25 04:01:08 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> > HYT00]
> > 2004-08-25 04:01:08 - ! [382] Logon to server 'computername\DBSERVER'
> > failed (ConnAttemptCachableOp)
> > 2004-08-25 04:31:51 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> > HYT00]
> > 2004-08-25 04:31:51 - ! [382] Logon to server 'computername\DBSERVER'
> > failed (ConnAttemptCachableOp)
> > 2004-08-25 04:31:51 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> > HYT00]
> > 2004-08-25 04:31:51 - ! [382] Logon to server 'computername\DBSERVER'
> > failed (ConnAttemptCachableOp)
> > 2004-08-25 05:00:20 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> > HYT00]
> > 2004-08-25 05:14:05 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> > HYT00]
> > 2004-08-25 06:58:22 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> > HYT00]
> > 2004-08-25 06:58:23 - ! [382] Logon to server 'computername\DBSERVER'
> > failed (ConnAttemptCachableOp)
> > 2004-08-25 06:59:26 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> > HYT00]
> > 2004-08-25 07:31:42 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE
> > HYT00]
> > 2004-08-25 07:31:42 - ! [382] Logon to server 'computername\DBSERVER'
> > failed (ConnAttemptCachableOp)
>
Subscribe to:
Posts (Atom)