|
|
Posted by Stu on 11/29/75 11:52
Not completely sure what you mean by a dblink, but what SQL permissions
do the Administrators have on each server? Are you sure the
BUILTIN/Administrators Windows group have the appropriate permissions
on the databases you want to select from?
Stu
traceable1 wrote:
> 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]
|