allowing ad hoc distributed queries for OPENROWSET and OPENDATASOURCE

run first:
sp_configure ‘show advanced options’, 1; RECONFIGURE;

then this:
sp_configure ‘Ad Hoc Distributed Queries’, 1; RECONFIGURE;

ad hoc opens security issues – use very carefully!!

only supposed to use ad hoc if there is infrequent access to the data
for any data sources that will be accessed more than several times, define a linked server.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.