May 11

 

If you have tried to install SQL Server 2008 R2 Developer Edition on Windows 7, you have probably spent all day (like me) getting the following error...

"The process does not possess the ‘SeSecurityPrivilege’ privilege which is required for this operation."

and have no idea how to solve it. Well, it's a real booger and might I say, "DAMN! Microsoft for not making this part of the pre-installation scan, or the "System Configuration Checker". It's not.

To fix the problem...

Open Group Policy:

  • Click "Start".
  • In the "Search Programs and Files" text box, type "gpedit.msc" and press return.
  • Navigate to...
    Computer Configuration\Windows Settings\Security Settings\Local Policies\User Rights Assignment\Manage auditing and security log
  •  Most likely the "Administrators" group (or the user you are running the installer as) is not listed here. It should be. I added them both.
  • Then navigate to...
    Computer Configuration\Windows Settings\Security Settings\Local Policies\User Rights Assignment\Debug programs
  •  Add the "Administrators" group (or the user you are running the installer as) here as well. I added them both
  • Restart your machine and re-run the setup and it should work this time.
blog comments powered by Disqus