ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.
Client Tools are failing to connect to SQL Database (Provider cannot be found. It may not be properly installed).
Article ID: 228243
CA Identity Suite
While using the Client Tools for Identity Governance to change and create/modify new Eurekify roles/permissions (as per the documentation - https://techdocs.broadcom.com/us/en/symantec-security-software/identity-security/identity-governance/14-4/configuring/permissions.html), an error is returned when trying to connect to the database:
Provider Cannot Be Found. It may not be properly installed.
3rd party libraries
Release : 14.4
Component : Identity Governance Client Tools connecting to MS SQL using the method "Static SQL Credentials".
This issue can be caused by the missing MS SQL client tools package or some associated dependencies\ libraries. Installing MS SQL Management Studio for testing appears to refresh\ redeploy the dependencies and worksaround the issue.