August 24, 2009 at 5:49 pm
Hi,
We have A/P Cluster setup of SQL Server 2005. We have a SQL Agent job which runs every 2 mins. This job has failed couple of times and I'm unable to find the root cause of failure.
Here I'm posting Application Event viewer error , System event viewer and the errors from SQLAGENT.OUT file. I have also configured database mail to send an email when a job fails BUT I did not get any email too!!
please advice me what will be the culprit..
1.Application Event viewer error
Event Type:Warning
Event Source:SQLAgent$INS1
Event Category:Job Engine
Event ID:208
Date:8/24/2009
Time:3:37:26 PM
User:N/A
Computer:INS1VS
Description:
SQL Server Scheduled Job Notification (0x3C7DD24C5BA0134385DA1A91EFA2D62F) - Status: Failed - Invoked on: 2009-08-24 15:32:00 - Message: The job failed. Unable to determine if the owner (sa) of job Notification has server access (reason: Unable to connect to server - check SQL Server and SQL Server Agent errorlogs).
2. System event viewer
Event Type:Warning
Event Source:LSASRV
Event Category:SPNEGO (Negotiator)
Event ID:40960
Date:8/24/2009
Time:3:30:22 PM
User:N/A
Computer:INS1
Description:
The Security System detected an authentication error for the server MSSQLSvc/INS1VS:1334. The failure code from authentication protocol Kerberos was "There are currently no logon servers available to service the logon request.
(0xc000005e)".
3.SQLAGENT.OUT file
2009-08-24 15:30:22 - ! [298] SQLServer Error: 848, SQL Network Interfaces: The system detected a possible attempt to compromise security. Please ensure that you can contact the server that authenticated you. [SQLSTATE HY000]
2009-08-24 15:30:22 - ! [298] SQLServer Error: 848, Cannot generate SSPI context [SQLSTATE HY000]
2009-08-24 15:30:22 - ! [382] Logon to server 'ins1vs\ins1' failed (SaveAllSchedules)
2009-08-24 15:32:38 - ! [298] SQLServer Error: 848, SQL Network Interfaces: The system detected a possible attempt to compromise security. Please ensure that you can contact the server that authenticated you. [SQLSTATE HY000]
2009-08-24 15:32:38 - ! [298] SQLServer Error: 848, Cannot generate SSPI context [SQLSTATE HY000]
2009-08-24 15:32:38 - ! [382] Logon to server 'ins1vs\ins1' failed (ConnUpdateStartExecutionDate)
2009-08-24 15:32:43 - ! [298] SQLServer Error: 848, SQL Network Interfaces: The system detected a possible attempt to compromise security. Please ensure that you can contact the server that authenticated you. [SQLSTATE HY000]
2009-08-24 15:32:43 - ! [298] SQLServer Error: 848, Cannot generate SSPI context [SQLSTATE HY000]
2009-08-24 15:32:43 - ! [382] Logon to server 'ins1vs\ins1' failed (ConnUpdateStartExecutionDate)
2009-08-24 15:33:16 - ! [298] SQLServer Error: 848, SQL Network Interfaces: The system detected a possible attempt to compromise security. Please ensure that you can contact the server that authenticated you. [SQLSTATE HY000]
2009-08-24 15:33:16 - ! [298] SQLServer Error: 848, Cannot generate SSPI context [SQLSTATE HY000]
2009-08-24 15:33:16 - ! [382] Logon to server 'ins1vs\ins1' failed (JobManager)
2009-08-24 15:33:21 - ! [298] SQLServer Error: 848, SQL Network Interfaces: The system detected a possible attempt to compromise security. Please ensure that you can contact the server that authenticated you. [SQLSTATE HY000]
2009-08-24 15:33:21 - ! [298] SQLServer Error: 848, Cannot generate SSPI context [SQLSTATE HY000]
2009-08-24 15:33:21 - ! [382] Logon to server 'ins1vs\ins1' failed (JobManager)
2009-08-24 15:34:02 - ! [298] SQLServer Error: 848, SQL Network Interfaces: The system detected a possible attempt to compromise security. Please ensure that you can contact the server that authenticated you. [SQLSTATE HY000]
2009-08-24 15:34:02 - ! [298] SQLServer Error: 848, Cannot generate SSPI context [SQLSTATE HY000]
2009-08-24 15:34:02 - ! [382] Logon to server 'ins1vs\ins1' failed (JobManager)
2009-08-24 15:34:12 - ! [298] SQLServer Error: 848, SQL Network Interfaces: The system detected a possible attempt to compromise security. Please ensure that you can contact the server that authenticated you. [SQLSTATE HY000]
2009-08-24 15:34:12 - ! [298] SQLServer Error: 848, Cannot generate SSPI context [SQLSTATE HY000]
2009-08-24 15:34:12 - ! [382] Logon to server 'ins1vs\ins1' failed (JobManager)
2009-08-24 15:34:49 - ! [298] SQLServer Error: 848, SQL Network Interfaces: The system detected a possible attempt to compromise security. Please ensure that you can contact the server that authenticated you. [SQLSTATE HY000]
2009-08-24 15:34:49 - ! [298] SQLServer Error: 848, Cannot generate SSPI context [SQLSTATE HY000]
2009-08-24 15:34:49 - ! [382] Logon to server 'ins1vs\ins1' failed (JobManager)
2009-08-24 15:34:55 - ! [298] SQLServer Error: 848, SQL Network Interfaces: The system detected a possible attempt to compromise security. Please ensure that you can contact the server that authenticated you. [SQLSTATE HY000]
2009-08-24 15:34:55 - ! [298] SQLServer Error: 848, Cannot generate SSPI context [SQLSTATE HY000]
2009-08-24 15:34:55 - ! [382] Logon to server 'ins1vs\ins1' failed (JobManager)
2009-08-24 15:35:32 - ! [298] SQLServer Error: 848, SQL Network Interfaces: The system detected a possible attempt to compromise security. Please ensure that you can contact the server that authenticated you. [SQLSTATE HY000]
2009-08-24 15:35:32 - ! [298] SQLServer Error: 848, Cannot generate SSPI context [SQLSTATE HY000]
2009-08-24 15:35:32 - ! [382] Logon to server 'ins1vs\ins1' failed (JobManager)
2009-08-24 15:35:38 - ! [298] SQLServer Error: 848, SQL Network Interfaces: The system detected a possible attempt to compromise security. Please ensure that you can contact the server that authenticated you. [SQLSTATE HY000]
2009-08-24 15:35:38 - ! [298] SQLServer Error: 848, Cannot generate SSPI context [SQLSTATE HY000]
2009-08-24 15:35:38 - ! [382] Logon to server 'ins1vs\ins1' failed (JobManager)
2009-08-24 15:36:10 - ! [298] SQLServer Error: 848, SQL Network Interfaces: The system detected a possible attempt to compromise security. Please ensure that you can contact the server that authenticated you. [SQLSTATE HY000]
2009-08-24 15:36:10 - ! [298] SQLServer Error: 848, Cannot generate SSPI context [SQLSTATE HY000]
2009-08-24 15:36:10 - ! [382] Logon to server 'ins1vs\ins1' failed (ConnUpdateJobActivity_NextScheduledRunDate)
2009-08-24 15:36:48 - ! [298] SQLServer Error: 848, SQL Network Interfaces: The system detected a possible attempt to compromise security. Please ensure that you can contact the server that authenticated you. [SQLSTATE HY000]
2009-08-24 15:36:48 - ! [298] SQLServer Error: 848, Cannot generate SSPI context [SQLSTATE HY000]
2009-08-24 15:36:48 - ! [382] Logon to server 'ins1vs\ins1' failed (ConnUpdateJobActivity_NextScheduledRunDate)
2009-08-24 15:37:26 - ! [298] SQLServer Error: 848, SQL Network Interfaces: The system detected a possible attempt to compromise security. Please ensure that you can contact the server that authenticated you. [SQLSTATE HY000]
2009-08-24 15:37:26 - ! [298] SQLServer Error: 848, Cannot generate SSPI context [SQLSTATE HY000]
2009-08-24 15:37:26 - ! [382] Logon to server 'ins1vs\ins1' failed (ConnAttemptCachableOp)
2009-08-24 15:37:31 - ! [298] SQLServer Error: 848, SQL Network Interfaces: The system detected a possible attempt to compromise security. Please ensure that you can contact the server that authenticated you. [SQLSTATE HY000]
2009-08-24 15:37:31 - ! [298] SQLServer Error: 848, Cannot generate SSPI context [SQLSTATE HY000]
2009-08-24 15:37:31 - ! [382] Logon to server 'ins1vs\ins1' failed (ConnAttemptCachableOp)
2009-08-24 15:38:04 - ! [298] SQLServer Error: 848, SQL Network Interfaces: The system detected a possible attempt to compromise security. Please ensure that you can contact the server that authenticated you. [SQLSTATE HY000]
2009-08-24 15:38:04 - ! [298] SQLServer Error: 848, Cannot generate SSPI context [SQLSTATE HY000]
2009-08-24 15:38:04 - ! [382] Logon to server 'ins1vs\ins1' failed (ConnGetOperator)
2009-08-24 15:38:04 - ! [252] Failed to retrieve operator 1 from the server
2009-08-24 15:38:09 - ! [298] SQLServer Error: 848, SQL Network Interfaces: The system detected a possible attempt to compromise security. Please ensure that you can contact the server that authenticated you. [SQLSTATE HY000]
2009-08-24 15:38:09 - ! [298] SQLServer Error: 848, Cannot generate SSPI context [SQLSTATE HY000]
2009-08-24 15:38:09 - ! [382] Logon to server 'ins1vs\ins1' failed (ConnGetOperator)
2009-08-24 15:38:09 - ! [252] Failed to retrieve operator 1 from the server
2009-08-24 15:38:19 - ! [298] SQLServer Error: 848, SQL Network Interfaces: The system detected a possible attempt to compromise security. Please ensure that you can contact the server that authenticated you. [SQLSTATE HY000]
2009-08-24 15:38:19 - ! [298] SQLServer Error: 848, Cannot generate SSPI context [SQLSTATE HY000]
2009-08-24 15:38:19 - ! [382] Logon to server 'ins1vs\ins1' failed (ConnAttemptCachableOp)
2009-08-24 15:38:21 - ! [298] SQLServer Error: 848, SQL Network Interfaces: The system detected a possible attempt to compromise security. Please ensure that you can contact the server that authenticated you. [SQLSTATE HY000]
2009-08-24 15:38:21 - ! [298] SQLServer Error: 848, Cannot generate SSPI context [SQLSTATE HY000]
2009-08-24 15:38:21 - ! [382] Logon to server 'ins1vs\ins1' failed (ConnUpdateStartExecutionDate)
2009-08-24 15:38:21 - ! [298] SQLServer Error: 848, SQL Network Interfaces: The system detected a possible attempt to compromise security. Please ensure that you can contact the server that authenticated you. [SQLSTATE HY000]
2009-08-24 15:38:21 - ! [298] SQLServer Error: 848, Cannot generate SSPI context [SQLSTATE HY000]
2009-08-24 15:38:21 - ! [382] Logon to server 'ins1vs\ins1' failed (JobManager)
2009-08-24 15:38:24 - ! [298] SQLServer Error: 848, SQL Network Interfaces: The system detected a possible attempt to compromise security. Please ensure that you can contact the server that authenticated you. [SQLSTATE HY000]
2009-08-24 15:38:24 - ! [298] SQLServer Error: 848, Cannot generate SSPI context [SQLSTATE HY000]
2009-08-24 15:38:24 - ! [382] Logon to server 'ins1vs\ins1' failed (ConnAttemptCachableOp)
2009-08-24 15:38:25 - ! [298] SQLServer Error: 848, SQL Network Interfaces: The system detected a possible attempt to compromise security. Please ensure that you can contact the server that authenticated you. [SQLSTATE HY000]
2009-08-24 15:38:25 - ! [298] SQLServer Error: 848, Cannot generate SSPI context [SQLSTATE HY000]
2009-08-24 15:38:25 - ! [382] Logon to server 'ins1vs\ins1' failed (ConnUpdateStartExecutionDate)
2009-08-24 15:38:25 - ! [298] SQLServer Error: 848, SQL Network Interfaces: The system detected a possible attempt to compromise security. Please ensure that you can contact the server that authenticated you. [SQLSTATE HY000]
2009-08-24 15:38:25 - ! [298] SQLServer Error: 848, Cannot generate SSPI context [SQLSTATE HY000]
2009-08-24 15:38:25 - ! [382] Logon to server 'ins1vs\ins1' failed (JobManager)
2009-08-24 15:38:26 - ! [298] SQLServer Error: 848, SQL Network Interfaces: The system detected a possible attempt to compromise security. Please ensure that you can contact the server that authenticated you. [SQLSTATE HY000]
2009-08-24 15:38:26 - ! [298] SQLServer Error: 848, Cannot generate SSPI context [SQLSTATE HY000]
2009-08-24 15:38:26 - ! [382] Logon to server 'ins1vs\ins1' failed (JobManager)
2009-08-24 15:38:31 - ! [298] SQLServer Error: 848, SQL Network Interfaces: The system detected a possible attempt to compromise security. Please ensure that you can contact the server that authenticated you. [SQLSTATE HY000]
2009-08-24 15:38:31 - ! [298] SQLServer Error: 848, Cannot generate SSPI context [SQLSTATE HY000]
2009-08-24 15:38:31 - ! [382] Logon to server 'ins1vs\ins1' failed (JobManager)
2009-08-24 15:38:32 - ! [298] SQLServer Error: 848, SQL Network Interfaces: The system detected a possible attempt to compromise security. Please ensure that you can contact the server that authenticated you. [SQLSTATE HY000]
2009-08-24 15:38:32 - ! [298] SQLServer Error: 848, Cannot generate SSPI context [SQLSTATE HY000]
2009-08-24 15:38:32 - ! [382] Logon to server 'ins1vs\ins1' failed (JobManager)
2009-08-24 15:38:36 - ! [298] SQLServer Error: 848, SQL Network Interfaces: The system detected a possible attempt to compromise security. Please ensure that you can contact the server that authenticated you. [SQLSTATE HY000]
2009-08-24 15:38:36 - ! [298] SQLServer Error: 848, Cannot generate SSPI context [SQLSTATE HY000]
2009-08-24 15:38:36 - ! [382] Logon to server 'ins1vs\ins1' failed (JobManager)
2009-08-24 15:38:37 - ! [298] SQLServer Error: 848, SQL Network Interfaces: The system detected a possible attempt to compromise security. Please ensure that you can contact the server that authenticated you. [SQLSTATE HY000]
2009-08-24 15:38:37 - ! [298] SQLServer Error: 848, Cannot generate SSPI context [SQLSTATE HY000]
2009-08-24 15:38:37 - ! [382] Logon to server 'ins1vs\ins1' failed (JobManager)
2009-08-24 15:38:38 - ! [298] SQLServer Error: 848, SQL Network Interfaces: The system detected a possible attempt to compromise security. Please ensure that you can contact the server that authenticated you. [SQLSTATE HY000]
2009-08-24 15:38:38 - ! [298] SQLServer Error: 848, Cannot generate SSPI context [SQLSTATE HY000]
2009-08-24 15:38:38 - ! [382] Logon to server 'ins1vs\ins1' failed (ConnUpdateJobActivity_NextScheduledRunDate)
2009-08-24 15:38:38 - ! [298] SQLServer Error: 848, SQL Network Interfaces: The system detected a possible attempt to compromise security. Please ensure that you can contact the server that authenticated you. [SQLSTATE HY000]
2009-08-24 15:38:38 - ! [298] SQLServer Error: 848, Cannot generate SSPI context [SQLSTATE HY000]
2009-08-24 15:38:38 - ! [382] Logon to server 'ins1vs\ins1' failed (ConnAttemptCachableOp)
2009-08-24 15:38:38 - ! [298] SQLServer Error: 848, SQL Network Interfaces: The system detected a possible attempt to compromise security. Please ensure that you can contact the server that authenticated you. [SQLSTATE HY000]
2009-08-24 15:38:38 - ! [298] SQLServer Error: 848, Cannot generate SSPI context [SQLSTATE HY000]
2009-08-24 15:38:38 - ! [382] Logon to server 'ins1vs\ins1' failed (ConnGetOperator)
2009-08-24 15:38:38 - ! [252] Failed to retrieve operator 1 from the server
2009-08-24 15:38:39 - ! [298] SQLServer Error: 848, SQL Network Interfaces: The system detected a possible attempt to compromise security. Please ensure that you can contact the server that authenticated you. [SQLSTATE HY000]
2009-08-24 15:38:39 - ! [298] SQLServer Error: 848, Cannot generate SSPI context [SQLSTATE HY000]
2009-08-24 15:38:39 - ! [382] Logon to server 'ins1vs\ins1' failed (ConnAttemptCachableOp)
2009-08-24 15:38:42 - ! [298] SQLServer Error: 848, SQL Network Interfaces: The system detected a possible attempt to compromise security. Please ensure that you can contact the server that authenticated you. [SQLSTATE HY000]
2009-08-24 15:38:42 - ! [298] SQLServer Error: 848, Cannot generate SSPI context [SQLSTATE HY000]
2009-08-24 15:38:42 - ! [382] Logon to server 'ins1vs\ins1' failed (JobManager)
2009-08-24 15:38:42 - ! [298] SQLServer Error: 848, SQL Network Interfaces: The system detected a possible attempt to compromise security. Please ensure that you can contact the server that authenticated you. [SQLSTATE HY000]
2009-08-24 15:38:42 - ! [298] SQLServer Error: 848, Cannot generate SSPI context [SQLSTATE HY000]
2009-08-24 15:38:42 - ! [382] Logon to server 'ins1vs\ins1' failed (ConnUpdateJobActivity_NextScheduledRunDate)
2009-08-24 15:38:42 - ! [298] SQLServer Error: 848, SQL Network Interfaces: The system detected a possible attempt to compromise security. Please ensure that you can contact the server that authenticated you. [SQLSTATE HY000]
2009-08-24 15:38:42 - ! [298] SQLServer Error: 848, Cannot generate SSPI context [SQLSTATE HY000]
2009-08-24 15:38:42 - ! [382] Logon to server 'ins1vs\ins1' failed (ConnAttemptCachableOp)
2009-08-24 15:38:43 - ! [298] SQLServer Error: 848, SQL Network Interfaces: The system detected a possible attempt to compromise security. Please ensure that you can contact the server that authenticated you. [SQLSTATE HY000]
2009-08-24 15:38:43 - ! [298] SQLServer Error: 848, Cannot generate SSPI context [SQLSTATE HY000]
2009-08-24 15:38:43 - ! [382] Logon to server 'ins1vs\ins1' failed (ConnGetOperator)
2009-08-24 15:38:43 - ! [252] Failed to retrieve operator 1 from the server
2009-08-24 15:38:43 - ! [298] SQLServer Error: 848, SQL Network Interfaces: The system detected a possible attempt to compromise security. Please ensure that you can contact the server that authenticated you. [SQLSTATE HY000]
2009-08-24 15:38:43 - ! [298] SQLServer Error: 848, Cannot generate SSPI context [SQLSTATE HY000]
2009-08-24 15:38:43 - ! [382] Logon to server 'ins1vs\ins1' failed (ConnAttemptCachableOp)
August 24, 2009 at 8:12 pm
Is your server part of a Domain? Is the service account username used for the SQL Services a domain account or local account?
The errors indicate that it has lost connection with the server that handles your account authentication. This would be your Active Directory server if you are in a domain environment.
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
August 24, 2009 at 9:31 pm
Yes, the server is a part Active Domain.
August 24, 2009 at 10:29 pm
August 24, 2009 at 10:50 pm
SQL Agent is running under domain account "abc\mssql" and its continually running and all other jobs also running fine. At one point in time the Notification Job failed twice. After that its also running fine. SQL Agent is not restarted at that time.
I'm analyzing the messages and want to know why at that the Agent loose connection/communication with the server but I did not find any clue so far
September 18, 2009 at 10:45 am
We too are experiencing similar problems and we have issues with the Sharepoint Search service. Have you made any progress on this problem?
September 18, 2009 at 2:16 pm
Try changing the owner of the job to a login that has sysadmin rights. It may be because your SA password expired
September 18, 2009 at 5:13 pm
we recieve SQLServer
Error: 848, Cannot generate SSPI context [SQLSTATE HY000]
whenever our service account does not have access to create SPN (service prinicple name), So please check with your windows team that the your service account (under which SQL Agent services are running) should have access to 'ins1vs\ins1' to create a SPN. if not then ask them to provide this autority to generate.
2) for database mail issue: please check that your database mail have correct SMTP if not so please send the log by executing this query:
SELECT * FROM msdb.dbo.sysmail_event_log
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply