Friday, January 10, 2014

Removing Sysadmin Role from sa user

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.

No comments:

Post a Comment

span.fullpost {display:inline;}