Upgrading to Commander 9.0 using SQL named instances or non-standard ports
Commander 9.0.0 has updated our database SQL driver. This driver has new configuration requirements which may result in issues during upgrades. Before this update, the legacy SQL driver accepted both the instance name and the port. The updated SQL driver uses either the instance name or the port to establish the connection but not both.
To confirm whether or not you are using a named instance or a non-standard port, launch the Snow Commander Control Panel on the Commander application server, and switch to the DB Management tab. You are using a named instance if the Instance Name field contains any content other than MSSQLSERVER (the default instance name). You are using a non-standard port if the Port field contains anything other than 1433.
For customers using the default SQL instance and port, no upgrade issues are expected.
Upgrading when using a SQL named instance
Upgrading when using a non-standard port
Upgrading when using a SQL named instance
The installer will automatically drop the port and use the instance name during the 9.0 upgrade. In order for this to be successful, the SQL Browser service must be running on the Commander database service. The SQL Browser service requires UDP port 1434 be opened between the Commander application server and the database server in order to discover the named instance, but the port can be closed after the upgrade completes successfully.Providing that the instance name (PRDCMDR in the image above) is valid, the installer will establish the connection using the instance name. The upgrade will proceed normally.
If the instance name is invalid, replace it with the correct instance name or leave blank for the default SQL instance and click OK. Restart the Commander Services on the Service Control tab, and then proceed with the upgrade.
Upgrading when using a non-standard port
If you are using a non-standard port, clear the instance name field and click OK. Restart the Commander Services on the Service Control tab, and then proceed with the upgrade.
