'Agent XPs' component is turned off as part of the security configuration for this server

To turn on Agent XP's by running this script:

 

sp_configure 'show advanced options', 1;
Go
RECONFIGURE;
GO
sp_configure 'Agent XPs', 1;
GO
RECONFIGURE
GO

  

原文地址:https://www.cnblogs.com/abclife/p/6277163.html