We are trying to carry out a clean install of IMC 7.3 onto a WS 2016 VM (Hyper-V) and connect it to a remote SQL 2016 database on our SQL farm. There doesnt seem to be a document indicating how to carry out this version of install just one for SQL Server 2014.
We have followed the guide for installing using a SQL Server 2014 server but there are some differences which may be the issue. On running the osql –S 192.168.20.110 –U sa –P iMC123456 command with the relevant server, user and password for the database it seems to connect ok as we get the SQL command prompt but when we run the envcheck.bat tool it tells us that "a database or database client was not detected".
I have installed SQL Management Studio and Client Tools Connectivity and Integration Services, Client Tools Backwards Compatibility and Client Tools SDK from the 2016 install media. We have checked that the specified port used for the database is the same as what has been manually selected on the SQL server.
Does anyone have access do a SQL 2016 remote install document or any advice on how to get the database and IMC install to communicate correctly?