SQL Server to prevent the component "Ad Hoc Distributed Queries" STATEMENT "OpenRowset/OpenDatasource" access, because this component has been shut down as part of this Server security configuration, system administrators can by using sp_configure enabled "Ad Hoc Distributed Queries", related to enable "Ad Hoc Distributed Queries" detailed information, please search in SQL Server books online "Ad Hoc Distributed Queries",

what is affected if opened the server

CodePudding user response:

Open, safety risk, shut out,
If can not use the external, that it doesn't matter that you have been open,