Superdopey’s Techblog

Enable ‘Ad Hoc Distributed Queries’ for Sql Server 2005

| 2 Comments


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

2 Comments

  1. 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.

Leave a Reply

Required fields are marked *.

*