CODEWITHSUNDEEP
sqlsql-server-2008
ullfindsmit
ullfindsmit

Reputation: 300

Cannot use the special principal 'sa'

When I try to run the command:

EXEC master..sp_addsrvrolemember @loginame = N'sa', @rolename = N'serveradmin'
GO

I get the error:

Msg 15405, Level 11, State 1, Procedure sp_addsrvrolemember, Line 45 Cannot use the special principal 'sa'.

Ideas/suggestions welcome.

Upvotes: 1

Views: 27887

Answers (1)

Stuart Ainsworth
Stuart Ainsworth

Reputation: 12940

'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?

Upvotes: 12

Related Questions