I tried to install a new instance of SQL Server 2017 on a Windows Server 2016, but received an error:
“The following error has occurred. SQL Server Browser service group does not exist. Check for earlier failures in the setup”.
The summary log file (shown at the end of my post) shows that installation of Database Engine Services failed.
One default instance (MSSQLSERVER) was already in-place on the Server with Standard Edition. I tried to install named-instance (PEGASUS), with an Express edition. I cannot use the existing instance for operational reasons. Also, this instance needs to log on as Local Service, when the other logs on as NT Service\MSSQLSERVER.
When I ran the SQL Server 2017 Setup, I forgot to do this using “Run as administrator”. Could this account for the problem? (I'm logged in as the “companyadmin” user).
The server is one of 3 domain controllers. I know SQL Server should not be installed on DCs, but for right now, having SQL Server on this server is a requirement.
I do not know if this is relevant, but the 2017 version of SQL Server is the only full SQL Server version installed, other than 2012 Native Client and 2014 Management Objects, but all security groups refer to 2005.
The link to Microsoft in the summary.txt file does not work, so I can't find more information from Microsoft.
Any ideas on how to fix this please?
Summary.txt
Overall summary: Final result: Failed: see details
below Exit code (Decimal): -2067413173 Start time:
2019-11-16 20:20:01 End time: 2019-11-16
21:02:31 Requested action: InstallSetup completed with required actions for features. Troubleshooting
information for those features: Next step for SQLEngine: Use
the following information to resolve the error, uninstall this
feature, and then run the setup process again.Machine Properties: Machine name: APPS Machine
processor count: 8 OS version: Microsoft
Windows Server 2016 Standard (10.0.14393) OS service pack:
OS region: United States OS language:
English (United States) OS architecture: x64 Process
architecture: 64 Bit OS clustered: NoProduct features discovered: Product Instance
Instance ID Feature
Language Edition Version Clustered
Configured SQL Server 2017 MSSQLSERVER
MSSQL14.MSSQLSERVER Database Engine Services
1033 Standard Edition 14.0.2002.14 No
Yes SQL Server 2017 MSSQLSERVER
MSAS14.MSSQLSERVER Analysis Services
1033 Standard Edition 14.0.2002.14 No
Yes SQL Server 2017
Client Tools Connectivity 1033
14.0.1000.169 No Yes SQL Server 2017 Client Tools Backwards Compatibility 1033
14.0.1000.169 No Yes SQL Server 2017 Integration Services 1033 Standard
Edition 14.0.2002.14 No YesPackage properties: Description: Microsoft SQL
Server 2017 ProductName: SQL Server 2017 Type:
RTM Version: 14 SPLevel:
0 Installation location: Z:\x64\setup\ Installation
edition: ExpressProduct Update Status: None discovered.
User Input Settings: ACTION: Install
ADDCURRENTUSERASSQLADMIN: false AGTSVCACCOUNT:
NT AUTHORITY\NETWORK SERVICE AGTSVCPASSWORD: *****
AGTSVCSTARTUPTYPE: Disabled ASBACKUPDIR:
Backup ASCOLLATION: Latin1_General_CI_AS
ASCONFIGDIR: Config ASDATADIR:
Data ASLOGDIR: Log ASPROVIDERMSOLAP:
1 ASSERVERMODE: TABULAR ASSVCACCOUNT:
ASSVCPASSWORD: ASSVCSTARTUPTYPE:
Automatic ASSYSADMINACCOUNTS: ASTELSVCACCT:
ASTELSVCPASSWORD:
ASTELSVCSTARTUPTYPE: 0 ASTEMPDIR: Temp
BROWSERSVCSTARTUPTYPE: Disabled CLTCTLRNAME:
CLTRESULTDIR: CLTSTARTUPTYPE:
0 CLTSVCACCOUNT: CLTSVCPASSWORD:
CLTWORKINGDIR:
COMMFABRICENCRYPTION: 0 COMMFABRICNETWORKLEVEL: 0
COMMFABRICPORT: 0 CONFIGURATIONFILE:
C:\Program Files\Microsoft SQL Server\140\Setup
Bootstrap\Log\20191116_202000\ConfigurationFile.ini CTLRSTARTUPTYPE:
0 CTLRSVCACCOUNT: CTLRSVCPASSWORD:
CTLRUSERS: ENABLERANU:
true ENU: true EXTSVCACCOUNT:
EXTSVCPASSWORD: FEATURES:
SQLENGINE FILESTREAMLEVEL: 0 FILESTREAMSHARENAME:
FTSVCACCOUNT: FTSVCPASSWORD:
HELP: false
IACCEPTPYTHONLICENSETERMS: false IACCEPTROPENLICENSETERMS:
false IACCEPTSQLSERVERLICENSETERMS: true INDICATEPROGRESS:
false INSTALLSHAREDDIR: D:\Program Files\Microsoft SQL
Server\ INSTALLSHAREDWOWDIR: d:\Program Files
(x86)\Microsoft SQL Server\ INSTALLSQLDATADIR:
INSTANCEDIR: D:\Opera3\SQLServer INSTANCEID:
PEGASUS INSTANCENAME: PEGASUS ISMASTERSVCACCOUNT:
NT AUTHORITY\Network Service ISMASTERSVCPASSWORD:
ISMASTERSVCPORT: 8391 ISMASTERSVCSSLCERTCN:
ISMASTERSVCSTARTUPTYPE: Automatic
ISMASTERSVCTHUMBPRINT: ISSVCACCOUNT:
NT AUTHORITY\Network Service ISSVCPASSWORD:
ISSVCSTARTUPTYPE: Automatic ISTELSVCACCT:
ISTELSVCPASSWORD:
ISTELSVCSTARTUPTYPE: 0 ISWORKERSVCACCOUNT: NT
AUTHORITY\Network Service ISWORKERSVCCERT:
ISWORKERSVCMASTER: ISWORKERSVCPASSWORD:
ISWORKERSVCSTARTUPTYPE: Automatic
MATRIXCMBRICKCOMMPORT: 0 MATRIXCMSERVERNAME:
MATRIXNAME: MRCACHEDIRECTORY:
NPENABLED: 0 PBDMSSVCACCOUNT:
PBDMSSVCPASSWORD:
PBDMSSVCSTARTUPTYPE: 0 PBENGSVCACCOUNT:
PBENGSVCPASSWORD:
PBENGSVCSTARTUPTYPE: 0 PBPORTRANGE:
PBSCALEOUT: false PID:
***** QUIET: false QUIETSIMPLE: false ROLE: RSINSTALLMODE:
DefaultNativeMode RSSVCACCOUNT:
RSSVCPASSWORD: RSSVCSTARTUPTYPE:
Automatic SAPWD: ***** SECURITYMODE:
SQL SQLBACKUPDIR: SQLCOLLATION:
Latin1_General_CI_AS SQLSVCACCOUNT: NT
AUTHORITY\LOCAL SERVICE SQLSVCINSTANTFILEINIT: false
SQLSVCPASSWORD: ***** SQLSVCSTARTUPTYPE:
Automatic SQLSYSADMINACCOUNTS: QUEST01\questadmin,
QUEST01\Lynn.Banks SQLTELSVCACCT: NT
Service\SQLTELEMETRY$PEGASUS SQLTELSVCPASSWORD:
SQLTELSVCSTARTUPTYPE: Automatic SQLTEMPDBDIR:
SQLTEMPDBFILECOUNT: 1 SQLTEMPDBFILEGROWTH:
64 SQLTEMPDBFILESIZE: 8 SQLTEMPDBLOGDIR:
SQLTEMPDBLOGFILEGROWTH: 64 SQLTEMPDBLOGFILESIZE:
8 SQLUSERDBDIR: SQLUSERDBLOGDIR:
SUPPRESSPRIVACYSTATEMENTNOTICE: false TCPENABLED:
0 UIMODE: Normal UpdateEnabled:
true UpdateSource: MU USEMICROSOFTUPDATE:
false X86: falseConfiguration file: C:\Program Files\Microsoft SQL
Server\140\Setup Bootstrap\Log\20191116_202000\ConfigurationFile.iniDetailed results: Feature: Database Engine
Services Status: Failed Reason for failure:
An error occurred during the setup process of the feature. Next
Step: Use the following information to resolve the
error, uninstall this feature, and then run the setup process again.
Component name: SQL Server Database Engine Services
Instance Features Component error code: 0x84C5C74B Error
description: SQL Server Browser service group does not
exist. Check for earlier failures in the setup. Error help link:
https://go.microsoft.com/fwlink?LinkId=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=14.0.2002.14&EvtType=0x95534F0C%400x0AE0775A%401221%4051019&EvtType=0x95534F0C%400x0AE0775A%401221%4051019Rules with failures:
Global rules:
Scenario specific rules:
Rules report file: C:\Program Files\Microsoft SQL
Server\140\Setup Bootstrap\Log\20191116_202000\SystemConfigurationCheck_Report.htm
Best Answer
As the few web pages I found about this problem did not exactly to match my case, I tried something simple which would not risk the other, live, default instance.
I was able to reinstall the second instance with these steps:
Helpful web pages I found included:
Conclusions include: