Sims - New Trust

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

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;

Code:

---

[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 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

Cough cough Aspen...

:-)

Quote:

---

Originally Posted by GREED

Cough cough Aspen...

:-)

---

Exactly, I suddenly feel ill ! Ha ha

Mwahahaha!! Good comeback!

I see you are pro SIMS then?

Actually scratch that, not for this thread...

Quote:

---

Originally Posted by GREED

Actually scratch that, not for this thread...

---

Could've started a deadly plague there ;)

Well adverted!

Quote:

---

Originally Posted by 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;

Code:

---

[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 ?

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