Sql-server – Permission error during installation of Microsoft SQL Server 2008 R2

permissionssql server

During setup I get several errors like the one bellow and none of the service for SQL server get installed. I did quick google search but it seems like the only solution for resolving this issue is re-installation of the whole system which is not an option. Please if you had this problem and resolved it without any drastic measures, please share it.

TITLE: Microsoft SQL Server 2008 R2 Setup

The following error has occurred:

Updating permission setting for folder 'D:\Program Files\Microsoft SQL Server\100\DTS\' failed. The folder permission setting were supposed to be set to 'D:(A;OICI;FA;;;BA)(A;OICI;FA;;;SY)(A;OICI;FA;;;CO)(A;OICI;0x1200a9;;;BU)'.

Click 'Retry' to retry the failed action, or click 'Cancel' to cancel this action and continue setup.

For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=10.50.1600.1&EvtType=0xE32A4906%25400x0200CF2B

enter image description here

enter image description here

enter image description here

Best Answer

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)
Related Topic