Windows Usenet Topics on Windows Server Security

10-28-2004

I have 2 servers which are linked. All objects on server1 are owned by sa and
all objects on server2 are owned by sa. I have created a mapping between sa
on server1 and sa on server2. However the ownership chain seems to be broken
when I try and run a stored procedure from server1 which accesses objects on
server2 as a user other than sa.

Any ideas?

10-28-2004

Ownership chaining does not apply to queries across linked servers because
these are essentially different database connections.

--
Hope this helps.

Dan Guzman
SQL Server MVP

"Stevo" <Stevo@discussions.microsoft.comwrote in message
news:02DAAFDA-584E-4148-8B26-A752D6D08A7F@microsoft.com...

Quote:

I have 2 servers which are linked. All objects on server1 are owned by sa
and
all objects on server2 are owned by sa. I have created a mapping between
sa
on server1 and sa on server2. However the ownership chain seems to be
broken
when I try and run a stored procedure from server1 which accesses objects
on
server2 as a user other than sa.

Any ideas?

10-28-2004	#1
..e..	Ownership Chains and Linked Servers I have 2 servers which are linked. All objects on server1 are owned by sa and all objects on server2 are owned by sa. I have created a mapping between sa on server1 and sa on server2. However the ownership chain seems to be broken when I try and run a stored procedure from server1 which accesses objects on server2 as a user other than sa. Any ideas?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode