none
SQL Server 2008 setup error: Attempted to perform an unauthorized operation

    Question

  • I'm trying to install SQL Server 2008 on a virtual machine with Windows 2008 R2.

    Setup fails with the error "Attempted to perform an unauthorized operation".

    Looking at the installation log, I see these details:

    2009-09-29 08:24:49 SQLBrowser: sRegLocation = 'SOFTWARE\Microsoft\Microsoft SQL Server', regView = 'Wow6432', sSddl = '(A;CI;KR;;;[SQLServer2005SQLBrowserUser$ITISFIM])', bOptional = 'False'.
    2009-09-29 08:24:49 Slp: Sco: Attempting to create base registry key HKEY_LOCAL_MACHINE, machine 
    2009-09-29 08:24:49 Slp: Sco: Attempting to open registry subkey 
    2009-09-29 08:24:49 Slp: Sco: Attempting to open registry subkey SOFTWARE\Microsoft\Microsoft SQL Server
    2009-09-29 08:24:49 Slp: Sco: Attempting to replace account with sid in security descriptor (A;CI;KR;;;[SQLServer2005SQLBrowserUser$ITISFIM])
    2009-09-29 08:24:49 Slp: ReplaceAccountWithSidInSddl -- SDDL to be processed:  (A;CI;KR;;;[SQLServer2005SQLBrowserUser$ITISFIM])
    2009-09-29 08:24:49 Slp: Sco: Account name to be translated into SID: SQLServer2005SQLBrowserUser$ITISFIM
    2009-09-29 08:24:49 Slp: Sco: Attempting to get account sid for user account SQLServer2005SQLBrowserUser$ITISFIM
    2009-09-29 08:24:49 Slp: Sco: Attempting to get sid for user account SQLServer2005SQLBrowserUser$ITISFIM
    2009-09-29 08:24:49 Slp: Sco: GetSidForAccount normalized accountName SQLServer2005SQLBrowserUser$ITISFIM parameter to SQLServer2005SQLBrowserUser$ITISFIM
    2009-09-29 08:24:49 Slp: Sco: Account name is translated into: S-1-5-21-3278988706-2344661944-1675463508-1000
    2009-09-29 08:24:49 Slp: Sco: Final security descriptor:  (A;CI;KR;;;S-1-5-21-3278988706-2344661944-1675463508-1000)
    2009-09-29 08:24:49 Slp: Sco: Attempting to set security descriptor (A;CI;KR;;;S-1-5-21-3278988706-2344661944-1675463508-1000)
    2009-09-29 08:24:49 Slp: Sco: Attempting to normalize security descriptor (A;CI;KR;;;S-1-5-21-3278988706-2344661944-1675463508-1000)
    2009-09-29 08:24:49 Slp: Sco: Adding 'D:' DACL identifier to the input security descriptor (A;CI;KR;;;S-1-5-21-3278988706-2344661944-1675463508-1000)
    2009-09-29 08:24:49 Slp: Sco: Attempting to replace account with sid in security descriptor D:(A;CI;KR;;;S-1-5-21-3278988706-2344661944-1675463508-1000)
    2009-09-29 08:24:49 Slp: ReplaceAccountWithSidInSddl -- SDDL to be processed:  D:(A;CI;KR;;;S-1-5-21-3278988706-2344661944-1675463508-1000)
    2009-09-29 08:24:49 Slp: ReplaceAccountWithSidInSddl -- SDDL to be returned:  D:(A;CI;KR;;;S-1-5-21-3278988706-2344661944-1675463508-1000)
    2009-09-29 08:24:49 Slp: Sco: Attempting to normalize security descriptor D:(A;CI;KR;;;S-1-5-21-3278988706-2344661944-1675463508-1000)
    2009-09-29 08:24:49 Slp: Sco: Attempting to replace account with sid in security descriptor D:(A;CI;KR;;;S-1-5-21-3278988706-2344661944-1675463508-1000)
    2009-09-29 08:24:49 Slp: ReplaceAccountWithSidInSddl -- SDDL to be processed:  D:(A;CI;KR;;;S-1-5-21-3278988706-2344661944-1675463508-1000)
    2009-09-29 08:24:49 Slp: ReplaceAccountWithSidInSddl -- SDDL to be returned:  D:(A;CI;KR;;;S-1-5-21-3278988706-2344661944-1675463508-1000)
    2009-09-29 08:24:49 Slp: Prompting user if they want to retry this action due to the following failure:
    2009-09-29 08:24:49 Slp: ----------------------------------------
    2009-09-29 08:24:49 Slp: The following is an exception stack listing the exceptions in outermost to innermost order
    2009-09-29 08:24:49 Slp: Inner exceptions are being indented
    2009-09-29 08:24:49 Slp: 
    2009-09-29 08:24:49 Slp: Exception type: Microsoft.SqlServer.Configuration.Sco.ScoException
    2009-09-29 08:24:49 Slp:     Message: 
    2009-09-29 08:24:49 Slp:         Attempted to perform an unauthorized operation.
    2009-09-29 08:24:49 Slp:     Data: 
    2009-09-29 08:24:49 Slp:       WatsonData = Microsoft SQL Server
    2009-09-29 08:24:49 Slp:       DisableRetry = true
    2009-09-29 08:24:49 Slp:     Inner exception type: System.UnauthorizedAccessException
    2009-09-29 08:24:49 Slp:         Message: 
    2009-09-29 08:24:49 Slp:                 Attempted to perform an unauthorized operation.
    2009-09-29 08:24:49 Slp:         Stack: 
    2009-09-29 08:24:49 Slp:                 at System.Security.AccessControl.Win32.GetSecurityInfo(ResourceType resourceType, String name, SafeHandle handle, AccessControlSections accessControlSections, RawSecurityDescriptor& resultSd)
    2009-09-29 08:24:49 Slp:                 at System.Security.AccessControl.NativeObjectSecurity.CreateInternal(ResourceType resourceType, Boolean isContainer, String name, SafeHandle handle, AccessControlSections includeSections, Boolean createByName, ExceptionFromErrorCode exceptionFromErrorCode, Object exceptionContext)
    2009-09-29 08:24:49 Slp:                 at Microsoft.SqlServer.Configuration.Sco.SqlRegistrySecurity..ctor(ResourceType resourceType, SafeRegistryHandle handle, AccessControlSections includeSections)
    2009-09-29 08:24:49 Slp:                 at Microsoft.SqlServer.Configuration.Sco.SqlRegistrySecurity.Create(InternalRegistryKey key)
    2009-09-29 08:24:49 Slp:                 at Microsoft.SqlServer.Configuration.Sco.InternalRegistryKey.SetSecurityDescriptor(String sddl, Boolean overwrite)
    2009-09-29 08:24:49 Slp: ----------------------------------------
    
    Any suggestions on how to fix this error?
    Thanks, Paolo
    Tuesday, September 29, 2009 3:33 PM

Answers

  • Hi,

    There seems to be a problem to your windows user account sid mapping, I am suggesting you create a new windows administrator user account, and then try to install SQL Server 2008.

    For more information on sid on Windows operating systems see here: http://support.microsoft.com/kb/243330

    If the problem continues existing, please feel free to let me know.

    Have a nice day,
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.
    Welcome to the All-In-One Code Framework! If you have any feedback, please tell us.
    • Marked as answer by Paolo Tedesco Wednesday, October 07, 2009 7:28 AM
    Wednesday, October 07, 2009 3:38 AM

All replies

  • Try this KB article http://support.microsoft.com/kb/2001727
    Vidhya Sagar. Mark as Answer if it helps!
    Wednesday, September 30, 2009 3:32 AM
  • Hi Vidhya, thank you for your reply, but I don't think it's something related to a regional settings mismatch.
    Wednesday, September 30, 2009 7:34 AM
  • Have the same exact error trying to install on Win7. Been installing and reinstalling for a couple days now.
    It is not a problem with regional settings.

    Any other ideas?

    Tim
    Wednesday, September 30, 2009 7:19 PM
  • Hi,

    Did you run the setup.exe as administrator? Which step did it fails at?


    Please remember to mark the replies as answers if they help and unmark them if they provide no help.
    Welcome to the All-In-One Code Framework! If you have any feedback, please tell us.
    Thursday, October 01, 2009 8:47 AM
  • Thanks for the reply.

    Yes, we ran setup.exe as administrator. We've also tried installing while logged in using the local adminstrator account. The same errors happens either way.


    The error is Attempted to perform an unauthorized operation." at step SqlBrowserConfigAction_install_ConfigNonRC_Cpu32.


    Tim
    • Proposed as answer by ThomChich Tuesday, October 20, 2009 4:21 PM
    • Unproposed as answer by Paolo Tedesco Wednesday, October 21, 2009 7:04 AM
    Thursday, October 01, 2009 9:00 PM
  • anything on this?
    Tuesday, October 06, 2009 8:36 PM
  • I am getting the same error too anything on this
    Tuesday, October 06, 2009 9:01 PM
  • Hi,

    There seems to be a problem to your windows user account sid mapping, I am suggesting you create a new windows administrator user account, and then try to install SQL Server 2008.

    For more information on sid on Windows operating systems see here: http://support.microsoft.com/kb/243330

    If the problem continues existing, please feel free to let me know.

    Have a nice day,
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.
    Welcome to the All-In-One Code Framework! If you have any feedback, please tell us.
    • Marked as answer by Paolo Tedesco Wednesday, October 07, 2009 7:28 AM
    Wednesday, October 07, 2009 3:38 AM
  • The SID problem seems the most likely explanation.
    In the meanwhile I have reverted the VM to a previous state, reinstalled and all went fine.

    Thanks,
    Paolo
    Wednesday, October 07, 2009 7:30 AM
  • Tim,

    I feel your pain... Spent about a day and a half trying to install SQL 2008 on a new Win 7 64 box. 

    Tried: Run As Admin; UAC off; Run under Vista; Enabled the Administrator account... all to no avail.

    In despiration I moved the install files to the box's C: drive (they'd been on another hard drive... E:\).  That did it.  Couldn't believe it, didn't look real!  We're hypothesizing that the OS is applying certain access rights based on the physical location of the source and my E: didn't cut it.

    Hope it works for you.

    Regards,
    Thom
    • Proposed as answer by bill sontag Wednesday, October 28, 2009 12:11 AM
    Tuesday, October 20, 2009 4:28 PM
  • You rock Thom!

    I went through the exact same steps and only copying it locally from the dvd worked!  MS needs to fix the permissions problems in Win 7, or at least explain them so we understand them.

    If you had errors during the SQL 2008 install process, you may have bad instances that will need to be removed before SP1 can be applied.  To do this, go to add/remove programs and select SLQ 2008 to uninstall.  Select remove from the first screen and then select the bad instances and remove them.  After I did this, sp 1 install correctly.

    Bill
    Wednesday, October 28, 2009 12:16 AM
  • Well, guys.
    I'm absolutely exhausted by installing SQL 2008 Developer on my W7 x 64 Ultimate. I spent about 4 days together to install it, but unable to overcome this error.
    Even if:
    -I created new admin user
    -I copied files to c:\temp\sql2008
    -I add full permissions to Everyone to registry 'HKLM\SOFTWARE\Microsoft\Microsoft SQL Server'.

    Still getting "Attempted to perform an unauthorized operation".


    2009-11-06 11:50:30 SQLBrowser: Returning DirSharedForCurrentVersion = 'C:\Program Files (x86)\Microsoft SQL Server\100\Shared\'.
    2009-11-06 11:50:30 SQLBrowser: Adding to dictionary pair ['DirSharedForCurrentVersion', 'C:\Program Files (x86)\Microsoft SQL Server\100\Shared\'].
    2009-11-06 11:50:30 SQLBrowser: LocationFragment Node for registry/directory path substitution: ''.
    2009-11-06 11:50:30 SQLBrowser: Adding to dictionary pair ['Shared90', '90\Shared\'].
    2009-11-06 11:50:30 SQLBrowser: LocationFragment Node for registry/directory path substitution: ''.
    2009-11-06 11:50:30 SQLBrowser: Adding to dictionary pair ['Shared', '100\Shared\'].
    2009-11-06 11:50:30 SQLBrowser: LocationFragment Node for registry/directory path substitution: ''.
    2009-11-06 11:50:30 SQLBrowser: Adding to dictionary pair ['ErrorDumps', 'ErrorDumps\'].
    2009-11-06 11:50:30 SQLBrowser: StartMethod Type='SqlBrowserPrivateConfig' Method='ApplyRegCommonPermissions'.
    2009-11-06 11:50:30 SQLBrowser: StartMethod Type='SqlBrowserPrivateConfig' Method='ApplyRegPermissions'.
    2009-11-06 11:50:30 SQLBrowser: Registry Permission Node: ''.
    2009-11-06 11:50:30 Slp: Sco: Attempting to replace property in string
    2009-11-06 11:50:30 Slp: Sco: Attempting to replace property in string
    2009-11-06 11:50:30 Slp: Sco: Attempting to replace property in string
    2009-11-06 11:50:30 Slp: Sco: Attempting to replace property in string
    2009-11-06 11:50:30 SQLBrowser: sRegLocation = 'SOFTWARE\Microsoft\Microsoft SQL Server', regView = 'Wow6432', sSddl = '(A;CI;KR;;;[SQLServer2005SQLBrowserUser$OTTML012648])', bOptional = 'False'.
    2009-11-06 11:50:30 Slp: Sco: Attempting to create base registry key HKEY_LOCAL_MACHINE, machine 
    2009-11-06 11:50:30 Slp: Sco: Attempting to open registry subkey 
    2009-11-06 11:50:30 Slp: Sco: Attempting to open registry subkey SOFTWARE\Microsoft\Microsoft SQL Server
    2009-11-06 11:50:30 Slp: Sco: Attempting to replace account with sid in security descriptor (A;CI;KR;;;[SQLServer2005SQLBrowserUser$OTTML012648])
    2009-11-06 11:50:30 Slp: ReplaceAccountWithSidInSddl -- SDDL to be processed:  (A;CI;KR;;;[SQLServer2005SQLBrowserUser$OTTML012648])
    2009-11-06 11:50:30 Slp: Sco: Account name to be translated into SID: SQLServer2005SQLBrowserUser$OTTML012648
    2009-11-06 11:50:30 Slp: Sco: Attempting to get account sid for user account SQLServer2005SQLBrowserUser$OTTML012648
    2009-11-06 11:50:30 Slp: Sco: Attempting to get sid for user account SQLServer2005SQLBrowserUser$OTTML012648
    2009-11-06 11:50:30 Slp: Sco: GetSidForAccount normalized accountName SQLServer2005SQLBrowserUser$OTTML012648 parameter to SQLServer2005SQLBrowserUser$OTTML012648
    2009-11-06 11:50:30 Slp: Sco: Account name is translated into: S-1-5-21-523843958-2108880671-1716404383-1045
    2009-11-06 11:50:30 Slp: Sco: Final security descriptor:  (A;CI;KR;;;S-1-5-21-523843958-2108880671-1716404383-1045)
    2009-11-06 11:50:30 Slp: Sco: Attempting to set security descriptor (A;CI;KR;;;S-1-5-21-523843958-2108880671-1716404383-1045)
    2009-11-06 11:50:30 Slp: Sco: Attempting to normalize security descriptor (A;CI;KR;;;S-1-5-21-523843958-2108880671-1716404383-1045)
    2009-11-06 11:50:30 Slp: Sco: Adding 'D:' DACL identifier to the input security descriptor (A;CI;KR;;;S-1-5-21-523843958-2108880671-1716404383-1045)
    2009-11-06 11:50:30 Slp: Sco: Attempting to replace account with sid in security descriptor D:(A;CI;KR;;;S-1-5-21-523843958-2108880671-1716404383-1045)
    2009-11-06 11:50:30 Slp: ReplaceAccountWithSidInSddl -- SDDL to be processed:  D:(A;CI;KR;;;S-1-5-21-523843958-2108880671-1716404383-1045)
    2009-11-06 11:50:30 Slp: ReplaceAccountWithSidInSddl -- SDDL to be returned:  D:(A;CI;KR;;;S-1-5-21-523843958-2108880671-1716404383-1045)
    2009-11-06 11:50:30 Slp: Sco: Attempting to normalize security descriptor D:(A;CI;KR;;;S-1-5-21-523843958-2108880671-1716404383-1045)
    2009-11-06 11:50:30 Slp: Sco: Attempting to replace account with sid in security descriptor D:(A;CI;KR;;;S-1-5-21-523843958-2108880671-1716404383-1045)
    2009-11-06 11:50:30 Slp: ReplaceAccountWithSidInSddl -- SDDL to be processed:  D:(A;CI;KR;;;S-1-5-21-523843958-2108880671-1716404383-1045)
    2009-11-06 11:50:30 Slp: ReplaceAccountWithSidInSddl -- SDDL to be returned:  D:(A;CI;KR;;;S-1-5-21-523843958-2108880671-1716404383-1045)
    2009-11-06 11:50:30 Slp: Prompting user if they want to retry this action due to the following failure:
    2009-11-06 11:50:30 Slp: ----------------------------------------
    2009-11-06 11:50:30 Slp: The following is an exception stack listing the exceptions in outermost to innermost order
    2009-11-06 11:50:30 Slp: Inner exceptions are being indented
    2009-11-06 11:50:30 Slp: 
    2009-11-06 11:50:30 Slp: Exception type: Microsoft.SqlServer.Configuration.Sco.ScoException
    2009-11-06 11:50:30 Slp:     Message: 
    2009-11-06 11:50:30 Slp:         Attempted to perform an unauthorized operation.
    2009-11-06 11:50:30 Slp:     Data: 
    2009-11-06 11:50:30 Slp:       WatsonData = Microsoft SQL Server
    2009-11-06 11:50:30 Slp:       DisableRetry = true
    2009-11-06 11:50:30 Slp:     Inner exception type: System.UnauthorizedAccessException
    2009-11-06 11:50:30 Slp:         Message: 
    2009-11-06 11:50:30 Slp:                 Attempted to perform an unauthorized operation.
    2009-11-06 11:50:30 Slp:         Stack: 
    2009-11-06 11:50:30 Slp:                 at System.Security.AccessControl.Win32.GetSecurityInfo(ResourceType resourceType, String name, SafeHandle handle, AccessControlSections accessControlSections, RawSecurityDescriptor& resultSd)
    2009-11-06 11:50:30 Slp:                 at System.Security.AccessControl.NativeObjectSecurity.CreateInternal(ResourceType resourceType, Boolean isContainer, String name, SafeHandle handle, AccessControlSections includeSections, Boolean createByName, ExceptionFromErrorCode exceptionFromErrorCode, Object exceptionContext)
    2009-11-06 11:50:30 Slp:                 at Microsoft.SqlServer.Configuration.Sco.SqlRegistrySecurity..ctor(ResourceType resourceType, SafeRegistryHandle handle, AccessControlSections includeSections)
    2009-11-06 11:50:30 Slp:                 at Microsoft.SqlServer.Configuration.Sco.SqlRegistrySecurity.Create(InternalRegistryKey key)
    2009-11-06 11:50:30 Slp:                 at Microsoft.SqlServer.Configuration.Sco.InternalRegistryKey.SetSecurityDescriptor(String sddl, Boolean overwrite)
    2009-11-06 11:50:30 Slp: ----------------------------------------
    Any other ideas what I can do?

    Strange thing is that when I installed VS2010 Beta 2, it installed for me SQL2008 Express without any problem :-(
    Friday, November 06, 2009 11:39 AM
  • I'm in the same boat.
    Did you ever get a fix for it?  Please let me know.
    I created a slipstream that works fine on a clean Windows 7 Pro 64 install on a drive outside of the RAID.
    But with all the toys I've got on the Ultimate install, Diskeeper, AVG, SpySweeper(took it out and VS2008 Pro installed, but not SQL), etc.  I guess the bits are too scrambled for the SQL installer.

    I just want to put the damn thing on so I can learn about stuff.

    Log Name:      Application
    Source:        .NET Runtime Optimization Service
    Date:          12/6/2009 2:55:06 PM
    Event ID:      1101
    Task Category: None
    Level:         Error
    Keywords:      Classic
    User:          N/A
    Computer:      DevSV
    Description:
    .NET Runtime Optimization Service (clr_optimization_v2.0.50727_32) - Failed to compile: C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\Tools\VDT\DataDesigners.dll . Error code = 0x8007000b


    Sunday, December 06, 2009 10:51 PM
  • same problem, 

    fix :Copy the install setup folder and files to C: hard drive, it work for me..... seems to be problems with wm7 permission.
    • Proposed as answer by davehants Tuesday, September 06, 2011 3:16 PM
    Wednesday, February 10, 2010 5:42 PM
  • I have the same issue.  I am trying to install a trial edition of SQL Server 2008 Enterprise.  It blows up at the GetSecurityInfo(...) call.  This is ridiculous.  The Windows 7 is a brand new installation.  The only thing I didn't do was format the hard drive before installing.  I'm sure that has something to do with it, but who knows?

    -Trey

    Wednesday, April 21, 2010 6:02 PM
  • Tim,

    I feel your pain... Spent about a day and a half trying to install SQL 2008 on a new Win 7 64 box. 

    Tried: Run As Admin; UAC off; Run under Vista; Enabled the Administrator account... all to no avail.

    In despiration I moved the install files to the box's C: drive (they'd been on another hard drive... E:\).  That did it.  Couldn't believe it, didn't look real!  We're hypothesizing that the OS is applying certain access rights based on the physical location of the source and my E: didn't cut it.

    Hope it works for you.

    Regards,
    Thom


    That's the answer!!! It says unauthorized operation, that might be because you are not admin but when you are admin, it means that there are some permissions that are not granted yet. When we create a folder with our admin user, then it apparently gets all required permissions.

    I followed what Thom mentioned. I created a folder on root drive c (my only drive) and copied downloaded file from download folder into it. I extracted it and installed without problem. I got a warning as usual in second window but SQL server engine installed and it works. I have a Windows 7 home premium and tried to install SQL server enterprise edition (trial 180 days) x64 version.

    Thank you again Thom.

     

    • Proposed as answer by davehants Tuesday, September 06, 2011 3:17 PM
    Saturday, April 24, 2010 6:12 PM
  • TRIED NEW ACCOUNT METHOD AND TRIED INSTALLING FROM C: DRIVE BUT NO LUCK!

     

    ============================================================

    SOLUTION:

    DONT ABORT THE INSTALLATION WHEN YOU GET THE ERROR MESSAGE:

    1. Run Process Monitor and click retry on the Error Message

    2. Stop the Process Monitor Trace and you'll see the problem is an ACCESS DENIED to registry key -

    HKLM\System\CurrentControlSet\Control\WMI\security

    3. Temporarily give your user account Full Control on this reg key

    4. Click Retry and the install succeeds.

     


    Jeremy - MCP | MCAD.Net | MCSD.Net
    Friday, May 14, 2010 6:08 AM
  • Copying the setup from the temporary folder created by my bundled setup into a normal folder worked for me too ! Thanks
    Friday, August 20, 2010 10:29 AM
  • What total ____. What good is a temporary folder if you can't use it?

     

    I tried the same thing: I moved my folder to C: and everything worked. I hate upgrading. I should have just stayed with XP. I regret the decision to upgrade to "windows 7" everyday since I have upgraded.

    Thursday, January 06, 2011 4:10 PM
  • I created new windows admin, ran setup as that admin account and still got the same error.
    Fahad
    Wednesday, May 25, 2011 6:28 PM
  • The post of the user "Meaning of Light" is very helpful. I used process monitor to easily find out what was wrong.
    Fahad
    Thursday, May 26, 2011 4:25 PM
  • I have tried all the things mentioned above, without success. Then I realized, using Process Monitor that I have existing databases in user databases folder which are left over from previous Windows installation and which are inaccessible by Windows (setup) because of the old ACL's (permissions, missing SID's) - obviously SQL setup has some problems with this.

    I took ownership of this files and after that everything worked just fine and I successfully installed SQL server 2008 Std along with SP2 after that. OS is Windows 7 x64.

     

    Nino
    www.raverus.com

    Saturday, August 06, 2011 7:46 AM
  • TRIED NEW ACCOUNT METHOD AND TRIED INSTALLING FROM C: DRIVE BUT NO LUCK!

     

    ============================================================

    SOLUTION:

    DONT ABORT THE INSTALLATION WHEN YOU GET THE ERROR MESSAGE:

    1. Run Process Monitor and click retry on the Error Message

    2. Stop the Process Monitor Trace and you'll see the problem is an ACCESS DENIED to registry key -

    HKLM\System\CurrentControlSet\Control\WMI\security

    3. Temporarily give your user account Full Control on this reg key

    4. Click Retry and the install succeeds.

     


    Jeremy - MCP | MCAD.Net | MCSD.Net

    This worked for me. Thanks!
    Wednesday, December 14, 2011 8:35 PM
  • It worked for me, thank you so much (tears in my eyes!).

    I have been struggling for more than a week. I tried all the registry areas (from logs, suggestions) but found nothing. It was Process Monitor which told me which registry entry to look into.

    Friday, October 12, 2012 3:01 PM
  • I  was able to install SQL Server 2008 R2 on Windows 8, 64 bit system.

    What worked for me?

    1) Create a folder under C:\temp\. Copied all the files from media drive to this folder. Right clicked the folder which I created. Granted "full control" to administrator , also added "Everyone" and granted to "full control" to this group. Right clicked again and Under General tab of properties, unchecked the "Read-Only (Only applied to files in this folder)" to remove read only to all the files under the folder.

    2) Uninstalled any previous failed/partial installation of SQL Server 2008 R2

    3) As Jeremy metioned:

    Go to regedit and give Administrator, current user and everyone full control to registry key located at:

    HKLM\System\CurrentControlSet\Control\WMI\security

    3) Ran the Set-up.exe from the temp folder created under Administrator mode.

    4) When I got the compatibility issue problem, I ignored and continued the installation. At the end it installed successfully.

    5) Ran the Microsoft updates and installed all the updates related to SQL Server.


    Abhishek

    Tuesday, June 04, 2013 8:15 PM
  • THATS GENIUS!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! Perfecto!

    P.S. folder sqlbackup dont have permissons ((

    Tuesday, June 18, 2013 11:31 AM
  • Thanks Thom...

    It solved my problem...


    Thursday, October 03, 2013 9:56 AM
  • Hi davehants,

    Thank you for your post, this works for me.

    Monday, January 06, 2014 4:59 PM
  • Wanted to throw my hat in the ring as none of the above answers fixed my problem with SQL Server 2008 R2 on Windows 8.1

    I had this exact problem happen to me during my installation: 

    2014-01-15 00:01:52 Slp: Sco: Attempting to write hklm registry key SOFTWARE\Microsoft\Microsoft SQL Server to file C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20140114_235617\Registry_SOFTWARE_Microsoft_Microsoft SQL Server.reg_
    2014-01-15 00:01:52 Slp: Sco: Attempting to write hklm registry key SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall to file C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20140114_235617\Registry_SOFTWARE_Microsoft_Windows_CurrentVersion_Uninstall.reg_
    2014-01-15 00:01:52 Slp: Sco: Attempting to write hklm registry key SOFTWARE\Microsoft\MSSQLServer to file C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20140114_235617\Registry_SOFTWARE_Microsoft_MSSQLServer.reg_
    2014-01-15 00:01:52 Slp: Sco: Attempting to write hklm registry key SOFTWARE\Wow6432Node\Microsoft\Microsoft SQL Server to file C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20140114_235617\Registry_SOFTWARE_Wow6432Node_Microsoft_Microsoft SQL Server.reg_
    2014-01-15 00:01:52 Slp: Sco: Attempting to write hklm registry key SOFTWARE\Wow6432Node\Microsoft\Windows\CurrentVersion\Uninstall to file C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20140114_235617\Registry_SOFTWARE_Wow6432Node_Microsoft_Windows_CurrentVersion_Uninstall.reg_
    2014-01-15 00:01:52 Slp: Sco: Attempting to write hklm registry key SOFTWARE\Wow6432Node\Microsoft\MSSQLServer to file C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20140114_235617\Registry_SOFTWARE_Wow6432Node_Microsoft_MSSQLServer.reg_
    2014-01-15 00:01:54 Slp: Attempted to perform an unauthorized operation.
    2014-01-15 00:01:54 Slp: Watson bucket for exception based failure has been created
    2014-01-15 00:01:54 SSIS: Failed to set registry permission on key 'SOFTWARE\Microsoft\Microsoft SQL Server\100' to SID 'S-1-5-21-1526145828-320026549-172912389-1029'. Exception message: 'Attempted to perform an unauthorized operation.'
    2014-01-15 00:01:54 Slp: Sco: Attempting to open registry subkey SOFTWARE\Microsoft\Microsoft SQL Server\100\SSIS
    2014-01-15 00:01:54 SSIS: Setting permision on registry key HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\100\SSIS.
    2014-01-15 00:01:54 Slp: Sco: Attempting to replace account with sid in security descriptor D:(A;OICI;KR;;;S-1-5-21-1526145828-320026549-172912389-1029)
    2014-01-15 00:01:54 Slp: ReplaceAccountWithSidInSddl -- SDDL to be processed:  D:(A;OICI;KR;;;S-1-5-21-1526145828-320026549-172912389-1029)
    2014-01-15 00:01:54 Slp: ReplaceAccountWithSidInSddl -- SDDL to be returned:  D:(A;OICI;KR;;;S-1-5-21-1526145828-320026549-172912389-1029)
    2014-01-15 00:01:54 Slp: Sco: Attempting to set security descriptor D:(A;OICI;KR;;;S-1-5-21-1526145828-320026549-172912389-1029)
    2014-01-15 00:01:54 Slp: Sco: Attempting to normalize security descriptor D:(A;OICI;KR;;;S-1-5-21-1526145828-320026549-172912389-1029)
    2014-01-15 00:01:54 Slp: Sco: Attempting to replace account with sid in security descriptor D:(A;OICI;KR;;;S-1-5-21-1526145828-320026549-172912389-1029)
    2014-01-15 00:01:54 Slp: ReplaceAccountWithSidInSddl -- SDDL to be processed:  D:(A;OICI;KR;;;S-1-5-21-1526145828-320026549-172912389-1029)
    2014-01-15 00:01:54 Slp: ReplaceAccountWithSidInSddl -- SDDL to be returned:  D:(A;OICI;KR;;;S-1-5-21-1526145828-320026549-172912389-1029)
    2014-01-15 00:01:54 Slp: Sco: Attempting to normalize security descriptor D:(A;OICI;KR;;;S-1-5-21-1526145828-320026549-172912389-1029)
    2014-01-15 00:01:54 Slp: Sco: Attempting to replace account with sid in security descriptor D:(A;OICI;KR;;;S-1-5-21-1526145828-320026549-172912389-1029)
    2014-01-15 00:01:54 Slp: ReplaceAccountWithSidInSddl -- SDDL to be processed:  D:(A;OICI;KR;;;S-1-5-21-1526145828-320026549-172912389-1029)
    2014-01-15 00:01:54 Slp: ReplaceAccountWithSidInSddl -- SDDL to be returned:  D:(A;OICI;KR;;;S-1-5-21-1526145828-320026549-172912389-1029)
    2014-01-15 00:01:54 Slp: Prompting user if they want to retry this action due to the following failure:
    2014-01-15 00:01:54 Slp: ----------------------------------------
    2014-01-15 00:01:54 Slp: The following is an exception stack listing the exceptions in outermost to innermost order
    2014-01-15 00:01:54 Slp: Inner exceptions are being indented
    2014-01-15 00:01:54 Slp: 
    2014-01-15 00:01:54 Slp: Exception type: Microsoft.SqlServer.Configuration.Sco.ScoException
    2014-01-15 00:01:54 Slp:     Message: 
    2014-01-15 00:01:54 Slp:         Attempted to perform an unauthorized operation.
    2014-01-15 00:01:54 Slp:     Data: 
    2014-01-15 00:01:54 Slp:       WatsonData = SSIS
    2014-01-15 00:01:54 Slp:       DisableRetry = true
    2014-01-15 00:01:54 Slp:     Inner exception type: System.UnauthorizedAccessException
    2014-01-15 00:01:54 Slp:         Message: 
    2014-01-15 00:01:54 Slp:                 Attempted to perform an unauthorized operation.
    2014-01-15 00:01:54 Slp:         Stack: 
    2014-01-15 00:01:54 Slp:                 at System.Security.AccessControl.Win32.GetSecurityInfo(ResourceType resourceType, String name, SafeHandle handle, AccessControlSections accessControlSections, RawSecurityDescriptor& resultSd)
    2014-01-15 00:01:54 Slp:                 at System.Security.AccessControl.NativeObjectSecurity.CreateInternal(ResourceType resourceType, Boolean isContainer, String name, SafeHandle handle, AccessControlSections includeSections, Boolean createByName, ExceptionFromErrorCode exceptionFromErrorCode, Object exceptionContext)
    2014-01-15 00:01:54 Slp:                 at Microsoft.SqlServer.Configuration.Sco.SqlRegistrySecurity..ctor(ResourceType resourceType, SafeRegistryHandle handle, AccessControlSections includeSections)
    2014-01-15 00:01:54 Slp:                 at Microsoft.SqlServer.Configuration.Sco.SqlRegistrySecurity.Create(InternalRegistryKey key)
    2014-01-15 00:01:54 Slp:                 at Microsoft.SqlServer.Configuration.Sco.InternalRegistryKey.SetSecurityDescriptor(String sddl, Boolean overwrite)
    2014-01-15 00:01:54 Slp: ----------------------------------------

    After about 5 hours of troubleshooting, I found out the cause was not that setup was being denied access to a registry key (at least from what I saw being generated by Procmon from Setup100.exe) - it seemed to just not like me having the Setup executable or the database engine running as NT AUTHORITY\NETWORK SERVICE.  

    After running setup as NT AUTHORITY\SYSTEM using PSExec and making the database engine run under NT AUTHORITY\SYSTEM instead of NT AUTHORITY\NETWORK SERVICE, installation completed with no errors. 

    Yeesh.


    • Edited by TeqTools Wednesday, January 15, 2014 6:58 PM More detail added
    Wednesday, January 15, 2014 6:56 PM