Today, when configuring distribution, I encountered an error, unable to open the SQL Agent, the detailed error message is as follows:
SQL Server blocked access to procedure ' dbo.sp_set_sqlagent_properties ' of component ' agents XPs ' because this component is Turned off as part of the security configuration for this server. A system administrator can enable the use of the "Agent XPs ' by using sp_configure. For more information on enabling ' Agent XPS ', search for ' agent xps ' in SQL Server Books Online. (. Net SqlClient Data Provider)
Solution found from the Internet
-- to resolve this error, following script Have to is executed on the server. sp_configure show Advanced options , ; go reconfigure go sp_configure agent XPs , ; go reconfigure go
When you run above script, it'll give a very similar output as following on the screen.
Error encountered while configure distribution, unable to open SQL Agent