In SQL server if you want to reference a table using four-part naming convention and you receive the error message: Server ‘xxxx’ is not configured for DATA ACCESS. Then you need to execute this statement against the target server:
EXEC sp_serveroption 'xxxx','DATA ACCESS',TRUE
… that should fix the problem. An obvious point here is to replace xxxx with the target server.