Update Rollup 9 for System Center 2016 Service Manager

• 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.

• 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