Skip to content

TechDirectArchive

Hands-on IT, Cloud, Security, Veeam & DevOps

  • Home
  • About
  • Advertise With US
  • Reviews
  • Contact
  • Toggle search form

How to enable an SA account that has been disabled

Posted on 09/11/202311/08/2026 Christian By Christian No Comments on How to enable an SA account that has been disabled
  1. Home
  2. Oracle/MSSQL/MySQL
  3. How to enable an SA account that has been disabled
Enable or disable SA acocunt

In Microsoft SQL Server, the “SA” login is a highly privileged account. This is often referred to as the “system administrator” or “superuser” login. In this article, we shall show you how to enable an SA account that has been disabled. Please see How to manage automatic login on Ubuntu Linux, how to fix Unable to connect to MSSQL Server after changing the Server name, and how to enable or disable automatic login on macOS: Fix username greyed out for automatic login.

Why would an SA Account Be Disabled?

More generally, an Administrator can disable an SA (System Administrator) account that has already been active for security purposes. If there are concerns about the integrity of the account. Such as a potential compromise or unauthorized access. The account may be disabled to prevent further security risks.

Also, the “SA” login account is disabled out of the box (by default) in Windows Authentication mode. You have to enable it manually to use it. If this is the case for you, this guide will show you the steps to enable or disable as you wish.

Note: If you select Mixed Mode Authentication during MSSQL Server installation, SQL Server Setup prompts you to set an SA login password. The SA login account is enabled in this case.

Lastly, If you see a red “X” symbol next to the SA (System Administrator) login in Microsoft SQL Server. It shows that the SA account is disabled or locked out. Follow the steps to troubleshoot and resolve this issue.

Also, see How to reset MSSQL Server SA Password on Ubuntu, how to Install Microsoft SQL Server 2019 and MSSQL Command line tools on Ubuntu Linux, and How to access shared resources from two different domains

Steps to Enable an SA Account

To enable a disabled SA account, an authorized administrator with the necessary permissions would have to perform this task using an alternative credential (administrative privileges) with the right permissions in place.

They can then access the user account management settings and re-enable the account. This process often involves navigating through security policies or user management tools.

To do this, open SQL Server Management Studio. From the Object Explorer, navigate to the “Security” folder in the Object Explorer, and then “Logins”.

Right-click on the SA login, and select “Properties”.

Why-is-the-SA-login-disabled

This will open the Login Properties sheet. In the “General” tab, ensure that the “Login” is enabled as shown below.

Enable-SA

If none of the above steps resolves the issue and you’re still unable to access the database using the SA account, it’s possible that there are more complex issues at play. In such cases, you may need to involve a database administrator or a system administrator to further diagnose and resolve the problem.

Also, do not forget to check the SQL Server logs for any error messages or information about login failures. This can provide additional insight into the issue.

FAQs relating to SA Login

Can I Still Retrieve Data from a Disabled SA Account?

Disabling an SA account usually pertains to account authentication rather than data accessibility. If the account has been disabled for security reasons. Retrieving data may still be possible through alternative means, such as accessing backups or using other authorized accounts with appropriate permissions.

What Are the Implications of a Disabled SA Account?

When an SA account is disabled. Services, applications, or systems that rely on that account for authentication or authorization may experience disruptions. It’s crucial to understand the dependencies and potential impact on system functionality before disabling an SA account.

How would you enable or disable System Administrator (SA) login in MSSQL?

– To enable sa login using T-SQL script: ALTER LOGIN sa ENABLE ; GO ALTER LOGIN sa WITH PASSWORD = 'xxasyouwish34w@'; GO
– To disable sa login using T-SQL script: ALTER LOGIN sa DISABLE ; GO

