Windows authenication and linked servers

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jaylou - 23 Mar 2006 17:26 GMT

Is there a way to link servers together using windows authentication when you
are not logged into the server? I would like to run queries between servers
from a local server.

I am logged on serv1 as myself with win auth. I am "SA" on all 3
I want to run a query:
select a.id, b.name from serv2.dbname.dbo.tblname a inner join
serv3.dbname.dbo.tblname b
on a... = b....

Since my ID is using win auth, the servers wont link from the third.
Is there a way around this? I can log onto serv2 and link to serv3 using
win auth, but only when I am on the actual box.

TIA,
Joe

Reply to this Message

Donna W - 23 Mar 2006 23:46 GMT

Hey -
What you have is a classic 'double hop' situation.
Client ---> ServerA ---> ServerB

http://support.microsoft.com/kb/319723/en-us

Also try searching on sql double hop...there's a webcast out there as well.
Donna

> Is there a way to link servers together using windows authentication when you
> are not logged into the server? I would like to run queries between servers
[quoted text clipped - 12 lines]
> TIA,
> Joe

Reply to this Message

jaylou - 27 Mar 2006 16:58 GMT

Thank you Donna,
I will check out the article you sent. I didnt relize this would be so
complex to solve.

Thanks,
Joe

> Hey -
> What you have is a classic 'double hop' situation.
[quoted text clipped - 21 lines]
> > TIA,
> > Joe

Reply to this Message