sp_configure 'show advanced options',1 reconfigure with override go sp_configure 'Ad Hoc Distributed Queries',1 reconfigure with override go
Enable ‘Ad Hoc Distributed Queries’ for Sql Server 2005
24/01/2008 | 2 Comments
Superdopey’s Techblog
24/01/2008 | 2 Comments
sp_configure 'show advanced options',1 reconfigure with override go sp_configure 'Ad Hoc Distributed Queries',1 reconfigure with override go
29/08/2008 at 17:42
sp_configure ‘Ad Hoc Distributed Queries’, 1
reconfigure with override
go
Ran this on SQL Server 2005 and received these messages:
Configuration option ‘Ad Hoc Distributed Queries’ changed from 1 to 1. Run the RECONFIGURE statement to install.
Msg 5845, Level 16, State 1, Line 3
Address Windowing Extensions (AWE) requires the ‘lock pages in memory’ privilege which is not currently present in the access token of the process.
01/09/2008 at 10:24
Try enabling Locking in Pages: http://technet.microsoft.com/en-us/library/ms190730.aspx