[sims] Sims - New Trust

[mattysmith80]

Hi all,

 

We are currently in our final stages of creating a trust to which we will be supporting several schools. We have a long term ambition to have one domain and network across all sites but more inimantly we need to establish a working solution for sims. We currently have sims set up at each site independently but I would like to be able to have sims ask me upon load up which sims database would I like to log onto. Meaning we could dive in and out of any sims systems at our trust sites. We have VPNs set up and present and basically change the connect.ini to a different server ip that we want to connect to...

 

So in a nutshell is anyone else doing the trust thing ? If so I'd love to hear your experience

 

Matty

[eddyc]

We have two schools linked together on a wan - some staff work in both schools and the post 16 centre has its own database.

The login prompt asks you to pick which database underneath the username and password fields.

Our connect.ini has the following in it;

 

[sIMSConnection]
ServerName=servername\simssql2008
DatabaseName=localdatabasename
ServerType=SIMSSQL
DatabaseMode=OnLine
CommandTimeout=100000

[sIMSDatabases]
FriendlyName0=School Number One
Server0=servername1\simssql2008
databasename0=database1
DatabaseMode0=Online
CommandTimeout=100000

FriendlyName1=School number two
Server1=123.123.123.123\SIMSSQL2008
databasename1=database2
DatabaseMode1=Online
CommandTimeout=100000

 

The [sIMSConnection] at the top is the default option on the drop down - so you may want to default the correct database in each school to be that schools own database

[mattysmith80]

Thanks for the update ill give that a go, and see how it works across our WAN... Long term we will have 17 sites so will probably need to look at one big solution

 

Thanks

Matty

[GREED]

Cough cough Aspen...

 

:-)

[mattysmith80]

Cough cough Aspen...

 

:-)

 

Exactly, I suddenly feel ill ! Ha ha

[GREED]

Mwahahaha!! Good comeback!

 

I see you are pro SIMS then?

[GREED]

Actually scratch that, not for this thread...

[jamesfed]

Actually scratch that, not for this thread...

 

Could've started a deadly plague there

 

Well adverted!

[mattysmith80]

We have two schools linked together on a wan - some staff work in both schools and the post 16 centre has its own database.

The login prompt asks you to pick which database underneath the username and password fields.

Our connect.ini has the following in it;

 

[sIMSConnection]
ServerName=servername\simssql2008
DatabaseName=localdatabasename
ServerType=SIMSSQL
DatabaseMode=OnLine
CommandTimeout=100000

[sIMSDatabases]
FriendlyName0=School Number One
Server0=servername1\simssql2008
databasename0=database1
DatabaseMode0=Online
CommandTimeout=100000

FriendlyName1=School number two
Server1=123.123.123.123\SIMSSQL2008
databasename1=database2
DatabaseMode1=Online
CommandTimeout=100000

 

The [sIMSConnection] at the top is the default option on the drop down - so you may want to default the correct database in each school to be that schools own database

 

Thanks for this I have just tested it, it works really well. However, when I select a school to log on to from the list and log in and then log out and back in the list disapears and when you check the connect.ini file it has saved the other database I logged onto over the top connection. and also creates an extra field like this at the bottom

 

[sIMSOffline]

PreviousRedirect=

PreviousServerName=192.168.5.245\sims2008

PreviousDatabaseName=sims

PreviousDatabaseMode=OnLine

 

Any suggestions ?

[eddyc]

No I've never seen that before! What if you remove the bits to the right of each line?