This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(25.6, 75%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYM%3C/text%3E%3C/svg%3E)
Hello
I am installing SCOM 2019 and use sql 2017 alwayson with latest CU.
The scom operationmanager DB not created and the installation failed.
All the prerequisites have taken place and the service accounts have the right permissions
Error: :Error in Forcing Service to Running state.: Threw Exception.Type: System.InvalidOperationException, Exception Error Code: 0x80131509, Exception.Message: Service MSSQLSERVER was not found on computer 'tek.gftk.vbm'.
[1:28:33]: Error: :CreateDatabase failed with the following exception: : Threw Exception.Type: System.Reflection.TargetInvocationException, Exception Error Code: 0x80131604, Exception.Message: Exception has been thrown by the target of an invocation.
Error: :Inner Exception.Type: System.ComponentModel.Win32Exception, Exception Error Code: 0x80131509,
A family of System Center products that provide infrastructure monitoring, help ensure the predictable performance and availability of vital applications, and offer comprehensive monitoring for datacenters and cloud, both private and public.
This is new installation for SCOM 2019 on SQL alwayson 2017 with latest cu , now the operationMG DB can be created but installation for SCOM management server fail and the role back process has been ran with fail installation process.
And you have follow the official documentation thoroughly?
How to install an Operations Manager management server
https://learn.microsoft.com/en-us/system-center/scom/deploy-install-mgmt-server?view=sc-om-2019
(Note: Make sure to check the steps for the SQL Always On Availability Group)
Already considered , This is the first time i have this error!!!
Hi,
I saw the following error somewhere:
Exception Error Code: 0x80131604, Exception.Message: Exception has been thrown by the target of an invocation
Can you please look up this article and configure the option like suggested:
Installation of a System Center 2012 Operations Manager server fails with error 0x80131604
https://learn.microsoft.com/en-us/troubleshoot/system-center/scom/management-server-installation-error-0x80131604
Re-run the installation after reconfonfiguring the option. Does it help?
----------
If my reply was helpful please don't forget to upvote and/or accept as answer, thank you!
Regards,
Stoyan
I already fix this issue yesterday but still i have the below issue
Error: :Error in Forcing Service to Running state.: Threw Exception.Type: System.InvalidOperationException, Exception Error Code: 0x80131509, Exception.Message: Service MSSQLSERVER was not found on computer 'OHzhtr7-INST01.nmnbhkj.com'.
So to get things clear here, did you manage to install SCOM 2019? Or is this error still appearing during the installation of SCOM 2019?
Please describe your scenario in the steps you have taken for us to get a better understanding, thanks!
[13:18:30]: Info: :SQL Product Level: RTM
[13:18:30]: Info: :SQL Edition: Enterprise Edition: Core-based Licensing (64-bit)
[13:18:30]: Info: :SQL Version: 14.0.3401.7
[13:18:30]: Info: :Info:sqlServerInstance = sql.xxxxx.xxxx
[13:18:30]: Info: :Info:sqlDataPath = E:\MSSQL14.INST01\MSSQL\DATA\
[13:18:30]: Info: :Info:sqlLogPath = E:\MSSQL14.INST01\MSSQL\DATA\
[13:18:30]: Always: :Entering GetRemoteOSVersion.
[13:18:30]: Info: :Info: remoteOS = 10.0.17763
[13:18:30]: Error: :Error in Forcing Service to Running state.: Threw Exception.Type: System.InvalidOperationException, Exception Error Code: 0x80131509, Exception.Message: Service MSSQLSERVER was not found on computer 'sql.xxxxx.xxxx'.
[13:18:30]: Error: :StackTrace: at System.ServiceProcess.ServiceController.GenerateNames()
at System.ServiceProcess.ServiceController.get_ServiceName()
at System.ServiceProcess.ServiceController.GenerateStatus()
at System.ServiceProcess.ServiceController.get_Status()
at Microsoft.EnterpriseManagement.OperationsManager.Setup.Common.SetupValidationHelpers.ForceSqlServiceToRunningState(String sqlServerInstance)
[13:18:30]: Error: :Inner Exception.Type: System.ComponentModel.Win32Exception, Exception Error Code: 0x80131509, Exception.Message: The specified service does not exist as an installed service
[13:18:30]: Error: :InnerException.StackTrace:
[13:18:30]: Warn: :Could not start the SQL Service sql.xxxxx.xxxx but we will attempt to connect anyway.
[13:18:30]: Debug: :Connection was not open. We will try to open it.
[13:18:30]: Debug: :SqlConnectionReady returned True.
[13:18:30]: Info: :Info:Using DB command timeout = 1800 seconds.
[13:18:30]: Info: :SQL Product Level: RTM
[13:18:30]: Info: :SQL Edition: Enterprise Edition: Core-based Licensing (64-bit)
[13:18:30]: Info: :SQL Version: 14.0.3401.7
[13:18:30]: Always: :Current Version of SQL=14.0.3401.7 Required Version=11.0.5058
[13:18:30]: Always: :check Sql version done
[13:18:30]: Info: :Info:Using DB command timeout = 1800 seconds.
[13:18:30]: Info: :Info:Using DB command timeout = 1800 seconds.
[13:18:30]: Info: :The SQL Collation is valid.
[13:18:30]: Error: :Error in Forcing Service to Running state.: Threw Exception.Type: System.InvalidOperationException, Exception Error Code: 0x80131509, Exception.Message: Service MSSQLSERVER was not found on computer 'sql.xxxxx.xxxx'.
[13:18:30]: Error: :StackTrace: at System.ServiceProcess.ServiceController.GenerateNames()
at System.ServiceProcess.ServiceController.get_ServiceName()
at System.ServiceProcess.ServiceController.GenerateStatus()
at System.ServiceProcess.ServiceController.get_Status()
at Microsoft.EnterpriseManagement.OperationsManager.Setup.Common.SetupValidationHelpers.ForceSqlServiceToRunningState(String sqlServerInstance)
[13:18:30]: Error: :Inner Exception.Type: System.ComponentModel.Win32Exception, Exception Error Code: 0x80131509, Exception.Message: The specified service does not exist as an installed service
[13:18:30]: Error: :InnerException.StackTrace:
[13:18:30]: Warn: :Could not start the SQL Service sql.xxxxx.xxxx but we will attempt to connect anyway.
[13:18:30]: Always: :ValidateSqlLogin: Sql connection string - Data source=sql.xxxxx.xxxx;Integrated Security=true;Connection Timeout=15
[13:18:30]: Debug: :Connection was not open. We will try to open it.
[13:18:30]: Debug: :SqlConnectionReady returned True.
[13:18:30]: Info: :Info:Using DB command timeout = 1800 seconds.
[13:18:30]: Debug: :Connection was not open. We will try to open it.
[13:18:30]: Debug: :SqlConnectionReady returned True.
[13:18:30]: Info: :Info:Using DB command timeout = 1800 seconds.
[13:18:31]: Info: :Info:Using DB command timeout = 1800 seconds.
[13:18:31]: Info: :Info:Database Creation succeeded: True
[13:18:31]: Error: :Error in Forcing Service to Running state.: Threw Exception.Type: System.InvalidOperationException, Exception Error Code: 0x80131509, Exception.Message: Service MSSQLSERVER was not found on computer 'sql.xxxxx.xxxx'.
[13:18:31]: Error: :StackTrace: at System.ServiceProcess.ServiceController.GenerateNames()
at System.ServiceProcess.ServiceController.get_ServiceName()
at System.ServiceProcess.ServiceController.GenerateStatus()
at System.ServiceProcess.ServiceController.get_Status()
at Microsoft.EnterpriseManagement.OperationsManager.Setup.Common.SetupValidationHelpers.ForceSqlServiceToRunningState(String sqlServerInstance)
[13:18:31]: Error: :Inner Exception.Type: System.ComponentModel.Win32Exception, Exception Error Code: 0x80131509, Exception.Message: The specified service does not exist as an installed service
[13:18:31]: Error: :InnerException.StackTrace:
[13:18:31]: Warn: :Could not start the SQL Service sql.xxxxx.xxxx but we will attempt to connect anyway.
[13:18:31]: Always: :ValidateSqlLogin: Sql connection string - Data source=sql.xxxxx.xxxx;Integrated Security=true;Connection Timeout=15
[13:18:31]: Debug: :Connection was not open. We will try to open it.
[13:18:31]: Debug: :SqlConnectionReady returned True.
[13:18:31]: Info: :Info:Using DB command timeout = 1800 seconds.
[13:18:31]: Debug: :Connection was not open. We will try to open it.
[13:18:31]: Debug: :SqlConnectionReady returned True.
[13:18:31]: Info: :Info:Using DB command timeout = 1800 seconds.
[13:18:31]: Info: :Info:Using DB command timeout = 1800 seconds.
[13:18:31]: Info: :Info:Database Creation succeeded: True
[13:18:31]: Info: :Info:DatabaseConfigurationPage: DB connection attempt completed.
[13:18:31]: Info: :Info:DatabaseConfigurationPage: DB connection attempt completed.
[13:18:31]: Info: :Checking freespace for: sql.xxxxx.xxxx,E:\
[13:18:31]: Always: :CheckUsedSpaceOnDrive: Checking for space on drive sql.xxxxx.xxxx,E:\
[13:18:31]: Info: :CheckUsedSpaceOnDrive succeeded.
[13:18:31]: Info: :Checking freespace for: sql.xxxxx.xxxx,E:\
[13:18:31]: Always: :CheckUsedSpaceOnDrive: Checking for space on drive sql.xxxxx.xxxx,E:\
[13:18:31]: Info: :CheckUsedSpaceOnDrive succeeded.
[13:18:31]: Always: :Entering Page: WebConsoleSitePage
[13:18:31]: Always: :User is attempting to install Web Console on a MG which does not contain reporting. This will break Application Advisor.
[13:18:34]: Info: :Website Binding info: *:80:
[13:18:34]: Always: :Entering Page: WebConsoleAuthorizationMode
[13:18:37]: Always: :Entering Page: AccountsInformationPage
[13:20:17]: Info: :Info:AccountsInformationPage: In OnNextFinalValidationsDoWork to validate account access.
[13:20:17]: Always: :successfully logged in with account mnoii.com\SCOMactionaccount
[13:20:17]: Error: :Error in Forcing Service to Running state.: Threw Exception.Type: System.InvalidOperationException, Exception Error Code: 0x80131509, Exception.Message: Service MSSQLSERVER was not found on computer 'sql.xxxxx.xxxx'.
[13:20:17]: Error: :StackTrace: at System.ServiceProcess.ServiceController.GenerateNames()
at System.ServiceProcess.ServiceController.get_ServiceName()
at System.ServiceProcess.ServiceController.GenerateStatus()
at System.ServiceProcess.ServiceController.get_Status()
at Microsoft.EnterpriseManagement.OperationsManager.Setup.Common.SetupValidationHelpers.ForceSqlServiceToRunningState(String sqlServerInstance)
[13:20:17]: Error: :Inner Exception.Type: System.ComponentModel.Win32Exception, Exception Error Code: 0x80131509, Exception.Message: The specified service does not exist as an installed service
[13:20:17]: Error: :InnerException.StackTrace:
[13:20:17]: Warn: :Could not start the SQL Service sql.xxxxx.xxxx but we will attempt to connect anyway.
[13:20:17]: Debug: :Connection was not open. We will try to open it.
[13:20:17]: Debug: :SqlConnectionReady returned True.
[13:20:17]: Info: :Info:Using DB command timeout = 1800 seconds.
[13:20:17]: Error: :Error in Forcing Service to Running state.: Threw Exception.Type: System.InvalidOperationException, Exception Error Code: 0x80131509, Exception.Message: Service MSSQLSERVER was not found on computer 'sql.xxxxx.xxxx'.
[13:20:17]: Error: :StackTrace: at System.ServiceProcess.ServiceController.GenerateNames()
at System.ServiceProcess.ServiceController.get_ServiceName()
at System.ServiceProcess.ServiceController.GenerateStatus()
at System.ServiceProcess.ServiceController.get_Status()
at Microsoft.EnterpriseManagement.OperationsManager.Setup.Common.SetupValidationHelpers.ForceSqlServiceToRunningState(String sqlServerInstance)
[13:20:17]: Error: :Inner Exception.Type: System.ComponentModel.Win32Exception, Exception Error Code: 0x80131509, Exception.Message: The specified service does not exist as an installed service
[13:20:17]: Error: :InnerException.StackTrace:
[13:20:17]: Warn: :Could not start the SQL Service sql.xxxxx.xxxx but we will attempt to connect anyway.
[13:20:17]: Debug: :Connection was not open. We will try to open it.
[13:20:17]: Debug: :SqlConnectionReady returned True.
[13:20:17]: Info: :Info:Using DB command timeout = 1800 seconds.
[13:20:17]: Error: :Error in Forcing Service to Running state.: Threw Exception.Type: System.InvalidOperationException, Exception Error Code: 0x80131509, Exception.Message: Service MSSQLSERVER was not found on computer 'sql.xxxxx.xxxx'.
[13:20:17]: Error: :StackTrace: at System.ServiceProcess.ServiceController.GenerateNames()
at System.ServiceProcess.ServiceController.get_ServiceName()
at System.ServiceProcess.ServiceController.GenerateStatus()
at System.ServiceProcess.ServiceController.get_Status()
at Microsoft.EnterpriseManagement.OperationsManager.Setup.Common.SetupValidationHelpers.ForceSqlServiceToRunningState(String sqlServerInstance)
[13:20:17]: Error: :Inner Exception.Type: System.ComponentModel.Win32Exception, Exception Error Code: 0x80131509, Exception.Message: The specified service does not exist as an installed service
[13:20:17]: Error: :InnerException.StackTrace:
[13:20:17]: Warn: :Could not start the SQL Service sql.xxxxx.xxxx but we will attempt to connect anyway.
[13:20:17]: Debug: :Connection was not open. We will try to open it.
[13:20:17]: Debug: :SqlConnectionReady returned True.
[13:20:17]: Info: :Info:Using DB command timeout = 1800 seconds.
[13:20:17]: Info: :No need to validate Data Reader and Data Writer are the same as the Management Group.
[13:20:17]: Error: :Error in Forcing Service to Running state.: Threw Exception.Type: System.InvalidOperationException, Exception Error Code: 0x80131509, Exception.Message: Service MSSQLSERVER was not found on computer 'sql.xxxxx.xxxx'.
[13:20:17]: Error: :StackTrace: at System.ServiceProcess.ServiceController.GenerateNames()
at System.ServiceProcess.ServiceController.get_ServiceName()
at System.ServiceProcess.ServiceController.GenerateStatus()
at System.ServiceProcess.ServiceController.get_Status()
at Microsoft.EnterpriseManagement.OperationsManager.Setup.Common.SetupValidationHelpers.ForceSqlServiceToRunningState(String sqlServerInstance)
[13:20:17]: Error: :Inner Exception.Type: System.ComponentModel.Win32Exception, Exception Error Code: 0x80131509, Exception.Message: The specified service does not exist as an installed service
[13:20:17]: Error: :InnerException.StackTrace:
[13:20:17]: Warn: :Could not start the SQL Service sql.xxxxx.xxxx but we will attempt to connect anyway.
[13:20:17]: Debug: :Connection was not open. We will try to open it.
[13:20:17]: Debug: :SqlConnectionReady returned True.
[13:20:17]: Info: :Info:Using DB command timeout = 1800 seconds.
[13:20:17]: Info: :Info:AccountsInformationPage: Async account validation thread returned to UI thread.
[13:20:17]: Info: :Writing values to property bag.
[13:20:17]: Info: :Done writing values to property bag.
[13:20:17]: Always: :Entering Page: ImproveUserExperiencePage
[13:20:19]: Always: :Entering Page: MSFTUpdatePage
[13:20:23]: Always: :Entering Page: ConfigurationSummaryPage
[13:20:23]: Info: :Website Binding info: *:80:
[13:20:23]: Always: :Operations Manager Web Address: http://OHQ-SCOM-SRV01/OperationsManager
[13:20:23]: Info: :Website Binding info: *:80:
[13:20:23]: Always: :Application Diagnostics Web Address: http://OHQ-SCOM-SRV01/AppDiagnostics
[13:20:23]: Info: :Website Binding info: *:80:
[13:20:23]: Always: :Application Advisor Web Address: http://OHQ-SCOM-SRV01/AppAdvisor
[13:20:26]: Debug: :No match for OMDATABASE found.
[13:20:26]: Debug: :No match for OMDATAWAREHOUSE found.
[13:20:26]: Info: :Info:AddDependentInstallItems: Added OMDATABASE item to the list of items to install
[13:20:26]: Debug: :No match for OMREPORTING found.
[13:20:26]: Always: :PrepareInstallDataItems: Install Item list:
[13:20:26]: Always: :***************************
[13:20:26]: Always: :Initial Configuration
[13:20:26]: Always: :Database Configuration
[13:20:26]: Always: :Management Server
[13:20:26]: Always: :Data Warehouse Configuration
[13:20:26]: Always: :Operations console
[13:20:26]: Always: :Web Console Server
[13:20:26]: Always: :Final Configuration
[13:20:26]: Always: :***************************
[13:20:26]: Debug: :*****ResetInstallItemFileLocations********************************************
[13:20:26]: Debug: :Item: Database Configuration
[13:20:26]: Debug: :path set to: C:\SCOM2019\System Center Operations Manager 2019\Setup\AMD64\SetupInstallItem.exe
[13:20:26]: Debug: :------------------------------------------------------------------------------
[13:20:26]: Debug: :Item: Management Server
[13:20:26]: Debug: :path set to: C:\SCOM2019\System Center Operations Manager 2019\Setup\AMD64\Server\OMServer.msi
[13:20:26]: Debug: :------------------------------------------------------------------------------
[13:20:26]: Debug: :Item: Data Warehouse Configuration
[13:20:26]: Debug: :path set to: C:\SCOM2019\System Center Operations Manager 2019\Setup\AMD64\SetupInstallItem.exe
[13:20:26]: Debug: :------------------------------------------------------------------------------
[13:20:26]: Debug: :Item: Operations console
[13:20:26]: Debug: :path set to: C:\SCOM2019\System Center Operations Manager 2019\Setup\AMD64\Console\OMConsole.msi
[13:20:26]: Debug: :------------------------------------------------------------------------------
[13:20:26]: Debug: :Item: Web Console Server
[13:20:26]: Debug: :path set to: C:\SCOM2019\System Center Operations Manager 2019\Setup\AMD64\WebConsole\WebConsole.msi
[13:20:26]: Debug: :------------------------------------------------------------------------------
[13:20:26]: Debug: :******************************************************************************
[13:20:26]: Debug: :Looking for file: C:\SCOM2019\System Center Operations Manager 2019\Setup\AMD64\SetupInstallItem.exe.
[13:20:26]: Debug: :Found C:\SCOM2019\System Center Operations Manager 2019\Setup\AMD64\SetupInstallItem.exe.
[13:20:26]: Debug: :Looking for file: C:\SCOM2019\System Center Operations Manager 2019\Setup\AMD64\Server\OMServer.msi.
[13:20:26]: Debug: :Found C:\SCOM2019\System Center Operations Manager 2019\Setup\AMD64\Server\OMServer.msi.
[13:20:26]: Debug: :Looking for file: C:\SCOM2019\System Center Operations Manager 2019\Setup\AMD64\SetupInstallItem.exe.
[13:20:26]: Debug: :Found C:\SCOM2019\System Center Operations Manager 2019\Setup\AMD64\SetupInstallItem.exe.
[13:20:26]: Debug: :Looking for file: C:\SCOM2019\System Center Operations Manager 2019\Setup\AMD64\Console\OMConsole.msi.
[13:20:26]: Debug: :Found C:\SCOM2019\System Center Operations Manager 2019\Setup\AMD64\Console\OMConsole.msi.
[13:20:26]: Debug: :Looking for file: C:\SCOM2019\System Center Operations Manager 2019\Setup\AMD64\WebConsole\WebConsole.msi.
[13:20:26]: Debug: :Found C:\SCOM2019\System Center Operations Manager 2019\Setup\AMD64\WebConsole\WebConsole.msi.
[13:20:26]: Always: :Begin: Property bag dump.
[13:20:26]: Always: :SetupStartTime = 11/16/2021 1:17:15 PM
[13:20:26]: Always: :Collection ProtectedProperties (System.Collections.ArrayList):
[13:20:26]: Always: : [0] = ActionAccountPassword
[13:20:26]: Always: : [1] = DASAccountPassword
[13:20:26]: Always: :DefaultLogName = C:\Users\mhamed\AppData\Local\SCOM\Logs\OpsMgrSetupWizard.log
[13:20:26]: Always: :DefaultLogPath = C:\Users\mhamed\AppData\Local\SCOM\Logs
[13:20:26]: Always: :locale = en
[13:20:26]: Always: :path = C:\SCOM2019\System Center Operations Manager 2019\Setup\AMD64\
[13:20:26]: Always: :SendCEIPReports = 1
[13:20:26]: Always: :EnableErrorReporting = Always
[13:20:26]: Always: :setupexepath = C:\Users\mhamed\AppData\Local\SCOM\Setup
[13:20:26]: Always: :ArchitectureIs64Check = True
[13:20:26]: Always: :Collection ListOfSupportedComponents (System.Collections.ArrayList):
[13:20:26]: Always: : [0] = OMCONSOLE
[13:20:26]: Always: : [1] = OMSERVER
[13:20:26]: Always: : [2] = OMWEBCONSOLE
[13:20:26]: Always: : [3] = OMREPORTING
[13:20:26]: Always: :install = 1
[13:20:26]: Always: :installpath = C:\Program Files\Microsoft System Center\Operations Manager
[13:20:26]: Always: :EulaFilesPath = C:\Users\mhamed\AppData\Local\SCOM\Setup
[13:20:26]: Always: :HealthServiceTypeId = AB4C891F-3359-3FB6-0704-075FBFE36710
[13:20:26]: Always: :hsPort = C51B7833-DA54-1653-D8FD-1A738EF8DED5
[13:20:26]: Always: :SysPrepScenario = NotASysPrepRun
[13:20:26]: Always: :ScreensLoaded = 1
[13:20:26]: Always: :Collection ListOfSelectedComponents (System.Collections.ArrayList):
[13:20:26]: Always: : [0] = OMSERVER
[13:20:26]: Always: : [1] = OMCONSOLE
[13:20:26]: Always: : [2] = OMWEBCONSOLE
[13:20:26]: Always: :OMSERVER = 1
[13:20:26]: Always: :ManagementServer = OHQ-SCOM-SRV01.mnoii.com
[13:20:26]: Always: :OMCONSOLE = 1
[13:20:26]: Always: :OMWEBCONSOLE = 1
[13:20:26]: Always: :SelectDatabaseInstanceReloadScreenInformation = 1
[13:20:26]: Always: :ReloadPrerequisitesPageChoice = PrerequisitesProgressPage
[13:20:26]: Always: :LoadedPrerequisiteXmlFile = True
[13:20:26]: Always: :PrerequisitesCheckXMLLoaded = True
[13:20:26]: Always: :CountFilteredPrerequisites_Failed = 0
[13:20:26]: Always: :CountFilteredPrerequisites_Warning = 0
[13:20:26]: Always: :CountFilteredPrerequisites_PassedWithChoices = 0
[13:20:26]: Always: :CountFilteredPrerequisites_Passed = 36
[13:20:26]: Always: :PrerequisiteState = Passed
[13:20:26]: Always: :XmlFilteredPrerequisites_Passed : Begin XML property
[13:20:26]: Always: :<?xml version="1.0" encoding="utf-8"?><Root><Title TitleText="OMSERVER"><Detail state="Passed" image="pack://application:,,,/SetupChainerUI;component/GreenCheck.png" name="ntfsCheckTitle" descriptionBody="" descriptionTitle="ntfsCheckPassed" resolution="ntfsCheckResolution" /><Detail state="Passed" image="pack://application:,,,/SetupChainerUI;component/GreenCheck.png" name="memoryCheckTitle" descriptionBody="" descriptionTitle="serverMemCheckPassed" resolution="serverMemCheckResolution" /><Detail state="Passed" image="pack://application:,,,/SetupChainerUI;component/GreenCheck.png" name="DriveSpaceCheckTitle" descriptionBody="" descriptionTitle="ServerDriveSpaceCheckPassed" resolution="ServerDriveSpaceCheckResolution" /><Detail state="Passed" image="pack://application:,,,/SetupChainerUI;component/GreenCheck.png" name="OSVersionCheckTitle" descriptionBody="" descriptionTitle="OSVersionCheckPassed" resolution="OSVersionCheckResolution" /><Detail state="Passed" image="pack://application:,,,/SetupChainerUI;component/GreenCheck.png" name="PowershellCheckTitle" descriptionBody="" descriptionTitle="PowershellCheckPassed" resolution="PowerShellCheckResolution" /><Detail state="Passed" image="pack://application:,,,/SetupChainerUI;component/GreenCheck.png" name="DomainControllerCheckTitle" descriptionBody="" descriptionTitle="DomainControllerCheckPassed" resolution="DomainControllerCheckResolution" /><Detail state="Passed" image="pack://application:,,,/SetupChainerUI;component/GreenCheck.png" name="WindowsInstallerCheckTitle" descriptionBody="" descriptionTitle="WindowsInstallerCheckPassed" resolution="WindowsInstallerCheckResolution" /><Detail state="Passed" image="pack://application:,,,/SetupChainerUI;component/GreenCheck.png" name="WinRMCheckTitle" descriptionBody="" descriptionTitle="WinRMCheckPassed" resolution="WinRMCheckResolution" /><Detail state="Passed" image="pack://application:,,,/SetupChainerUI;component/GreenCheck.png" name="PendingRebootCheckTitle" descriptionBody="" descriptionTitle="PendingRebootCheckPassed" resolution="PendingRebootCheckResolution" /><Detail state="Passed" image="pack://application:,,,/SetupChainerUI;component/GreenCheck.png" name="ClusteredServerCheckTitle" descriptionBody="" descriptionTitle="ClusteredServerCheckPassed" resolution="ClusteredServerCheckResolution" /><Detail state="Passed" image="pack://application:,,,/SetupChainerUI;component/GreenCheck.png" name="RemoteRegistryCheckTitle" descriptionBody="" descriptionTitle="RemoteRegistryCheckPassed" resolution="RemoteRegistryCheckResolution" /><Detail state="Passed" image="pack://application:,,,/SetupChainerUI;component/GreenCheck.png" name="ActiveDirectoryCheckTitle" descriptionBody="" descriptionTitle="ActiveDirectoryCheckPassed" resolution="ActiveDirectoryCheckResolution" /><Detail state="Passed" image="pack://application:,,,/SetupChainerUI;component/GreenCheck.png" name="IsComputerNameValidTitle" descriptionBody="" descriptionTitle="IsComputerNameValidPassed" resolution="IsComputerNameValidResolution" /><Detail state="Passed" image="pack://application:,,,/SetupChainerUI;component/GreenCheck.png" name="AVIcodeAgentCheck" descriptionBody="" descriptionTitle="AVICodeAgentCheckPassed" resolution="AVICodeAgentCheckResolution" /><Detail state="Passed" image="pack://application:,,,/SetupChainerUI;component/GreenCheck.png" name="MOMASPAgentInstalledCheck" descriptionBody="" descriptionTitle="MOMASPAgentCheckPassed" resolution="MOMASPAgentResolution" /></Title><Title TitleText="OMCONSOLE"><Detail state="Passed" image="pack://application:,,,/SetupChainerUI;component/GreenCheck.png" name="DriveSpaceCheckTitle" descriptionBody="" descriptionTitle="ConsoleDriveSpaceCheckPassed" resolution="ConsoleDriveSpaceCheckResolution" /><Detail state="Passed" image="pack://application:,,,/SetupChainerUI;component/GreenCheck.png" name="OSVersionCheckTitle" descriptionBody="" descriptionTitle="OSVersionCheckPassed" resolution="OSVersionCheckResolution" /><Detail state="Passed" image="pack://application:,,,/SetupChainerUI;component/GreenCheck.png" name="ReportViewerCheckTitle" descriptionBody="" descriptionTitle="ReportViewerCheckPassed" resolution="ReportViewerCheckResolution" /></Title><Title TitleText="OMWEBCONSOLE"><Detail state="Passed" image="pack://application:,,,/SetupChainerUI;component/GreenCheck.png" name="memoryCheckTitle" descriptionBody="" descriptionTitle="ReportingMemCheckPassed" resolution="ReportingMemCheckResolution" /><Detail state="Passed" image="pack://application:,,,/SetupChainerUI;component/GreenCheck.png" name="SEViewerInstalledCheck" descriptionBody="" descriptionTitle="SeViewerInstalledCheckPassed" resolution="SeViewerInstalledCheckResolution" /><Detail state="Passed" image="pack://application:,,,/SetupChainerUI;component/GreenCheck.png" name="IISCheckTitle" descriptionBody="" descriptionTitle="IISCheckPassed" resolution="IISCheckResolution" /><Detail state="Passed" image="pack://application:,,,/SetupChainerUI;component/GreenCheck.png" name="IISMetabaseCheckTitle" descriptionBody="" descriptionTitle="IISMetabaseCheckPassed" resolution="IISMetabaseCheckResolution" /><Detail state="Passed" image="pack://application:,,,/SetupChainerUI;component/GreenCheck.png" name="AspNetCheckTitle" descriptionBody="" descriptionTitle="AspNetCheckPassed" resolution="AspNetCheckResolution" /><Detail state="Passed" image="pack://application:,,,/SetupChainerUI;component/GreenCheck.png" name="WindowsAuthRoleCheckTitle" descriptionBody="" descriptionTitle="WindowsAuthRoleCheckPassed" resolution="WindowsAuthRoleCheckResolution" /><Detail state="Passed" image="pack://application:,,,/SetupChainerUI;component/GreenCheck.png" name="StaticContentRoleCheckTitle" descriptionBody="" descriptionTitle="StaticContentRoleCheckPassed" resolution="StaticContentRoleCheckResolution" /><Detail state="Passed" image="pack://application:,,,/SetupChainerUI;component/GreenCheck.png" name="DefaultDocumentRoleCheckTitle" descriptionBody="" descriptionTitle="DefaultDocumentRoleCheckPassed" resolution="DefaultDocumentRoleCheckResolution" /><Detail state="Passed" image="pack://application:,,,/SetupChainerUI;component/GreenCheck.png" name="DirectoryBrowsingRoleCheckTitle" descriptionBody="" descriptionTitle="DirectoryBrowsingRoleCheckPassed" resolution="DirectoryBrowsingRoleCheckResolution" /><Detail state="Passed" image="pack://application:,,,/SetupChainerUI;component/GreenCheck.png" name="HttpErrorsRoleCheckTitle" descriptionBody="" descriptionTitle="HttpErrorsRoleCheckPassed" resolution="HttpErrorsRoleCheckResolution" /><Detail state="Passed" image="pack://application:,,,/SetupChainerUI;component/GreenCheck.png" name="HttpLoggingRoleCheckTitle" descriptionBody="" descriptionTitle="HttpLoggingRoleCheckPassed" resolution="HttpLoggingRoleCheckResolution" /><Detail state="Passed" image="pack://application:,,,/SetupChainerUI;component/GreenCheck.png" name="RequestMonitorRoleCheckTitle" descriptionBody="" descriptionTitle="RequestMonitorRoleCheckPassed" resolution="RequestMonitorRoleCheckResolution" /><Detail state="Passed" image="pack://application:,,,/SetupChainerUI;component/GreenCheck.png" name="RequestFilterRoleCheckTitle" descriptionBody="" descriptionTitle="RequestFilterRoleCheckPassed" resolution="RequestFilterRoleCheckResolution" /><Detail state="Passed" image="pack://application:,,,/SetupChainerUI;component/GreenCheck.png" name="StaticContentCheckTitle" descriptionBody="" descriptionTitle="StaticContentCheckPassed" resolution="StaticContentCheckResolution" /><Detail state="Passed" image="pack://application:,,,/SetupChainerUI;component/GreenCheck.png" name="IsapiAllowedCheckTitle" descriptionBody="" descriptionTitle="IsapiAllowedCheckPassed" resolution="IsapiAllowedCheckResolution" /><Detail state="Passed" image="pack://application:,,,/SetupChainerUI;component/GreenCheck.png" name="IsAspNetIntegratedHandlerInstalledTitle" descriptionBody="" descriptionTitle="IsAspNetIntegratedHandlerInstalledPassed" resolution="IsAspNetIntegratedHandlerInstalledResolution" /><Detail state="Passed" image="pack://application:,,,/SetupChainerUI;component/GreenCheck.png" name="HttpActivationCheckTitle" descriptionBody="" descriptionTitle="HttpActivationCheckPassed" resolution="HttpActivationCheckResolution" /><Detail state="Passed" image="pack://application:,,,/SetupChainerUI;component/GreenCheck.png" name="HttpActivationCheckTitle" descriptionBody="" descriptionTitle="HttpActivation45RoleCheckPassed" resolution="HttpActivation45RoleCheckResolution" /></Title></Root>
[13:20:26]: Always: :End XML property
[13:20:26]: Always: :UserSelectedInstallType = FirstServer
[13:20:26]: Always: :ManagementGroupName = mnoiicom
[13:20:26]: Always: :SqlServerInstance = sql.xxxxx.xxxx
[13:20:26]: Always: :DatabaseName = OperationsManager
[13:20:26]: Always: :DatabaseSize = 1000
[13:20:26]: Always: :DatabaseLogPath = E:\MSSQL14.INST01\MSSQL\DATA\
[13:20:26]: Always: :DatabasePath = E:\MSSQL14.INST01\MSSQL\DATA\
[13:20:26]: Always: :DbMode = New
[13:20:26]: Always: :SqlServerInstancePhysical = OHQ-SQL02\INST01
[13:20:26]: Always: :DatabaseScenario = NewDatabase
[13:20:26]: Always: :ServerScenario = FirstServer
[13:20:26]: Always: :DWSqlServerInstancePhysical = OHQ-SQL02\INST01
[13:20:26]: Always: :DWSqlServerInstance = sql.xxxxx.xxxx
[13:20:26]: Always: :DWDatabaseName = OperationsManagerDW
[13:20:26]: Always: :DWDatabaseSize = 1000
[13:20:26]: Always: :DWDatabaseLogPath = E:\MSSQL14.INST01\MSSQL\DATA\
[13:20:26]: Always: :DWDatabasePath = E:\MSSQL14.INST01\MSSQL\DATA\
[13:20:26]: Always: :DataWarehouseScenario = NewDatabase
[13:20:26]: Always: :WebsiteName = Default Web Site
[13:20:26]: Always: :WebConsoleAuthorizationMode = Mixed
[13:20:26]: Always: :DataReaderAccount = LocalSystem: False Account User Name: mnoii.com\SCOMreporting
[13:20:26]: Always: :ActionAccount = LocalSystem: False Account User Name: mnoii.com\SCOMactionaccount
[13:20:26]: Always: :DASAccount = LocalSystem: False Account User Name: mnoii.com\SCOMdas
[13:20:26]: Always: :DataWriterAccount = LocalSystem: False Account User Name: mnoii.com\SCOMreporting
[13:20:26]: Always: :UseMicrosoftUpdate = 1
[13:20:26]: Always: :Collection ItemsToInstall (System.Collections.ArrayList):
[13:20:26]: Always: : [0] = Initial Configuration (Microsoft.SystemCenter.Essentials.SetupFramework.InstallItemsInstallDataItem)
[13:20:26]: Always: : [1] = Database Configuration (Microsoft.SystemCenter.Essentials.SetupFramework.InstallItemsInstallDataItem)
[13:20:26]: Always: : [2] = Management Server (Microsoft.SystemCenter.Essentials.SetupFramework.InstallItemsInstallDataItem)
[13:20:26]: Always: : [3] = Data Warehouse Configuration (Microsoft.SystemCenter.Essentials.SetupFramework.InstallItemsInstallDataItem)
[13:20:26]: Always: : [4] = Operations console (Microsoft.SystemCenter.Essentials.SetupFramework.InstallItemsInstallDataItem)
[13:20:26]: Always: : [5] = Web Console Server (Microsoft.SystemCenter.Essentials.SetupFramework.InstallItemsInstallDataItem)
[13:20:26]: Always: : [6] = Final Configuration (Microsoft.SystemCenter.Essentials.SetupFramework.InstallItemsInstallDataItem)
[13:20:26]: Always: :End: Property bag dump.
[13:20:26]: Always: :Entering Page: ProgressPage
[13:20:26]: Always: :!***** Installing: INITIAL_CONFIGURATION ***
[13:20:26]: Info: :SetProgressScreen: StartMinorStep.
[13:20:26]: Debug: :LoadAndInitializeUpdateFile: Loading QFE file from C:\Users\mhamed\AppData\Local\SCOM\Setup\qfelist.xaml
[13:20:26]: Debug: :LoadUpdatesFile: File C:\Users\mhamed\AppData\Local\SCOM\Setup\qfelist.xaml not found. No QFE's to apply for this file.
[13:20:26]: Debug: :InitializeUpdateItems: No QFE's to apply.
[13:20:26]: Debug: :LoadAndInitializeUpdateFile: Loading QFE file from C:\SCOM2019\System Center Operations Manager 2019\Setup\AMD64\qfelist.xaml
[13:20:26]: Debug: :LoadUpdatesFile: File C:\SCOM2019\System Center Operations Manager 2019\Setup\AMD64\qfelist.xaml not found. No QFE's to apply for this file.
[13:20:26]: Debug: :InitializeUpdateItems: No QFE's to apply.
[13:20:26]: Warn: :ApplyUpdates: Unable to load QFE file.
[13:20:26]: Always: :Doing Preinstall task for INITIAL_CONFIGURATION
[13:20:26]: Warn: :CheckAndLoadUpdateFiles: Unable to load QFE file.
[13:20:26]: Always: :Doing Install task for INITIAL_CONFIGURATION
[13:20:27]: Debug: :DoInstallTask: Found Microsoft.SystemCenter.Essentials.SetupFramework.InstallItemsDelegates.UpgradeProcessor;DoUpgradePreInstallTasks as type and method.
[13:20:27]: Info: :Type: Microsoft.SystemCenter.Essentials.SetupFramework.InstallItemsDelegates.UpgradeProcessor Method: DoUpgradePreInstallTasks
[13:20:27]: Always: :Doing Postinstall task for INITIAL_CONFIGURATION
[13:20:27]: Warn: :ApplyUpdates: Unable to load QFE file.
[13:20:27]: Info: :SetProgressScreen: FinishMinorStep.
[13:20:27]: Always: :!***** Installing: OMDATABASE ***
[13:20:27]: Info: :SetProgressScreen: StartMinorStep.
[13:20:27]: Warn: :ApplyUpdates: Unable to load QFE file.
[13:20:27]: Always: :Doing Preinstall task for OMDATABASE
[13:20:27]: Debug: :ProcessInstalls: Install Item Databa
Hi @yasser Mohamed AbdelMoneim ,
Could you please upload the OpsMgrSetupWizard.log to this thread so that we can investigate more?
The log file is found under %LocalAppData%\SCOM\Logs
----------
If the reply was helpful please don't forget to upvote and/or accept as answer, thank you!
Best regards,
Leon
Error: :DB operations failed with SQL error 2812: Could not find stored procedure 'p_MOMManagementGroupInfoSelect'.
: Threw Exception.Type: System.Data.SqlClient.SqlException, Exception Error Code: 0x80131904, Exception.Message: Could not find stored procedure 'p_MOMManagementGroupInfoSelect'.
[14:10:12]: Error: :StackTrace: at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
To eliminate any permission risks, try installing SCOM 2019 with an account that has full permissions (sysadmin) on the SQL AlwaysOn cluster.
Also make sure that the server you are attempting to install SCOM 2019 on does not have any previous SCOM agents installed.