SQL Server 2008 Enterprise (10.0.2531.0) installed on SQL Server 2003 R2 SP2.
I am logged in as sa and I try to grant sysadmin (or any server role) to a new account (either windows or sql authentication) and it fails without an error. If I use the gui in the management studio it says okay but when you check the role is not granted.
If I use t-sql command (sp_addsrvrolemember) it doesn't generate an error but again nothing happens. The role is not granted.
View Complete Post