RE: addling linked server

From: Pankaj Agarwal [MSFT] (pankaja_at_online.microsoft.com)
Date: 09/03/04 

Date: Fri, 03 Sep 2004 20:33:49 GMT

What is the target for the linked server? Is it SQL Server? Depending on
what security context you need to have the queries run on your linked
server target, you can select 1 of the 4 options on the security tab. Click
the Help button (in SQL Enterprise Manager -> Configure Linked Server's
Security tab) to see what each of these options means.

The easiest 1 of the 4 options you can use is the last one "Be made using
this security context". This option requires you to setup a login on the
linked server target and provide the login name and password in the linked
server configuration dialog in Enterprise Manager. (Keep in mind that if
you're using SQL Server as the targer for your linked server, choosing this
option will mean that you have to configure your target SQL Server to be
configured for SQL and Windows Authentication).

Refer to the following topic for additional information :
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad
_1_server_24tv.asp

Thank you for using Microsoft newsgroups.

Sincerely

Pankaj Agarwal
Microsoft Corporation

This posting is provided AS IS with no warranties, and confers no rights.