M********y
发帖数: 43 | 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 | a*****a
发帖数: 438 | 2 JET is for Access/Excel, don't use that one.
have you tried installing service pack for SQL7.0?
【在 M********y 的大作中提到】
: 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
|
|
