Server is not configured for DATA ACCESS

Matt_B

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.

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.