Share via

Unable to start SQLServer agent resource on cluster after upgrading to 9.00.3186 or Higher

  • Article

Error
===

2008-03-19 23:06:23 - ? [100] Microsoft SQLServerAgent version 9.00.3186.00 (x86
unicode retail build) : Process ID 2428
2008-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.3042
2008-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 detected
2008-03-19 23:06:23 - ? [339] Local computer is SNETNAME running Windows NT 5.2
(3790) Service Pack 2
2008-03-19 23:06:23 - ? [432] There are 11 subsystems in the subsystems cache
2008-03-19 23:06:38 - ! [364] The Messenger service has not been started - NetSend
notifications will not be sent
2008-03-19 23:06:38 - ? [129] SQLSERVERAGENT starting under Windows NT service
control
2008-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 effect
2008-03-19 23:06:38 - + [408] SQL Server MSSQLSERVER is clustered - AutoRestart has
been disabled
2008-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 6512
2008-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.3042
2008-03-18 12:18:30 - ? [103] NetLib being used by driver is DBNETLIB.DLL; Local
host server is np:pistondist
2008-03-18 12:18:30 - ? [310] 16 processor(s) and 32765 MB RAM detected
2008-03-18 12:18:30 - ? [339] Local computer is PISTONDIST running Windows NT 5.2
(3790) Service Pack 2
2008-03-18 12:18:31 - ? [432] There are 11 subsystems in the subsystems cache
2008-03-18 12:18:31 - ! [364] The Messenger service has not been started - NetSend
notifications will not be sent
2008-03-18 12:18:31 - ? [129] SQLSERVERAGENT starting under Windows NT service
control
2008-03-18 12:18:32 - + [396] An idle CPU condition has not been defined - OnIdle
job schedules will have no effect
2008-03-18 12:18:32 - + [408] SQL Server MSSQLSERVER is clustered - AutoRestart has
been disabled
2008-03-18 12:18:32 - + [162] Internal request (from SetJobNextRunDate [reason:
schedule will not run again]) to deactivate schedule 66
2008-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
ServerHost
Value: 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. https://support.microsoft.com/?id=956378
Note: Before applying the Hotfix. you have to follow the  steps mentioned in Resolution else hotfix would fail.

 

Regards

Karthick PK

Comments

  • Anonymous
    January 14, 2009
    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/

  • Anonymous
    March 30, 2009
    The comment has been removed

  • Anonymous
    March 31, 2009
    Looks like a Kerberos issue Modify the below Registry key to narrow down the issue. HKEY_LOCAL_MACHINESOFTWAREMicrosoftMicrosoft SQL ServerMSSQL.XSQLServerAgent ServerHost Value:np:DB1 Then start the SQLServer Agent. Let me know how it goes. Regards Kathick P K

  • Anonymous
    August 07, 2009
    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

  • Anonymous
    June 09, 2010
    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