[SOLVED] - Cannot upgrade V3 to V4 - System.Data.SqlClient.SqlException
You attempt to upgrade an Easify V3 installation to version 4 and the upgrade fails.
The EasifyV4Setup.log file in your %temp% folder contains the following error:
ERROR installing Easify Server: Exception type System.Data.SqlClient.SqlException
Exception message: Connection Timeout Expired. The timeout period elapsed while attempting to consume the pre-login handshake acknowledgement.
This can be caused if the TCPIP settings on the SQL Server are incorrect.
- Start SQL Server Configuration Manager
- Open the node SQL Server Network Configuration
- Left-click Protocols for MYSQLINSTANCE
- In the right-hand pane, right-click TCP/IP
- Click Properties
- Select the IP Addresses tab
- For each listed IP address, ensure Active and Enabled are both Yes.
Restart the SQL Server (EASIFY) Service, or reboot your computer to apply the new settings.
Regards - Richard (Easify Developer)