SQL Server 2008 installation will fail if the setup account does not have certain user rights

The following error has occurred while installing Microsoft SQL server 2008 R2.

ERROR :

Updating permission setting for folder 'C:\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.

CAUSE :

above problem occured just because of your local / Domain Security policy Restrictions.

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

RESOLUTION :

To add the rights to the local administrator account follow these steps:

1. Log on to the computer as a user who has administrative credentials.
2. Click Start, click Run, type Control admintools , and then click OK.
3. Double-click Local Security Policy.
4. In the Local Security Settings dialog box, click Local Policies, double-click User Rights Assignment, and then double-click Backup Files and Directories.
5. In the Backup Files and Directories Properties dialog box, click Add User or Group.
6. In the Select User or Groups dialog box,type the user account being used for setup, and then click OK two times.
7. Repeat the procedure for the other two policies mentioned in the Cause section
8. On the File menu, click Exit to close the Local Security Settings dialog box. 

For more information please refer microsoft Knowledge base article : http://support.microsoft.com/kb/2000257


Cheers!!!!

Gaurang Patel

free spam filter