Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Problem adding the securityadmin role to the sa account (2005) Expand / Collapse
Author
Message
Posted Thursday, August 9, 2007 3:54 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Today @ 12:03 AM
Points: 99, Visits: 1,221

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!

Post #389203
Posted Thursday, August 9, 2007 4:16 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 9:34 AM
Points: 5,480, Visits: 10,303

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

Post #389205
Posted Thursday, August 9, 2007 4:18 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Today @ 12:03 AM
Points: 99, Visits: 1,221
Thanks John. But just out of interest why would I be getting that error?
Post #389206
Posted Thursday, August 9, 2007 6:22 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 9:34 AM
Points: 5,480, Visits: 10,303

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

Post #389244
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse