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