How to: Enable ‘Ad Hoc Distributed Queries’ in SQL Server 2008

The other day I did some testing of UC Logic iSync – 3rd party utility for Auotonomy WorkSite which is intended for synchronizing of metadata across libraries. It turned out that iSync requires  ‘Ad Hoc Distributed Queries’ SQL server feature enabled to work properly (which was indicaed in iSyncLog available through Event Viewer) which was not enabled in my case.

So below you may find code to enable this feature in SQL Server (in my case it was SQL 2008 R2 SP1, but I guess this is applicable to other version too):

\nEXEC\n\nsp_configure ‘show advanced options’,1;\n\nGO\n\nRECONFIGURE;\n\nGO\n\nEXEC\n\nsp_configure ‘Ad Hoc Distributed Queries’,1;\n\nGO\n\nRECONFIGURE

Leave a Reply

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