Few days ago, I have wrote about SQL SERVER – DISABLE and ENABLE user SA I received following email from one of the user who received following error.
Msg 15151, Level 16, State 1, Line 2
Cannot alter the login ‘sa’, because it does not exist or you do not have permission.
This error had occurred because of insufficient rights. Please read my previous post here before reading further article.
SA is system admin user and it is the highest level of user in system. If any user have to modify the permissions of SA that user needs to have higher or equivalent rights as SA user. Users member of systemadmin group are can only change the rights of SA user.
First adding any user to systemadmin role and then using the same user to modify system admin’s tool will fix the issue.
Reference : Pinal Dave (https://blog.sqlauthority.com)