Friday, March 22, 2013

Can’t edit or create maintainance jobs in SQL Management Studio

Error: Agent XPs component turned off off as part of the security configuration….

image

 

Executed following:

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

Threw an some error but after this it was possible to edit again.

References:

http://social.msdn.microsoft.com/Forums/en-US/sqlsetupandupgrade/thread/e8924b76-0a8b-46a4-b7e5-db6bc5b4f883/

No comments: