SQL usage across servers

Because you want to import some data from a database on another server.

Through the internet, get

SELECT * FROM OPENROWSET (' SQLOLEDB ', ' Server name '; ' User name '; ' Password ', database name. dbo. Table name)

Result Error:

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.

Workaround:

In the native execution

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

You need to do this when you're done with this machine

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

SQL usage across servers