Recently had a tedious experience trying to connect our existing UIM 20.3.3 installation to the same SQL server DB, but with the DB now hosted on Win2019 (previously on Win2012R2 cluster) NOT attempting to move to TLS 1.2 at this time (more fun with that later).
In summary: UIM worked to SQL 2014 hosted on Win2012R2 no problems, non-encrypted DB connection: copied DB to SQL server 2017 hosted on Win2019 - which *does* have SCHANNEL configured for TLS 1.2 only - and data_engine couldn't connect. Packet capture showed the beginnings of an encryption exchange (TDS7 from UIM, response from SQL server, end of TDS7 from UIM and SQL side sends FIN) between SQL server and UIM and then the TCP connection was torn down. Neither SQL server is configured for TLS 1.2 - but it may be that Win2019 overrides this? Have another client connection to the same, newly built SQL server (also not using TLS 1.2), but this time hosted on Win2019 and this application works fine (obv different DB on SQL server).
Q: has anyone else seen this combination cause problems, please?
The other major SQL client app couldn't support TLS 1.2 until recently, which is why UIM wasn't moved to TLS 1.2 for the DB connection.
Thanks.