Why do I get a missing 'OSQL.EXE' error message when trying to install a Client Automation remote engine even if I have the SQL Server Client tools already installed?

Document ID : KB000016061
Last Modified Date : 14/02/2018
Show Technical Document Details
Introduction:

When i try install a CA Client Automation remote engine server connected to a SQL Server 2012 mdb, I always receive the error: 

       RemoteEngineError.jpg

Question:

Why do I get a missing 'OSQL.EXE' error message when trying to install a Client Automation remote engine even if I have the SQL Server Client Tools already installed?

Environment:
Client Automation 12.9 and above.
Answer:

Recent versions of SQL Server do not provide OSQL.EXE in their set of files when the Client Tools are installed.

The OSQL.EXE file is installed on the full SQL Server installation, the one holding the Database Management System itself.

So, there is already a computer with OSQL installed: the SQL Server computer hosting the mdb the domain manager connects to.

 

In order to workaround the situations the following steps should be executed:

From the computer holding the full SQL Server installation you might be able to copy just the following two files to the remote engine server (place them in the same directory) and have it work: 

    C:\Program Files\Microsoft SQL Server\110\Tools\Binn\OSQL.EXE 

    C:\Program Files\Microsoft SQL Server\110\Tools\Binn\Resources\1033\osql.rll 

This should solve the problem and the remote engine setup procedure should normally continue.

Additional Information:

This TechDoc is based on the following page:

Can I get OSQL if I install SQL Server Client Tools?