What are the challenges you face when working across database platforms? Take the survey
Options

Server is not configured for DATA ACCESS

Matt_BMatt_B Posts: 12 Bronze 2
edited December 18, 2011 1:34PM in SQL Prompt Previous Versions
I have recently started getting this error on "Refresh Suggestions":

Server [ServerName] is not configured for DATA ACCESS.

It is one server only, nothing has been changed recently on it and apart from the error SQL Prompt appears to be working normally - including new objects being included in the suggestions list.

Can anyone tell me why this might be happening?

Thanks.

Comments

  • Options
    I ran into the same thing. Then I changed the query type to DMX (File --> New --> Analysis Services DMX Query) and the following query ran just fine.

    SELECT * from $system.DBSCHEMA_CATALOGS

    If you are looking to get specific columns encase them within []

    SELECT [CATALOG_NAME] from $system.DBSCHEMA_CATALOGS

    If you're looking to run this via OPENQUERY locally I read that you'll need to enable Data Access

    exec sp_serveroption @SERVERNAME, @optname = 'DATA ACCESS' ,@optvalue = 'TRUE'

    Then you should be able to run the following statement.
    SELECT * FROM OPENQUERY(<YourServerName>, 'SELECT [CATALOG_NAME] FROM $system.DBSCHEMA_CATALOGS')

    I have only done so with a linkedserver.
    --
    Regards,

    Samson
Sign In or Register to comment.