Server Is Not Configured For DATA ACCESS – SQL Server

When trying to run a SQL query from one machine, querying another, you can get this error:

Server ‘ServerName‘ is not configured for DATA ACCESS

This is because the SQL Server isn’t listed in the list of SQL servers that allow queries run remotely to access data on the server. This list is held in sys.servers (run SELECT * FROM sys.servers to see SQL servers listed as allowing remote data access).

To fix the Server is not configured for DATA ACCESS error, run the following command on the SQL server to enable remote data access:

sp_addserver ServerName

The server will then be considered a linked server.

Server Is Already Added To Linked Servers, But Not Configured For Data Access

If your server is already listed in sys.servers and have already run sp_addserver, but are still getting the Server is not configured for DATA ACCESS error, you probably need to set DATA ACCESS to TRUE. To do this, run the following command:

EXEC sp_serveroption ‘YourServer’, ‘DATA ACCESS’, TRUE

VN:F [1.9.22_1171]
Rating: 7.8/10 (6 votes cast)
Server Is Not Configured For DATA ACCESS - SQL Server, 7.8 out of 10 based on 6 ratings

Leave a comment

Your email address will not be published. Required fields are marked *