Home Forums SQL Server 2005 SQL Server 2005 General Discussion SQL Server Agent won't start RE: SQL Server Agent won't start

  • March 7, 2008 at 4:29 am

    #786541

    thanks's Phillip,

    what database should i run this against? msdb?

    sp_configure 'show advanced options','1'

    RECONFIGURE

    go

    sp_configure 'Agent XPs','1'

    RECONFIGURE

    go

    This will enable Agent XP's and SQL Server Agent should start.

    ------------------------------------------------------------------------
    All it takes, is a step in the right direction, your feet will manage to find the way. I didn't say it'll be easy!!![font="Comic Sans MS"]:cool:[/font]