Share via

SCOM 2019 INSTALLATION ERROR FOR MANAGEMENT SERVER

Teja Konapalli 1 Reputation point
2022-09-06T10:15:24.677+00:00

Hi All,
Could you please help here with the below error while installing SCOM 2019:

[15:00:01]: 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'.
[15:00:01]: Error: :StackTrace: at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader()
at Microsoft.EnterpriseManagement.OperationsManager.Setup.Common.SqlRetryHandler.ExecuteReader(SqlCommand sqlCommand, SqlDataReader& result)
at Microsoft.EnterpriseManagement.OperationsManager.Setup.Common.SqlRetryHandler.ExecuteT
[15:00:01]: Error: :Error:Failed to execute sql command. Setup will not retry on this Sql error. Command: p_MOMManagementGroupInfoSelect
[15:00:01]: Error: :Sql error: 16. Error: 2812. Error Message: Could not find stored procedure 'p_MOMManagementGroupInfoSelect'.
[15:00:01]: Info: :Info:isOMDatabase: Read did not return true. The MG is missing. This is not OM DB
[15:00:01]: Info: :Info:Using DB command timeout = 1800 seconds.
[15:00:01]: 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'.
[15:00:01]: Error: :StackTrace: at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader()
at Microsoft.EnterpriseManagement.OperationsManager.Setup.Common.SqlRetryHandler.ExecuteReader(SqlCommand sqlCommand, SqlDataReader& result)
at Microsoft.EnterpriseManagement.OperationsManager.Setup.Common.SqlRetryHandler.ExecuteT
[15:00:01]: Error: :Error:Failed to execute sql command. Setup will not retry on this Sql error. Command: p_MOMManagementGroupInfoSelect
[15:00:01]: Error: :Sql error: 16. Error: 2812. Error Message: Could not find stored procedure 'p_MOMManagementGroupInfoSelect'.
[15:00:01]: Always: :Azman store table not found in SCOM2019ReportServerDB table, assuming this is an not a valid OMDB for empty DB scenario.
[15:00:01]: Debug: :Connection was not open. We will try to open it.
[15:00:01]: Debug: :SqlConnectionReady returned True.
[15:00:01]: Info: :Info:Using DB command timeout = 1800 seconds.
[15:00:01]: 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'.
[15:00:01]: Error: :StackTrace: at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader()
at Microsoft.EnterpriseManagement.OperationsManager.Setup.Common.SqlRetryHandler.ExecuteReader(SqlCommand sqlCommand, SqlDataReader& result)
at Microsoft.EnterpriseManagement.OperationsManager.Setup.Common.SqlRetryHandler.ExecuteT
[15:00:01]: Error: :Error:Failed to execute sql command. Setup will not retry on this Sql error. Command: p_MOMManagementGroupInfoSelect
[15:00:01]: Error: :Sql error: 16. Error: 2812. Error Message: Could not find stored procedure 'p_MOMManagementGroupInfoSelect'.
[15:00:01]: Info: :Info:isOMDatabase: Read did not return true. The MG is missing. This is not OM DB
[15:00:01]: Info: :Info:Using DB command timeout = 1800 seconds.
[15:00:01]: 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'.
[15:00:01]: Error: :StackTrace: at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader()
at Microsoft.EnterpriseManagement.OperationsManager.Setup.Common.SqlRetryHandler.ExecuteReader(SqlCommand sqlCommand, SqlDataReader& result)
at Microsoft.EnterpriseManagement.OperationsManager.Setup.Common.SqlRetryHandler.ExecuteT
[15:00:01]: Error: :Error:Failed to execute sql command. Setup will not retry on this Sql error. Command: p_MOMManagementGroupInfoSelect
[15:00:01]: Error: :Sql error: 16. Error: 2812. Error Message: Could not find stored procedure 'p_MOMManagementGroupInfoSelect'.

@Leon Laude please help her

SQL Server version : 2017

SQL Server Reporting Services version: 2017

SQL Server located locally / remotely?: REMOTE

Is this a standalone SQL Server or SQL Cluster / SQL Always On?: STANDALONE

Operations Manager
Operations Manager
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.
1,485 questions
0 comments

