SQL2008R2 Express install error: Not all privileges or groups referenced are assigned to the caller

Question

Win7Pro
In attempting to install SQL2008R2 Express Edition I'm getting this message about 90% into the installation process: "Not all privileges or groups referenced are assigned to the caller"

Things I've tried:
1) Put the user 'Joe' into the following Local Security areas: Backup files and directories; Debug Programs; Manage auditing and coding; Restore files and directories; Take Ownership.... as well as even Change System Time; Change Time Zone. [Note I've done a restart after these were assigned]
2) I've even tried several new names for the SQL Instance and I still get the issue.

I'm at a loss of what to do...  Help deeply appreciated!

I'm installing SQL2008R2EE under 'Joe' and 'Joe' is part assigned as a member of Administrators.
Note: I have installed SQL2008R2EE before but due to some issues I needed to uninstall/reinstall.  Now, even after uninstalling properly in Win7Pro I get the above error message.

 

Answer 1

Hi total1,

Please have a look at the following blog post to grant the account permissions:

http://www.bradg.co.za/?p=12

---

Please remember to mark the replies as answers if they help and unmark them if they provide no help.
Get or Request Code Sample from Microsoft
If you have any feedback, please tell us.

Answer 2

Hi Jian,

I solved the issue by removing ALL directories under c:\Program Files (x86) and c:\Program Files that were related to Microsoft SQL Server.  Evidently, whenever I created an Instance the SQL installation process creates a directory of the same name.  So whatever the issue is relative to the uninstall process under SQL 2008R2 (not R2 SP1), there's a lack of full cleanup of the directories and related files.  I did not update the Registry (Win7 Professional) just removed the associated Microsoft SQL directories and related files/subdirectories under the above directory structure.

Thanks for jumping in and suggesting the link!!! ;-)

Answer 3

Hi Jian et al.,

I finally figured this one out on my Server 2008 box.  I was attempting to install from my e: drive and kept getting this error.  I verified in my local policy that my user had a privlege required and even tried SQL 2012.  I finally found someone that offhandedly mentioned that they had this problem until they the install from the local desktop of the server.  I tried that and it worked.  I did make sure to clean up previous files before trying the install, but the local c: drive install seems to be the issue.