SQL Agent stopped running..

  • Hi all,

    My sql server agent stopped last night and I'm trying to understand why. I've seen previous posts with this error description and my group policy for this user seems to be correct. This has been running under the same admin account now for months. Any ideas and thanks in advance for any help!

    Message

    [298] SQLServer Error: 15281, SQL Server blocked access to procedure 'dbo.sp_sqlagent_has_server_access' of component 'Agent XPs' because this component is turned off as part of the security configuration for this server. A system administrator can enable the use of 'Agent XPs' by using sp_configure. For more information about enabling 'Agent XPs', see "Surface Area Configuration" in SQL Server Books Online. [SQLSTATE 42000] (ConnIsLoginSysAdmin)

  • And did you do what it said and enable the XPs? What happened when you did?

    Watch my free SQL Server Tutorials at:
    http://MidnightDBA.com
    Blog Author of:
    DBA Rant – http://www.MidnightDBA.com/DBARant

    Minion Maintenance is FREE:

  • Somebody must have run sp_configure or something. Did you try to reconfigure per the error message suggestions?

    Regards,Yelena Varsha

  • I ran stored procedure sp_configure and Agent XPs run value was 1. We booted the box at this point and all services came up cleanly.

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

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