SQL Server setup fails on SQLBrowserConfigAction_install_ConfigNonRC_CPU32

Issue:- SQL Server setup Installation  gets fail with below error highlighted in details.txt file.

TITLE: Microsoft SQL Server 2008 R2 Setup
------------------------------
The following error has occurred:
Attempted to perform an unauthorized operation.
Click 'Retry' to retry the failed action, or click 'Cancel' to cancel this action and continue setup.
For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=10.50.1600.1&EvtType=0x88792597%25400xBB814387


  SQLBrowserConfigAction_install_ConfigNonRC_CPU32


2015-09-22 17:02:51 SQLBrowser: SQL Server Browser Install for feature 'SQL_Browser_Redist_SqlBrowser_Cpu32' failed with cancel exception: Microsoft.SqlServer.Configuration.Sco.ScoException: Attempted to perform an unauthorized operation. ---> System.UnauthorizedAccessException: Attempted to perform an unauthorized operation.
   at System.Security.AccessControl.Win32.GetSecurityInfo(ResourceType resourceType, String name, SafeHandle handle, AccessControlSections accessControlSections, RawSecurityDescriptor& resultSd)
   at System.Security.AccessControl.NativeObjectSecurity.CreateInternal(ResourceType resourceType, Boolean isContainer, String name, SafeHandle handle, AccessControlSections includeSections, Boolean createByName, ExceptionFromErrorCode exceptionFromErrorCode, Object exceptionContext)
   at Microsoft.SqlServer.Configuration.Sco.SqlRegistrySecurity..ctor(ResourceType resourceType, SafeRegistryHandle handle, AccessControlSections includeSections)
   at Microsoft.SqlServer.Configuration.Sco.SqlRegistrySecurity.Create(InternalRegistryKey key)
   at Microsoft.SqlServer.Configuration.Sco.InternalRegistryKey.SetSecurityDescriptor(String sddl, Boolean overwrite)
   --- End of inner exception stack trace ---
   at Microsoft.SqlServer.Configuration.Sco.InternalRegistryKey.SetSecurityDescriptor(String sddl, Boolean overwrite)
   at Microsoft.SqlServer.Configuration.Sco.SqlRegistryKey.SetSecurityDescriptor(String sddl, Boolean overwrite)
   at Microsoft.SqlServer.Configuration.SqlBrowser.SqlBrowserPrivateConfigBase.SetSecurityDescriptorByLocation(String sRegLocation, RegistryView regView, String sSddl, Boolean bOptional)
   at Microsoft.SqlServer.Configuration.SqlBrowser.SqlBrowserPrivateConfigBase.ApplyRegPermissions(XmlNodeList xmlNodeListRegPermissions, Dictionary`2 dictionaryGroups, Dictionary`2 dicLocationFragments)
   at Microsoft.SqlServer.Configuration.SqlBrowser.SqlBrowserPrivateConfig.ApplyRegCommonPermissions(XmlElement xmlRootPermissions, Dictionary`2 dictionaryGroups, Dictionary`2 dicLocationFragments)
   at Microsoft.SqlServer.Configuration.SqlBrowser.SqlBrowserPrivateConfig.ApplyPermissions(String sXmlPermissionsFile, String sBrowserPrincipal)
   at Microsoft.SqlServer.Configuration.SqlBrowser.SqlBrowserPrivateConfig.ConfigStaticProperties(SqlBrowserPublicConfig publicConfigSqlBrowser)
   at Microsoft.SqlServer.Configuration.SqlBrowser.SqlBrowserPrivateConfig.ExecConfigNonRC(SqlBrowserPublicConfig publicConfigSqlBrowser)
   at Microsoft.SqlServer.Configuration.SqlBrowser.SqlBrowserPrivateConfig.SelectAndExecTiming(ConfigActionTiming timing, Dictionary`2 actionData, PublicConfigurationBase spcbPublicConfig)
   at Microsoft.SqlServer.Configuration.SqlBrowser.SqlBrowserPrivateConfigBase.ExecWithRetry(ConfigActionTiming timing, Dictionary`2 actionData, PublicConfigurationBase spcbPublicConfig).

----

at Microsoft.SqlServer.Configuration.SqlBrowser.SqlBrowserPrivateConfigBase.ExecWithRetry(ConfigActionTiming timing, Dictionary`2 actionData, PublicConfigurationBase spcbPublicConfig).
2015-09-22 17:02:51 SQLBrowser: The last attempted operation: Adding access control entry '(A;CI;KR;;;[SQLServer2005SQLBrowserUser$XXXXDB1])' to registry key 'SOFTWARE\Microsoft\Microsoft SQL Server' in view 'Wow6432' in order to configure the SQL Server Browser service..
2015-09-22 17:02:51 Slp: Configuration action failed for feature SQL_Browser_Redist during timing ConfigNonRC and scenario ConfigNonRC.
2015-09-22 17:02:51 Slp: Attempted to perform an unauthorized operation.
2015-09-22 17:02:51 Slp: The configuration failure category of current exception is ConfigurationFailure
2015-09-22 17:02:51 Slp: Configuration action failed for feature SQL_Browser_Redist during timing ConfigNonRC and scenario ConfigNonRC.
2015-09-22 17:02:51 Slp: Microsoft.SqlServer.Configuration.Sco.ScoException: Attempted to perform an unauthorized operation. ---> System.UnauthorizedAccessException: Attempted to perform an unauthorized operation.
2015-09-22 17:02:51 Slp:    at System.Security.AccessControl.Win32.GetSecurityInfo(ResourceType resourceType, String name, SafeHandle handle, AccessControlSections accessControlSections, RawSecurityDescriptor& resultSd)
2015-09-22 17:02:51 Slp:    at System.Security.AccessControl.NativeObjectSecurity.CreateInternal(ResourceType resourceType, Boolean isContainer, String name, SafeHandle handle, AccessControlSections includeSections, Boolean createByName, ExceptionFromErrorCode exceptionFromErrorCode, Object exceptionContext)

Resolution:-

 I suggest searching for the phrases “Error,” “Watson bucket,” and “Exception.” In this example, by using these search criteria, you receive the following results:

• Error: X occurrences
• Exception: Y occurrences
• Watson bucket: Z occurrences

Concentrate on Error, exception and Watson keyword.
In my case the issue was with some permission exception.

I copied Setup file in C:\ drive -- Uninstall SQl Server  Engine and replication component.

then Secpol.msc->Local policies->User Rights Assignment -- add added Administrators to below policies

• Backup files and directories
• Debug Programs
• Manage auditing and security log

executed the setup again with run as Administrator.

Now installation completed successfully.

if then also issue does not resolve, and setup gets fail at this point

"SQL_Browser_Redist_SqlBrowser_Cpu3"
 then something it looks related to Browser Service is not installing successfully.

Go to control panel and carefully check SQL Server Browser Application is uninstalled.
if it is uninstalled, then go to services.msc and check  services for browser service is present.
If  browser service is present in services.msc.
run below command

C:\> sc query  sqlbrowser
if it says "The specified service does not exist as an installed service, but services display in services.msc console
then check the service Name of SQLBrowser Service.
In order to check this right click  browser service --> property--> in general Tab -- Service Name.

suppose Service Name is sqlbrowser_old 

run below command

C:\> sc delete sqlbrowser_old

Then uninstall the  failed setup of SQL Server  and install it again.

Now the issue of failed corruption because of
SQL_Browser_Redist_SqlBrowser_Cpu3 will resolve.


Thanks for reading and Happy troubleshooting and Happy Learning.