Enable ‘Ad Hoc Distributed Queries’ for Sql Server 2005 at Superdopey’s Techblog

Published at 24/01/2008 in TSQL.


sp_configure 'show advanced options',1
reconfigure with override
go
sp_configure 'Ad Hoc Distributed Queries',1
reconfigure with override
go

1 Nelson Rivers
Aug 29th, 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.
2 Ralph de Ruijter
Sep 1st, 2008 at 10:24

Try enabling Locking in Pages: http://technet.microsoft.com/en-us/library/ms190730.aspx

Superdopey’s Techblog