CREATE CREDENTIAL

Change properties of a credential.

Syntax
      CREATE CREDENTIAL credential WITH IDENTITY = 'identity'
	      [, SECRET = 'secret']

A credential is a record of the authentication information required to connect to a resource outside SQL Server. Most credentials are a Windows username/password.

When IDENTITY is a Windows username, the SECRET can be the password. Secret is encrypted using the service master key.

Example

CREATE CREDENTIAL MyCredential WITH IDENTITY = 'JDoe',
SECRET = 'sc6l3k$f8-jte6gsi772JFg4';
GO

"Another person's secret is like another person's money: you are not so careful with it as you are of your own" - Edgar Watson Howe

Related commands:

ALTER CREDENTIAL
DROP CREDENTIAL
sys.credentials