• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 234
  • Last Modified:

SQL Server blocked access to procedure

When I right click and go to properties on SQL Server Agent (XPs disabled) I get the following message.

SQL Server blocked access to procedure 'dbo.sp_get_sqlagent_properties' 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', search for 'Agent XPs' in SQL Server Books Online. (Microsoft SQL Server, Error: 15281)
0
daise703
Asked:
daise703
1 Solution
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
Like the message says, you need to enable the XPs by using SP_CONFIGURE:
EXEC SP_CONFIGURE 'show advanced options',1
GO
RECONFIGURE WITH OVERRIDE
GO
EXEC SP_CONFIGURE 'Agent XPs',1
GO
RECONFIGURE WITH OVERRIDE
GO
EXEC SP_CONFIGURE 'show advanced options', 0
GO

Open in new window

0

Featured Post

Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now