IBM Support

"The 'SQLNCLI11.1' provider is not registered on the local machine" when testing database connection



User launches Controller Configuration. User opens 'database connections' and selects a connection.
User clicks the 'tick' button (to test a connection).
- An error appears.


image 2725
The 'SQLNCLI11.1' provider is not registered on the local machine


The SQL Native Client (2012) has not been installed on the Controller application server.

Resolving The Problem

Install the relevant version of the SQL Native client onto the Controller application server.


Example: Controller 10.4.2

Even if you are using a later version of Microsoft SQL server (for example SQL 2019) you must download and install the SQL 2012 Native client (also known as 'SQLNCLI11.1'):

1. Download the 64-bit Microsoft SQL 2012 Native client (sqlncli.msi)

  • TIP: A link to where to download it (correct at the time of writing this Technote), this can be found below

2. Logon to the Controller application server

3. Double-click on the file: sqlncli.msi

4. Test.

Document Location


[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SS9S6B","label":"IBM Cognos Controller"},"ARM Category":[{"code":"a8m0z0000000AxnAAE","label":"Documentation"}],"ARM Case Number":"TS003546894","Platform":[{"code":"PF033","label":"Windows"}],"Version":"10.4.2","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
02 April 2020