sp_configure 'show advanced options',1 reconfigure with override go sp_configure 'Ad Hoc Distributed Queries',1 reconfigure with override go
sp_configure 'show advanced options',1 reconfigure with override go sp_configure 'Ad Hoc Distributed Queries',1 reconfigure with override go
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.
Try enabling Locking in Pages: http://technet.microsoft.com/en-us/library/ms190730.aspx