We are migrating the ILMT database to a new SQL server. We have edited the 'serverName' and 'portNumber' settings in the server.xml file but it appears to be ignoring the port - the error in the tema log is 'The TCP/IP connection to the host 'correct_host', port 1433 has failed. Changing the port in server.xml and defining the server name as 'server,port' in serverl.xml do seem to make any difference.

How can we get ILMT to use a different port for its database connection?

The answer is to edit the database.yml file and change the hostname here in the format of 'hostname\instance:port'. If only the KB articles made this clear.