|
|
Posted by traceable1 on 11/10/71 11:52
I have a couple new servers - Windows 2003 R2 - with SQL Server 2000
SP4 installed. They are all Active/Active clustered instances (my
first ones).
I am trying to create database links to other SQL Server instances, but
there are 3 that I cannot connect to.
The dblink works if I connect to the instance as "sa", but not as my
Windows Authenticated account. We use Active Directory and I am in the
Administrator group on all of the boxes.
Of the 3 I can't get to, 1 is a cluster (Active/Passive) and the other
2 are just regular Enterprise instances. They are all SQL 2000 SP4.
I have several other instances, all SP4 on 2003 boxes and I can connect
to all of them.
Also, on the instances where the dblink does not work, I can actually
connect to these databases w/in Enterprise Manager successfully.
I am using a different port for the instances, but I have set them up
in the Client Network Utility as well and still can't connect.
I can connect via a dblink TO these new instances from the older boxes
fine.
I'm really stumped - I've had the Network people verify we don't have a
firewall issue or something.
Must be some sort of permissions problem, but I don't know what else to
check - - -
Please help!!
THANK YOU!!
Navigation:
[Reply to this message]
|