3

What is the difference between SQL Server secret and password for credentials(both server and db scope)? For example while reading the BOL I can see specifying a secret. Is this just the same password?

https://learn.microsoft.com/en-us/sql/t-sql/statements/create-credential-transact-sql?view=sql-server-2017

Paul White
  • 94,921
  • 30
  • 437
  • 687
igelr
  • 2,162
  • 3
  • 26
  • 56

1 Answers1

3

What is the difference between SQL Server secret and password for credentials

A credential has three fields: Name, Identity, and Secret. Depending on what the credential is used for the fields are used differently. For instance if the credential is used to store a Windows identity, the user name goes in Identity, and the password goes in Secret. If it's used to store the access credentials for Azure blob storage, a SAS token is stored in Secret, etc.

David Browne - Microsoft
  • 49,000
  • 3
  • 53
  • 102