Cannot Connect to Multiple databases on a single connect.ini only logs on to a single database
To resolve this issue you have to remove the info from the SIMSOffline section of the connect.ini on the affected workstations.
Once this is done; login to SIMS, select either of the databases on the drop down option and login – it then logs onto the database that was selected and the connect.ini is updated with the SIMSconnection, the database0 and the SIMSoffline sections set to that database.
When you log out of SIMS, then select a different database from the drop down and log in, the connect.ini is then updated once more and those sections are changed to reflect the database selected.
The SIMSOffline section needs to be empty in order to trigger the update every time a change of database is selected via the drop down.
Example of a SIMS connect INI with multiple Databases:
[SIMSConnection]
ServerName=SERVERNAME\SQLINSTANCE
DatabaseName=SIMS1
DatabaseMode=OnLine
[SIMSDatabases]
FriendlyName0= SIMS Database 1
Server0=SERVERNAME\SQLINSTANCE
DatabaseName0=SIMS1
DatabaseMode0=Online
FriendlyName1=SIMS Database 2
Server1=SERVERNAME\SQLINSTANCE
DatabaseName1=SIMS2
DatabaseMode1=Online
[SIMSOffline]
PreviousRedirect=
PreviousServerName=SERVERNAME\SQLINSTANCE
PreviousDatabaseName=SIMS1
PreviousDatabaseMode=OnLine