Permission error during installation of Microsoft SQL Server 2008 R2
Solution 1:
I'm late to the party here, I realize, but I just wandered across this after having the same problem. The comment from @fission led me to the following KB article:
http://support.microsoft.com/kb/2000257
The key information is here:
This behavior is by design. In addition to adding the user account that is running the setup as a local administrator as documented in How to: Install SQL Server 2008 (Setup), the setup user account requires the following default user rights for the setup to complete successfully.
Local Policy Object Display Name (User Right)
- Backup files and directories (SeBackupPrivilege)
- Debug Programs (SeDebugPrivilege)
- Manage auditing and security log (SeSecurityPrivilege)
Solution 2:
This post on MSDN forums worked for me:
I posted something on the Avast forums and got back a response that explains/solves the issue. Avast has a self-defense module that locks down permissions on the C:\Windows\Temp folder. It may lock down other folders, but I don't know that for sure.
This can be disabled. Doing so allows the installation to complete without error. To disable the Avast self-defence module:
Systray -> Right Click Avast -> Open Avast user interface -> Settings -> Troubleshooting -> Enable self-defense module.
Symantec does not cause the SQL installation to fail like Avast does. And, this problem does not happen on Windows 7.