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

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

book

Article ID: 370737

calendar_today

Updated On:

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, the current usable DB drivers of the data_engine (SQLOLEDB) and (SQLNCLI11) are outdated/deprecated.

  • SQLOLEDB is a legacy, deprecated OLE DB driver for MS SQL Server (originally bundled with Windows).

  • MSOLEDBSQL is the modern, officially supported OLE DB driver.

As of DX UIM 20.4 CU4 or higher:

Select MSOLEDBSQL as the 'Provider.'



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

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

Powered by Wolken Software