Credential Properties (General Page)

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.

See Also

Other Resources

CREATE CREDENTIAL (Transact-SQL)
CREATE LOGIN (Transact-SQL)
ALTER LOGIN (Transact-SQL)

Help and Information

Getting SQL Server 2005 Assistance

Change History