Prerequisites for Domain Manager 14.6 with remote SQL Server database.

Products

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

Issue/Introduction

Installation prerequisite for Client Automation 14.6, when the Domain Manager is pointed to a remote SQL Server database has a change, compared from previous versions, which can be seen here:

Install Considerations - CA Client Automation 14.6

These new prerequisites are:

• Microsoft command line SQLCMD 15(ODBC) for SQL server.
• Microsoft OLE DB Driver version 19.x for SQL Server.

Where can I get these?

Environment

Client Automation 14.6

Resolution

1.- SQLCMD can be obtained from here:

https://learn.microsoft.com/en-us/sql/tools/sqlcmd/sqlcmd-download-install?view=sql-server-ver17&tabs=windows

Browse down to “Download and Install sqlcmd (ODBC)”.

2.- OLE DB Driver can be downloaded along with SSMS, which can be found here:

https://learn.microsoft.com/en-us/ssms/release-history

Browse down to “Fixed version installers” and download version 19.3