SQL SERVER – Fix – Agent Starting Error 15281 – 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

SQL Server Agent fails to start because of the error 15281 is a very common error.

agenterror1 SQL SERVER   Fix   Agent Starting Error 15281   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

When you start to restart SQL Agent sometimes it will give following error.

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)

agenterror2 SQL SERVER   Fix   Agent Starting Error 15281   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

To resolve this error, following script has to be executed on the server.

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

When you run above script, it will give a very similar output as following on the screen.

agenterror3 SQL SERVER   Fix   Agent Starting Error 15281   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

Now, if you try to restart SQL Agent it will just work fine.

agenterror4 SQL SERVER   Fix   Agent Starting Error 15281   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

That’s it! Sometimes there is a simpler solution to complicated error.

Reference: Pinal Dave (http://blog.sqlauthority.com)

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s