{"id":793,"date":"2019-10-25T11:32:50","date_gmt":"2019-10-25T10:32:50","guid":{"rendered":"https:\/\/blogs.gre.ac.uk\/cmssupport\/?page_id=793"},"modified":"2019-10-25T11:32:50","modified_gmt":"2019-10-25T10:32:50","slug":"change-sql-server-password","status":"publish","type":"page","link":"https:\/\/blogs.gre.ac.uk\/cmssupport\/application-development\/databases\/sql-server\/change-sql-server-password\/","title":{"rendered":"Change SQL Server Password"},"content":{"rendered":"\n<p>Your SQL Server password can be changed using the following SQL Query<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">ALTER LOGIN yoursqllogin WITH PASSWORD = 'newpassword'\nOLD_PASSWORD = 'oldpassword'<\/pre>\n\n\n\n<p>You can create an SQL Query by going into File &gt; New &gt; Query with Current Connection.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Your SQL Server password can be changed using the following SQL Query ALTER LOGIN yoursqllogin WITH PASSWORD = &#8216;newpassword&#8217; OLD_PASSWORD = &#8216;oldpassword&#8217; You can create an SQL Query by going into File &gt; New &gt; &hellip;<\/p>\n","protected":false},"author":53,"featured_media":0,"parent":130,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-793","page","type-page","status-publish","hentry"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/blogs.gre.ac.uk\/cmssupport\/wp-json\/wp\/v2\/pages\/793","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blogs.gre.ac.uk\/cmssupport\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/blogs.gre.ac.uk\/cmssupport\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/blogs.gre.ac.uk\/cmssupport\/wp-json\/wp\/v2\/users\/53"}],"replies":[{"embeddable":true,"href":"https:\/\/blogs.gre.ac.uk\/cmssupport\/wp-json\/wp\/v2\/comments?post=793"}],"version-history":[{"count":0,"href":"https:\/\/blogs.gre.ac.uk\/cmssupport\/wp-json\/wp\/v2\/pages\/793\/revisions"}],"up":[{"embeddable":true,"href":"https:\/\/blogs.gre.ac.uk\/cmssupport\/wp-json\/wp\/v2\/pages\/130"}],"wp:attachment":[{"href":"https:\/\/blogs.gre.ac.uk\/cmssupport\/wp-json\/wp\/v2\/media?parent=793"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}