[sims] Connect.ini issue with multiple databases

[localzuk]

For some strange reason, I appear to now have an issue with my connect.ini file since moving the server from one virtual server to another, and I'm at a loss as to what the issue is.

 

I have the following

 

[sIMSConnection]
ServerName=svr5\SIMS2012
DatabaseName=SIMS
CommandTimeout=10000000
DatabaseMode=OnLine

[sIMSDatabases]
FriendlyName0=School 1
Server0=svr0\SIMS2012
DatabaseName0=SIMS
DatabaseMode0=OnLine

FriendlyName1=School 2
Server1=svr1\SIMS2012
DatabaseName1=SIMS
DatabaseMode1=OnLine

FriendlyName2=School 3
Server2=svr2\SIMS2012
DatabaseName2=SIMS
DatabaseMode2=OnLine

FriendlyName3=School 4
Server3=svr3\SIMS2012
DatabaseName3=SIMS
DatabaseMode3=OnLine

FriendlyName4=School 5
Server4=svr4\SIMS2012
DatabaseName4=SIMS
DatabaseMode4=OnLine

FriendlyName5=School 6
Server5=svr5\SIMS2012
DatabaseName5=SIMS
DatabaseMode5=OnLine

 

Only the School 6 one works. (That's a copy paste, but with the actual school names and server names switched out).

 

However, if I put the following:

 

[sIMSConnection]
ServerName=svr1\SIMS2012
DatabaseName=SIMS
ServerType=SIMSSQL

 

it works fine. So it isn't a connectivity issue.

 

What am I doing wrong? This was all working before!!

Edited April 3, 2018 by localzuk

[Arthur]

Do you have any INI files in the following folder?

 

%LocalAppData%\VirtualStore\Program Files(x86)\SIMS

[localzuk]

Nope, that path doesn't exist.

[MrMat]

Try permissions. Make sure you have read/write on the connect.ini.

 

User needs to have write/modify permissions on the connect.ini for the multiple databases to work (as it actually re-writes the top part of the connect file when you use the drop down).

[localzuk]

Try permissions. Make sure you have read/write on the connect.ini.

User needs to have write/modify permissions on the connect.ini for the multiple databases to work (as it actually re-writes the top part of the connect file when you use the drop down).

Woo! Thanks! That did it.