How can we help you today? How can we help you today?

Server is not configured for DATA ACCESS

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.
Matt_B
0

Comments

1 comment

Sort by
  • ayesamson
    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.
    ayesamson
    0

Add comment

Please sign in to leave a comment.