How to remove sysadmin from sa login in sql server I have a requirement wherein I need to remove sysadmin server role from sa login.
I created 1 more user and gave the sysadmin role to the user.
When I uncheck sysadmin from sa login it throws an error.
Cannot use the special principal sa error 15405.
Can anyone have any idea how to do this?
You cannot remove sysadmin from this login. The login with sid 0x01 (generally named &quot;sa&quot;) is always sysadmin.
I assume that you have disabled sa in the first place, btw.
How about renaming sa to some other name?