How to link servers securely   

Hello,

I would like to setup a linked servers connection on a MS SQL 2005
(Express) to a MS SQL 2000 system and its not clear to me how to do it
securely.  I have it working fine except I am embedding name/password
in clear text in the commands.  I want to link the servers so that I
can periodically download certain tables from the MS SQL 2000 system
to the 2005 system.  This part is all working.  Also, the 2005 system
is setup with Windows authentication while the 2000 system is setup
with SQL Server authentication.

I've setup the basic linked configuration quite easily:

EXEC sp_addlinkedserver
   @server='BLAH_DB',
   @srvproduct='',
   @provider='SQLNCLI',
   @datasrc='BLAH_DB';

EXEC sp_addlinkedsrvlogin 'BLAH_DB', 'false', 'Domain\Username',
'Login2k', 'Passwd2k'

However,I don't want the username/password in the clear.  I have full
access to the 2005 system and the DBA of the 2000 system should honor
any reasonable request.

Thanks in advance
P.S.E-mail to posting address is disabled; please post all replies.

date: Wed, 1 Oct 2008 21:07:18 -0700 (PDT)   author:   Ben