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

Certain Folders are not Visible in Windows Explorer

Hellow Friends,

Last day i had a Problem with Windows Explorer due to this problem Some Folders are not visible in Windows Explorer.

My File server was 2008 R2 SP1 and accessing shared files from Windows 7 , XP and all other flavours of OS, but i was not able to access that folders.
After trouble shooting of this problem i found interesting thing, when i access folders with Full path in explorer than it was accessible, but the same folder was not accessible via Command Prompt.

I have changed Folder Option to show hidden files and Folder but the problem was still remains then after i decided to start server in safe mode and full scan with fully updated Antivirus software but problem was not resolved.

Finally i got the problem resolution with cause.

Cause :

This problem may arise due to Some system file corruption or Malicious software / Virus issues which change some system settings.

Resolution :

1) Open Command Prompt.
2) Go to your Folder Drive
3) Type Command " attrib -h -r -s /D /S < Folder Name >" or " attrib -h -r -s /D /S < *.*>"
4) hit Enter
5) Bang!!!!! now Files and Folders will appears with existing File and Folder permissions.

i also found some work around for this particular Problem.

1) http://social.technet.microsoft.com/Forums/en/w7itprogeneral/thread/947489ae-dc86-45f0-ad5e-463a62e1d59f

2) http://social.technet.microsoft.com/Forums/en/w7itpronetworking/thread/09bd78bf-06c3-4c85-91f7-41bc12c647bb

3) http://social.technet.microsoft.com/Forums/en-US/winserverPN/thread/f29363c6-c75b-44d0-91ce-e159063671d1

Cheers !!!

Gaurang Patel

free spam filter exchange spam filter exchange spam filter exchange spam filter exchange spam filter exchange spam filter