2012 install fails installing 2nd instance (Network Steve Forum)

2012 install fails installing 2nd instance

Windows 7. Had 2008 R2 and 2005 installed. Uninstalled both. Running as admin, installed one named instance of 2012, seemed fine. Upon trying to install second named instance, install is S L O W and then eventually fails with "Attempted to perform an unauthorized operation." Options are to retry or cancel, retry fails same way. Log shows:

(01) 2014-09-22 08:04:45 Slp: Running Action: SniServerConfigAction_Install_atConfigNonRC_Cpu32
(01) 2014-09-22 08:04:45 Slp: Action Data:
(01) 2014-09-22 08:04:45 Slp:   Feature = SQL_Engine_Core_Inst_sql_engine_core_inst_Cpu32
(01) 2014-09-22 08:04:45 Slp:   Scenario = install
(01) 2014-09-22 08:04:45 Slp:   Timing = ConfigNonRC
(01) 2014-09-22 08:04:45 Slp:   ConfigObjectType = Microsoft.SqlServer.Configuration.SniServer.SniServerConfigurationPrivate
(01) 2014-09-22 08:04:45 Slp:   FeatureName = SQL_Engine_Core_Inst
(01) 2014-09-22 08:04:45 Slp:   FeatureCpuType = Cpu32
(01) 2014-09-22 08:04:45 Slp:   FeaturePackageId = sql_engine_core_inst
(01) 2014-09-22 08:04:45 Slp:   SlipstreamInstall = 1
(01) 2014-09-22 08:04:45 SQLEngine: Entering Function SniServerConfigurationPrivate.Install.
(01) 2014-09-22 08:04:45 SQLEngine: Timing: ConfigNonRC, NPENABLED: 0, TCPENABLED: 0.
(01) 2014-09-22 08:04:45 SQLEngine: Entering Function SniServerConfigurationPrivate.SniServerInstallAtConfigNonRC.
(01) 2014-09-22 08:04:45 SQLEngine: Entering Function SniServerConfigurationPrivate.GetInstanceId.
(01) 2014-09-22 08:04:45 SQLEngine: Current instance ID is MSSQL11.JECL.
(01) 2014-09-22 08:04:45 SQLEngine: Leaving Function SniServerConfigurationPrivate.GetInstanceId.
(01) 2014-09-22 08:04:45 SQLEngine: Entering Function SniServerConfigurationPrivate.GetInstanceName.
(01) 2014-09-22 08:04:45 SQLEngine: Current instance name is JECL.
(01) 2014-09-22 08:04:45 SQLEngine: Leaving Function SniServerConfigurationPrivate.GetInstanceName.
(01) 2014-09-22 08:04:45 SQLEngine: Entering Function SniServerConfigurationPrivate.CheckForNullOrEmpty.
(01) 2014-09-22 08:04:45 SQLEngine: Leaving Function SniServerConfigurationPrivate.CheckForNullOrEmpty.
(01) 2014-09-22 08:04:45 SQLEngine: Entering Function SniServerConfigurationPrivate.CheckForNullOrEmpty.
(01) 2014-09-22 08:04:45 SQLEngine: Leaving Function SniServerConfigurationPrivate.CheckForNullOrEmpty.
(01) 2014-09-22 08:04:45 SQLEngine: Setting SQL Server Network Interfaces parameters for instance name JECL, instance ID MSSQL11.JECL.
(01) 2014-09-22 08:04:45 SQLEngine: Entering Function NLRegSSetting.NLRegSSetting.
(01) 2014-09-22 08:04:45 SQLEngine: Leaving Function NLRegSSetting.NLRegSSetting.
(01) 2014-09-22 08:04:45 SQLEngine: Creating SQL Server Network Interfaces registry settings for instance ID MSSQL11.JECL.
(01) 2014-09-22 08:04:45 SQLEngine: Entering Function NLRegSSetting.SetDefaults.
(01) 2014-09-22 08:04:45 SQLEngine: "OverwriteAll" flag value is True.
(01) 2014-09-22 08:04:45 SQLEngine: Leaving Function NLRegSSetting.SetDefaults.
(01) 2014-09-22 08:04:45 SQLEngine: Creating SQL Server Network Interfaces registry settings to enable local connectivity using MDAC or WDAC for instance name JECL.
(01) 2014-09-22 08:04:45 SQLEngine: Entering Function NLRegSSetting.SetShilohRootById.
(01) 2014-09-22 08:04:46 SQLEngine: Leaving Function NLRegSSetting.SetShilohRootById.
(01) 2014-09-22 08:04:46 SQLEngine: Shared Memory protocol is enabled by default.
(01) 2014-09-22 08:04:46 SQLEngine: Entering Function NLRegSSetting.SetRegParameter.
(01) 2014-09-22 08:04:46 SQLEngine: Leaving Function NLRegSSetting.SetRegParameter.
(01) 2014-09-22 08:04:46 SQLEngine: Applying ACL changes for instance name JECL, instance ID MSSQL11.JECL.
(01) 2014-09-22 08:04:46 SQLEngine: Entering Function NLRegSSetting.AclHives.
(01) 2014-09-22 08:04:46 Slp: Sco: Attempting to get default machine specific group name
(01) 2014-09-22 08:04:46 Slp: Sco: groupNamePrefix: SQLServer2005SQLBrowserUser
(01) 2014-09-22 08:04:46 Slp: Sco.UserGroup.GetMachineSpecificGroupName - version: 90
(01) 2014-09-22 08:04:46 Slp: Sco.UserGroup.GetOriginalMachineName - Opening regkey: SOFTWARE\Microsoft\Microsoft SQL Server\90\Machines
(01) 2014-09-22 08:04:46 Slp: Sco.UserGroup.GetOriginalMachineName - Under registry hive: ProcessDefault
(01) 2014-09-22 08:04:46 Slp: Sco: Attempting to create base registry key HKEY_LOCAL_MACHINE, machine
(01) 2014-09-22 08:04:46 Slp: Sco: Attempting to open registry subkey SOFTWARE\Microsoft\Microsoft SQL Server\90\Machines
(01) 2014-09-22 08:04:46 Slp: Sco: Attempting to get registry value OriginalMachineName
(01) 2014-09-22 08:04:46 Slp: Sco.UserGroup.GetMachineSpecificGroupName - finalGroupName: SQLServer2005SQLBrowserUser$ST11614
(01) 2014-09-22 08:04:46 SQLEngine: Entering Function NLRegSSetting.GetRegistrySettingWithRetry.
(01) 2014-09-22 08:04:46 Slp: Sco: Attempting to create base registry key HKEY_LOCAL_MACHINE, machine
(01) 2014-09-22 08:04:46 Slp: Sco: Attempting to open registry subkey SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL11.JECL\Setup
(01) 2014-09-22 08:04:46 Slp: Sco: Attempting to get registry value SQLGroup
(01) 2014-09-22 08:04:46 SQLEngine: Leaving Function NLRegSSetting.GetRegistrySettingWithRetry.
(01) 2014-09-22 08:04:46 Slp: Sco: Attempting to get account from sid S-1-5-80-2483883049-3947497301-3355925126-3596787874-223481326
(01) 2014-09-22 08:04:46 SQLEngine: The SQL Server Database Engine service group name is 'NT SERVICE\MSSQL$JECL'.
(01) 2014-09-22 08:04:46 SQLEngine: Caching SQL Server Database Engine service group SID value: S-1-5-80-2483883049-3947497301-3355925126-3596787874-223481326.
(01) 2014-09-22 08:04:46 SQLEngine: SQL Server Database Engine service group SID: S-1-5-80-2483883049-3947497301-3355925126-3596787874-223481326, SQL Server Browser service group name: SQLServer2005SQLBrowserUser$ST11614.
(01) 2014-09-22 08:04:46 Slp: Sco: Attempting to initialize user group SQLServer2005SQLBrowserUser$ST11614
(01) 2014-09-22 08:04:46 Slp: Sco: Attempting to check if user group SQLServer2005SQLBrowserUser$ST11614 exists
(01) 2014-09-22 08:04:46 Slp: Sco: Attempting to open root DirectoryEntry object for local computer
(01) 2014-09-22 08:04:46 Slp: Sco: Attempting to check if container 'WinNT://ST11614,computer' of group exists
(01) 2014-09-22 08:04:46 Slp: Sco: User group SQLServer2005SQLBrowserUser$ST11614 exists
(01) 2014-09-22 08:04:46 SQLEngine: Entering Function NLRegSSetting.ReplaceSddlTags.
(01) 2014-09-22 08:04:46 SQLEngine: Input SDDL (A;CI;KRKW;;;S-1-5-80-2483883049-3947497301-3355925126-3596787874-223481326)(A;CI;KR;;;[SQLServer2005SQLBrowserUser$ST11614])(A;CI;KR;;;BU).
(01) 2014-09-22 08:04:46 Slp: Sco: Attempting to normalize security descriptor (A;CI;KRKW;;;S-1-5-80-2483883049-3947497301-3355925126-3596787874-223481326)(A;CI;KR;;;[SQLServer2005SQLBrowserUser$ST11614])(A;CI;KR;;;BU)
(01) 2014-09-22 08:04:46 Slp: Sco: Adding 'D:' DACL identifier to the input security descriptor (A;CI;KRKW;;;S-1-5-80-2483883049-3947497301-3355925126-3596787874-223481326)(A;CI;KR;;;[SQLServer2005SQLBrowserUser$ST11614])(A;CI;KR;;;BU)
(01) 2014-09-22 08:04:46 Slp: Sco: Attempting to replace account with sid in security descriptor D:(A;CI;KRKW;;;S-1-5-80-2483883049-3947497301-3355925126-3596787874-223481326)(A;CI;KR;;;[SQLServer2005SQLBrowserUser$ST11614])(A;CI;KR;;;BU)
(01) 2014-09-22 08:04:46 Slp: ReplaceAccountWithSidInSddl -- SDDL to be processed: D:(A;CI;KRKW;;;S-1-5-80-2483883049-3947497301-3355925126-3596787874-223481326)(A;CI;KR;;;[SQLServer2005SQLBrowserUser$ST11614])(A;CI;KR;;;BU)
(01) 2014-09-22 08:04:46 Slp: Sco: Account name to be translated into SID: SQLServer2005SQLBrowserUser$ST11614
(01) 2014-09-22 08:04:46 Slp: Sco: Attempting to get account sid for user account SQLServer2005SQLBrowserUser$ST11614
(01) 2014-09-22 08:04:46 Slp: Sco: Attempting to get sid for user account SQLServer2005SQLBrowserUser$ST11614
(01) 2014-09-22 08:04:46 Slp: Sco: GetSidForAccount normalized accountName SQLServer2005SQLBrowserUser$ST11614 parameter to SQLServer2005SQLBrowserUser$ST11614
(01) 2014-09-22 08:04:46 Slp: Sco: Account name is translated into: S-1-5-21-394174720-1573589792-2502536862-1032
(01) 2014-09-22 08:04:46 Slp: Sco: Final security descriptor: D:(A;CI;KRKW;;;S-1-5-80-2483883049-3947497301-3355925126-3596787874-223481326)(A;CI;KR;;;S-1-5-21-394174720-1573589792-2502536862-1032)(A;CI;KR;;;BU)
(01) 2014-09-22 08:04:46 SQLEngine: Output SDDL D:(A;CI;KRKW;;;S-1-5-80-2483883049-3947497301-3355925126-3596787874-223481326)(A;CI;KR;;;S-1-5-21-394174720-1573589792-2502536862-1032)(A;CI;KR;;;BU).
(01) 2014-09-22 08:04:46 SQLEngine: Leaving Function NLRegSSetting.ReplaceSddlTags.
(01) 2014-09-22 08:04:46 SQLEngine: Entering Function NLRegSSetting.SetSecurityDescriptor.
(01) 2014-09-22 08:04:46 Slp: Sco: Attempting to create base registry key HKEY_LOCAL_MACHINE, machine
(01) 2014-09-22 08:04:46 Slp: Sco: Attempting to open registry subkey SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL11.JECL\MSSQLServer\SuperSocketNetLib
(01) 2014-09-22 08:04:46 Slp: Sco: Attempting to replace account with sid in security descriptor D:(A;CI;KRKW;;;S-1-5-80-2483883049-3947497301-3355925126-3596787874-223481326)(A;CI;KR;;;S-1-5-21-394174720-1573589792-2502536862-1032)(A;CI;KR;;;BU)
(01) 2014-09-22 08:04:46 Slp: ReplaceAccountWithSidInSddl -- SDDL to be processed: D:(A;CI;KRKW;;;S-1-5-80-2483883049-3947497301-3355925126-3596787874-223481326)(A;CI;KR;;;S-1-5-21-394174720-1573589792-2502536862-1032)(A;CI;KR;;;BU)
(01) 2014-09-22 08:04:46 Slp: ReplaceAccountWithSidInSddl -- SDDL to be returned: D:(A;CI;KRKW;;;S-1-5-80-2483883049-3947497301-3355925126-3596787874-223481326)(A;CI;KR;;;S-1-5-21-394174720-1573589792-2502536862-1032)(A;CI;KR;;;BU)
(01) 2014-09-22 08:04:46 Slp: Sco: Attempting to set security descriptor D:(A;CI;KRKW;;;S-1-5-80-2483883049-3947497301-3355925126-3596787874-223481326)(A;CI;KR;;;S-1-5-21-394174720-1573589792-2502536862-1032)(A;CI;KR;;;BU)
(01) 2014-09-22 08:04:46 Slp: Sco: Attempting to normalize security descriptor D:(A;CI;KRKW;;;S-1-5-80-2483883049-3947497301-3355925126-3596787874-223481326)(A;CI;KR;;;S-1-5-21-394174720-1573589792-2502536862-1032)(A;CI;KR;;;BU)
(01) 2014-09-22 08:04:46 Slp: Sco: Attempting to replace account with sid in security descriptor D:(A;CI;KRKW;;;S-1-5-80-2483883049-3947497301-3355925126-3596787874-223481326)(A;CI;KR;;;S-1-5-21-394174720-1573589792-2502536862-1032)(A;CI;KR;;;BU)
(01) 2014-09-22 08:04:46 Slp: ReplaceAccountWithSidInSddl -- SDDL to be processed: D:(A;CI;KRKW;;;S-1-5-80-2483883049-3947497301-3355925126-3596787874-223481326)(A;CI;KR;;;S-1-5-21-394174720-1573589792-2502536862-1032)(A;CI;KR;;;BU)
(01) 2014-09-22 08:04:46 Slp: ReplaceAccountWithSidInSddl -- SDDL to be returned: D:(A;CI;KRKW;;;S-1-5-80-2483883049-3947497301-3355925126-3596787874-223481326)(A;CI;KR;;;S-1-5-21-394174720-1573589792-2502536862-1032)(A;CI;KR;;;BU)
(01) 2014-09-22 08:04:46 Slp: Sco: Attempting to normalize security descriptor D:(A;CI;KRKW;;;S-1-5-80-2483883049-3947497301-3355925126-3596787874-223481326)(A;CI;KR;;;S-1-5-21-394174720-1573589792-2502536862-1032)(A;CI;KR;;;BU)
(01) 2014-09-22 08:04:46 Slp: Sco: Attempting to replace account with sid in security descriptor D:(A;CI;KRKW;;;S-1-5-80-2483883049-3947497301-3355925126-3596787874-223481326)(A;CI;KR;;;S-1-5-21-394174720-1573589792-2502536862-1032)(A;CI;KR;;;BU)
(01) 2014-09-22 08:04:46 Slp: ReplaceAccountWithSidInSddl -- SDDL to be processed: D:(A;CI;KRKW;;;S-1-5-80-2483883049-3947497301-3355925126-3596787874-223481326)(A;CI;KR;;;S-1-5-21-394174720-1573589792-2502536862-1032)(A;CI;KR;;;BU)
(01) 2014-09-22 08:04:46 Slp: ReplaceAccountWithSidInSddl -- SDDL to be returned: D:(A;CI;KRKW;;;S-1-5-80-2483883049-3947497301-3355925126-3596787874-223481326)(A;CI;KR;;;S-1-5-21-394174720-1573589792-2502536862-1032)(A;CI;KR;;;BU)
(01) 2014-09-22 08:04:46 Slp: Prompting user if they want to retry this action due to the following failure:
(01) 2014-09-22 08:04:46 Slp: ----------------------------------------
(01) 2014-09-22 08:04:46 Slp: The following is an exception stack listing the exceptions in outermost to innermost order
(01) 2014-09-22 08:04:46 Slp: Inner exceptions are being indented
(01) 2014-09-22 08:04:46 Slp:
(01) 2014-09-22 08:04:46 Slp: Exception type: Microsoft.SqlServer.Configuration.Sco.ScoException
(01) 2014-09-22 08:04:46 Slp:     Message:
(01) 2014-09-22 08:04:46 Slp:         Attempted to perform an unauthorized operation.
(01) 2014-09-22 08:04:46 Slp:     HResult : 0x84bb0001
(01) 2014-09-22 08:04:46 Slp:         FacilityCode : 1211 (4bb)
(01) 2014-09-22 08:04:46 Slp:         ErrorCode : 1 (0001)
(01) 2014-09-22 08:04:46 Slp:     Data:
(01) 2014-09-22 08:04:46 Slp:       WatsonData = SuperSocketNetLib
(01) 2014-09-22 08:04:46 Slp:       DisableRetry = true
(01) 2014-09-22 08:04:46 Slp:     Inner exception type: System.UnauthorizedAccessException
(01) 2014-09-22 08:04:46 Slp:         Message:
(01) 2014-09-22 08:04:46 Slp:                 Attempted to perform an unauthorized operation.
(01) 2014-09-22 08:04:46 Slp:         HResult : 0x80070005
(01) 2014-09-22 08:04:46 Slp:         Stack:
(01) 2014-09-22 08:04:46 Slp:                 at System.Security.AccessControl.Win32.GetSecurityInfo(ResourceType resourceType, String name, SafeHandle handle, AccessControlSections accessControlSections, RawSecurityDescriptor& resultSd)
(01) 2014-09-22 08:04:46 Slp:                 at System.Security.AccessControl.NativeObjectSecurity.CreateInternal(ResourceType resourceType, Boolean isContainer, String name, SafeHandle handle, AccessControlSections includeSections, Boolean createByName, ExceptionFromErrorCode exceptionFromErrorCode, Object exceptionContext)
(01) 2014-09-22 08:04:46 Slp:                 at Microsoft.SqlServer.Configuration.Sco.SqlRegistrySecurity..ctor(ResourceType resourceType, SafeRegistryHandle handle, AccessControlSections includeSections)
(01) 2014-09-22 08:04:46 Slp:                 at Microsoft.SqlServer.Configuration.Sco.SqlRegistrySecurity.Create(InternalRegistryKey key)
(01) 2014-09-22 08:04:46 Slp:                 at Microsoft.SqlServer.Configuration.Sco.InternalRegistryKey.GetAccessControl()
(01) 2014-09-22 08:04:46 Slp:                 at Microsoft.SqlServer.Configuration.Sco.InternalRegistryKey.SetSecurityDescriptor(String sddl, Boolean overwrite)
(01) 2014-09-22 08:04:46 Slp: ----------------------------------------
(01) 2014-09-22 08:06:48 Slp: User has chosen to retry this action

