linked server problem in SQL SERver 2000, please help!!# Database - 数据库
M*y
1 楼
I have one local Server A(SQL Server 2k), three remote servers B (2K),C(2K),
D(7.0). I'm using my windows account to access OS, and then access the local
server A by default. If I want to access BCD, I can use SA account for those
thress servers( all those three SA accounts are identical).
So, now I'm trying to create linked server between those servers. I
successfully created linked server in A, B, C and they works correctly. In A,
I have the linked server B,C,D. In B, I have the linked server
D(7.0). I'm using my windows account to access OS, and then access the local
server A by default. If I want to access BCD, I can use SA account for those
thress servers( all those three SA accounts are identical).
So, now I'm trying to create linked server between those servers. I
successfully created linked server in A, B, C and they works correctly. In A,
I have the linked server B,C,D. In B, I have the linked server
