After replacing a development installation of Ignition 8.1 with 7.9.17, I am suddenly unable to communicate with my local SQL server. The connection was fine before the reinstall but now it’s faulted and showing this error:
Cannot create PoolableConnectionFactory (The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. Error: “No appropriate protocol (protocol is disabled or cipher suites are inappropriate)”.)
I’ve double checked all the usual SQL server settings (SQL server authentication enabled, TCP/IP enabled, SQL server browser running etc.) and everything seems to be fine, which isn’t surprising seeing as the version 8 gateway wasn’t having any issues communicating with it. I’m also able to connect to the server using the same login credentials that Ignition is configured to use, both locally and from another PC on the same network.
The only change I can think of between the two installations is that I’ve added a couple of extra user accounts to the PC Ignition and SQL are installed on, there was only one when I installed the original Ignition 8 gateway. The same user account was used to install both Ignition and SQL though so I’m not sure why simply having multiple users would cause issues.
Any suggestions would be appreciated.