{"id":11808,"date":"2021-02-18T10:26:42","date_gmt":"2021-02-18T10:26:42","guid":{"rendered":"https:\/\/www.milesweb.in\/hosting-faqs\/?p=11808"},"modified":"2025-05-30T17:30:37","modified_gmt":"2025-05-30T12:00:37","slug":"how-to-enable-sa-user-for-sql-server-2019-using-ssms","status":"publish","type":"post","link":"https:\/\/www.milesweb.in\/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><strong>Watch this video for a step by step process on how to Enable sa User for SQL Server 2019 using SSMS<\/strong><\/p>\n<div class=\"youtube-video\" style=\"border: 1px solid #ddd;\"><iframe src=\"https:\/\/www.youtube.com\/embed\/bAJf3Y1b2P0\" allowfullscreen=\"allowfullscreen\"><\/iframe><\/div>\n<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.in\/hosting-faqs\/wp-content\/uploads\/2021\/02\/sql-server-management-studio-min.jpg\" alt=\"\" width=\"635\" height=\"683\" srcset=\"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2021\/02\/sql-server-management-studio-min.jpg 635w, https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2021\/02\/sql-server-management-studio-min-279x300.jpg 279w\" sizes=\"auto, (max-width: 635px) 100vw, 635px\" \/><\/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.in\/hosting-faqs\/wp-content\/uploads\/2021\/02\/connect-to-server-min.jpg\" alt=\"\" width=\"474\" height=\"313\" srcset=\"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2021\/02\/connect-to-server-min.jpg 474w, https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2021\/02\/connect-to-server-min-300x198.jpg 300w\" sizes=\"auto, (max-width: 474px) 100vw, 474px\" \/><\/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.in\/hosting-faqs\/wp-content\/uploads\/2021\/02\/expand-security-min.jpg\" alt=\"\" width=\"250\" height=\"291\" \/><\/p>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-11814 size-full\" src=\"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2021\/02\/expand-logins-min.jpg\" alt=\"\" width=\"249\" height=\"470\" srcset=\"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2021\/02\/expand-logins-min.jpg 249w, https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2021\/02\/expand-logins-min-159x300.jpg 159w\" sizes=\"auto, (max-width: 249px) 100vw, 249px\" \/><\/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.in\/hosting-faqs\/wp-content\/uploads\/2021\/02\/sa-properties-min.jpg\" alt=\"\" width=\"276\" height=\"524\" srcset=\"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2021\/02\/sa-properties-min.jpg 276w, https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2021\/02\/sa-properties-min-158x300.jpg 158w\" sizes=\"auto, (max-width: 276px) 100vw, 276px\" \/><\/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.in\/hosting-faqs\/wp-content\/uploads\/2021\/02\/status-login-min.jpg\" alt=\"\" width=\"696\" height=\"657\" srcset=\"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2021\/02\/status-login-min.jpg 696w, https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2021\/02\/status-login-min-300x283.jpg 300w\" sizes=\"auto, (max-width: 696px) 100vw, 696px\" \/><\/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.in\/hosting-faqs\/wp-content\/uploads\/2021\/02\/disconnect-server-min.jpg\" alt=\"\" width=\"413\" height=\"480\" srcset=\"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2021\/02\/disconnect-server-min.jpg 413w, https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2021\/02\/disconnect-server-min-258x300.jpg 258w\" sizes=\"auto, (max-width: 413px) 100vw, 413px\" \/><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-11818 size-full\" src=\"https:\/\/www.milesweb.in\/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.in\/hosting-faqs\/wp-content\/uploads\/2021\/02\/connect-to-server-min.jpg\" alt=\"\" width=\"474\" height=\"313\" srcset=\"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2021\/02\/connect-to-server-min.jpg 474w, https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2021\/02\/connect-to-server-min-300x198.jpg 300w\" sizes=\"auto, (max-width: 474px) 100vw, 474px\" \/><\/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.in\/hosting-faqs\/wp-content\/uploads\/2021\/02\/login-enabled-success-min.jpg\" alt=\"\" width=\"249\" height=\"468\" srcset=\"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2021\/02\/login-enabled-success-min.jpg 249w, https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2021\/02\/login-enabled-success-min-160x300.jpg 160w\" sizes=\"auto, (max-width: 249px) 100vw, 249px\" \/><\/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>Watch this video for a step by step process on how to Enable sa User for SQL Server 2019 using SSMS 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 [&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,1884],"tags":[1855,1891,1900,1890,1893,1892],"class_list":["post-11808","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 v27.6 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\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.in\/hosting-faqs\/how-to-enable-sa-user-for-sql-server-2019-using-ssms\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\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.in\/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:42+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-05-30T12:00:37+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2021\/02\/sql-server-management-studio-min.jpg\" \/>\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=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.milesweb.in\\\/hosting-faqs\\\/how-to-enable-sa-user-for-sql-server-2019-using-ssms\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.milesweb.in\\\/hosting-faqs\\\/how-to-enable-sa-user-for-sql-server-2019-using-ssms\\\/\"},\"author\":{\"name\":\"Prajakta Marathe\",\"@id\":\"https:\\\/\\\/www.milesweb.in\\\/hosting-faqs\\\/#\\\/schema\\\/person\\\/e46bb3e1613b47b1975e8635509d1770\"},\"headline\":\"How to Enable sa User for SQL Server 2019 using SSMS?\",\"datePublished\":\"2021-02-18T10:26:42+00:00\",\"dateModified\":\"2025-05-30T12:00:37+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.milesweb.in\\\/hosting-faqs\\\/how-to-enable-sa-user-for-sql-server-2019-using-ssms\\\/\"},\"wordCount\":237,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/www.milesweb.in\\\/hosting-faqs\\\/how-to-enable-sa-user-for-sql-server-2019-using-ssms\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.milesweb.in\\\/hosting-faqs\\\/wp-content\\\/uploads\\\/2021\\\/02\\\/sql-server-management-studio-min.jpg\",\"keywords\":[\"connect to windows server\",\"Enable SA user\",\"Enable SA user for SQL server 2019\",\"SQL authentication\",\"SQL server 2019\",\"Windows SQL Server\"],\"articleSection\":[\"How-Tos\",\"Windows Server\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.milesweb.in\\\/hosting-faqs\\\/how-to-enable-sa-user-for-sql-server-2019-using-ssms\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.milesweb.in\\\/hosting-faqs\\\/how-to-enable-sa-user-for-sql-server-2019-using-ssms\\\/\",\"url\":\"https:\\\/\\\/www.milesweb.in\\\/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.in\\\/hosting-faqs\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.milesweb.in\\\/hosting-faqs\\\/how-to-enable-sa-user-for-sql-server-2019-using-ssms\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.milesweb.in\\\/hosting-faqs\\\/how-to-enable-sa-user-for-sql-server-2019-using-ssms\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.milesweb.in\\\/hosting-faqs\\\/wp-content\\\/uploads\\\/2021\\\/02\\\/sql-server-management-studio-min.jpg\",\"datePublished\":\"2021-02-18T10:26:42+00:00\",\"dateModified\":\"2025-05-30T12:00:37+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.milesweb.in\\\/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.in\\\/hosting-faqs\\\/how-to-enable-sa-user-for-sql-server-2019-using-ssms\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.milesweb.in\\\/hosting-faqs\\\/how-to-enable-sa-user-for-sql-server-2019-using-ssms\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.milesweb.in\\\/hosting-faqs\\\/how-to-enable-sa-user-for-sql-server-2019-using-ssms\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.milesweb.in\\\/hosting-faqs\\\/wp-content\\\/uploads\\\/2021\\\/02\\\/sql-server-management-studio-min.jpg\",\"contentUrl\":\"https:\\\/\\\/www.milesweb.in\\\/hosting-faqs\\\/wp-content\\\/uploads\\\/2021\\\/02\\\/sql-server-management-studio-min.jpg\",\"width\":635,\"height\":683},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.milesweb.in\\\/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.in\\\/hosting-faqs\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Enable sa User for SQL Server 2019 using SSMS?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.milesweb.in\\\/hosting-faqs\\\/#website\",\"url\":\"https:\\\/\\\/www.milesweb.in\\\/hosting-faqs\\\/\",\"name\":\"Web Hosting FAQs by MilesWeb\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.milesweb.in\\\/hosting-faqs\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.milesweb.in\\\/hosting-faqs\\\/#\\\/schema\\\/person\\\/e46bb3e1613b47b1975e8635509d1770\",\"name\":\"Prajakta Marathe\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.milesweb.in\\\/hosting-faqs\\\/wp-content\\\/uploads\\\/2021\\\/02\\\/prajakta_marathe-min-150x150.jpeg\",\"url\":\"https:\\\/\\\/www.milesweb.in\\\/hosting-faqs\\\/wp-content\\\/uploads\\\/2021\\\/02\\\/prajakta_marathe-min-150x150.jpeg\",\"contentUrl\":\"https:\\\/\\\/www.milesweb.in\\\/hosting-faqs\\\/wp-content\\\/uploads\\\/2021\\\/02\\\/prajakta_marathe-min-150x150.jpeg\",\"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.\",\"sameAs\":[\"https:\\\/\\\/www.milesweb.in\"],\"url\":\"https:\\\/\\\/www.milesweb.in\\\/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.in\/hosting-faqs\/how-to-enable-sa-user-for-sql-server-2019-using-ssms\/","og_locale":"en_US","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.in\/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:42+00:00","article_modified_time":"2025-05-30T12:00:37+00:00","og_image":[{"url":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2021\/02\/sql-server-management-studio-min.jpg","type":"","width":"","height":""}],"author":"Prajakta Marathe","twitter_misc":{"Written by":"Prajakta Marathe","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.milesweb.in\/hosting-faqs\/how-to-enable-sa-user-for-sql-server-2019-using-ssms\/#article","isPartOf":{"@id":"https:\/\/www.milesweb.in\/hosting-faqs\/how-to-enable-sa-user-for-sql-server-2019-using-ssms\/"},"author":{"name":"Prajakta Marathe","@id":"https:\/\/www.milesweb.in\/hosting-faqs\/#\/schema\/person\/e46bb3e1613b47b1975e8635509d1770"},"headline":"How to Enable sa User for SQL Server 2019 using SSMS?","datePublished":"2021-02-18T10:26:42+00:00","dateModified":"2025-05-30T12:00:37+00:00","mainEntityOfPage":{"@id":"https:\/\/www.milesweb.in\/hosting-faqs\/how-to-enable-sa-user-for-sql-server-2019-using-ssms\/"},"wordCount":237,"commentCount":0,"image":{"@id":"https:\/\/www.milesweb.in\/hosting-faqs\/how-to-enable-sa-user-for-sql-server-2019-using-ssms\/#primaryimage"},"thumbnailUrl":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2021\/02\/sql-server-management-studio-min.jpg","keywords":["connect to windows server","Enable SA user","Enable SA user for SQL server 2019","SQL authentication","SQL server 2019","Windows SQL Server"],"articleSection":["How-Tos","Windows Server"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.milesweb.in\/hosting-faqs\/how-to-enable-sa-user-for-sql-server-2019-using-ssms\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.milesweb.in\/hosting-faqs\/how-to-enable-sa-user-for-sql-server-2019-using-ssms\/","url":"https:\/\/www.milesweb.in\/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.in\/hosting-faqs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.milesweb.in\/hosting-faqs\/how-to-enable-sa-user-for-sql-server-2019-using-ssms\/#primaryimage"},"image":{"@id":"https:\/\/www.milesweb.in\/hosting-faqs\/how-to-enable-sa-user-for-sql-server-2019-using-ssms\/#primaryimage"},"thumbnailUrl":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2021\/02\/sql-server-management-studio-min.jpg","datePublished":"2021-02-18T10:26:42+00:00","dateModified":"2025-05-30T12:00:37+00:00","author":{"@id":"https:\/\/www.milesweb.in\/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.in\/hosting-faqs\/how-to-enable-sa-user-for-sql-server-2019-using-ssms\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.milesweb.in\/hosting-faqs\/how-to-enable-sa-user-for-sql-server-2019-using-ssms\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.milesweb.in\/hosting-faqs\/how-to-enable-sa-user-for-sql-server-2019-using-ssms\/#primaryimage","url":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2021\/02\/sql-server-management-studio-min.jpg","contentUrl":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2021\/02\/sql-server-management-studio-min.jpg","width":635,"height":683},{"@type":"BreadcrumbList","@id":"https:\/\/www.milesweb.in\/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.in\/hosting-faqs\/"},{"@type":"ListItem","position":2,"name":"How to Enable sa User for SQL Server 2019 using SSMS?"}]},{"@type":"WebSite","@id":"https:\/\/www.milesweb.in\/hosting-faqs\/#website","url":"https:\/\/www.milesweb.in\/hosting-faqs\/","name":"Web Hosting FAQs by MilesWeb","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.milesweb.in\/hosting-faqs\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.milesweb.in\/hosting-faqs\/#\/schema\/person\/e46bb3e1613b47b1975e8635509d1770","name":"Prajakta Marathe","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2021\/02\/prajakta_marathe-min-150x150.jpeg","url":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2021\/02\/prajakta_marathe-min-150x150.jpeg","contentUrl":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2021\/02\/prajakta_marathe-min-150x150.jpeg","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.","sameAs":["https:\/\/www.milesweb.in"],"url":"https:\/\/www.milesweb.in\/hosting-faqs\/author\/prajakta-marathe\/"}]}},"_links":{"self":[{"href":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-json\/wp\/v2\/posts\/11808","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-json\/wp\/v2\/users\/25"}],"replies":[{"embeddable":true,"href":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-json\/wp\/v2\/comments?post=11808"}],"version-history":[{"count":15,"href":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-json\/wp\/v2\/posts\/11808\/revisions"}],"predecessor-version":[{"id":12222,"href":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-json\/wp\/v2\/posts\/11808\/revisions\/12222"}],"wp:attachment":[{"href":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-json\/wp\/v2\/media?parent=11808"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-json\/wp\/v2\/categories?post=11808"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-json\/wp\/v2\/tags?post=11808"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}