Client Tools unable to connect to Remote MS SQL database.

Products

• CA Identity Manager
• CA Identity Governance
• CA Identity Portal
• CA Identity Suite

Issue/Introduction

After upgrading Governance from 14.1 to version 14.3 we are having issues launching Client Tools and getting it to connect to SQL Server.   

Cause

Issue was due to the MS SQL database being remote and not having the MS SQL Client tools installed.   This could also occur in a new installation using a remote MS SQL database if the Microsoft SQL Native Client 2012 are not installed.

Environment

Release : 14.3

Component : GovernanceMinder(Role & Compliance Manager)

Resolution

Install the Microsoft SQL Client server tools as documented in the system requirements:
https://techdocs.broadcom.com/content/broadcom/techdocs/us/en/ca-enterprise-software/layer7-identity-and-access-management/identity-governance/14-3/installing/system-requirements.html

 

(Optional)  Microsoft SQL Native Client 2012 — Only required if you reference a remote SQL Server instance.

Additional Information

The same holds true for Oracle databases, if the Oracle database is remote the Oracle Client will need to be installed locally to Governance.