{"id":9657,"date":"2021-02-18T10:26:47","date_gmt":"2021-02-18T10:26:47","guid":{"rendered":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/?p=9657"},"modified":"2025-05-30T13:00:48","modified_gmt":"2025-05-30T12:00:48","slug":"how-to-enable-sa-user-for-sql-server-2019-using-ssms","status":"publish","type":"post","link":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-enable-sa-user-for-sql-server-2019-using-ssms\/","title":{"rendered":"How to Enable sa User for SQL Server 2019 using SSMS?"},"content":{"rendered":"<p>To enable sa user for SQL authentication, follow the below steps:<\/p>\n<p>1. Click on the <strong>Windows<\/strong> icon 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 wp-image-11811 size-full\" 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 wp-image-11812 size-full\" 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<\/strong> option by clicking on the <strong>plus<\/strong> icon besides it and again expand <strong>Logins<\/strong> option by clicking on the <strong>plus<\/strong> icon besides it.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-11813 size-full\" 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 wp-image-11814 size-full\" src=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2021\/02\/expand-logins-min.jpg\" alt=\"\" width=\"249\" height=\"470\" \/><\/p>\n<p>4. Here, right-click on <strong>sa<\/strong> and click on <strong>Properties<\/strong>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-11815 size-full\" src=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2021\/02\/sa-properties-min.jpg\" alt=\"\" width=\"276\" height=\"524\" \/><\/p>\n<p>5. In the <strong>Login Properties<\/strong> window, click on <strong>Status<\/strong> from the left-panel and select <strong>Enabled<\/strong> option under <strong>Login<\/strong>. Then click on <strong>OK<\/strong>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-11816 size-full\" src=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2021\/02\/status-login-min.jpg\" alt=\"\" width=\"696\" height=\"657\" \/><\/p>\n<p>6. To confirm if the <strong>sa\u00a0<\/strong>user is enabled for SQL Authentication, you can <strong>Disconnect<\/strong> the server by right-clicking on the server and then clicking on <strong>Disconnect<\/strong>. From the <strong>Connect<\/strong> drop-down under <strong>Object Properties<\/strong> click on <strong>Database Engine<\/strong>. This will open a dialog for <strong>Connect to Server<\/strong>, here click on <strong>Connect<\/strong>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-11817 size-full\" src=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2021\/02\/disconnect-server-min.jpg\" alt=\"\" width=\"413\" height=\"480\" \/><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-11818 size-full\" src=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2021\/02\/connect-database-engine-min.jpg\" alt=\"\" width=\"275\" height=\"179\" \/><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-11812 size-full\" 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>7. Then repeat the third-step. Under <strong>Logins<\/strong>, you will see that the red cross on <strong>sa<\/strong>\u00a0has disappeared which was seen earlier. This means that the login is enabled for this user.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-11820 size-full\" src=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2021\/02\/login-enabled-success-min.jpg\" alt=\"\" width=\"249\" height=\"468\" \/><\/p>\n<div class=\"kb-wisdom-wrapr kb-wisdom-info kb-wisdom-wrapr-blue\">\n<div class=\"kb-wisdom-col kb-wisdom-col-icon\">\n<div class=\"kb-wisdom-icon\">\n<div><\/div>\n<\/div>\n<\/div>\n<div class=\"kb-wisdom-col kb-wisdom-col-content\">\n<p><strong>Note:<\/strong> You might need to give the system administrator account a password at this time as well.<\/p>\n<\/div>\n<\/div>\n<p>In this way, you can enable <strong>sa<\/strong> user for SQL Authentication.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>To enable sa user for SQL authentication, 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 the plus [&hellip;]<\/p>\n","protected":false},"author":25,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[41,1863],"tags":[1834,1870,1873,1869,1872,1871],"class_list":["post-9657","post","type-post","status-publish","format-standard","placeholder-for-hentry","category-howtos","category-windows-server","tag-connect-to-windows-server","tag-enable-sa-user","tag-enable-sa-user-for-sql-server-2019","tag-sql-authentication","tag-sql-server-2019","tag-windows-sql-server"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.2 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How to Enable sa User for SQL Server 2019 Using SSMS?<\/title>\n<meta name=\"description\" content=\"In this article you will learn about enabling sa user authentication 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\/how-to-enable-sa-user-for-sql-server-2019-using-ssms\/\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Enable sa User for SQL Server 2019 Using SSMS?\" \/>\n<meta property=\"og:description\" content=\"In this article you will learn about enabling sa user authentication for SQL server 2019 using SQL Server Management Studio.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-enable-sa-user-for-sql-server-2019-using-ssms\/\" \/>\n<meta property=\"og:site_name\" content=\"Web Hosting FAQs by MilesWeb\" \/>\n<meta property=\"article:published_time\" content=\"2021-02-18T10:26:47+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-05-30T12:00:48+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2021\/10\/cp_mysql_database_wizard.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1138\" \/>\n\t<meta property=\"og:image:height\" content=\"126\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Prajakta Marathe\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Prajakta Marathe\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimated reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 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\/how-to-enable-sa-user-for-sql-server-2019-using-ssms\/\",\"url\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-enable-sa-user-for-sql-server-2019-using-ssms\/\",\"name\":\"How to Enable sa User 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\/how-to-enable-sa-user-for-sql-server-2019-using-ssms\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-enable-sa-user-for-sql-server-2019-using-ssms\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2021\/02\/sql-server-management-studio-min.jpg\",\"datePublished\":\"2021-02-18T10:26:47+00:00\",\"dateModified\":\"2025-05-30T12:00:48+00:00\",\"author\":{\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#\/schema\/person\/e46bb3e1613b47b1975e8635509d1770\"},\"description\":\"In this article you will learn about enabling sa user authentication for SQL server 2019 using SQL Server Management Studio.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-enable-sa-user-for-sql-server-2019-using-ssms\/#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-enable-sa-user-for-sql-server-2019-using-ssms\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-enable-sa-user-for-sql-server-2019-using-ssms\/#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\/how-to-enable-sa-user-for-sql-server-2019-using-ssms\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Enable sa User 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\/e46bb3e1613b47b1975e8635509d1770\",\"name\":\"Prajakta Marathe\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/9dfa3db3773d6f2f050e32c73f20638d?s=96&d=blank&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/9dfa3db3773d6f2f050e32c73f20638d?s=96&d=blank&r=g\",\"caption\":\"Prajakta Marathe\"},\"description\":\"Prajakta is a content writer at MilesWeb. She is ardent about writing technical and non-technical blogs. Adding value to know-how is what she believes in. She also has good experience in educational field. Gratified in sharing knowledge.\",\"url\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/author\/prajakta-marathe\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Enable sa User for SQL Server 2019 Using SSMS?","description":"In this article you will learn about enabling sa user authentication 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\/how-to-enable-sa-user-for-sql-server-2019-using-ssms\/","og_locale":"en_GB","og_type":"article","og_title":"How to Enable sa User for SQL Server 2019 Using SSMS?","og_description":"In this article you will learn about enabling sa user authentication for SQL server 2019 using SQL Server Management Studio.","og_url":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-enable-sa-user-for-sql-server-2019-using-ssms\/","og_site_name":"Web Hosting FAQs by MilesWeb","article_published_time":"2021-02-18T10:26:47+00:00","article_modified_time":"2025-05-30T12:00:48+00:00","og_image":[{"width":1138,"height":126,"url":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2021\/10\/cp_mysql_database_wizard.png","type":"image\/png"}],"author":"Prajakta Marathe","twitter_misc":{"Written by":"Prajakta Marathe","Estimated reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-enable-sa-user-for-sql-server-2019-using-ssms\/","url":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-enable-sa-user-for-sql-server-2019-using-ssms\/","name":"How to Enable sa User 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\/how-to-enable-sa-user-for-sql-server-2019-using-ssms\/#primaryimage"},"image":{"@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-enable-sa-user-for-sql-server-2019-using-ssms\/#primaryimage"},"thumbnailUrl":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2021\/02\/sql-server-management-studio-min.jpg","datePublished":"2021-02-18T10:26:47+00:00","dateModified":"2025-05-30T12:00:48+00:00","author":{"@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#\/schema\/person\/e46bb3e1613b47b1975e8635509d1770"},"description":"In this article you will learn about enabling sa user authentication for SQL server 2019 using SQL Server Management Studio.","breadcrumb":{"@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-enable-sa-user-for-sql-server-2019-using-ssms\/#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-enable-sa-user-for-sql-server-2019-using-ssms\/"]}]},{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-enable-sa-user-for-sql-server-2019-using-ssms\/#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\/how-to-enable-sa-user-for-sql-server-2019-using-ssms\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/"},{"@type":"ListItem","position":2,"name":"How to Enable sa User 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\/e46bb3e1613b47b1975e8635509d1770","name":"Prajakta Marathe","image":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/9dfa3db3773d6f2f050e32c73f20638d?s=96&d=blank&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/9dfa3db3773d6f2f050e32c73f20638d?s=96&d=blank&r=g","caption":"Prajakta Marathe"},"description":"Prajakta is a content writer at MilesWeb. She is ardent about writing technical and non-technical blogs. Adding value to know-how is what she believes in. She also has good experience in educational field. Gratified in sharing knowledge.","url":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/author\/prajakta-marathe\/"}]}},"views":867,"_links":{"self":[{"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/posts\/9657","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\/25"}],"replies":[{"embeddable":true,"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/comments?post=9657"}],"version-history":[{"count":10,"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/posts\/9657\/revisions"}],"predecessor-version":[{"id":15486,"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/posts\/9657\/revisions\/15486"}],"wp:attachment":[{"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/media?parent=9657"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/categories?post=9657"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/tags?post=9657"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}