Error:
SQL server blocked access to procedure 'dbo_sp_set_sqlagent_properties of component 'Agent XPs' because this component is turned off as part of security configuration for this server. A systemadministrator can enable the use use of 'Agent Xps' by using sp_configure.
Solution:
Configure the 'Agent XPs' using 'sp_configure'sp_configure 'show advanced options', 1;
GO
RECONFIGURE;
GO
sp_configure 'Agent XPs', 1;
GO
RECONFIGURE
GO
No comments:
Post a Comment