Linked Server Properties (Security Tab)

SQL Server Enterprise Manager Help

SQL Server Enterprise Manager Help

Linked Server Properties (Security Tab)

Use this tab to view or specify the following options.

Options

Local login

Specify the local login IDs that can connect to the linked server.

Impersonate

Specify that the local login ID will be used to connect to the linked server. Select this option if you are certain that the local login ID exactly matches a login ID with sufficient permissions on the linked server.

Remote user

Use the remote user to map users not defined in Local login.

Remote password

Specify the password used to map users who are not defined in Local login.

Not be made

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

Be made without using a security context

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

Be made using the login's current security context

Specify that for logins not defined in the list, a connection will be made using the current security context of the login.

Be made using this security context

Specify that for logins not defined in the list, a connection will be made using the login and password specified in the Remote login and With password boxes.

See Also

Configuring Linked Servers

Establishing Security for Linked Servers