Wednesday, June 20, 2012

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

1 comment:


  1. windows 7 ultimate x86 cd key , windows 7 key online purchase paypal , windows 8.1 professional key , win 7key , office 2016 product key , windows 7 anytime upgrade home basic to ultimate , windows 7 professional sp1 32 bit product key free download , key windows 7 ultimate sp1 , lDWh9Q

    ReplyDelete