The DSM Reporter is not connected to a database and a DSM domain

Products

• CA Client Automation - IT Client Manager
• CA Client Automation

Issue/Introduction

When opening DSM Reporter on a remote machine following error appears :

The DSM Reporter is not connected to a database and a DSM domain. The following messages were retrieved from a non-localized, detailed trace log and may be helpful in further diagnosing the problem: Domain Connect: Error opening domain database (%s/%s/%s) Db->Connect returned %li   Connect to Database %s with username %s failed   cAmo: Domain->Connect failed   Data Manager - Unable to connect using manager name only - DB was not initialized   Retry connection

 

 

In TRC_REPORTER_*.log there are these errors

REPORTER  |CDb         |DbImpl_Ado.cpp    |000465|DETAIL | CDb_Ado::internConnect using connection string: Provider=SQLNCLI;DataTypeCompatibility=80;Trusted_Connection=No;
REPORTER  |Ingres      |DbImpl_Ingres.cpp |000103|DETAIL | trperf_on: 0
REPORTER  |CDb         |DbImpl_Ado.cpp    |002644|NOTIFY | Error Message: ADO Version 10.0 - COM Error: ErrorCode:-2146824582,WordErrorCode:0, Unknown error 0x800A0E7A, Provider cannot be found. It may not be properly installed., ADODB.Connection, C:\Windows\HELP\ADO270.CHM
REPORTER  |CDb         |CDb.cpp           |000293|ERROR  | *** error trying to connect with:<ip_address> result:-3...
REPORTER  |~ResContext |~ResContext       |000000|INFO   | Free context 03154998
REPORTER  |amLog       |                  |000000|ERROR  | Connecting to DB - Failed

 

Environment

Client Automation - All Versions

Cause

Reporter needs the file sqlncli11.dll or sqlncli10.dll

SQL Server Native Client is missing

Resolution

1- Download the file x64 file sqlncli.msi from here :

Download Microsoft® SQL Server® 2012 Native Client – QFE from Official Microsoft Download Center

 

2- Execute sqlncli.msi on remote reporter machine and install "Client Components"

Microsoft SQL Server 2012 Native Client is installed.

 

And Reporter could be opened.