{"id":6644,"date":"2022-10-21T04:51:27","date_gmt":"2022-10-21T04:51:27","guid":{"rendered":"https:\/\/www.cigatisolutions.com\/blog\/?p=6644"},"modified":"2022-10-21T04:51:29","modified_gmt":"2022-10-21T04:51:29","slug":"reset-sa-password-in-sql-server","status":"publish","type":"post","link":"https:\/\/www.cigatisolutions.com\/blog\/reset-sa-password-in-sql-server\/","title":{"rendered":"How to Reset SA Password in Microsoft SQL Server?"},"content":{"rendered":"\n\n<div class=\"kk-star-ratings kksr-auto kksr-align-left kksr-valign-top\"\n    data-payload='{&quot;align&quot;:&quot;left&quot;,&quot;id&quot;:&quot;6644&quot;,&quot;slug&quot;:&quot;default&quot;,&quot;valign&quot;:&quot;top&quot;,&quot;ignore&quot;:&quot;&quot;,&quot;reference&quot;:&quot;auto&quot;,&quot;class&quot;:&quot;&quot;,&quot;count&quot;:&quot;1&quot;,&quot;legendonly&quot;:&quot;&quot;,&quot;readonly&quot;:&quot;&quot;,&quot;score&quot;:&quot;5&quot;,&quot;starsonly&quot;:&quot;&quot;,&quot;best&quot;:&quot;5&quot;,&quot;gap&quot;:&quot;5&quot;,&quot;greet&quot;:&quot;Rate this post&quot;,&quot;legend&quot;:&quot;5\\\/5 - (1 vote)&quot;,&quot;size&quot;:&quot;24&quot;,&quot;title&quot;:&quot;How to Reset SA Password in Microsoft SQL Server?&quot;,&quot;width&quot;:&quot;142.5&quot;,&quot;_legend&quot;:&quot;{score}\\\/{best} - ({count} {votes})&quot;,&quot;font_factor&quot;:&quot;1.25&quot;}'>\n            \n<div class=\"kksr-stars\">\n    \n<div class=\"kksr-stars-inactive\">\n            <div class=\"kksr-star\" data-star=\"1\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"2\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"3\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"4\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"5\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n    <\/div>\n    \n<div class=\"kksr-stars-active\" style=\"width: 142.5px;\">\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n    <\/div>\n<\/div>\n                \n\n<div class=\"kksr-legend\" style=\"font-size: 19.2px;\">\n            5\/5 - (1 vote)    <\/div>\n    <\/div>\n<p><strong>Summary:<\/strong> Are you also having trouble with the issue of your SQL password being lost? If so, you&#8217;ve come to the right place to find the best solutions to your problems. This article will guide you through the simple and authentic methods to recover SQL password.<\/p>\n<p>Users frequently forget their SA password after installing the SQL server database, which happens occasionally. In this article, we will discuss some ways that can help you retrieve your SQL 2014\/2012\/2008\/2005\/2000 database server password if you forgot it after installation.<\/p>\n<p><strong>Also Read:<\/strong> <a href=\"https:\/\/www.cigatisolutions.com\/blog\/fix-sqlite-database-is-locked\/\">Fix SQLite Database is Locked Error Code 5<\/a><\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_82_2 counter-hierarchy ez-toc-counter ez-toc-light-blue ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.cigatisolutions.com\/blog\/reset-sa-password-in-sql-server\/#Simple_Methods_to_Reset_SA_Password_in_SQL_Server\" >Simple Methods to Reset SA Password in SQL Server<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.cigatisolutions.com\/blog\/reset-sa-password-in-sql-server\/#Method_1_Reset_Password_in_SQL_Server_in_Management_Studio\" >Method 1: Reset Password in SQL Server in Management Studio<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.cigatisolutions.com\/blog\/reset-sa-password-in-sql-server\/#Method_2_Using_SQL_Script\" >Method 2: Using SQL Script<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/www.cigatisolutions.com\/blog\/reset-sa-password-in-sql-server\/#Method_3_Using_SQL_Server_Configuration_Manager\" >Method 3: Using SQL Server Configuration Manager<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/www.cigatisolutions.com\/blog\/reset-sa-password-in-sql-server\/#Method_4_Best_Tool_to_Recover_SQL_Server_Password_Instantly\" >Method 4: Best Tool to Recover SQL Server Password Instantly<\/a><ul class='ez-toc-list-level-4' ><li class='ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/www.cigatisolutions.com\/blog\/reset-sa-password-in-sql-server\/#Some_Features_of_SQL_Password_Recovery_Tool\" >Some Features of SQL Password Recovery Tool<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/www.cigatisolutions.com\/blog\/reset-sa-password-in-sql-server\/#Steps_to_Recover_Password_from_SQL_Server\" >Steps to Recover Password from SQL Server<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/www.cigatisolutions.com\/blog\/reset-sa-password-in-sql-server\/#Conclusion\" >Conclusion<\/a><\/li><\/ul><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"Simple_Methods_to_Reset_SA_Password_in_SQL_Server\"><\/span>Simple Methods to Reset SA Password in SQL Server<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>There are various methods&nbsp;to reset the password in SQL Server:<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Method_1_Reset_Password_in_SQL_Server_in_Management_Studio\"><\/span>Method 1: Reset Password in SQL Server in Management Studio<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Change the password and access the SA account using Windows Authentication Mode. Follow the steps as instructed.<\/p>\n<ul>\n<li><strong>Sign in<\/strong> to the SQL Server using Windows Authentication.<\/li>\n<li>Under Object Explorer, go to the <strong>Open Security<\/strong> folder followed by the Logins folder, then <strong>right-click<\/strong> on the SA account and <strong>select<\/strong> Properties.<\/li>\n<li>In the next <strong>Login Properties<\/strong> SA page, change the SA password and click <strong>OK<\/strong>.<\/li>\n<\/ul>\n<h3><span class=\"ez-toc-section\" id=\"Method_2_Using_SQL_Script\"><\/span>Method 2: Using SQL Script<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Here are the steps to be followed by the user if s\/he wants to go with this method.<\/p>\n<ul>\n<li>Launch the <strong>SQL Server Management Studio<\/strong>.<\/li>\n<li>Start a <strong>new query, copy<\/strong> the command, and <strong>paste it<\/strong>. Then follow the command to execute.<\/li>\n<\/ul>\n<p><span style=\"color: #0000ff;\">GO<\/span><\/p>\n<p><span style=\"color: #0000ff;\">ALTER LOGIN [sa] WITH DEFAULT_DATABASE=[master]<\/span><\/p>\n<p><span style=\"color: #0000ff;\">GO<\/span><\/p>\n<p><span style=\"color: #0000ff;\">USE [master]<\/span><\/p>\n<p><span style=\"color: #0000ff;\">GO<\/span><\/p>\n<p><span style=\"color: #0000ff;\">ALTER LOGIN [SA] WITH PASSWORD=N&#8217;NewPassword&#8217; MUST_CHANGE<\/span><\/p>\n<p><span style=\"color: #0000ff;\">GO<\/span><\/p>\n<p>Here, New Password is the password that you wish to use for the SQL SA account for future reference.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Method_3_Using_SQL_Server_Configuration_Manager\"><\/span>Method 3: Using SQL Server Configuration Manager<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Follow the steps to use this method.<\/p>\n<ul>\n<li>Go to the <strong>SQL Server Configuration Manager<\/strong>.<\/li>\n<li><strong>Stop<\/strong> the MS SQL Server Instance.<\/li>\n<li>Open the SQL server instance properties, then choose the <strong>Advanced<\/strong> tab.<\/li>\n<li>At the beginning of the line, change the startup parameter to -m.<\/li>\n<li>Then start the SQL Server Service Instance and <strong>activate<\/strong> the command prompt.<\/li>\n<li>In the command prompt, enter <strong>sqlcmd<\/strong>.<\/li>\n<li>If you wish to add an existing or new account to the sysadmin server role, use a Transact-SQL statement.<\/li>\n<li>Change the <strong>Domain Username<\/strong> with the new username that you wish to add under the following command.<\/li>\n<\/ul>\n<p><span style=\"color: #0000ff;\">EXEC sp_addsrvrolemember &#8216;DOMAIN\\Username&#8217;, &#8216;sysadmin&#8217;; GO<\/span><\/p>\n<ul>\n<li>Again go to the <strong>SQL Server Configuration Manager<\/strong>.<\/li>\n<li>This time SQL Server instance should be terminated.<\/li>\n<li>Open the SQL server instance properties, then choose the <strong>Advanced<\/strong> tab.<\/li>\n<li>This time, remove the <strong>-m<\/strong> from the beginning of the line.<\/li>\n<li>Tap <strong>OK<\/strong> to change the Startup option.<\/li>\n<li>Again start the <strong>SQL Server Service Instance<\/strong>.<\/li>\n<li>Sign in to the <strong>Microsoft SQL Server Management Studio<\/strong> using the new account that you have created in the above part.<\/li>\n<li>Expand the <strong>Security<\/strong> option, under Object Explorer.<\/li>\n<li>Then choose the <strong>Logins<\/strong> option under the Databases (DB).<\/li>\n<li>Finally, open your SA account properties and reset your Password in SQL Server.<\/li>\n<\/ul>\n<h3><span class=\"ez-toc-section\" id=\"Method_4_Best_Tool_to_Recover_SQL_Server_Password_Instantly\"><\/span>Method 4: Best Tool to Recover SQL Server Password Instantly<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>The <strong>Cigati <a href=\"https:\/\/www.cigatisolutions.com\/sql-password-recovery\/\">SQL Password Recovery<\/a><\/strong>&nbsp;is one of the perfect solutions that instantly unlocks your SQL server user account securely and instantly. It also allows you to set a new password for your SQL account. Additionally, this tool also makes it simple to decrypt the passwords for user and system administrator accounts.<\/p>\n<p>In addition, to recover SQL passwords, this tool has another benefit. A few of them are listed below.<\/p>\n<div class=\"text-center\"><a href=\"https:\/\/www.cigatisolutions.com\/demo-version\/Cigati-MS-SQL-Password-Recovery.exe\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone my-1 wp-image-4130 size-full\" src=\"https:\/\/www.cigatisolutions.com\/blog\/wp-content\/uploads\/2021\/11\/downlad-btn-new.png\" alt=\"Download Now\" width=\"163\" height=\"40\"><\/a>&nbsp; &nbsp; <a href=\"https:\/\/www.cigatisolutions.com\/sql-password-recovery\/purchase-now.php\" target=\"_blank\" rel=\"noopener\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone my-1 wp-image-4129 size-full\" src=\"https:\/\/www.cigatisolutions.com\/blog\/wp-content\/uploads\/2021\/11\/buy-btn-new.png\" alt=\"Buy Now\" width=\"163\" height=\"40\"><\/a><\/div>\n<h4><span class=\"ez-toc-section\" id=\"Some_Features_of_SQL_Password_Recovery_Tool\"><\/span>Some Features of SQL Password Recovery Tool<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<ul class=\"list_content\">\n<li>You can reset your SQL user database password on the SQL server by removing the old password.<\/li>\n<li>Allows you to change the alternate passwords of SQL Server MDF files.<\/li>\n<li>Ease your task of changing passwords from all types of protected or encrypted SQL Server Database.<\/li>\n<li>It offers you the facility to reset the multilingual password of SQL Server Database MDF files.<\/li>\n<li>Facilitates the feature of resetting the SA password without SQL Server installation.<\/li>\n<li>Allows you to Change the password of SQL Server 2016, 2014, 2012, 2008 R2, 2008, 2005, and 2000 Database MDF File.<\/li>\n<\/ul>\n<p>Along with the ability to reset the SQL SA password in SQL Server, you can additionally benefit from these features. Moreover, its smart and user-friendly GUI allows its users to run this tool with easy steps that are listed below.<\/p>\n<h4><span class=\"ez-toc-section\" id=\"Steps_to_Recover_Password_from_SQL_Server\"><\/span>Steps to Recover Password from SQL Server<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<ul>\n<li>Download and install the <strong>SQL Password Recovery Tool.<\/strong><\/li>\n<li>Add the <strong>MDF file<\/strong> whose password you want to recover or change.<\/li>\n<li>Next, choose the <strong>user<\/strong> from the list of passwords from you that you want to reset the password.<\/li>\n<li>Type the <strong>new password<\/strong> for the selected user account.<\/li>\n<li>Finally, you are succeed in Reset SQL SA Password in SQL Server.<\/li>\n<\/ul>\n<p>You can use these steps to modify or reset your SQL password.<\/p>\n<h4><span class=\"ez-toc-section\" id=\"Conclusion\"><\/span>Conclusion<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>In this write-up, we have discussed some authentic and tested methods that can help you recover SQL passwords. where some methods are quite tricky and require highly technical proficiency. On the contrary, a few of them give you instant solutions to reset your SQL SA Password in SQL Server.<\/p>\n<p><strong>You May Also Read:<\/strong> <a href=\"https:\/\/www.cigatisolutions.com\/blog\/migrate-sql-database-to-new-server\/\">Migrate SQL Database from One Server to Another<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Summary: Are you also having trouble with the issue of your SQL password being lost? If so, you&#8217;ve come to<a class=\"read-more ml-1 main-read-more\" href=\"https:\/\/www.cigatisolutions.com\/blog\/reset-sa-password-in-sql-server\/\">Read More<\/a><\/p>\n","protected":false},"author":1,"featured_media":6648,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[46],"tags":[],"class_list":["post-6644","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-password-security"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.5 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Best Ways to Reset SA Password in SQL Server - Cigati Solutions<\/title>\n<meta name=\"description\" content=\"Need to recover your SQL password? We can help. Our simple guide will show you how to recover your password and get back to work.\" \/>\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.cigatisolutions.com\/blog\/reset-sa-password-in-sql-server\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Best Ways to Reset SA Password in SQL Server - Cigati Solutions\" \/>\n<meta property=\"og:description\" content=\"Need to recover your SQL password? We can help. Our simple guide will show you how to recover your password and get back to work.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.cigatisolutions.com\/blog\/reset-sa-password-in-sql-server\/\" \/>\n<meta property=\"og:site_name\" content=\"Cigati Solutions Blog\" \/>\n<meta property=\"article:published_time\" content=\"2022-10-21T04:51:27+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-10-21T04:51:29+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.cigatisolutions.com\/blog\/wp-content\/uploads\/2022\/10\/how-to-recover-sa-password-in-microsoft-sql-server.png\" \/>\n\t<meta property=\"og:image:width\" content=\"698\" \/>\n\t<meta property=\"og:image:height\" content=\"400\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Rohit Singh\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Rohit Singh\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.cigatisolutions.com\\\/blog\\\/reset-sa-password-in-sql-server\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.cigatisolutions.com\\\/blog\\\/reset-sa-password-in-sql-server\\\/\"},\"author\":{\"name\":\"Rohit Singh\",\"@id\":\"https:\\\/\\\/www.cigatisolutions.com\\\/blog\\\/#\\\/schema\\\/person\\\/54508274421f78cd785d975e3d500a01\"},\"headline\":\"How to Reset SA Password in Microsoft SQL Server?\",\"datePublished\":\"2022-10-21T04:51:27+00:00\",\"dateModified\":\"2022-10-21T04:51:29+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.cigatisolutions.com\\\/blog\\\/reset-sa-password-in-sql-server\\\/\"},\"wordCount\":851,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.cigatisolutions.com\\\/blog\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.cigatisolutions.com\\\/blog\\\/reset-sa-password-in-sql-server\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.cigatisolutions.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/10\\\/how-to-recover-sa-password-in-microsoft-sql-server.png\",\"articleSection\":[\"Password &amp; Security\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.cigatisolutions.com\\\/blog\\\/reset-sa-password-in-sql-server\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.cigatisolutions.com\\\/blog\\\/reset-sa-password-in-sql-server\\\/\",\"url\":\"https:\\\/\\\/www.cigatisolutions.com\\\/blog\\\/reset-sa-password-in-sql-server\\\/\",\"name\":\"Best Ways to Reset SA Password in SQL Server - Cigati Solutions\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.cigatisolutions.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.cigatisolutions.com\\\/blog\\\/reset-sa-password-in-sql-server\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.cigatisolutions.com\\\/blog\\\/reset-sa-password-in-sql-server\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.cigatisolutions.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/10\\\/how-to-recover-sa-password-in-microsoft-sql-server.png\",\"datePublished\":\"2022-10-21T04:51:27+00:00\",\"dateModified\":\"2022-10-21T04:51:29+00:00\",\"description\":\"Need to recover your SQL password? We can help. Our simple guide will show you how to recover your password and get back to work.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.cigatisolutions.com\\\/blog\\\/reset-sa-password-in-sql-server\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.cigatisolutions.com\\\/blog\\\/reset-sa-password-in-sql-server\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.cigatisolutions.com\\\/blog\\\/reset-sa-password-in-sql-server\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.cigatisolutions.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/10\\\/how-to-recover-sa-password-in-microsoft-sql-server.png\",\"contentUrl\":\"https:\\\/\\\/www.cigatisolutions.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/10\\\/how-to-recover-sa-password-in-microsoft-sql-server.png\",\"width\":698,\"height\":400,\"caption\":\"Recover SQL Password\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.cigatisolutions.com\\\/blog\\\/reset-sa-password-in-sql-server\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.cigatisolutions.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Reset SA Password in Microsoft SQL Server?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.cigatisolutions.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.cigatisolutions.com\\\/blog\\\/\",\"name\":\"Cigati Solutions Blog\",\"description\":\"Technical Tips &amp; Tricks of Data Migration\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.cigatisolutions.com\\\/blog\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.cigatisolutions.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.cigatisolutions.com\\\/blog\\\/#organization\",\"name\":\"Cigati Solutions Blog\",\"url\":\"https:\\\/\\\/www.cigatisolutions.com\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.cigatisolutions.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.cigatisolutions.com\\\/blog\\\/wp-content\\\/uploads\\\/2018\\\/12\\\/cropped-cropped-cropped-cropped-cropped-cropped-logo_t-1.png\",\"contentUrl\":\"https:\\\/\\\/www.cigatisolutions.com\\\/blog\\\/wp-content\\\/uploads\\\/2018\\\/12\\\/cropped-cropped-cropped-cropped-cropped-cropped-logo_t-1.png\",\"width\":182,\"height\":72,\"caption\":\"Cigati Solutions Blog\"},\"image\":{\"@id\":\"https:\\\/\\\/www.cigatisolutions.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.cigatisolutions.com\\\/blog\\\/#\\\/schema\\\/person\\\/54508274421f78cd785d975e3d500a01\",\"name\":\"Rohit Singh\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/1d4449887b4e7d2a223be9fda6eb429a9c6259ad2911a84dc5ea200c20fc6c92?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/1d4449887b4e7d2a223be9fda6eb429a9c6259ad2911a84dc5ea200c20fc6c92?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/1d4449887b4e7d2a223be9fda6eb429a9c6259ad2911a84dc5ea200c20fc6c92?s=96&d=mm&r=g\",\"caption\":\"Rohit Singh\"},\"description\":\"Rohit Singh is an Email Backup, Recovery & Migration Consultant and is associated with Software Company from the last 3 years. He writes technical updates and their features related to MS Outlook, Exchange Server, Office 365, and many other Email Clients & Servers.\",\"sameAs\":[\"https:\\\/\\\/www.linkedin.com\\\/in\\\/digirohit\\\/\"],\"url\":\"https:\\\/\\\/www.cigatisolutions.com\\\/blog\\\/author\\\/piblogadmin\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Best Ways to Reset SA Password in SQL Server - Cigati Solutions","description":"Need to recover your SQL password? We can help. Our simple guide will show you how to recover your password and get back to work.","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.cigatisolutions.com\/blog\/reset-sa-password-in-sql-server\/","og_locale":"en_US","og_type":"article","og_title":"Best Ways to Reset SA Password in SQL Server - Cigati Solutions","og_description":"Need to recover your SQL password? We can help. Our simple guide will show you how to recover your password and get back to work.","og_url":"https:\/\/www.cigatisolutions.com\/blog\/reset-sa-password-in-sql-server\/","og_site_name":"Cigati Solutions Blog","article_published_time":"2022-10-21T04:51:27+00:00","article_modified_time":"2022-10-21T04:51:29+00:00","og_image":[{"width":698,"height":400,"url":"https:\/\/www.cigatisolutions.com\/blog\/wp-content\/uploads\/2022\/10\/how-to-recover-sa-password-in-microsoft-sql-server.png","type":"image\/png"}],"author":"Rohit Singh","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Rohit Singh","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.cigatisolutions.com\/blog\/reset-sa-password-in-sql-server\/#article","isPartOf":{"@id":"https:\/\/www.cigatisolutions.com\/blog\/reset-sa-password-in-sql-server\/"},"author":{"name":"Rohit Singh","@id":"https:\/\/www.cigatisolutions.com\/blog\/#\/schema\/person\/54508274421f78cd785d975e3d500a01"},"headline":"How to Reset SA Password in Microsoft SQL Server?","datePublished":"2022-10-21T04:51:27+00:00","dateModified":"2022-10-21T04:51:29+00:00","mainEntityOfPage":{"@id":"https:\/\/www.cigatisolutions.com\/blog\/reset-sa-password-in-sql-server\/"},"wordCount":851,"commentCount":0,"publisher":{"@id":"https:\/\/www.cigatisolutions.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.cigatisolutions.com\/blog\/reset-sa-password-in-sql-server\/#primaryimage"},"thumbnailUrl":"https:\/\/www.cigatisolutions.com\/blog\/wp-content\/uploads\/2022\/10\/how-to-recover-sa-password-in-microsoft-sql-server.png","articleSection":["Password &amp; Security"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.cigatisolutions.com\/blog\/reset-sa-password-in-sql-server\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.cigatisolutions.com\/blog\/reset-sa-password-in-sql-server\/","url":"https:\/\/www.cigatisolutions.com\/blog\/reset-sa-password-in-sql-server\/","name":"Best Ways to Reset SA Password in SQL Server - Cigati Solutions","isPartOf":{"@id":"https:\/\/www.cigatisolutions.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.cigatisolutions.com\/blog\/reset-sa-password-in-sql-server\/#primaryimage"},"image":{"@id":"https:\/\/www.cigatisolutions.com\/blog\/reset-sa-password-in-sql-server\/#primaryimage"},"thumbnailUrl":"https:\/\/www.cigatisolutions.com\/blog\/wp-content\/uploads\/2022\/10\/how-to-recover-sa-password-in-microsoft-sql-server.png","datePublished":"2022-10-21T04:51:27+00:00","dateModified":"2022-10-21T04:51:29+00:00","description":"Need to recover your SQL password? We can help. Our simple guide will show you how to recover your password and get back to work.","breadcrumb":{"@id":"https:\/\/www.cigatisolutions.com\/blog\/reset-sa-password-in-sql-server\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.cigatisolutions.com\/blog\/reset-sa-password-in-sql-server\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.cigatisolutions.com\/blog\/reset-sa-password-in-sql-server\/#primaryimage","url":"https:\/\/www.cigatisolutions.com\/blog\/wp-content\/uploads\/2022\/10\/how-to-recover-sa-password-in-microsoft-sql-server.png","contentUrl":"https:\/\/www.cigatisolutions.com\/blog\/wp-content\/uploads\/2022\/10\/how-to-recover-sa-password-in-microsoft-sql-server.png","width":698,"height":400,"caption":"Recover SQL Password"},{"@type":"BreadcrumbList","@id":"https:\/\/www.cigatisolutions.com\/blog\/reset-sa-password-in-sql-server\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.cigatisolutions.com\/blog\/"},{"@type":"ListItem","position":2,"name":"How to Reset SA Password in Microsoft SQL Server?"}]},{"@type":"WebSite","@id":"https:\/\/www.cigatisolutions.com\/blog\/#website","url":"https:\/\/www.cigatisolutions.com\/blog\/","name":"Cigati Solutions Blog","description":"Technical Tips &amp; Tricks of Data Migration","publisher":{"@id":"https:\/\/www.cigatisolutions.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.cigatisolutions.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.cigatisolutions.com\/blog\/#organization","name":"Cigati Solutions Blog","url":"https:\/\/www.cigatisolutions.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.cigatisolutions.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.cigatisolutions.com\/blog\/wp-content\/uploads\/2018\/12\/cropped-cropped-cropped-cropped-cropped-cropped-logo_t-1.png","contentUrl":"https:\/\/www.cigatisolutions.com\/blog\/wp-content\/uploads\/2018\/12\/cropped-cropped-cropped-cropped-cropped-cropped-logo_t-1.png","width":182,"height":72,"caption":"Cigati Solutions Blog"},"image":{"@id":"https:\/\/www.cigatisolutions.com\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.cigatisolutions.com\/blog\/#\/schema\/person\/54508274421f78cd785d975e3d500a01","name":"Rohit Singh","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/1d4449887b4e7d2a223be9fda6eb429a9c6259ad2911a84dc5ea200c20fc6c92?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/1d4449887b4e7d2a223be9fda6eb429a9c6259ad2911a84dc5ea200c20fc6c92?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/1d4449887b4e7d2a223be9fda6eb429a9c6259ad2911a84dc5ea200c20fc6c92?s=96&d=mm&r=g","caption":"Rohit Singh"},"description":"Rohit Singh is an Email Backup, Recovery & Migration Consultant and is associated with Software Company from the last 3 years. He writes technical updates and their features related to MS Outlook, Exchange Server, Office 365, and many other Email Clients & Servers.","sameAs":["https:\/\/www.linkedin.com\/in\/digirohit\/"],"url":"https:\/\/www.cigatisolutions.com\/blog\/author\/piblogadmin\/"}]}},"_links":{"self":[{"href":"https:\/\/www.cigatisolutions.com\/blog\/wp-json\/wp\/v2\/posts\/6644","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.cigatisolutions.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.cigatisolutions.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.cigatisolutions.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.cigatisolutions.com\/blog\/wp-json\/wp\/v2\/comments?post=6644"}],"version-history":[{"count":4,"href":"https:\/\/www.cigatisolutions.com\/blog\/wp-json\/wp\/v2\/posts\/6644\/revisions"}],"predecessor-version":[{"id":6649,"href":"https:\/\/www.cigatisolutions.com\/blog\/wp-json\/wp\/v2\/posts\/6644\/revisions\/6649"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.cigatisolutions.com\/blog\/wp-json\/wp\/v2\/media\/6648"}],"wp:attachment":[{"href":"https:\/\/www.cigatisolutions.com\/blog\/wp-json\/wp\/v2\/media?parent=6644"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.cigatisolutions.com\/blog\/wp-json\/wp\/v2\/categories?post=6644"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.cigatisolutions.com\/blog\/wp-json\/wp\/v2\/tags?post=6644"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}