+ Post New Thread
Results 1 to 10 of 10
MIS Systems Thread, Sims - New Trust in Technical; Hi all, We are currently in our final stages of creating a trust to which we will be supporting several ...
  1. #1

    Join Date
    Dec 2012
    Posts
    44
    Thank Post
    0
    Thanked 3 Times in 3 Posts
    Rep Power
    4

    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

  2. #2
    eddyc's Avatar
    Join Date
    Aug 2008
    Location
    Bristol
    Posts
    438
    Thank Post
    99
    Thanked 47 Times in 43 Posts
    Rep Power
    22
    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

  3. Thanks to eddyc from:

    vikpaw (13th February 2013)

  4. #3

    Join Date
    Dec 2012
    Posts
    44
    Thank Post
    0
    Thanked 3 Times in 3 Posts
    Rep Power
    4
    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

  5. #4

    GREED's Avatar
    Join Date
    Mar 2008
    Location
    Portsmouth
    Posts
    3,072
    Thank Post
    377
    Thanked 380 Times in 309 Posts
    Blog Entries
    8
    Rep Power
    178
    Cough cough Aspen...

    :-)

  6. #5

    Join Date
    Dec 2012
    Posts
    44
    Thank Post
    0
    Thanked 3 Times in 3 Posts
    Rep Power
    4
    Quote Originally Posted by GREED View Post
    Cough cough Aspen...

    :-)
    Exactly, I suddenly feel ill ! Ha ha

  7. #6

    GREED's Avatar
    Join Date
    Mar 2008
    Location
    Portsmouth
    Posts
    3,072
    Thank Post
    377
    Thanked 380 Times in 309 Posts
    Blog Entries
    8
    Rep Power
    178
    Mwahahaha!! Good comeback!

    I see you are pro SIMS then?

  8. #7

    GREED's Avatar
    Join Date
    Mar 2008
    Location
    Portsmouth
    Posts
    3,072
    Thank Post
    377
    Thanked 380 Times in 309 Posts
    Blog Entries
    8
    Rep Power
    178
    Actually scratch that, not for this thread...

  9. #8
    jamesfed's Avatar
    Join Date
    Sep 2009
    Location
    Reading
    Posts
    2,207
    Thank Post
    137
    Thanked 345 Times in 291 Posts
    Rep Power
    87
    Quote Originally Posted by GREED View Post
    Actually scratch that, not for this thread...
    Could've started a deadly plague there

    Well adverted!

  10. #9

    Join Date
    Dec 2012
    Posts
    44
    Thank Post
    0
    Thanked 3 Times in 3 Posts
    Rep Power
    4
    Quote Originally Posted by eddyc View Post
    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 ?

  11. #10
    eddyc's Avatar
    Join Date
    Aug 2008
    Location
    Bristol
    Posts
    438
    Thank Post
    99
    Thanked 47 Times in 43 Posts
    Rep Power
    22
    No I've never seen that before! What if you remove the bits to the right of each line?

SHARE:
+ Post New Thread

Similar Threads

  1. [SIMS] sims and trusted logins
    By kevin_lane in forum MIS Systems
    Replies: 2
    Last Post: 19th January 2012, 07:58 PM
  2. [SIMS] SIMS - new user
    By timbo343 in forum MIS Systems
    Replies: 7
    Last Post: 29th March 2011, 02:29 PM
  3. SIMS, new server, small school, ESXi?
    By contink in forum MIS Systems
    Replies: 11
    Last Post: 13th March 2010, 11:33 AM
  4. Sims new installation
    By kcymer in forum MIS Systems
    Replies: 4
    Last Post: 2nd June 2009, 01:48 PM
  5. Fresh Install of SIMS (new DB)
    By binky in forum MIS Systems
    Replies: 10
    Last Post: 19th February 2008, 11:09 AM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •