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;