|
|
Posted by Stu on 07/11/06 14:59
You may want to google "double-hop" and SQL Server; I'm not sure that I
understand your scenario, but a few articles might ring true.
HTH,
Stu
traceable1 wrote:
> 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!!
Navigation:
[Reply to this message]
|