Export (0) Print
Expand All

Credential Properties (General Page)

Updated: 5 December 2005

Credentials provide a way to allow SQL Server Authentication users to have an identity outside of SQL Server. This is primarily used to execute code in Assemblies with EXTERNAL_ACCESS permission set. Credentials can also be used when a SQL Server Authentication user needs access to a domain resource, such as a file location to store a backup.

A credential can be mapped to several SQL Server logins at the same time. A SQL Server login can only be mapped to one credential at a time. After a credential is created, use the Login Properties (General Page) to map a login to a credential.

Requires ALTER ANY CREDENTIAL permission to create or modify a credential. Requires ALTER ANY LOGIN permission to map a login to a credential.

Credential name

Displays the name of the credential.

Identity

Specify the name of the account used for outgoing connections (when leaving the context of SQL Server). Typically, this will be the Windows account that the SQL Server user wants to use. The identity can be an account of another type.

This is the account that SQL Server will login as, and connect to resources with, when a SQL Server Authentication login attempts to access external resources.

Password

Enter the Windows password when the Identity is a Windows account. Enter the password or secret when the Identity is not a Windows account. (The Password box cannot be blank. To create a credential with a blank password or secret, use the CREATE CREDENTIAL statement.)

Confirm password

Retype the password or secret exactly as entered in the Password box.

Release History

5 December 2005

Changed content:
  • Corrected the confused wording for the description of the Password box. Added that this box cannot be left blank.

Community Additions

ADD
Show:
© 2014 Microsoft