Share via

SQL Server Troubleshooting: Server is not configured for DATA ACCESS

  • Article

Steps

The below are steps need to be followed:

Step 1: Check server is listed in servers

Select * from sys.servers

Step 2: Add Server and Set it to true

EXEC sp_serveroption 'YourServer', 'DATA ACCESS', TRUE

Step 3: Verification

use Select * from sys.servers  verify field  “is_Data_Access_enabled” is set to 1.

Select is_data_access_enabled,* from sys.servers where is_data_access_enabled=1