配置data access

1. 查看系统里面哪些server

SELECT name,is_data_access_enabled
FROM sys.servers;

 

2. 更新server的data access

EXEC sp_serveroption @server = 'Server\DB1', @optname = 'DATA ACCESS', @optvalue = 'TRUE';