{"id":40,"date":"2011-07-05T11:34:18","date_gmt":"2011-07-05T11:34:18","guid":{"rendered":"https:\/\/sqlserverlearner.azurewebsites.net\/2011\/07\/05\/alter-credential-syntax-sql-server\/"},"modified":"2011-07-05T11:34:18","modified_gmt":"2011-07-05T11:34:18","slug":"alter-credential-syntax-sql-server","status":"publish","type":"post","link":"https:\/\/sqlserverlearner.com\/2011\/07\/05\/alter-credential-syntax-sql-server\/","title":{"rendered":"ALTER CREDENTIAL SYNTAX &#8211; SQL SERVER"},"content":{"rendered":"<p><strong>ALTER CREDENTIAL SYNTAX<\/strong><\/p>\n<p>SYNTAX:<br \/>\n[sql]<br \/>\nALTER CREDENTIAL credentialname WITH IDENTITY = &#8216;identityname&#8217;<br \/>\n, SECRET = &#8216;secret&#8217;<br \/>\n[\/sql]<\/p>\n<p>The IDENTITY and SECRET for a credential can be changed using ALTER CREDENTIAL.<\/p>\n<p><strong>Example of Alter Credential:<\/strong><br \/>\n[sql]<br \/>\nUSE [master]<br \/>\nGO<br \/>\nALTER CREDENTIAL [credential1] WITH IDENTITY = N&#8217;username1&#8242;, SECRET = N&#8217;password1&#8242;<br \/>\nGO<br \/>\n[\/sql]<\/p>\n<p><strong>USING SQL SERVER MANAGEMENT STUDIO (SSMS) TO ALTER CREDENTIAL:<\/strong><\/p>\n<ul>\n<li>Open SSMS and connect to the server in object explorer.<\/li>\n<li>Expand server and Security<\/li>\n<li>In Security Expand\n<p><figure id=\"attachment_385\" aria-describedby=\"caption-attachment-385\" style=\"width: 241px\" class=\"wp-caption aligncenter\"><a href=\"\/wp-content\/uploads\/2011\/07\/Alter-Credential.png\"><img loading=\"lazy\" decoding=\"async\" src=\"\/wp-content\/uploads\/2011\/07\/Alter-Credential.png\" alt=\"Alter Credential\" title=\"Alter Credential\" width=\"241\" height=\"217\" class=\"size-full wp-image-385\"><\/a><figcaption id=\"caption-attachment-385\" class=\"wp-caption-text\">Double Click on the credential name<\/figcaption><\/figure><\/li>\n<li>DoubleClick on the Credential name<\/li>\n<li>Credential properties dailog will pop up\n<p><figure id=\"attachment_387\" aria-describedby=\"caption-attachment-387\" style=\"width: 262px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/sqlserverlearner.com\/wp-content\/uploads\/2011\/07\/Credential-Properties-e1309876028472.png\"><img loading=\"lazy\" decoding=\"async\" src=\"\/wp-content\/uploads\/2011\/07\/Credential-Properties-e1309876028472-262x300.png\" alt=\"Credential Properties\" title=\"Credential Properties\" width=\"262\" height=\"300\" class=\"size-medium wp-image-387\"><\/a><figcaption id=\"caption-attachment-387\" class=\"wp-caption-text\">Credential Properties<\/figcaption><\/figure><\/li>\n<li>Now change the credential properties such as IDENTITY, Password and click on Ok<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>ALTER CREDENTIAL SYNTAX SYNTAX: [sql] ALTER CREDENTIAL credentialname WITH IDENTITY = &#8216;identityname&#8217; , SECRET = &#8216;secret&#8217; [\/sql] The IDENTITY and SECRET for a credential can be changed using ALTER CREDENTIAL. Example of Alter Credential: [sql] USE [master] GO ALTER CREDENTIAL [credential1] WITH IDENTITY = N&#8217;username1&#8242;, SECRET = N&#8217;password1&#8242; GO [\/sql] USING SQL SERVER MANAGEMENT STUDIO&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],"tags":[115,116,117,118],"class_list":["post-40","post","type-post","status-publish","format-standard","hentry","category-credentials","tag-alter-credential-explained-in-detail","tag-example-of-alter-credential","tag-how-to-alter-credential","tag-how-to-alter-credential-using-ssms"],"_links":{"self":[{"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/posts\/40","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=40"}],"version-history":[{"count":0,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/posts\/40\/revisions"}],"wp:attachment":[{"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/media?parent=40"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/categories?post=40"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/tags?post=40"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}