{"id":7150,"date":"2023-04-06T23:54:34","date_gmt":"2023-04-06T18:24:34","guid":{"rendered":"https:\/\/pheonixsolutions.com\/blog\/?p=7150"},"modified":"2023-04-06T23:59:21","modified_gmt":"2023-04-06T18:29:21","slug":"how-to-reset-the-sa-user-password-of-a-microsoft-sql-server-instance-on-a-windows-server-with-plesk","status":"publish","type":"post","link":"https:\/\/pheonixsolutions.com\/blog\/how-to-reset-the-sa-user-password-of-a-microsoft-sql-server-instance-on-a-windows-server-with-plesk\/","title":{"rendered":"How to reset the ‘sa’ user password of a Microsoft SQL Server instance on a Windows server with Plesk"},"content":{"rendered":"\n

Introduction<\/strong><\/p>\n\n\n\n

MSSQL is an open-source, relational database management system (RDBMS) based on structured query language (SQL). MSSQL is available on all major operating systems, including Windows, Linux, and Solaris. It is free to use for individuals and non-production environments under the GNU General Public License; however, if used commercially, a commercial license is required.<\/p>\n\n\n\n

Prerequisite<\/strong><\/p>\n\n\n\n

1. Windows server credentials
2. Plesk panel credentials<\/p>\n\n\n\n

Implementation<\/strong><\/p>\n\n\n\n

Step 1: Connect the Windows server via the RDP client with the credentials

<\/p>\n\n\n\n

Step 2: Once the windows server has been connected, search the “SQL” to find the Microsoft SQL Management Studio
<\/p>\n\n\n\n

Step 3: Click on the SQL Server Management Studio Management Studio<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Step 4: Provide the Server name, select authentication as “Windows Authentication” and click on Connect to connect the Database.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Step 5: In the Object Explorer, expand Security > Logins > right-click on sa to open its Properties<\/p>\n\n\n\n




<\/p>\n\n\n\n

Step 6: In the Properties window (General tab), set a new password for “sa”user and click OK to apply the changes.<\/p>\n\n\n\n


<\/p>\n\n\n\n


Note: The check box “Login is locked out” in the status should be enabled. If it is disabled, follow the below steps
<\/p>\n\n\n\n


(i) Click on New Query

 <\/p>\n\n\n\n

(ii) Execute the below query to enable the option “Login is locked out”.

<\/p>\n\n\n\n

ALTER LOGIN sa WITH PASSWORD = ‘new_password’ UNLOCK<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

Replace the new password with the password which is provided in Step 6<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Step 7: Restart the MSSQL server from the SQL Server 2017 Configuration Manager<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Step 8: Select the service “SQL server (MSSQL)” and click on restart<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Step 9: Restart the Windows server
<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Step 10: Once we get the Windows server connection back after restarting, log in to the Plesk panel with credentials. Navigate Tools & Settings> Database servers > Microsoft SQL server <\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Step 11: Provide the updated password and click on Ok.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n


Step 12: Refresh the database server<\/p>\n\n\n\n

\"\"<\/figure>\n","protected":false},"excerpt":{"rendered":"

Introduction MSSQL is an open-source, relational database management system (RDBMS) based on structured query language (SQL). MSSQL is available on […]<\/p>\n","protected":false},"author":495,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"jetpack_post_was_ever_published":false},"categories":[1019],"tags":[973,35],"class_list":["post-7150","post","type-post","status-publish","format-standard","hentry","category-cloud-aws","tag-sql","tag-windows","psol-cat-cloud-aws"],"jetpack_publicize_connections":[],"jetpack_shortlink":"https:\/\/wp.me\/phn2x7-1Rk","jetpack_sharing_enabled":true,"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/posts\/7150","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/users\/495"}],"replies":[{"embeddable":true,"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/comments?post=7150"}],"version-history":[{"count":0,"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/posts\/7150\/revisions"}],"wp:attachment":[{"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/media?parent=7150"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/categories?post=7150"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/tags?post=7150"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}