+ Post New Thread
Results 1 to 6 of 6
MIS Systems Thread, New CMIS Database on same server? in Technical; Hi, We currently have CMIS and ePortal installed on our Admin Server to serve our Primary School side. Would it ...
  1. #1
    RTi
    RTi is offline

    Join Date
    Feb 2008
    Location
    Birmingham
    Posts
    153
    Thank Post
    23
    Thanked 15 Times in 10 Posts
    Rep Power
    16

    New CMIS Database on same server?

    Hi,

    We currently have CMIS and ePortal installed on our Admin Server to serve our Primary School side. Would it be possible to have another instance of CMIS and ePortal installed on same server to be used by our Children's Centre? (we cant just add the CC Pupils onto the school system..due to census and other reasons.)

    if anyone has any advice.. i'd greatly appreciate it..

  2. #2

    Michael's Avatar
    Join Date
    Dec 2005
    Location
    Birmingham
    Posts
    9,266
    Thank Post
    242
    Thanked 1,575 Times in 1,254 Posts
    Rep Power
    341
    I see no reason why you couldn't have another instance of SQL, this shouldn't be a problem, but I'm not sure about CMIS or E-Portal. As E-Portal uses IIS, you may need to use a different port for example.

    Have you asked Link2ICT about it?

  3. #3

    john's Avatar
    Join Date
    Sep 2005
    Location
    London
    Posts
    10,403
    Thank Post
    1,517
    Thanked 1,056 Times in 925 Posts
    Rep Power
    303
    Quote Originally Posted by RTi View Post
    Hi,

    We currently have CMIS and ePortal installed on our Admin Server to serve our Primary School side. Would it be possible to have another instance of CMIS and ePortal installed on same server to be used by our Children's Centre? (we cant just add the CC Pupils onto the school system..due to census and other reasons.)

    if anyone has any advice.. i'd greatly appreciate it..
    You want what I have. I have 2x SQL Databases, and when I open Facility I get two in the recent list and choose from the DB I want and it works great. However, ePortal can only be in one system so you would need to install ePortal on a second box for the children's centre on another box or VM and point it back to that DB. Not too much hassle realy.

    However how does the licensing apply for what you are doing in Birmingham as I assume you are licenses via the LA and would they be happy for you to do that?

  4. #4
    RTi
    RTi is offline

    Join Date
    Feb 2008
    Location
    Birmingham
    Posts
    153
    Thank Post
    23
    Thanked 15 Times in 10 Posts
    Rep Power
    16
    Thanks for the replies..

    I have contacted our LA regarding licenses and installation costs.. thought I'd post on here to see if it was possible ?

    does the extra database put a greater load on server resources? we do have a spare VM but would need a SQL server licence.. also been looking at open source options..as it's mainly for electronic registration and attendance reports..

  5. #5

    Join Date
    Jun 2007
    Location
    Wakefield, West Yorkshire
    Posts
    632
    Thank Post
    98
    Thanked 134 Times in 104 Posts
    Rep Power
    67
    Hi,

    You can add another SQL database on a different instance of SQL, or in the same instance.
    ePortal, you can run multiple installs on the same machines but this is usually done for large scale implementations only and there is a lot of manual installations, scripting and training needed. it isn't a viable option really for just having 2 database on one box.
    If you have processor licenses for SQL on that server, add the second database to that box. That will get around needing extra SQL licensing. If you have CALs you'll need to consider that.

    ePortal / Facility licensing you'll need to sort out through the LA as you are doing. ePortal can go on that spare VM. Facility (primary version) can be installed wherever you like it won't make a difference.

    If they're just using it for attendance, the overhead on the SQL server will be negligable but the overhead to ePortal will always be considerable, so that's another reason to put it on its own VM.

    Mic @ Serco


    All posts are my own personal opinion and not necessarily those of my employers or others who I work with or represent

  6. #6
    RTi
    RTi is offline

    Join Date
    Feb 2008
    Location
    Birmingham
    Posts
    153
    Thank Post
    23
    Thanked 15 Times in 10 Posts
    Rep Power
    16
    Thanks for that detailed post.. I can raise those options with the LA when they get back to me..

SHARE:
+ Post New Thread

Similar Threads

  1. Facility CMIS/ePortal and DC on same server?
    By Trapper in forum Windows Server 2000/2003
    Replies: 5
    Last Post: 24th January 2011, 05:27 PM
  2. No access to any database on SQL server
    By button_ripple in forum MIS Systems
    Replies: 2
    Last Post: 1st May 2009, 08:17 AM
  3. Joomla and Moodle on same server
    By bensewell in forum Web Development
    Replies: 2
    Last Post: 14th June 2007, 02:16 PM
  4. Replies: 6
    Last Post: 12th June 2007, 06:43 PM
  5. Multiple SQL Apps on same server with WSUS installed
    By ITWombat in forum Educational Software
    Replies: 3
    Last Post: 8th May 2006, 07:14 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
  •