Post reply

Problem adding the securityadmin role to the sa account (2005)

  • August 9, 2007 at 3:54 am

    #118054

    Hi Guys,

    I'm trying to add the securityadmin server role to the sa user but have been unable to due to an error occuring. The error says "Add member failed for server role 'securityadmin'. Cannot use the special principal 'sa' Microsoft SQL Server error 15405."

    I assumed that the sa account would already have the required permission to perform most operations on the server but I have been asked to try assiging this server role to sa by a support guy for our third party product.

    Has anyone got any ideas why this error is occuring? I have been looking on loads of forums but cannot find anything relevant to me.

    Thanks in advance for any help!

  • August 9, 2007 at 4:16 am

    #725658

    Chris

    Yes, sa can perform any task that a member of security admin can (and more).  Mind you if your thrid party product requires the sa account, then it's probably time to change your third party!

    John

  • August 9, 2007 at 4:18 am

    #725659

    Thanks John. But just out of interest why would I be getting that error?

  • August 9, 2007 at 6:22 am

    #725690

    Chris

    I think the answer is "just because".  sa has fixed permissions and therefore you can't add it to or remove it from fixed server roles, hence the error message.

    John

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply