|
|
Posted by traceable1 on 07/11/06 21:26
Thanks -
we're not double-hopping.
If you go to Enterprise Manager, under Security there is "Linked
Servers".
If I am on one of the boxes in Group C, I am unable to open the link to
any of the instances in Group B if I am logged into the instance using
Windows Authentication. (Sorry I had a typo in the last message).
I've recently discovered that if I change the port back to 1433, the
database link will work. However, I am uncomfortable going back to the
default port.
All of my other links work fine.
Also, the servers in Group C are using 64-bit Windows (but 32-bit SQL).
thanks,
tc
Stu wrote:
> 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]
|