SQL Server 2008 setup error: Attempted to perform an unauthorized operation
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
September 29th, 2009 3:33pm

Try this KB article http://support.microsoft.com/kb/2001727
Free Windows Admin Tool Kit Click here and download it now
September 30th, 2009 3:32am

Hi Vidhya, thank you for your reply, but I don't think it's something related to a regional settings mismatch.
September 30th, 2009 7:34am

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
Free Windows Admin Tool Kit Click here and download it now
September 30th, 2009 7:19pm

Hi,

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

October 1st, 2009 8:47am

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
Free Windows Admin Tool Kit Click here and download it now
October 1st, 2009 9:00pm

anything on this?
October 6th, 2009 8:36pm

I am getting the same error too anything on this
Free Windows Admin Tool Kit Click here and download it now
October 6th, 2009 9:01pm

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,
October 7th, 2009 3:38am

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
Free Windows Admin Tool Kit Click here and download it now
October 7th, 2009 7:30am

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
October 20th, 2009 4:28pm

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
Free Windows Admin Tool Kit Click here and download it now
October 28th, 2009 12:16am

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 :-(
November 6th, 2009 11:39am

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


Free Windows Admin Tool Kit Click here and download it now
December 6th, 2009 10:51pm

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
February 10th, 2010 5:42pm

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

Free Windows Admin Tool Kit Click here and download it now
April 21st, 2010 6:02pm

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
April 24th, 2010 6:12pm

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.

 

Free Windows Admin Tool Kit Click here and download it now
May 14th, 2010 6:08am

Copying the setup from the temporary folder created by my bundled setup into a normal folder worked for me too ! Thanks
August 20th, 2010 10:29am

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.

Free Windows Admin Tool Kit Click here and download it now
January 6th, 2011 4:10pm

I created new windows admin, ran setup as that admin account and still got the same error.
May 25th, 2011 6:28pm

The post of the user "Meaning of Light" is very helpful. I used process monitor to easily find out what was wrong.
Free Windows Admin Tool Kit Click here and download it now
May 26th, 2011 4:25pm

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

August 6th, 2011 7:46am

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.

Free Windows Admin Tool Kit Click here and download it now
December 14th, 2011 8:35pm

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.

October 12th, 2012 3:01pm

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.

Free Windows Admin Tool Kit Click here and download it now
June 4th, 2013 8:15pm

THATS GENIUS!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! Perfecto!

P.S. folder sqlbackup dont have permissons ((

June 18th, 2013 11:31am

Thanks Thom...

It solved my problem...


Free Windows Admin Tool Kit Click here and download it now
October 3rd, 2013 9:56am

Hi davehants,

Thank you for your post, this works for me.

January 6th, 2014 4:59pm

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
Free Windows Admin Tool Kit Click here and download it now
January 15th, 2014 6:56pm

Hi,

I am getting the error "Attempted to perform an unauthorized operation" on windows 8.1 while installing SQL server 2008.

The specific error is The error is Attempted to perform an unauthorized operation." at stepSqlBrowserConfigAction_install_ConfigNonRC_Cpu32 .

I have tried everything from copying to the C drive. I am the admin on the machine. I also checked access in registry. It already has acesss to HKLM\System\CurrentControlSet\Control\WMI\security

Can someone comment on how to resolve this issue. I also tried NT AUTHORITY\SYSTEM but getting the same error.

Any help would be appreciated.

October 29th, 2014 1:58pm

Set your date in 2008. Example 07/11/2008 and then install again!

Simple!

Free Windows Admin Tool Kit Click here and download it now
November 8th, 2014 1:11am

I'm absolutely exhausted by installing SQL 2008 Developer on my W7 x 32 Prof.. I spent about 5 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 tried to install by Administrator ID,

- I  given full permission for user to regedit =  HKLM\System\CurrentControlSet\Control\WMI\security 

Before i was trying to install in windows 8.1 prof. but i was face this error then i format my pc and install Win 7 Prof. but still same error and i am trying lost of time from last 5 days

Please help me if somebody have solution for this

Thanking you in advance

Regards

Udaysinh Vaghela

uday_oman@hotmail.com

December 15th, 2014 1:25pm

WOW...............  THANKS GOD I GOT THE SOLUTION\

DEAR ALL I SHAR WITH YOU ALL PEOPLE


Procedure 1: Basic slipstream steps

Follow the following steps to create a slipstream drop that you can use for installing the original media and a service pack at the same time.
  1. Install the following prerequisites for SQL Server 2008.
  2. Download the service pack package that matches you system architecture. For example download the x64 package of SQL Server 2008 Service Pack 1 if your system is an x64-based system.
  3. Extract the service pack by running the following command: 
    SQLServer2008SP1-KB968369-x64-ENU.exe /x:C:\SP1
  4. Run the service pack to install Setup files on the computer. You will receive a Setup Support Files dialog box if the Setup support files have not been installed. You can also run the following file to install the setup support files: 
    C:\SP1\x64\setup\1033\sqlsupport.msi
  5. Run the Setup.exe file from the SQL Server 2008 source media by specifying the /PCUSource parameter. For example:
    Setup.exe /PCUSource=C:\SP1

Read Article http://support.microsoft.com/kb/955392

enjoy

thanking you

Regards

Udaysinh Vaghela

uday_oman@hotmail.com

+968 99154460

Free Windows Admin Tool Kit Click here and download it now
December 15th, 2014 2:33pm

This worked for me. Thank you very much.

Run Process Monitor and click retry on the Error MessageGreat

May 26th, 2015 9:37pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics