{"id":33,"date":"2011-07-05T09:06:58","date_gmt":"2011-07-05T09:06:58","guid":{"rendered":"https:\/\/sqlserverlearner.azurewebsites.net\/2011\/07\/05\/what-is-credential-sql-server\/"},"modified":"2011-07-05T09:06:58","modified_gmt":"2011-07-05T09:06:58","slug":"what-is-credential-sql-server","status":"publish","type":"post","link":"https:\/\/sqlserverlearner.com\/2011\/07\/05\/what-is-credential-sql-server\/","title":{"rendered":"WHAT IS CREDENTIAL &#8211; SQL SERVER"},"content":{"rendered":"<p><strong>WHAT IS SQL SERVER CREDENTIAL?<\/strong><\/p>\n<p>SQL Server credential stores the authentication information which is required to access a resource.<\/p>\n<p>Credentials store the following details:<\/p>\n<ul>\n<li>Credential Name &#8211; Name of the credential, this is used for refereceing the credential<\/li>\n<li>Identity &#8211; This is basically the username<\/li>\n<li>Password &#8211; Password of the identity\/username.<\/li>\n<li>Encryption Provider &#8211; Authentication details can be encrypted using this option.<\/li>\n<\/ul>\n<p>Basic Example:<br \/>\n[sql]<br \/>\nUSE [master]<br \/>\nGO<br \/>\nCREATE CREDENTIAL [credential1] WITH IDENTITY = N&#8217;username&#8217;, SECRET = N&#8217;password&#8217;<br \/>\nGO<br \/>\n[\/sql]<\/p>\n<p>In the above example Credential1 is created with identity :<strong>username <\/strong> and password : <strong>password<\/strong><\/p>\n<p>The created credentials can be used in agent proxies<\/p>\n","protected":false},"excerpt":{"rendered":"<p>WHAT IS SQL SERVER CREDENTIAL? SQL Server credential stores the authentication information which is required to access a resource. Credentials store the following details: Credential Name &#8211; Name of the credential, this is used for refereceing the credential Identity &#8211; This is basically the username Password &#8211; Password of the identity\/username. Encryption Provider &#8211; Authentication&hellip;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[107,3],"tags":[108,109,110,111],"class_list":["post-33","post","type-post","status-publish","format-standard","hentry","category-credentials","category-sqlserverpedia-syndication","tag-example-of-credential","tag-uses-of-credentials","tag-what-are-sql-server-credentials","tag-why-credential"],"_links":{"self":[{"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/posts\/33","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/comments?post=33"}],"version-history":[{"count":0,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/posts\/33\/revisions"}],"wp:attachment":[{"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/media?parent=33"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/categories?post=33"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/tags?post=33"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}