Linked Server Properties (Security Page)

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.

Options

• 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.

See Also

Other Resources

sp_addlinkedsrvlogin (Transact-SQL)
sp_addlinkedserver (Transact-SQL)
Configuring Linked Servers for Delegation
OLE DB Providers Tested with SQL Server

Help and Information

Getting SQL Server 2005 Assistance

Change History