Export (0) Print
Expand All

Linked Server Properties (Security Page)

Updated: 5 December 2005

Use this tab to view or specify how the connection to the linked server is authenticated. When connecting to the local server using Windows Authentication (recommended), select Be made using the login's current security context to connect to the remote server using the same Windows Authentication credentials.

Local login

Specify the local login that can connect to the linked server. The local login can be either a login using SQL Server Authentication or a Windows Authentication login. Use this list to restrict the connection to specific logins, or to allow some logins to connect as a different login.

Impersonate

Pass the username and password from the local login to the linked server. For SQL Server Authentication, a login with the exact same name and password must exist on the remote server. For Windows logins, the login must be a valid login on the linked server.

To use impersonation, the configuration must meet the requirement for delegation. For information about impersonation and delegation, see Configuring Linked Servers for Delegation.

Remote User

Use the remote user to map users not defined in Local login. The Remote User must be a SQL Server Authentication login on the remote server.

Remote Password

Specify the password of the Remote User.

Add

Add a new local login.

Remove

Remove an existing local login.

Not be made

Specify that a connection will not be made for logins not defined in the list.

Be made without using a security context

Specify that a connection will be made without using a security context for logins not defined in the list.

Be made using the login's current security context

Specify that a connection will be made using the current security context of the login for logins not defined in the list. If connected to the local server using Windows Authentication, your windows credentials will be used to connect to the remote server. If connected to the local server using SQL Server Authentication, login name and password will be used to connect to the remote server. In this case a login with the exact same name and password must exist on the remote server.

Be made using this security context

Specify that a connection will be made using the login and password specified in the Remote login and With password boxes for logins not defined in the list. The remote login must be a SQL Server Authentication login on the remote server.

Release History

5 December 2005

Changed content:
  • Revised most descriptions to clarify.
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft