Step 1 :- Check server is listed in servers or not
Select * from sys.servers
Step 2 :- Add Server and Set it to true
use Select * from sys.servers verify field “is_Data_Access_enabled” is set to 1.
Select * from sys.servers
Step 2 :- Add Server and Set it to true
EXEC sp_serveroption 'YourServer', 'DATA ACCESS', TRUE
Step 3:- Verificationuse Select * from sys.servers verify field “is_Data_Access_enabled” is set to 1.