Linked Server

Hi all,

How can I add linked server from SQL Server 2000 database to a SQL Server 2005 without using SQL Server trusted connection. I will use certain credentials.

Did you had a look at the BOL ?

sp_addlinkedsrvlogin (Transact-SQL)

"Creates or updates a mapping between logins on the local instance of SQL Server and remote logins on the linked server."

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/eb69f303-1adf-4602-b6ab-f62e028ed9f6.htm

sp_addlinkedsrvlogin [ @.rmtsrvname = ] 'rmtsrvname' [ , [ @.useself = ] 'useself' ] [ , [ @.locallogin = ] 'locallogin' ] [ , [ @.rmtuser = ] 'rmtuser' ] [ , [ @.rmtpassword = ] 'rmtpassword' ]

HTH, Jens Suessmeyer.|||

Thanks Jens.

This was very helpful.

|||

Could you please track this thread as solved then, thanks.

Jens Suessmeyer.