Unlock your potential with Microsoft Copilot
Get things done faster and unleash your creativity with the power of AI anywhere you go.
Update Rollup 9 for System Center 2016 Service Manager
Update Rollup 9 for System Center 2016 Service Manager
Important! Selecting a language below will dynamically change the complete page content to that language.
Version:
2016 UR9
Date Published:
3/21/2020
File Name:
SCSM2016_CU_KB4546987_amd64_7.5.7487.210.exe
SCSM2016_CU_KB4546987_i386_7.5.7487.210.exe
File Size:
70.1 MB
70.0 MB
KB Articles:
This article describes the issues that are fixed in Update Rollup 9 for Microsoft System Center 2016 Service Manager.
Issues that are fixed and improvements
- Enables support for MSOLEDBSQL driver so that the customers may move from SQL Native Client . Manual steps are required to use MSOLEDBSQL driver with SQL Server Analysis Server (SSAS), which are provided in the next section.
- Fixes an issue where the query results were not localized if the language of the portal is non-English.
- Fixes an issue where the user was not able to submit a service request if one of the lists contained an item with a plus ‘+’ sign
- The first item in the lists while submitting a service request is now not selected by default. This ensures that the right category item is selected by the user.
- Fixes an issue where few users were unable to submit requests via portal with an error ‘The given key was not present in the dictionary’.
- Supports the SCCM 1806, 1810, 1902, 1906, 1910 releases. However, there is a limitation that the size of the devices supported by SCCM should be less than 2 PB.
Steps to change provider in SQL Server Analysis Server
- Open SQL Server Management Studio and navigate to Databases>Analysis Service DB>Datasources>DW DB. Replace ‘Analysis Service DB’ with the name of your actual Analysis Service database, and ‘DW DB’ with the name of your actual Data Warehouse database.
- Right click on DW DB and click on properties
- In the properties tab change the provider name from ‘SQL Native Client’ to ‘MSOLEDBSQL’ in the connection string
- Under the Security Settings click on the Impersonation Info
- Provide the username and password if you are using windows authentication and click Ok.
- The properties pane now reflects the new provider name in the connection string
- Click Ok
- Restart SQL Server Analysis Service from services.msc
Supported Operating Systems
Windows Server 2016
Supported Operating System Windows Server 2012 R2, Windows Server 2016 System Center 2016 Service Manager- Please refer KB4546987 for detailed installation instructions.