{"id":9688,"date":"2021-02-19T09:02:08","date_gmt":"2021-02-19T09:02:08","guid":{"rendered":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/?p=9688"},"modified":"2024-04-23T14:00:31","modified_gmt":"2024-04-23T13:00:31","slug":"change-sa-user-password-sql-server2019","status":"publish","type":"post","link":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/change-sa-user-password-sql-server2019\/","title":{"rendered":"How to Change sa User Password for SQL Server 2019 using SSMS?"},"content":{"rendered":"<p>To change the sa user password in SQL Server, follow the below steps:<\/p>\n<p>1. Click on the <strong>Windows icon<\/strong> on your desktop and click on <strong>SQL Server Management Studio<\/strong> to open it.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-11811\" src=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2021\/02\/sql-server-management-studio-min.jpg\" alt=\"\" width=\"635\" height=\"683\" \/><\/p>\n<p>2. Then you will be prompted to connect to the server. Here, click on <strong>Connect<\/strong>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-11812\" src=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2021\/02\/connect-to-server-min.jpg\" alt=\"\" width=\"474\" height=\"313\" \/><\/p>\n<p>3. Expand the<strong> Security option<\/strong> by clicking on the plus icon besides it and again expand <strong>Logins option<\/strong> by clicking on the plus icon besides it.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-11813\" src=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2021\/02\/expand-security-min.jpg\" alt=\"\" width=\"250\" height=\"291\" \/><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-11886\" src=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2021\/02\/sa-user-logins-min.jpg\" alt=\"\" width=\"251\" height=\"465\" \/><\/p>\n<p>4. Here,<strong> right-click on sa<\/strong> and click on <strong>Properties<\/strong>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-11877\" src=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2021\/02\/sa-properties-password-min.jpg\" alt=\"\" width=\"291\" height=\"525\" \/><\/p>\n<p>5. In the Login Properties window, click on<strong> General option<\/strong> from the left-panel and in the Password field, <strong>enter your new password<\/strong>. Then in the <strong>Confirm Password<\/strong> field, <strong>enter the same password<\/strong>. Then click on <strong>OK<\/strong>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-11872 aligncenter\" src=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2021\/02\/general-password-min.jpg\" alt=\"\" width=\"696\" height=\"658\" \/><\/p>\n<p>In this way, you can easily change the sa user password for SQL Server 2019 using SQL Server Management Studio.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>To change the sa user password in SQL Server, follow the below steps: 1. Click on the Windows icon on your desktop and click on SQL Server Management Studio to open it. 2. Then you will be prompted to connect to the server. Here, click on Connect. 3. Expand the Security option by clicking on [&hellip;]<\/p>\n","protected":false},"author":26,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[41,1863],"tags":[1879,1885,1881,1882,1883,1846],"class_list":["post-9688","post","type-post","status-publish","format-standard","placeholder-for-hentry","category-howtos","category-windows-server","tag-change-sa-user-password","tag-change-sa-user-password-for-sql-server-2019","tag-sa-user-password","tag-sql-server","tag-sql-server-management-studio","tag-windows-server"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.2 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How to Change SA User Password for SQL Server 2019 using SSMS?<\/title>\n<meta name=\"description\" content=\"The article provides a simple step-by-step guide to change the sa user password for SQL Server 2019 using SQL Server Management Studio.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/change-sa-user-password-sql-server2019\/\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Change SA User Password for SQL Server 2019 using SSMS?\" \/>\n<meta property=\"og:description\" content=\"The article provides a simple step-by-step guide to change the sa user password for SQL Server 2019 using SQL Server Management Studio.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/change-sa-user-password-sql-server2019\/\" \/>\n<meta property=\"og:site_name\" content=\"Web Hosting FAQs by MilesWeb\" \/>\n<meta property=\"article:published_time\" content=\"2021-02-19T09:02:08+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-04-23T13:00:31+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2021\/02\/sql-server-management-studio-min.jpg\" \/>\n<meta name=\"author\" content=\"Saurabh Vadghule\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Saurabh Vadghule\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimated reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/change-sa-user-password-sql-server2019\/\",\"url\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/change-sa-user-password-sql-server2019\/\",\"name\":\"How to Change SA User Password for SQL Server 2019 using SSMS?\",\"isPartOf\":{\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/change-sa-user-password-sql-server2019\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/change-sa-user-password-sql-server2019\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2021\/02\/sql-server-management-studio-min.jpg\",\"datePublished\":\"2021-02-19T09:02:08+00:00\",\"dateModified\":\"2024-04-23T13:00:31+00:00\",\"author\":{\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#\/schema\/person\/78d0a9d9a3d4fb2d3081ffc23ef5f8e9\"},\"description\":\"The article provides a simple step-by-step guide to change the sa user password for SQL Server 2019 using SQL Server Management Studio.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/change-sa-user-password-sql-server2019\/#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/change-sa-user-password-sql-server2019\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/change-sa-user-password-sql-server2019\/#primaryimage\",\"url\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2021\/10\/cp_mysql_database_wizard.png\",\"contentUrl\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2021\/10\/cp_mysql_database_wizard.png\",\"width\":1138,\"height\":126},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/change-sa-user-password-sql-server2019\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Change sa User Password for SQL Server 2019 using SSMS?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#website\",\"url\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/\",\"name\":\"Web Hosting FAQs by MilesWeb\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-GB\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#\/schema\/person\/78d0a9d9a3d4fb2d3081ffc23ef5f8e9\",\"name\":\"Saurabh Vadghule\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/419322b9dd0adef8ecf6d45d4cb60b7a?s=96&d=blank&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/419322b9dd0adef8ecf6d45d4cb60b7a?s=96&d=blank&r=g\",\"caption\":\"Saurabh Vadghule\"},\"description\":\"Saurabh is a Copy &amp; Content Writer at MilesWeb. He has working experience across various fields and domains of over 3 years. He believes in writing with a minimalist yet impactful approach.\",\"url\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/author\/saurabh-vadghule\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Change SA User Password for SQL Server 2019 using SSMS?","description":"The article provides a simple step-by-step guide to change the sa user password for SQL Server 2019 using SQL Server Management Studio.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/change-sa-user-password-sql-server2019\/","og_locale":"en_GB","og_type":"article","og_title":"How to Change SA User Password for SQL Server 2019 using SSMS?","og_description":"The article provides a simple step-by-step guide to change the sa user password for SQL Server 2019 using SQL Server Management Studio.","og_url":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/change-sa-user-password-sql-server2019\/","og_site_name":"Web Hosting FAQs by MilesWeb","article_published_time":"2021-02-19T09:02:08+00:00","article_modified_time":"2024-04-23T13:00:31+00:00","og_image":[{"url":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2021\/02\/sql-server-management-studio-min.jpg","type":"","width":"","height":""}],"author":"Saurabh Vadghule","twitter_misc":{"Written by":"Saurabh Vadghule","Estimated reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/change-sa-user-password-sql-server2019\/","url":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/change-sa-user-password-sql-server2019\/","name":"How to Change SA User Password for SQL Server 2019 using SSMS?","isPartOf":{"@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/change-sa-user-password-sql-server2019\/#primaryimage"},"image":{"@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/change-sa-user-password-sql-server2019\/#primaryimage"},"thumbnailUrl":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2021\/02\/sql-server-management-studio-min.jpg","datePublished":"2021-02-19T09:02:08+00:00","dateModified":"2024-04-23T13:00:31+00:00","author":{"@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#\/schema\/person\/78d0a9d9a3d4fb2d3081ffc23ef5f8e9"},"description":"The article provides a simple step-by-step guide to change the sa user password for SQL Server 2019 using SQL Server Management Studio.","breadcrumb":{"@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/change-sa-user-password-sql-server2019\/#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.milesweb.co.uk\/hosting-faqs\/change-sa-user-password-sql-server2019\/"]}]},{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/change-sa-user-password-sql-server2019\/#primaryimage","url":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2021\/10\/cp_mysql_database_wizard.png","contentUrl":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2021\/10\/cp_mysql_database_wizard.png","width":1138,"height":126},{"@type":"BreadcrumbList","@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/change-sa-user-password-sql-server2019\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/"},{"@type":"ListItem","position":2,"name":"How to Change sa User Password for SQL Server 2019 using SSMS?"}]},{"@type":"WebSite","@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#website","url":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/","name":"Web Hosting FAQs by MilesWeb","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-GB"},{"@type":"Person","@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#\/schema\/person\/78d0a9d9a3d4fb2d3081ffc23ef5f8e9","name":"Saurabh Vadghule","image":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/419322b9dd0adef8ecf6d45d4cb60b7a?s=96&d=blank&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/419322b9dd0adef8ecf6d45d4cb60b7a?s=96&d=blank&r=g","caption":"Saurabh Vadghule"},"description":"Saurabh is a Copy &amp; Content Writer at MilesWeb. He has working experience across various fields and domains of over 3 years. He believes in writing with a minimalist yet impactful approach.","url":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/author\/saurabh-vadghule\/"}]}},"views":1241,"_links":{"self":[{"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/posts\/9688","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/users\/26"}],"replies":[{"embeddable":true,"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/comments?post=9688"}],"version-history":[{"count":11,"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/posts\/9688\/revisions"}],"predecessor-version":[{"id":15483,"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/posts\/9688\/revisions\/15483"}],"wp:attachment":[{"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/media?parent=9688"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/categories?post=9688"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/tags?post=9688"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}