• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 363
  • 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
Dawin Daise
Asked:
Dawin Daise
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Office 2010

This course will introduce you to the interfaces and features of Microsoft Office 2010 Word, Excel, PowerPoint, Outlook, and Access. You will learn about the features that are shared between all products in the Office suite, as well as the new features that are product specific.

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