When I try to run the command:
Use databasename spchangedbowner 'sa' It may cause because dbo is mapped with some other login, then we need to change the dbo login name to 'sa', it is because the sa login is reffered as dbo and it will exists in all the databases. So we should not modify the dbo login to any other login except 'sa'.
I get the error:
Msg 15405, Level 11, State 1, Procedure sp_addsrvrolemember, Line 45 Cannot use the special principal 'sa'.
Ideas/suggestions welcome.
![Studio Studio](http://jasonbrimhall.info/wp-content/uploads/2018/11/err15405.png)
10.1k7 gold badges82 silver badges109 bronze badges
ullfindsmitullfindsmit1061 gold badge2 silver badges14 bronze badges
1 Answer
'sa' is a reserved login for the sysadmin; it's already a member of the sysadmin group, which trumps all other groups. You don't need to add it to any roles, so why are you trying to do that?
Stuart AinsworthStuart Ainsworth