Microsoft Download Center Archive

Update Rollup 9 for System Center 2016 Service Manager

  • Published:
  • Version: 2016 UR9
  • Category: servers
  • Language: English

Update Rollup 9 for System Center 2016 Service Manager

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

Knowledge Base Articles:

Files

Status: Live

This download is still available on microsoft.com. The downloads below will come directly from the Microsoft Download Center.

System Requirements

Operating Systems: Windows Server 2016

Supported Operating System Windows Server 2012 R2, Windows Server 2016 System Center 2016 Service Manager

Installation Instructions

Please refer KB4546987 for detailed installation instructions.

This page was generated from a snapshot of the Microsoft Download Center made on .
Report a problem