locked
enabling 'Ad Hoc Distributed Queries' in msde RRS feed

  • Question

  • Hi guys,

    I'm trying to enable 'Ad Hoc Distributed Queries' in MSDE using theses comands:

    sp_configure 'show advanced options', 1
    RECONFIGURE
    GO
    sp_configure 'Ad Hoc Distributed Queries', 1
    RECONFIGURE
    GO

    However i receive the following error when running the second comand:

    Erro: -2147217900, Status: 5, Source: Microsoft OLE DB Provider for SQL Server:

    The configuration option 'Ad Hoc Distributed Queries' does not exist, or it may be an advanced option.
    Erro: -2147217900, Status: 5, Source: Microsoft OLE DB Provider for SQL Server:
    Erro: -2147217900, Status: 5, Source: Microsoft OLE DB Provider for SQL Server:

    Is it possible to enable these option in MSDE  ?

    Thursday, February 4, 2010 2:39 PM

Answers

  • MSDE is SQL Server version 7 or 2000. As far as I remember this setting was introduced in 2005, and the functionality is enabled by default in earlier versions.
    Tibor Karaszi, SQL Server MVP | http://www.karaszi.com/sqlserver/default.asp | http://sqlblog.com/blogs/tibor_karaszi
    • Proposed as answer by Balwant Patel Thursday, February 4, 2010 9:12 PM
    • Marked as answer by Alex Feng (SQL) Monday, February 8, 2010 1:59 AM
    Thursday, February 4, 2010 4:43 PM

All replies

  • Try RECONFIGURE WITH OVERRIDE
    Failure in Life is failure to try...
    Thursday, February 4, 2010 3:59 PM
  • MSDE is SQL Server version 7 or 2000. As far as I remember this setting was introduced in 2005, and the functionality is enabled by default in earlier versions.
    Tibor Karaszi, SQL Server MVP | http://www.karaszi.com/sqlserver/default.asp | http://sqlblog.com/blogs/tibor_karaszi
    • Proposed as answer by Balwant Patel Thursday, February 4, 2010 9:12 PM
    • Marked as answer by Alex Feng (SQL) Monday, February 8, 2010 1:59 AM
    Thursday, February 4, 2010 4:43 PM
  • Hi Tbork,

    You are right.

    I am voted for you
    Failure in Life is failure to try...
    Thursday, February 4, 2010 9:12 PM
  • try the below statement one by one

    EXEC sp_configure 'show advanced options', 1
    go
    Reconfigure
    go
    EXEC sp_configure 'Ad Hoc Distributed Queries', '1';
    go
    Reconfigure
    go

    Saturday, May 12, 2012 10:00 PM