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 ...
26th April 2011, 05:37 PM #1
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?
IDG Tech News
26th April 2011, 06:17 PM #2
27th April 2011, 06:22 AM #3
@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.
27th April 2011, 09:14 AM #4
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.
Thanks to Theblacksheep from:
28th April 2011, 09:38 AM #5
I know of a guy running 90+ off one box! It can surely
28th April 2011, 09:47 AM #6
That's just showing off! lol
Originally Posted by vikpaw
Do some LEA's centrally host sims and fms?
28th April 2011, 09:55 AM #7
29th April 2011, 07:20 PM #8
Who? Me or him? It was an LA bod, by the way.
Originally Posted by steveg
30th April 2011, 09:40 AM #9
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.
30th April 2011, 10:43 AM #10
It does work and somewhere in another thread NorthernSands has posted a modified connect.ini to allow choice of which sims to connect to.
2nd May 2011, 08:10 AM #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 08:16 AM.
Reason: Link to connect.ini post
By Disease in forum MIS Systems
Last Post: 13th July 2010, 12:19 PM
By sacrej in forum MIS Systems
Last Post: 5th March 2010, 11:13 AM
By ful56_uk in forum MIS Systems
Last Post: 9th April 2009, 12:32 PM
By localzuk in forum MIS Systems
Last Post: 20th November 2008, 05:13 PM
By matt40k in forum MIS Systems
Last Post: 22nd August 2008, 08:58 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)