New SCOM 2019 Install with SQL 2019 fails "SQL Server version cannot be verified"

Rahul Sukumar 141 Reputation points
2020-11-28T04:43:12.363+00:00

I am trying to install SCOM 2019 with SQL 2019 CU8 as the operational database. During setup, I specify the SQL Server name and port, and after it tries to validate for many seconds, it gives me the following error:

The installed version of SQL Server could not be verified or is not supported. Verify that the computer and the installed version of SQL Server meet the minimum requirements for installation, and that the firewall settings are correct. See the Supported Configurations document for further information.

According to the documentation, SQL Server 2019 is supported with ODBC 17.3 or later (installed latest version) and MSOLEDBSQL 18.2 or later (latest version installed).

The SQL server is on a separate VM than the SCOM server I am trying to install.

Has anyone been able to install SCOM 2019 with SQL 2019 as the DB? Am I missing anything?

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,417 questions
0 comments

5 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. CyrAz 5,181 Reputation points
    2020-11-28T13:04:05.193+00:00

    Could you show us the install log? They are under %LocalAppData%\SCOM\Log

    0 comments
  2. Rahul Sukumar 141 Reputation points
    2020-11-28T13:11:44.873+00:00

    I disabled Windows Firewall on the SQL Server and I was able to continue. I'll have to check the firewall logs to see what is blocking the SCOM install.

    0 comments
  3. SChalakov 10,261 Reputation points MVP
    2020-11-28T19:30:03.503+00:00

    Hi @Rahul Sukumar ,

    I had this case many times. In my opinion the SQL version is not the casue here. If you have CU8 then you are good to go. This is also depicetd here:

    SQL Server requirements

    The most common reason for this particular error is that the installation account is missing local admin permissions on your SQL DB server(s). I usual encounter this in bigger organizations during the install of SCOM, so I ask the DB Admins to grant me Local Admin permissions on the SQL node(s) only during the install of the first management server and then those can be removed. Please check if this is the case also here and update us on the progress.

    Many thanks in advance!

    ----------

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

    0 comments
  4. Rahul Sukumar 141 Reputation points
    2020-11-29T18:54:22.307+00:00

    @SChalakov The installation account did in fact have local admin rights on the SQL Server. I am not really sure why this is required but I had that setup anyway. Port 1433 is allowed for SQL access. I also opened SMB ports on the SQL server but this still did not work.

    It wasn't until I disabled the Windows firewall completely on the SQL box that the installation continued.

    0 comments
  5. AlexZhu-MSFT 5,551 Reputation points Microsoft Vendor
    2020-11-30T02:27:02.323+00:00

    Hi,

    To narrow down the problem, we may try to allow dynamic ports (49152-65535) to see if the problem can be duplicated.

    Hope the above information helps.

    Alex Zhu

    If the response is helpful, please click "Accept Answer" and upvote it.

    0 comments