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:
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