Have tried uninstalling an re-installing.

Suggestions as to what to do to fix this would be appreciated.

-Art

September 22nd, 2014 10:01am

Hi,

This is strange did you used same account you used to install SQLserver 2012 default instance to install the named instance ?

Attempted to perform an unauthorized operation.
(01) 2014-09-22 08:04:46 Slp:     HResult : 0x84bb0001

As per above message it points to fact that account does not have required permissions. Is the Machine Hyper V/ VMWAARE?

Have a look at http://support.microsoft.com/kb/2799534/en-gb

Free Windows Admin Tool Kit Click here and download it now

September 22nd, 2014 10:29am

Thanks for the response.

Ran as admin. Didn't install the default instance, just the named instance, like I said the first instance seemed to install fine. Rebooted and tried to install second instance is where problem shows up. Not a VM just, Win 7 desktop. Running install from d: drive but installing to c:

-Art

September 22nd, 2014 10:36am

Thanks for the response.

Ran as admin. Didn't install the default instance, just the named instance, like I said the first instance seemed to install fine. Rebooted and tried to install second instance is where problem shows up. Not a VM just, Win 7 desktop. Running install from d: drive but installing to c:

-Art

As per message it seems to me like permission issue. Follow workaround mentioned in the article

Free Windows Admin Tool Kit Click here and download it now

September 22nd, 2014 11:12am

Finally solved it somehow, any or all of:

Complete de-installation
Remove all data/install directories
Remove all user directories
Walk registry and delete anything SQL that looked to have something to do with the server/browser
Install from c:

This was handy: http://technet.microsoft.com/en-us/sysinternals/bb963902.aspx

Edited by AnAnonymousParty 14 hours 51 minutes ago typo
Proposed as answer by Shanky_621 1 hour 16 minutes ago

September 22nd, 2014 3:45pm

Thanks for providing answer I have proposed it you can mark your reply as answer

Free Windows Admin Tool Kit Click here and download it now

September 23rd, 2014 5:21am

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