Post reply

SQL Agent not starting

  • August 12, 2011 at 12:53 am

    #246142

    I used the following command from command prompt to start the agent :

    C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Binn>sqlagent.exe

    -c -v>c:\sqlagent.out

    and here is the output of the log file generated:

    Microsoft (R) SQLServerAgent 10.50.1600.1

    Copyright (C) Microsoft Corporation.

    2011-08-12 02:45:15 - ? [094] SQLServerAgent started from command line

    2011-08-12 02:45:15 - ? [100] Microsoft SQLServerAgent version 10.50.1600.1 ((Unknown) unicode retail build) : Process ID 1988

    2011-08-12 02:45:15 - ? [101] SQL Server BR-SQL08DEV version 10.50.1600 (0 connection limit)

    2011-08-12 02:45:15 - ? [102] SQL Server ODBC driver version 10.50.1600

    2011-08-12 02:45:15 - ? [103] NetLib being used by driver is DBNETLIB.DLL; Local host server is

    2011-08-12 02:45:15 - ? [310] 4 processor(s) and 4096 MB RAM detected

    2011-08-12 02:45:15 - ? [339] Local computer is BR-SQL08DEV running Windows NT 6.1 (7600)

    2011-08-12 02:45:15 - ? [432] There are 12 subsystems in the subsystems cache

    2011-08-12 02:45:15 - ! [364] The Messenger service has not been started - NetSend notifications will not be sent

    2011-08-12 02:45:15 - ! [298] SQLServer Error: 22022, Usage: EXECUTE xp_sqlagent_notify 'A', NULL, NULL, <alert_id>, <action type> [SQLSTATE 42000]

    2011-08-12 02:45:15 - ! [442] ConnConnectAndSetCryptoForXpstar failed (0).

    2011-08-12 02:45:16 - ? [098] SQLServerAgent terminated (normally)

    Please share any inputs if you have.

    Thanks

    Chandan

  • August 12, 2011 at 1:24 am

    #1367742

    See whether this helps

    http://support.microsoft.com/kb/975752/en-us?sd=rss&spid=13165

    --------------------------------------------------------------------------------------------------
    I am just an another naive wannabe DBA trying to learn SQL Server

  • August 12, 2011 at 4:13 am

    #1367795

    Sachin Nandanwar (8/12/2011)

    See whether this helps

    http://support.microsoft.com/kb/975752/en-us?sd=rss&spid=13165

    It does not let me run this CU. I have repaired the shared features in SQL installation through repair wizard. I have rebooted it and will try applying the CU again.

    Thanks

  • August 14, 2011 at 7:44 am

    #1368382

    what events do you see in the application event log when trying to start the agent service normally

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply