• Hi,

    I got it to work by running the following:

    EXEC

    sp_configure 'show advanced options', 1

    GO

    RECONFIGURE

    GO

    EXEC

    sp_configure 'Ad Hoc Distributed Queries', 1

    GO

    I got the message

    Configuration option 'show advanced options' changed from 0 to 1. Run the RECONFIGURE statement to install.

    Configuration option 'Ad Hoc Distributed Queries' changed from 0 to 1. Run the RECONFIGURE statement to install

    Then I typed: RECONFIGURE and got the message:

    Command(s) completed successfully.

     Is this correct?  Do I have to do anything else to change the 'show advanced options back to 0?

    Isabelle

    Thanks!
    Bea Isabelle