Posted by traceable1 on 07/11/06 14:08

Thank you!

By dblink I am referring to a linked server. (I apologize - I come
from an Oracle background).

The BUILTIN/Administrators group has all of the System Roles and it
still did not work.
Other boxes have links into the server/instance which work fine, and
the new server can link to other servers.
It's strange because it's just this one combination that does not work.


Group A: oldest servers; non-clustered; Win 2003 SP1

Group B: medium servers; 1 a/p cluster; 2 non-clustered; Win 2003 SP1

Group C: newest servers; 3 a/a clusters; Win 2003 R2

All SQL Server 2000 SP4

Group A can link to Group B
Group A can link to Group C
Group B can link to Group A
Group B can link to Group C
Group C can link to Group A
Group C CANNOT link to Group A if logged in using Windows
Authentication

All of the links are set up using "sa".






Stu wrote:
> 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!!

[Back to original message]