8 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. SChalakov 10,391 Reputation points MVP
    2022-09-07T06:14:19.767+00:00

    Hi @Teja Konapalli ,

    Have you already esnured that the account, which you are using for the installation has sufficient permissions on the SQL Server Intsance? This error might be related to the "Security Admin" role of the installation account, as depicted here:

    Management server installation 2016 errors.
    https://social.technet.microsoft.com/Forums/ie/en-US/8e06d12e-2e8d-4538-8c1f-58253fb1bc83/management-server-installation-2016-errors?forum=operationsmanagergeneral

    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'.
    The problem was fixed by checking the "security admin" tag in SQL for the account that was making the install.

    Same here, again permission issue:
    Operation Manager (SCOM) install SQL error
    https://stackoverflow.com/questions/27933571/operation-manager-scom-install-sql-error

    The problem was fixed by checking the "security admin" tag in SQL for the account that was making the install. I must mention that the account was already sa and dbcreator.

    So, please make sure you have Full Admin Permissions on the SQL Instance, that will host the SCOM database, re-start the setup process and it should work. Please also make sure you are starting the setup as an Administrator.
    Please don't forget that only during the initial install of each maanagement server, your accout (the account which is installing SCOM) should have also Local Administrative Permissions on all nodes, part of the SQL AlwaysOn Cluster or on the SQL Server if you are not using SQL AlwaysOn on the backend.

    I hope I could be of assistance.

    ----------

    (If the reply was helpful please don't forget to upvote and/or accept as answer, thank you)
    Regards
    Stoyan Chalakov

    1 person found this answer helpful.
    0 comments
  2. Teja Konapalli 1 Reputation point
    2022-09-07T04:51:58.767+00:00

    @Leon Laude could you please help here and am having this issue from 3 days and unable to move forward..

    0 comments
  3. Teja Konapalli 1 Reputation point
    2022-09-07T07:14:45.473+00:00

    Hi @SChalakov ,

    Account rights --> Am using windows admin authentication for both SCOM and SQL instance.

    How to use that security admin configurations?

    Attaching the opsmgrsetupwizard.txt --> please refer and offer the resolution step238473-opsmgrsetupwizard.txt

    238472-image.png

    0 comments
  4. Bob Cornelissen 251 Reputation points MVP
    2022-09-07T08:35:48.623+00:00

    I see multiple runs in that log file.

    1. Can you check the properties of the SQL Instance Authentication setting. It should be Windows Authentication (not mixed).
    2. your administrator account should be both windows admin on both machines, and also a SQL Admin. You can check that in SQL (in sql mgmt studio, instance - Security- Logins), find that administrator account and go for Properties - Server Roles. check its sysadmin (should be a checkbox). Use the domain-based accounts and not a local account on that server.
    3. do not use this administrator account as any of the 4 service accounts you fill in in the scom install wizard. in one of the errors it looks like it is trying to create and assign the admin account while it already exists. Create at least an mgmt server action account service account and a Data Access service service account. Best practice is to create 4 different ones. for small scom deployments you could use the data access account also as data reader and data writer. so either 2 or 4 service accounts created in the domain.
    4. when you re-run the wizard on that first management server (it looks like this is the first mgmt server). First confirm that the OperationsManager database is gone again from you SQL server, if it has not cleaned it up already the last time.
    5. make sure you are logged in with the admin account from the domain and not the local admin account on mgmt server (saw something in log file locations, just confirming). From corpdom i mean.
    0 comments
  5. SChalakov 10,391 Reputation points MVP
    2022-09-07T09:03:23.693+00:00

    Hi Tejal,

    as Bob stated - please chceck and ensure that Windows Authentication is configured. From:

    SQL Server Design Considerations
    https://learn.microsoft.com/en-us/system-center/scom/plan-sqlserver-design?view=sc-om-2019

    During the initial installation of the operational database, only use Windows Authentication on the SQL Server that hosts the Operations Manager operational database. Do not use Mixed Mode (Windows Authentication and SQL Server Authentication) because using SQL Server Authentication mode during the initial installation of the operational database can cause issues. Although enabling Mixed Mode security is possible on the SQL Server hosting the Operations Manager operational database, it is not supported as all contact with the database is accomplished using Windows accounts only.

    Regarding the SQL Security Role, this will help you configure it:

    SQL Server Security – Fixed server and database roles
    https://www.red-gate.com/simple-talk/databases/sql-server/database-administration-sql-server/sql-server-security-fixed-server-and-database-roles/

    Please also take the other recommendations from Bon into consideration. Still, I think the Security Admin membership should do the job.

    ----------

    (If the reply was helpful please don't forget to upvote and/or accept as answer, thank you)
    Regards
    Stoyan Chalakov

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.