+ Post New Thread
Results 1 to 11 of 11
MIS Systems Thread, 2 fms databases on 1 server in Technical; I have a project coming up with effectively 2 schools in one building, does anyone know if it is possible ...
  1. #1

    Join Date
    Feb 2007
    Location
    East Sussex
    Posts
    470
    Thank Post
    16
    Thanked 88 Times in 80 Posts
    Rep Power
    30

    2 fms databases on 1 server

    I have a project coming up with effectively 2 schools in one building, does anyone know if it is possible to install 2 fms (and sims) databases on 1 server, and if this is supported?

    I assume I'll just install 2 different named instances of SQL server, but not sure if this is supported by Capita? Has anyone done this before?

    Thanks

    Steve

  2. #2

    Join Date
    Sep 2006
    Location
    London
    Posts
    1,357
    Thank Post
    36
    Thanked 362 Times in 247 Posts
    Rep Power
    81
    Yes its supported.

  3. Thanks to PhilNeal from:

    steveg (27th April 2011)

  4. #3
    NorthernSands's Avatar
    Join Date
    Mar 2011
    Location
    Qatar
    Posts
    134
    Thank Post
    21
    Thanked 19 Times in 19 Posts
    Rep Power
    11
    @steveg: It looks like I might be running two SIMS DBs on one server (two instances, but no FMS). The only question mark I have at the moment is SOLUS3. I've not looked into it fully yet, though.

  5. #4

    Theblacksheep's Avatar
    Join Date
    Feb 2008
    Location
    In a house.
    Posts
    1,946
    Thank Post
    139
    Thanked 291 Times in 211 Posts
    Rep Power
    193
    We've got 2 databases, academyFMS and oldschoolFMS.

    Database select tool doesn't always work, but you can setup 2 shortcuts, 1 to each database.

  6. Thanks to Theblacksheep from:

    steveg (27th April 2011)

  7. #5

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,785
    Thank Post
    715
    Thanked 1,440 Times in 1,193 Posts
    Rep Power
    359
    I know of a guy running 90+ off one box! It can surely
    Be done.

  8. #6

    Join Date
    Feb 2007
    Location
    East Sussex
    Posts
    470
    Thank Post
    16
    Thanked 88 Times in 80 Posts
    Rep Power
    30
    Quote Originally Posted by vikpaw View Post
    I know of a guy running 90+ off one box! It can surely
    Be done.
    That's just showing off! lol

    Do some LEA's centrally host sims and fms?

  9. #7

    Join Date
    Sep 2006
    Location
    London
    Posts
    1,357
    Thank Post
    36
    Thanked 362 Times in 247 Posts
    Rep Power
    81
    They do.

  10. #8

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,785
    Thank Post
    715
    Thanked 1,440 Times in 1,193 Posts
    Rep Power
    359
    Quote Originally Posted by steveg View Post
    That's just showing off! lol

    Do some LEA's centrally host sims and fms?
    Who? Me or him? It was an LA bod, by the way.

  11. #9
    jamesfed's Avatar
    Join Date
    Sep 2009
    Location
    Reading
    Posts
    2,212
    Thank Post
    138
    Thanked 346 Times in 292 Posts
    Rep Power
    90
    Our LEA hosts SIMS (and every other school in the county) for us so I can only imagine they host multiple databases on the same server.

  12. #10

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,785
    Thank Post
    715
    Thanked 1,440 Times in 1,193 Posts
    Rep Power
    359
    It does work and somewhere in another thread NorthernSands has posted a modified connect.ini to allow choice of which sims to connect to.

  13. #11
    NorthernSands's Avatar
    Join Date
    Mar 2011
    Location
    Qatar
    Posts
    134
    Thank Post
    21
    Thanked 19 Times in 19 Posts
    Rep Power
    11
    The Connect.ini I posted is for the SIMS DB. For FMS, @Theblacksheep is correct; the best way I've found with FMS is to use FDS and setup two or more shortcuts as required.

    EDIT: Here's a link to the post with the connect.ini:

    Running an addional sims.net database for testing.
    Last edited by NorthernSands; 2nd May 2011 at 07:16 AM. Reason: Link to connect.ini post

SHARE:
+ Post New Thread

Similar Threads

  1. Which server to install SIMS+FMS on!
    By Disease in forum MIS Systems
    Replies: 12
    Last Post: 13th July 2010, 11:19 AM
  2. installing FMS on 2008R2 Terminal Server
    By sacrej in forum MIS Systems
    Replies: 19
    Last Post: 5th March 2010, 10:13 AM
  3. Movng FMS over to a new server
    By ful56_uk in forum MIS Systems
    Replies: 20
    Last Post: 9th April 2009, 11:32 AM
  4. Terminal Server, SIMS.net and FMS
    By localzuk in forum MIS Systems
    Replies: 6
    Last Post: 20th November 2008, 04:13 PM
  5. Moving SIMS\FMS to a new server
    By matt40k in forum MIS Systems
    Replies: 2
    Last Post: 22nd August 2008, 07:58 PM

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
  •