DX UIM 20.4/23.4 - which database driver is supported for MS SQL Server database on Windows

Products

• CA Unified Infrastructure Management On-Premise (Nimsoft / UIM)
• CA Unified Infrastructure Management SaaS (Nimsoft / UIM)
• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

After upgrading to 20.4 CU4 or higher, or when upgrading to 23.4 or higher, some customers encounter issues due to the configured database driver in the data_engine provider field.

Environment

• DX UIM 20.4 or higher
• DX UIM 23.4 or higher

Cause

• Guidance

Resolution

Configure the MS SQL Driver
The driver provides connectivity between DX UIM and the MS SQL server database to enable the transfer and storing of data in the database.

IMPORTANT!
According to Microsoft (Microsoft OLE DB Driver for SQL Server), the current usable DB drivers of the data_engine (SQLOLEDB) and (SQLNCLI11) are outdated/deprecated.

• DX UIM 20.4 CU4 or higher
  Select MSOLEDBSQL (which is supported from DX UIM 20.4 CU4 or higher) as the Provider.

• DX UIM 23.4 or higher
  Microsoft SQL Server
  As of  data_engine 20.41 in DX UIM 20.4 CU4 or higher, Microsoft OLE DB Driver for SQL Server (MSOLEDBSQL) is supported, preferred, and recommended.

Supported versions of MSOLEDBSQL

On MS Windows your current driver version can be checked by navigating via Control Panel->Programs-> MSOLEDBSQL on the Primary hub or checking the Windows registry at:
HKEY_LOCAL_MACHINE>SOFTWARE>Microsoft>MSOLEDBSQL, click on MSOLEDBSQL and the installed version will be displayed.

• DX UIM 20.4 CU7: MSOLEDBSQL version is 18.6.3.0
• DX UIM 20.4 CU8: MSOLEDBSQL version is 18.6.5.0
• DX UIM 20.4 CU9: MSOLEDBSQL version is 18.6.6.0
• DX UIM 20.4 CU11: MSOLEDBSQL version is 18.6.6.0
• DX UIM 23.4 CU2 : MSOLEDBSQL version is 18.7.2

Please also refer to: Configure the MS SQL Driver

• Currently, MSOLEDBSQL version 19 has not been tested and therefore it is not supported but testing is underway and version 19 should be supported this summer.

Notes on database user permissions

If you are not using the System Administrator (sa) login and require SQL Authentication on Microsoft SQL Server, your user account must have the following permissions: 

• The db_owner database role for the UIM  
• Read and update permissions on the master and tmpdb system databases. 
• The serveradmin database role to create and execute stored procedures