Install Domain Manager - no Microsoft SQL Client Tools installed

Products

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

Issue/Introduction

When installing a new Domain Manager with a remote database on Microsoft SQL Server 2022, following error appears :

"The database server name is set to a remote system, but there are no Microsoft SQL Client Tools installed. You must install Microsoft SQL Client Tools before you can install a manager using remote Microsoft Server MDB."

Environment

Client Automation 14.5.
Microsoft SQL Server 2022 installed on a remote machine
SQL Server Management Studio (SSMS) version 18 or higher installed on Domain Manager

Resolution

Latest versions of SSMS (18 and higher versions) do not include the tools like osql.exe and sqlcmd.exe needed for Domain Manager Client Automation installation
The solution if to install the version 17.9.1 which contains the needed tools (osql.exe and sqlcmd.exe).

See this link to download previous version : Previous SSMS releases

Uninstall SSMS version 18 or higher and install SSMS 17.9.1 on Domain Manager. This version is working fine with Microsoft SQL Server 2022