locked
SQL Server 2008 R2 setup fails with error - Attempted to perform an unauthorized operation RRS feed

  • Question

  • My SQL Server 2008R2 evaluation version expired and I’ve been trying to install SQL Server 2008R2 development version on Windows 7. I have already spent three days on it and tried all recommendations I had found from the people who had the same problem:

    http://social.msdn.microsoft.com/Forums/en/sqlsetupandupgrade/thread/61d56f64-2575-4a58-9503-84579476afaf

    -          I am logged in as administrator

    -          I have copied setup files to my C: drive.

    -          I created a new windows administrator user account and then tried to install with it.

    -          I run setup as administrator.

    -          I have UAC off.

    -          My account has full permission to registry ‘HKLM\SOFTWARE\Microsoft\Microsoft SQL Server’.

     

    I even tried to install SQL Server 2008 development  version first and then upgrade to the 2008R2. I had no problems installing SQL Server 2008 but the upgrade failed.

    It fails on the step SqlBrowserConfigAction_upgrade_ConfigNonRC_Cpu32  with an error “Attempted to perform an unauthorized operation.”

    Please, any ideas how to fix this?

     

    This is the piece of the installation log where it fails:

     

    2011-01-26 15:20:01 Slp: Sco: Attempting to get service status for service SQLBrowser

    2011-01-26 15:20:01 Slp: Sco: Attempting to open SC Manager

    2011-01-26 15:20:01 Slp: Sco: Attempting to open service handle for service SQLBrowser

    2011-01-26 15:20:01 Slp: Invoking QueryServiceStatus Win32 API

    2011-01-26 15:20:01 Slp: Sco: Attempting to close service handle for service SQLBrowser

    2011-01-26 15:20:01 Slp: Sco: Attempting to close SC Manager

    2011-01-26 15:20:01 Slp: Sco: Returning service status Stopped

    2011-01-26 15:20:01 Slp: Sco: Service SQLBrowser stopped in less than 1 seconds

    2011-01-26 15:20:01 SQLBrowser: EndMethod Type='SqlBrowserPrivateConfig' Method='StopServiceIfNeeded'.

    2011-01-26 15:20:01 Slp: Sco: Attempting to get service sid type for service SQLBrowser

    2011-01-26 15:20:01 Slp: Sco: Attempting to open SC Manager

    2011-01-26 15:20:01 Slp: Sco: Attempting to open service handle for service SQLBrowser

    2011-01-26 15:20:01 Slp: Sco: Returning service sid type SERVICE_SID_TYPE_UNRESTRICTED

    2011-01-26 15:20:01 Slp: Sco: Attempting to close service handle for service SQLBrowser

    2011-01-26 15:20:01 Slp: Sco: Attempting to close SC Manager

    2011-01-26 15:20:01 SQLBrowser: Setting SQL Server Browser service Display name to 'SQL Server Browser'.

    2011-01-26 15:20:01 Slp: Sco: Attempting to set display name for service SQLBrowser, display name SQL Server Browser

    2011-01-26 15:20:01 Slp: Sco: Attempting to open SC Manager

    2011-01-26 15:20:01 Slp: Sco: Attempting to open service handle for service SQLBrowser

    2011-01-26 15:20:01 Slp: Invoking ChangeServiceConfig Win32 API

    2011-01-26 15:20:02 Slp: Sco: Attempting to close service handle for service SQLBrowser

    2011-01-26 15:20:02 Slp: Sco: Attempting to close SC Manager

    2011-01-26 15:20:02 SQLBrowser: Setting SQL Server Browser service Error Control 'Normal'.

    2011-01-26 15:20:02 Slp: Sco: Attempting to set error control for service SQLBrowser, error control Normal

    2011-01-26 15:20:02 Slp: Sco: Attempting to open SC Manager

    2011-01-26 15:20:02 Slp: Sco: Attempting to open service handle for service SQLBrowser

    2011-01-26 15:20:02 Slp: Invoking ChangeServiceConfig Win32 API

    2011-01-26 15:20:02 Slp: Sco: Attempting to close service handle for service SQLBrowser

    2011-01-26 15:20:02 Slp: Sco: Attempting to close SC Manager

    2011-01-26 15:20:02 SQLBrowser: Setting path to executable for SQL Server Browser service to '"C:\Program Files\Microsoft SQL Server\90\Shared\sqlbrowser.exe"'.

    2011-01-26 15:20:02 Slp: Sco: Attempting to set binary file for service SQLBrowser, binary file "C:\Program Files\Microsoft SQL Server\90\Shared\sqlbrowser.exe"

    2011-01-26 15:20:02 Slp: Sco: Attempting to open SC Manager

    2011-01-26 15:20:02 Slp: Sco: Attempting to open service handle for service SQLBrowser

    2011-01-26 15:20:02 Slp: Invoking ChangeServiceConfig Win32 API

    2011-01-26 15:20:02 Slp: Sco: Attempting to close service handle for service SQLBrowser

    2011-01-26 15:20:02 Slp: Sco: Attempting to close SC Manager

    2011-01-26 15:20:02 SQLBrowser: Setting SQL Server Browser service description to 'Provides SQL Server connection information to client computers.'.

    2011-01-26 15:20:02 Slp: Sco: Attempting to set description for service SQLBrowser, description Provides SQL Server connection information to client computers.

    2011-01-26 15:20:02 Slp: Sco: Attempting to open SC Manager

    2011-01-26 15:20:02 Slp: Sco: Attempting to open service handle for service SQLBrowser

    2011-01-26 15:20:02 Slp: Sco: Attempting to close service handle for service SQLBrowser

    2011-01-26 15:20:02 Slp: Sco: Attempting to close SC Manager

    2011-01-26 15:20:02 Slp: Sco: Attempting to get default machine specific group name

    2011-01-26 15:20:02 Slp: Sco: groupNamePrefix: SQLServer2005SQLBrowserUser

    2011-01-26 15:20:02 Slp: Sco.UserGroup.GetMachineSpecificGroupName - version: 90

    2011-01-26 15:20:02 Slp: Sco.UserGroup.GetOriginalMachineName - Opening regkey: SOFTWARE\Microsoft\Microsoft SQL Server\90\Machines

    2011-01-26 15:20:02 Slp: Sco.UserGroup.GetOriginalMachineName - Under registry hive: ProcessDefault

    2011-01-26 15:20:02 Slp: Sco: Attempting to create base registry key HKEY_LOCAL_MACHINE, machine

    2011-01-26 15:20:02 Slp: Sco: Attempting to open registry subkey SOFTWARE\Microsoft\Microsoft SQL Server\90\Machines

    2011-01-26 15:20:02 Slp: Sco: Attempting to get registry value OriginalMachineName

    2011-01-26 15:20:02 Slp: Sco.UserGroup.GetMachineSpecificGroupName - finalGroupName: SQLServer2005SQLBrowserUser$ANDREYB

    2011-01-26 15:20:02 SQLBrowser: Retrieved SQL Server Browser group name: 'SQLServer2005SQLBrowserUser$ANDREYB'.

    2011-01-26 15:20:02 SQLBrowser: StartMethod Type='SqlBrowserPrivateConfig' Method='ApplyPermissions'.

    2011-01-26 15:20:02 SQLBrowser: Adding mapping of property 'ServiceGroupNameSQLBrowser' to principal 'SQLServer2005SQLBrowserUser$ANDREYB'

    2011-01-26 15:20:02 SQLBrowser: LocationFragment Node for registry/directory path substitution: '<LocationFragment Name="RegMicrosoftBase" Value="SOFTWARE\Microsoft"></LocationFragment>'.

    2011-01-26 15:20:02 SQLBrowser: Adding to dictionary pair ['RegMicrosoftBase', 'SOFTWARE\Microsoft'].

    2011-01-26 15:20:02 SQLBrowser: LocationFragment Node for registry/directory path substitution: '<LocationFragment Name="DirSharedForSqlBrowser"></LocationFragment>'.

    2011-01-26 15:20:02 SQLBrowser: Returning DirSqlBrowserBinFileFullPath = 'C:\Program Files\Microsoft SQL Server\90\Shared\sqlbrowser.exe'.

    2011-01-26 15:20:02 SQLBrowser: Returning DirSharedForSqlBrowser = 'C:\Program Files\Microsoft SQL Server\90\Shared\'.

    2011-01-26 15:20:02 SQLBrowser: Adding to dictionary pair ['DirSharedForSqlBrowser', 'C:\Program Files\Microsoft SQL Server\90\Shared\'].

    2011-01-26 15:20:02 SQLBrowser: LocationFragment Node for registry/directory path substitution: '<LocationFragment Name="DirSharedForCurrentVersion"></LocationFragment>'.

    2011-01-26 15:20:02 Slp: Sco: Attempting to create base registry key HKEY_LOCAL_MACHINE, machine

    2011-01-26 15:20:02 Slp: Sco: Attempting to open registry subkey SOFTWARE\Microsoft\Microsoft SQL Server\100

    2011-01-26 15:20:02 Slp: Sco: Attempting to get registry value SharedCode

    2011-01-26 15:20:02 SQLBrowser: Returning DirSharedForCurrentVersion = 'C:\Program Files\Microsoft SQL Server\100\Shared\'.

    2011-01-26 15:20:02 SQLBrowser: Adding to dictionary pair ['DirSharedForCurrentVersion', 'C:\Program Files\Microsoft SQL Server\100\Shared\'].

    2011-01-26 15:20:02 SQLBrowser: LocationFragment Node for registry/directory path substitution: '<LocationFragment Name="Shared90"></LocationFragment>'.

    2011-01-26 15:20:02 SQLBrowser: Adding to dictionary pair ['Shared90', '90\Shared\'].

    2011-01-26 15:20:02 SQLBrowser: LocationFragment Node for registry/directory path substitution: '<LocationFragment Name="Shared"></LocationFragment>'.

    2011-01-26 15:20:02 SQLBrowser: Adding to dictionary pair ['Shared', '100\Shared\'].

    2011-01-26 15:20:02 SQLBrowser: LocationFragment Node for registry/directory path substitution: '<LocationFragment Name="ErrorDumps"></LocationFragment>'.

    2011-01-26 15:20:02 SQLBrowser: Adding to dictionary pair ['ErrorDumps', 'ErrorDumps\'].

    2011-01-26 15:20:02 SQLBrowser: StartMethod Type='SqlBrowserPrivateConfig' Method='ApplyRegCommonPermissions'.

    2011-01-26 15:20:02 SQLBrowser: StartMethod Type='SqlBrowserPrivateConfig' Method='ApplyRegPermissions'.

    2011-01-26 15:20:02 SQLBrowser: Registry Permission Node: '<SqlPermission SecurityDescriptor="(A;CI;KR;;;[ServiceGroupNameSQLBrowser])" Registry="[RegMicrosoftBase]\Microsoft SQL Server"></SqlPermission>'.

    2011-01-26 15:20:02 Slp: Sco: Attempting to replace property in string

    2011-01-26 15:20:02 Slp: Sco: Attempting to replace property in string

    2011-01-26 15:20:02 Slp: Sco: Attempting to replace property in string

    2011-01-26 15:20:02 Slp: Sco: Attempting to replace property in string

    2011-01-26 15:20:02 SQLBrowser: sRegLocation = 'SOFTWARE\Microsoft\Microsoft SQL Server', regView = 'ProcessDefault', sSddl = '(A;CI;KR;;;[SQLServer2005SQLBrowserUser$ANDREYB])', bOptional = 'False'.

    2011-01-26 15:20:02 Slp: Sco: Attempting to create base registry key HKEY_LOCAL_MACHINE, machine

    2011-01-26 15:20:02 Slp: Sco: Attempting to open registry subkey SOFTWARE\Microsoft\Microsoft SQL Server

    2011-01-26 15:20:02 Slp: Sco: Attempting to replace account with sid in security descriptor (A;CI;KR;;;[SQLServer2005SQLBrowserUser$ANDREYB])

    2011-01-26 15:20:02 Slp: ReplaceAccountWithSidInSddl -- SDDL to be processed:  (A;CI;KR;;;[SQLServer2005SQLBrowserUser$ANDREYB])

    2011-01-26 15:20:02 Slp: Sco: Account name to be translated into SID: SQLServer2005SQLBrowserUser$ANDREYB

    2011-01-26 15:20:02 Slp: Sco: Attempting to get account sid for user account SQLServer2005SQLBrowserUser$ANDREYB

    2011-01-26 15:20:02 Slp: Sco: Attempting to get sid for user account SQLServer2005SQLBrowserUser$ANDREYB

    2011-01-26 15:20:02 Slp: Sco: GetSidForAccount normalized accountName SQLServer2005SQLBrowserUser$ANDREYB parameter to SQLServer2005SQLBrowserUser$ANDREYB

    2011-01-26 15:20:02 Slp: Sco: Account name is translated into: S-1-5-21-2655203314-2631384128-2251800517-1046

    2011-01-26 15:20:02 Slp: Sco: Final security descriptor:  (A;CI;KR;;;S-1-5-21-2655203314-2631384128-2251800517-1046)

    2011-01-26 15:20:02 Slp: Sco: Attempting to set security descriptor (A;CI;KR;;;S-1-5-21-2655203314-2631384128-2251800517-1046)

    2011-01-26 15:20:02 Slp: Sco: Attempting to normalize security descriptor (A;CI;KR;;;S-1-5-21-2655203314-2631384128-2251800517-1046)

    2011-01-26 15:20:02 Slp: Sco: Adding 'D:' DACL identifier to the input security descriptor (A;CI;KR;;;S-1-5-21-2655203314-2631384128-2251800517-1046)

    2011-01-26 15:20:02 Slp: Sco: Attempting to replace account with sid in security descriptor D:(A;CI;KR;;;S-1-5-21-2655203314-2631384128-2251800517-1046)

    2011-01-26 15:20:02 Slp: ReplaceAccountWithSidInSddl -- SDDL to be processed:  D:(A;CI;KR;;;S-1-5-21-2655203314-2631384128-2251800517-1046)

    2011-01-26 15:20:02 Slp: ReplaceAccountWithSidInSddl -- SDDL to be returned:  D:(A;CI;KR;;;S-1-5-21-2655203314-2631384128-2251800517-1046)

    2011-01-26 15:20:02 Slp: Sco: Attempting to normalize security descriptor D:(A;CI;KR;;;S-1-5-21-2655203314-2631384128-2251800517-1046)

    2011-01-26 15:20:02 Slp: Sco: Attempting to replace account with sid in security descriptor D:(A;CI;KR;;;S-1-5-21-2655203314-2631384128-2251800517-1046)

    2011-01-26 15:20:02 Slp: ReplaceAccountWithSidInSddl -- SDDL to be processed:  D:(A;CI;KR;;;S-1-5-21-2655203314-2631384128-2251800517-1046)

    2011-01-26 15:20:02 Slp: ReplaceAccountWithSidInSddl -- SDDL to be returned:  D:(A;CI;KR;;;S-1-5-21-2655203314-2631384128-2251800517-1046)

    2011-01-26 15:20:02 Slp: Prompting user if they want to retry this action due to the following failure:

    2011-01-26 15:20:02 Slp: ----------------------------------------

    2011-01-26 15:20:02 Slp: The following is an exception stack listing the exceptions in outermost to innermost order

    2011-01-26 15:20:02 Slp: Inner exceptions are being indented

    2011-01-26 15:20:02 Slp:

    2011-01-26 15:20:02 Slp: Exception type: Microsoft.SqlServer.Configuration.Sco.ScoException

    2011-01-26 15:20:02 Slp:     Message:

    2011-01-26 15:20:02 Slp:         Attempted to perform an unauthorized operation.

    2011-01-26 15:20:02 Slp:     Data:

    2011-01-26 15:20:02 Slp:       WatsonData = Microsoft SQL Server

    2011-01-26 15:20:02 Slp:       DisableRetry = true

    2011-01-26 15:20:02 Slp:     Inner exception type: System.UnauthorizedAccessException

    2011-01-26 15:20:02 Slp:         Message:

    2011-01-26 15:20:02 Slp:                 Attempted to perform an unauthorized operation.

    2011-01-26 15:20:02 Slp:         Stack:

    2011-01-26 15:20:02 Slp:                 at System.Security.AccessControl.Win32.GetSecurityInfo(ResourceType resourceType, String name, SafeHandle handle, AccessControlSections accessControlSections, RawSecurityDescriptor& resultSd)

    2011-01-26 15:20:02 Slp:                 at System.Security.AccessControl.NativeObjectSecurity.CreateInternal(ResourceType resourceType, Boolean isContainer, String name, SafeHandle handle, AccessControlSections includeSections, Boolean createByName, ExceptionFromErrorCode exceptionFromErrorCode, Object exceptionContext)

    2011-01-26 15:20:02 Slp:                 at Microsoft.SqlServer.Configuration.Sco.SqlRegistrySecurity..ctor(ResourceType resourceType, SafeRegistryHandle handle, AccessControlSections includeSections)

    2011-01-26 15:20:02 Slp:                 at Microsoft.SqlServer.Configuration.Sco.SqlRegistrySecurity.Create(InternalRegistryKey key)

    2011-01-26 15:20:02 Slp:                 at Microsoft.SqlServer.Configuration.Sco.InternalRegistryKey.GetAccessControl()

    2011-01-26 15:20:02 Slp:                 at Microsoft.SqlServer.Configuration.Sco.InternalRegistryKey.SetSecurityDescriptor(String sddl, Boolean overwrite)

    2011-01-26 15:20:02 Slp: ----------------------------------------

     

     

    Thanks,

    Andrey

     

     

    Wednesday, January 26, 2011 9:13 PM

Answers

  • Please try to use local admin account and nt local service to install SQL to a totally local path.

     

     


    Qiong Wu - MSFT
    Monday, January 31, 2011 7:52 AM

All replies

  • Please try to use local admin account and nt local service to install SQL to a totally local path.

     

     


    Qiong Wu - MSFT
    Monday, January 31, 2011 7:52 AM
  • Hi,

    Could you please upload the complete setup logs to http://skydrive.live.com and post the share link here? For more information about how to get setup log files, please refer to http://msdn.microsoft.com/en-us/library/ms143702.aspx.


    Best Regards,
    Chunsong Feng [MSFT]

    Please remember to click "Mark as Answer" on the post that helps you, and to click "Unmark as Answer" if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.
    Tuesday, February 1, 2011 2:22 AM
  • 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.

    Wednesday, October 29, 2014 2:07 PM
  • 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.

    Sunday, November 2, 2014 2:39 AM
  • Please try option2 of Case 3 in the below article.

    http://support.microsoft.com/kb/971268


    Bharath Kumar ------------- Please mark solved if I've answered your question, vote for it as helpful to help other user's find a solution quicker

    Sunday, November 2, 2014 5:53 AM