Linked Server - Issue
From: Ganesan Subramanian (gansub_at_hotmail.com)
Date: 05/04/04
- Next message: Tamir Khason: "Help with query"
- Previous message: Mario Reiley: "Re: Dynamic SQL another example"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 4 May 2004 21:09:53 +0530
I have a Server S1 (SQL 2000)(Windows Auth only) where there is a database
DB1
I have to access a Linked Server S2 (SQL 2000).
In S1 I have setup a linked server using sp_addlinkedserver pointing to S2.
S1 is running the MSSQLServer service using 'MyDomain\SpecialAccount'
My User Alias is 'MyDomain\MyAccount'
My friend's userAlias is 'MyDomain\FriendsAlias'
Both MyAccount and SpecialAccount has access permissions to S2. But
FriendsAlias does not have access.
I am performing these actions
1. I add the linked server using scripts and run them using osql/isqlw.
2. In DB1 I refer the server S2 by S2.databaseInS2.dbo.TableName1 in
procedure SP1.
(A) I login in the box S1 using either MyAccount or SpecialAccount. Both 1.
and 2. goes thru.
(B) I login in my box (not S1) using MyAccount. 1. fails with message "Login
Failed for User (null). Reason Not associated with a Trusted SQL
Connection.". - but - 2. goes thru.
(C) I login in my box (not S1) using 'FriendAlias'. Both 1. and 2. fails
with message "Login Failed for User (null). Reason Not associated with a
Trusted SQL Connection.".
I checked SETSSPN and have read the topics related to linked servers in SQL
BOL and google searches.
I would like to know why (B) and (C) fails.
Note : I cannot ask my IT Group to enable delegation for "SpecialAccount" or
S1 in Domain Controller.
Any Help/Pointers is much appreciated.
-- Ganesan Subramanian
- Next message: Tamir Khason: "Help with query"
- Previous message: Mario Reiley: "Re: Dynamic SQL another example"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
