ENSURE THAT AD HOC DISTRIBUTED QUERIES ARE ENABLED. RUN THE FOLLOWI...
2. Ensure that ad hoc distributed queries are enabled. Run the
following statements:
EXEC sp_configure 'show advanced',1;
RECONFIGURE;
EXEC sp_configure 'Ad Hoc Distributed Queries', 1;
RECONFIGURE;