SQL Server Provisioning Tool

Question

Running under Server 2008, SQL Server 2005 SP2 has the option to "Add New Administrator" from the SQL Server 2005 Surface Ara Configuration. This launches the SQL Server 2005 User Provisioning Tool for Vista. You are then able to grant privileges such as Server SysAdmin role etc.

When I do this the privileges are copied across and appear to be saved but when I return to this tool it is clear that they have not been saved. Anybody else experience this or know how to "make it stick" ?

Answer 1

It seems that the tool is simply not verifying that the privileges are already granted, and it's granting the privileges on every run, which is ok with me (you could check the members of the sysadmin server role.)