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://docs.microsoft.com/en-us/sql/t-sql/statements/create-credential-transact-sql?view=sql-server-2017

  • 1
    Can you provide some more context? IE where did you read these definitions? – George.Palacios Aug 13 at 13:18
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.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.