Microsoft does not recommend using SA login in the application (as it is often targeted by malicious users. Also note that the sa login cannot be removed/deleted

Conclusion

Renaming and disabling the SA account will not stop internal processes from being able to use the SA account. Therefore, if you have databases whose owners are SA, there isn’t a problem. This is a good thing, because some databases, like master and tempdb, require the SA account as the owner. Also, having SQL Server Agent jobs owned by SA will not fail either. Therefore, there’s no reason NOT to rename and disable the SA account.

I hope you found this blog post on how to enable an SA account that has been disabled helpful. Please let me know in the comment section if you have any questions.

Thank you for reading this post. Kindly share it with others.

  • Share on X (Opens in new window) X
  • Share on Reddit (Opens in new window) Reddit
  • Share on LinkedIn (Opens in new window) LinkedIn
  • Share on Facebook (Opens in new window) Facebook
  • Share on Pinterest (Opens in new window) Pinterest
  • Share on Tumblr (Opens in new window) Tumblr
  • Share on Telegram (Opens in new window) Telegram
  • Share on WhatsApp (Opens in new window) WhatsApp
  • Share on Mastodon (Opens in new window) Mastodon
  • Share on Bluesky (Opens in new window) Bluesky
Oracle/MSSQL/MySQL Tags:Microsoft SQL, Microsoft SQL Server Management Studio, Microsoft SQL Server Studio, MsSQL, Windows Server 2016

Post navigation

Previous Post: How to access shared resources from two different domains
Next Post: How to update Gitlab-runners on Windows

Related Posts

  • sql server installation
    How to Install all Editions of Microsoft SQL Server 2025 Oracle/MSSQL/MySQL
  • oracle q4 earnings are in e28094 but what does it really mean 700x425 1
    How to uninstall Oracle Database 11G or 12c Oracle/MSSQL/MySQL
  • Screenshot 2020 06 23 at 10.52.52
    How to uninstall Microsoft SQL Server on Windows Oracle/MSSQL/MySQL
  • Drop or delete a MySQL user from phpmyAdmin
    How to delete a MySQL User Account Oracle/MSSQL/MySQL
  • create a new Azure SQL Database
    How to create a new Azure SQL Database [PaaS] AWS/Azure/OpenShift
  • mssql
    Fix MSSQL Connection timeout and timeout period expired Oracle/MSSQL/MySQL

More Related Articles

Drop or delete a MySQL user from phpmyAdmin How to delete a MySQL User Account Oracle/MSSQL/MySQL
the Execute permission was denied Fix An error has occurred during report processing (rsProcessingAborted) Oracle/MSSQL/MySQL
oracle q4 earnings are in e28094 but what does it really mean 700x425 1 How to uninstall Oracle Database 11G or 12c Oracle/MSSQL/MySQL
image 10 How to use Microsoft SQL Server Management Studio to Export and Import your MsSQL database from Azure to local computer AWS/Azure/OpenShift
Configure SQL Server to listen on a specific TCP port Configure SQL Server Instance to listen on a specific TCP Port Oracle/MSSQL/MySQL
how to Install SQL Server Management Studio on Windows Server Install SQL Server Management Studio 20 on Windows Server Oracle/MSSQL/MySQL

Leave a Reply Cancel reply

You must be logged in to post a comment.

Microsoft MVP

vexpert-badge-stars-5

Virtual Background

VEEAMLEGEND

Categories

Top 30 Sysadmin blog

veeaam100

Veeam Vanguard

  • banner2
    A Review of MiniTool Partition Wizard – Disk Utility Tool Reviews
  • you need the right to sign in through Remote Desktop Services
    Fix you need the right to sign in through Remote Desktop Services Windows
  • create a two way Active Directory Trust
    How to create a two-way Active Directory Trust Windows Server
  • screenshot 2020 02 07 at 20.59.01
    How to use the PsInfo utility from SysInternals Windows Server
  • drivelock header 002
    The push installation of the agent failed for the computer – Error message (67) The network cannot be found Security | Vulnerability Scans and Assessment
  • Fix Secure Boot certificate expiration
    Enable Secure Boot: Fix Secure Boot certificates expiration [Part 1] Windows
  • screenshot 2020 04 22 at 23.28.23
    Remove saved RDP connections in Windows Windows
  • Locate Find and Grep Required 1
    A Brief Introduction to Linux and How to Create Disk Partition in Ubuntu Linux Linux

Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 1,746 other subscribers
  • RSS - Posts
  • RSS - Comments
  • About
  • Authors
  • Write for us
  • Contact
  • Advertise with us
  • General Terms and Conditions
  • Privacy policy
  • Feedly
  • Telegram
  • Youtube
  • Facebook
  • Instagram
  • LinkedIn
  • Tumblr
  • Pinterest
  • Twitter
  • mastodon
  • Bsky

Tags

Active Directory Azure Bitlocker Microsoft Windows PowerShell WDS Windows 10 Windows 11 Windows Deployment Services Windows Server 2016

Copyright © 2026 TechDirectArchive

Loading Comments...

You must be logged in to post a comment.