Resolution

In SSMS, default database of user's login must be changed.

Connect to SSMS using the servername, servername will be found in site report
Expand the Security Folder
Expand the Logins Folder
Find the username from the list of all logins
Right Click on the username and click on Properties
Click General Tab on the left
Under default database drop down menu, select MUNIS production database from the list
Click OK

Reconfigure the ODBC connection using the same server name and now the train/test/live/prod databases should be available.

Browser not supported