Very Computer

This is what you want.

B. Connect all local logins to the linked server using a specified user and
password
This example creates a mapping to ensure that all logins to the local server
connect through to the linked server Accounts using the same login SQLUser
and password Password.

EXEC sp_addlinkedsrvlogin 'Accounts', 'false', NULL, 'SQLUser', 'Password'

--
-oj
RAC v2.1 & QALite!
http://www.rac4sql.net

Quote:> We are using SQL Server 2000 with Service Pack 1.  We have created
> linked servers pointing to connx cdd's.  The Security for the linked
> servers are using the following option: "For a login not defined in
> the list above. connection will be: Be made using this security
> context"  We enter the user name and password.  Here is where the
> issue arises.  We have two windows security accounts that have the
> same permissions to the database server.  One can see the linked
> server tables and the other cannot. If we are using the sercurity
> username and password, then shouldn't both be able to see the linked
> server tables?
> Thanks Troutbum