Agent issues for SQL Server

Error: (This is a proxy service issue)

When executing this SQL statement, Tip: Msg 15281, Level 16, State 1, line 1th
SQL Server blocked access to the STATEMENT ' openrowset/opendatasource ' of component ' Ad Hoc distributed Queries ' because this component was shut down as part of this server's security configuration. System administrators can enable ' Ad Hoc distributed Queries ' by using sp_configure. For more information about enabling ' Ad Hoc distributed Queries ', see "surface area Configurator" in SQL Server Books Online.

Execute the following statement to

--Open

exec sp_configure ' show advanced options ', 1
Reconfigure
exec sp_configure ' Ad Hoc distributed Queries ', 1
Reconfigure

If the above two sentences also reported error, follow the instructions to install. As in the following statement

exec sp_configure ' Ole Automation procedures ', 1
Reconfigure

When the result is shown, it turns out to be successful.

Understand not deep, just give yourself a note, have a deeper understanding, or feel that I understand the wrong place welcome message and treatise.

Agent issues for SQL Server