Error encountered while configure distribution, unable to open SQL Agent

Source: Internet
Author: User
Tags sql server books

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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.