Update Rollup 2 for System Center 2022 Service Manager

Symptom 

Microsoft is receiving reports that this update rollup won’t install on systems if the Hotfix for System Center 2022 Service Manager - June 2023 (KB5021792) was already installed.  

Resolution

If the Hotfix for System Center 2022 Service Manager - June 2023 (KB5021792) is already installed, please wait for the next update rollup. Note that systems on 2022 RTM are not impacted and can apply UR2. 

Before the installation

Before you apply this update, follow these steps:

1. Exit all Service Manager-related applications before you apply this update. For example, exit the Service Manager console, the Self-Service Portal links, and the authoring tool.

2. Make sure that the Data Warehouse Server has successfully synchronized with the Management Server at least once, without any management packs in the “Pending Disassociation,” “Pending Association,” or “Imported” status.

3. If you have customizations in the portal sidebar, make a backup of the Views\Shared\Sidebar.cshtml file.

Installation

1. Make sure that the update is installed on the Service Manager components in the following order:

   • Data Warehouse server

   • Primary Management server

   • Secondary Management servers

   • Self Service Portal server

   • All Analyst consoles

2. Download the update to a target folder.

   • Note: This update contains both the x86-based and x64-based versions. Download the appropriate version for your system.

3. Open the target folder, and then right-click the downloaded file from step 2.

4. Select Run as administrator.

5. Accept the Microsoft Software License terms, and then follow the steps in the installation wizard.

Post installation

1. Restart the System Center Data Access Service on the Primary Management Server and all Secondary Management Servers.

2. Restart all the Analyst consoles after the update is installed.

3. If any customizations were backed up for the portal sidebar, merge the required changes in the updated Views\Shared\Sidebar.cshtml file.

4. Restart the system that is hosting the portal server that is running IIS.

5. Restart the Data Warehouse management server.

Steps to change the provider in SQL Server Analysis Server

Important: Follow these steps only after you install the latest SQL driver (MSOLEDBSQL or the Microsoft SqlClient Data Provider for SQL Server) on the SQL Server Analysis Server role. For more information about how to install MSOLEDBSQL, see Microsoft OLE DB driver for SQL Server. For more information about SqlClient, see Overview of the SqlClient driver.

1. Open SQL Server Management Studio and connect to the Analysis Services role.

2. Expand Databases > [Analysis Service DB] > Data Sources.

• Note: In this path, replace [Analysis Service DB] with the name of the actual Analysis Service database (usually DWASDataBase).

3. Repeat the following actions for all listed data sources:

• Right-click a data source (such as DWDataMart), and then select Properties.

• Under General, select Connection String, select Connection Manager, select the Providers list. and then change the provider name, as appropriate:

• For .Net Providers, select .Net SQLClient provider, and then select OK.

• For MSOLEDBSQL provider, change the provider name from SQLNCLI11 to MSOLEDBSQL.

• Under Security Settings. select Impersonation Info.

• If you are using Windows authentication, provide the username and password, and then select OK.

• Select OK.

• Restart SQL Server Analysis Service from Services.msc.