Karthick PK 's Blog

Karthick PK's technical blog covering topics such as SQLServer troubleshooting, technologies and security.

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

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

Rate This
  • Comments 5

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. http://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
  • 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.

    Regards

    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

Page 1 of 1 (5 items)
Leave a Comment
  • Please add 8 and 1 and type the answer here:
  • Post