During in place upgrade of SQL Server 2022, Installation may fail with below error or warning, but it will end with successful message. During SSRS or PBIRS installation it may fail with Second error as shown below -
First Error/Warning During upgrade
Second Error SSRS/PBI RS:
UnexpectedError: setup failed for packageId: SSReportingServicesSetup, package: Microsoft SQL Server Reporting Services, errorCode: -2147483648, errorMessage: Something went wrong, please find details in setup logs.
Resolution :
Sometimes the SQL Server WMI namespace (root\Microsoft\SqlServer\ComputerManagement) is missing or corrupted.
Run this in Command Prompt:
mofcomp "C:\Program Files (x86)\Microsoft SQL Server\150\Shared\sqlmgmproviderxpsp2up.mof"
Note: make sure you are in the right folder and right version of the SQL Server.
