Troubleshooting
Problem
User launches Controller Configuration. User opens 'database connections' and selects a connection.
User clicks the 'tick' button (to test a connection).
- An error appears.
Symptom
The 'SQLNCLI11.1' provider is not registered on the local machine
Cause
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.
Related Information
Document Location
Worldwide
[{"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"}}]
Was this topic helpful?
Document Information
Modified date:
02 April 2020
UID
ibm16151713