Monday 24 June 2013

What is error 15281 during distributor configuration in SQL server 2012 replication?

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 system
administrator 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