acb8ba78   
   From: esquel@sommarskog.se   
      
   TechWitch (tech.witch@gmail.com) writes:   
   > Is anyone on this group aware of a new "feature" with SQL 2005 that   
   > would disallow adding a user to the sysadmin server role?  I have   
   > tried performing this and it always completes without error:   
   >   
   > EXEC sys.sp_addsrvrolemember @loginame = N'My_Login', @rolename =   
   > N'sysadmin'   
   >   
   > BUT when I review the permissions using "sp_helpsrvrolemember   
   > @srvrolename='sysadmin'" after executing the above command, My_Login   
   > isn't present in the list.   
   >   
   > Has anyone else conquered an issue like this yet?  I'm a member of   
   > Builtin\Administrators and it has sysadmin, so I should,   
   > theoretically, be able to do this.   
      
   I don't know what is going on. All I can tell is that when I run:   
      
      CREATE LOGIN My_Login WITH PASSWORD = 'AjaBaja!'   
      
      EXEC sys.sp_addsrvrolemember @loginame = N'My_Login',   
                                   @rolename = N'sysadmin'   
      
      EXEC sp_helpsrvrolemember @srvrolename='sysadmin'   
      
      DROP LOGIN My_Login   
      
   My_Login is indeed listed.   
      
      
   --   
   Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se   
      
   Links for SQL Server Books Online:   
   SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx   
   SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx   
   SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)