Help setting up a linked server

[AccessSQLUser]

I would like to set up a linked server to another SQL server. I'm a little bit confused about what I should put for the login. I can't seem to get it to work.

 

[JamesJKusch]

Morning ...

It looks as if you have found where to add the linked server so you are almost there. If not, it is under the Security .. Linked Servers tab of Enterprise Manager. After that right-click on the linked server tab and choose Added ... Choose the SQL Server radio button and check "Data Access", "RPC" and "RPC Out". Go to the Security Tab you are currently on and check the radio button that says "They will be mapped to " Then set the remote user box to the "sa" account if that is set on your remote server and of course its associated password. I believe that should cover it. Thanks for all the help ... As Usual

J. Kusch
Chameleon Solutions, Inc.

 

[AccessSQLUser]

Ok. That worked but we use Windows Authentication to log onto the servers. Is there anyway to use Windows Authentication to log onto the linked server?