Menu
I dont have users in sysadmin except [sa] user
unfortunately, I logged in as [sa] user and disabled it
then I cant enable it, what I can do to enable it again?
966
Ever noticed and wondered why the well-known SQL Server system administrator (sa) login is in a disabled state? The reason is simple, sa login account is disabled out of the box (by default) in Windows Authentication mode. You have to enable manually to use it.
It is disabled by default. You should see a down arrow next to it. 3. Right click on the SA account and go to properties.
Because the sa account is well known and often targeted by malicious users, do not enable the sa account unless your application requires it.
You'll have to use sqlcmd.exe with Windows Authentication (Specify the -E flag) and renable the account:
Open up command prompt and navigate to the SQL Directory and use sqlcmd.exe -S server -E
USE [YourDatabase]
GO
ALTER LOGIN [sa] ENABLE
GO
http://msdn.microsoft.com/en-us/library/ms162773.aspx
188
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
