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.
cacls /s
on those directories (while the installer is sitting at the Retry box). Or you could try setting the permissions yourself w/cacls
just to see what it says. I wonder how setup is doing that. Also, I wonder if the other messages (The process does not possess theSeSecurityPrivilege
privilege which is required for this operation.) are at all related. ApparentlyseSecurityPrivilege
=Manage Auditing and Security Log
in the Local Security Policy > User Rights Assignment, if that helps any. – fission Jul 24 '11 at 10:39