Error===
2008-03-19 23:06:23 - ? [100] Microsoft SQLServerAgent version 9.00.3186.00 (x86 unicode retail build) : Process ID 24282008-03-19 23:06:23 - ? [101] SQL Server SNETNAME version 9.00.3186 (0 connection limit)2008-03-19 23:06:23 - ? [102] SQL Server ODBC driver version 9.00.30422008-03-19 23:06:23 - ? [103] NetLib being used by driver is DBNETLIB.DLL; Local host server is 2008-03-19 23:06:23 - ? [310] 4 processor(s) and 2560 MB RAM detected2008-03-19 23:06:23 - ? [339] Local computer is SNETNAME running Windows NT 5.2 (3790) Service Pack 22008-03-19 23:06:23 - ? [432] There are 11 subsystems in the subsystems cache2008-03-19 23:06:38 - ! [364] The Messenger service has not been started - NetSend notifications will not be sent2008-03-19 23:06:38 - ? [129] SQLSERVERAGENT starting under Windows NT service control2008-03-19 23:06:38 - + [260] Unable to start mail session (reason: No mail profile defined)2008-03-19 23:06:38 - + [396] An idle CPU condition has not been defined - OnIdle job schedules will have no effect2008-03-19 23:06:38 - + [408] SQL Server MSSQLSERVER is clustered - AutoRestart has been disabled2008-03-19 23:06:39 - ! [298] SQLServer Error: 22022, CryptUnprotectData() returned error -2146893813, 'Key not valid for use in specified state.' [SQLSTATE 42000] 2008-03-19 23:06:39 - ! [442] ConnConnectAndSetCryptoForXpstar failed (0).2008-03-19 23:06:40 - ? [098] SQLServerAgent terminated (normally)
Error2=====2008-03-18 12:18:30 - ? [100] Microsoft SQLServerAgent version 9.00.3200.00 ((Unknown) unicode retail build) : Process ID 65122008-03-18 12:18:30 - ? [101] SQL Server PISTONDIST version 9.00.3200 (0 connection limit)2008-03-18 12:18:30 - ? [102] SQL Server ODBC driver version 9.00.30422008-03-18 12:18:30 - ? [103] NetLib being used by driver is DBNETLIB.DLL; Local host server is np:pistondist2008-03-18 12:18:30 - ? [310] 16 processor(s) and 32765 MB RAM detected2008-03-18 12:18:30 - ? [339] Local computer is PISTONDIST running Windows NT 5.2 (3790) Service Pack 22008-03-18 12:18:31 - ? [432] There are 11 subsystems in the subsystems cache2008-03-18 12:18:31 - ! [364] The Messenger service has not been started - NetSend notifications will not be sent2008-03-18 12:18:31 - ? [129] SQLSERVERAGENT starting under Windows NT service control2008-03-18 12:18:32 - + [396] An idle CPU condition has not been defined - OnIdle job schedules will have no effect2008-03-18 12:18:32 - + [408] SQL Server MSSQLSERVER is clustered - AutoRestart has been disabled2008-03-18 12:18:32 - + [162] Internal request (from SetJobNextRunDate [reason: schedule will not run again]) to deactivate schedule 662008-03-18 12:18:32 - ! [298] SQLServer Error: 22022, CryptUnprotectData() returned error -2146892987, 'The requested operation cannot be completed. The computer must be trusted for delegation and the current user account must be configured to allow delegation.' [SQLSTATE 42000] 2008-03-18 12:18:32 - ! [442] ConnConnectAndSetCryptoForXpstar failed (0).2008-03-18 12:18:33 - ? [098] SQLServerAgent terminated (normally)
Resolution
========
Modify the the following Key.=======================
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.X\SQLServerAgent
Modify the value data of the serverhost key to np:Virtualservername
Ie:HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.X\SQLServerAgent ServerHostValue: np:Virtualservername.
This will force the SQLServer agent to connect with SQLserver using Named Pipes so delegation is not used.
-----------------------------------------------------------------------------------------------------------------
We have a HOTFIX available for this issue and it is included in the cumulative update pack9 for SQLServer service pack2. http://support.microsoft.com/?id=956378Note: Before applying the Hotfix. you have to follow the steps mentioned in Resolution else hotfix would fail.
Regards
Karthick PK
PingBack from http://blog.a-foton.ru/index.php/2009/01/14/unable-to-start-sqlserver-agent-resource-on-cluster-after-upgrading-to-9003186-or-higher/
Karthick-
I see this excact same error in SQL Server 2008 (10.0.1600)
We just (just!) upgraded the forest from 2000 mode to 2003 mode...
We are not running a cluster.
Microsoft (R) SQLServerAgent 10.0.1600.22
Copyright (C) Microsoft Corporation, 1995 - 2008.
2009-03-30 23:58:22 - ? [094] SQLServerAgent started from command line
2009-03-30 23:58:23 - ? [100] Microsoft SQLServerAgent version 10.0.1600.22 (x86
unicode retail build) : Process ID 3876
2009-03-30 23:58:23 - ? [101] SQL Server DB1 version 10.00.1600 (0 connection li
mit)
2009-03-30 23:58:23 - ? [102] SQL Server ODBC driver version 10.00.1600
2009-03-30 23:58:23 - ? [103] NetLib being used by driver is DBNETLIB.DLL; Local
host server is
2009-03-30 23:58:23 - ? [310] 1 processor(s) and 510 MB RAM detected
2009-03-30 23:58:23 - ? [339] Local computer is DB1 running Windows NT 6.0 (6001
) Service Pack 1
2009-03-30 23:58:23 - ? [432] There are 12 subsystems in the subsystems cache
2009-03-30 23:58:24 - ! [364] The Messenger service has not been started - NetSe
nd notifications will not be sent
2009-03-30 23:58:24 - ! [298] SQLServer Error: 22022, Usage: EXECUTE xp_sqlagen
t_notify 'A', NULL, NULL, <alert_id>, <action type> [SQLSTATE 42000]
2009-03-30 23:58:24 - ! [442] ConnConnectAndSetCryptoForXpstar failed (0).
2009-03-30 23:58:25 - ? [098] SQLServerAgent terminated (normally)
any thoughts?
Looks like a Kerberos issue
Modify the below Registry key to narrow down the issue.
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL
Server\MSSQL.X\SQLServerAgent
ServerHost
Value:np:DB1
Then start the SQLServer Agent. Let me know how it goes.
Kathick P K
i duplicate the database same server.i used in this way go to database ,tasks,copy database,give servername,destination name and ihave error on EXECUTESQLSERVERAGENTJOB status is error. how to fix this one
I can't send email using database email.. I already tried different servers. like yahoo mail, windows live, and the smtp of xp. but same error appears.. Here's the error message from the Server Agent out.:
Date,Source,Severity,Message
06/05/2010 14:46:04,,Information,[098] SQLServerAgent terminated (normally)
06/05/2010 14:45:55,,Information,[131] SQLSERVERAGENT service stopping due to a stop request from a user<c/> process<c/> or the OS...
06/05/2010 13:40:05,,Warning,[396] An idle CPU condition has not been defined - OnIdle job schedules will have no effect
06/05/2010 13:40:05,,Warning,[260] Unable to start mail session (reason: No mail profile defined)
06/05/2010 13:40:04,,Information,[129] SQLSERVERAGENT starting under Windows NT service control
06/05/2010 13:40:04,,Error,[364] The Messenger service has not been started - NetSend notifications will not be sent
06/05/2010 13:40:02,,Information,[432] There are 12 subsystems in the subsystems cache
06/05/2010 13:40:01,,Information,[339] Local computer is USER-E128DF3DF6 running Windows NT 5.1 (2600) Service Pack 2
06/05/2010 13:40:01,,Information,[310] 1 processor(s) and 512 MB RAM detected
06/05/2010 13:40:01,,Information,[103] NetLib being used by driver is DBNETLIB.DLL; Local host server is
06/05/2010 13:40:01,,Information,[102] SQL Server ODBC driver version 10.00.1600
06/05/2010 13:40:01,,Information,[101] SQL Server USER-E128DF3DF6 version 10.00.1600 (0 connection limit)
06/05/2010 13:40:01,,Information,[100] Microsoft SQLServerAgent version 10.0.1600.22 (x86 unicode retail build) : Process ID 2560
06/05/2010 13:39:50,,Information,[393] Waiting for SQL Server to recover databases...
I hope someone can be a solution for this thing..
Thanks a lot
Miralance