SQL Server blocked access to the STATEMENT ' Openrowset/opendatasource ' of the component ' Ad Hoc distributed Queries '

Delphi ADO

Cross-database access statements are as follows

Select *  from OpenDataSource('SQLOLEDB','Data Source=server; User Id=sa; Password=123'). erp_logon.dbo.yq_userswhereUserno= 'Admin'  andPwd= '040'  andDb= 'Book set 1'

Error content: SQL Server blocked access to component ' Ad Hoc distributed Queries ' STATEMENT ' Openrowset/opendatasource ', 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.

Below for the online search to the original URL is: http://www.htmer.com/article/922.htm

Look at the error prompt to know that because the SQL Server ad hoc distributed queries component is disabled, here I use the SQL Server version is 2005, only need to open the ad hoc distributed queries on it, Here's how:

1. Open the ad HOC distributed queries component and execute the following statement in the SQL Query Editor:

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

2. Close the ad HOC distributed queries component and execute the following statement in the SQL Query Editor:

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

SQL Server blocked access to the STATEMENT ' Openrowset/opendatasource ' of the component ' Ad Hoc distributed Queries '