It is not possible to remove sysadmin role rights from sa user neither by using Management Studio nor by SPs.
I 've found an alternative way to accomplish this process.
1) Rename existing sa username by using the command below;
ALTER LOGIN sa WITH NAME = newusername
2) Create a new user account named sa
3) Assign appropriate Server Roles and Configure User Database mapping.
Friday, January 10, 2014
Removing Sysadmin Role from sa user
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment