Today wrote an Excel table import feature, results in Excel table content import to page times wrong: SQL Server blocked the STATEMENT ' openrowset/for component ' Ad Hoc distributed Queries ' OpenDataSource ' access because this component has been 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.
Check on the Internet, the experiment has worked, so record:
Run the following statement in the database SQL Query Editor
1. Enable ' Ad Hoc distributed Queries ':
1 exec ' Show advanced Options ',12reconfigure3exec'Ad Hoc Distributed Queries',14reconfigure
enable ' Ad Hoc distributed Queries '
2. Close ' Ad Hoc distributed Queries ':
1 exec ' Ad Hoc Distributed Queries ',02reconfigure3exec'Show advanced options ',04reconfigure
Close ' Ad Hoc distributed Queries ':
SQL Server blocked access to the component ' Ad Hoc distributed Queries ' STATEMENT ' openrowset/opendatasource ' solution