+ Post New Thread
Results 1 to 8 of 8
MIS Systems Thread, New server, new install tips in Technical; Just got a new server to install sims on, any tips ? I'm not doing virtualisation as I don't have ...
  1. #1

    Join Date
    May 2010
    Posts
    1,071
    Thank Post
    106
    Thanked 94 Times in 70 Posts
    Rep Power
    50

    New server, new install tips

    Just got a new server to install sims on, any tips ? I'm not doing virtualisation as I don't have the knowledge or time - so this will be a standalone server.
    I'm thinking Raid 10 , but not sure what OS or sql version

  2. #2
    maark's Avatar
    Join Date
    Feb 2006
    Location
    leicester
    Posts
    475
    Thank Post
    90
    Thanked 76 Times in 67 Posts
    Rep Power
    39
    We are having a new server configured today with the help of LEA.
    Mine is virtual with hyper V.
    We have Server 2012 running SQL 2008 R2.

  3. Thanks to maark from:

    caffrey (3rd January 2014)

  4. #3
    Ghostgame's Avatar
    Join Date
    Jun 2012
    Location
    Ipswich
    Posts
    287
    Thank Post
    32
    Thanked 67 Times in 39 Posts
    Rep Power
    33
    If you don't mind the Windows 8 style interface for Windows Server 2012 go for that. (Just be aware Capita does not support Windows Server 2012R2 yet)
    However Windows Server 2008R2 is probably going to be cheaper.

    I would go for SQL 2008R2 as although SQL 2012 is supported it has a few niggles.
    Just be aware that Capita's drop date for SQL 2008R2 is Autumn 2014 release.

    If only a small amount of users are going to be on SIMS, take a look at Express edition of SQl.
    Its free but limits you to a database size of 10GB's, 1GB of RAM and 1 CPU.

    If you are going to have a large amount you might want to have a look at Standard.
    You have to pay a license fee and you are limited to 4 CPU's.

    I would recommend at single disk or small array on RAID 1 for the operating system.
    For the databases, an array of at least 3 disks on RAID 5 for the databases. If a disk fails you will have reduced performance but no data loss.

    Hopefully this is helpful and not too rambling

  5. 3 Thanks to Ghostgame:

    Alis_Klar (8th January 2014), caffrey (3rd January 2014), vikpaw (3rd January 2014)

  6. #4

    Join Date
    May 2010
    Posts
    1,071
    Thank Post
    106
    Thanked 94 Times in 70 Posts
    Rep Power
    50
    Cheers for the info,
    Shame about 2012R2, when they say not supported what does that mean ? I'd rather have the latest of everything on to save updating later. Also what niggles for sql 2012 ?

  7. #5
    Ghostgame's Avatar
    Join Date
    Jun 2012
    Location
    Ipswich
    Posts
    287
    Thank Post
    32
    Thanked 67 Times in 39 Posts
    Rep Power
    33
    Means if you get an issue with your SIMS databases or system on the server, Capita might not give you any help.
    Usually by extension your LA won't either.

    My niggles with SQL 2012 have been:
    - there has not been an installable release yet for SQL2012 (ETA is January but based on the Summer 2 release). Means some parts can't be installed via SIMSInst and have to be done manually.
    - has broke B2B on every server I have switched the school over too. Got round it by creating the tasks manually but have nearly fixed the issue with Capita's help so they can be created manually again. (Been distracted by the SIMS update)

  8. #6

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,439
    Thank Post
    368
    Thanked 649 Times in 530 Posts
    Rep Power
    160
    Just be aware, Windows Server "unsupported" would mean restoring the database onto a supported OS then replicating the issue before Capita would deal with any problems you log. "Unsupported" SQL Server is... well lets just say you can't restore a backup from a higher version of SQL Server to a lower version of SQL Server. It's possible, it just involves a world of pain.

    I'd be tempted to run on a newer OS - especially after Windows Server 2008 was so problematic compared to R2 version. SQL Server is a no-no.

  9. #7
    Alis_Klar's Avatar
    Join Date
    Oct 2007
    Location
    East Birmingham
    Posts
    293
    Thank Post
    148
    Thanked 22 Times in 12 Posts
    Rep Power
    18
    @Ghostgame
    - there has not been an installable release yet for SQL2012 (ETA is January but based on the Summer 2 release). Means some parts can't be installed via SIMSInst and have to be done manually.
    Will the effect every future SIMS upgrade untill they fix the issues?

    I am also deploying a new server. I am still running Server 2003 R2 with SQL 2008. We have had SIMS for less than 2 years and LA did not mention that 2003 was unsupported. I am not going to panic and try to get the server up and running before the Census this month but will need to get a move on anyway.

    We have new hardware waiting to use as our Virtual SIMS server.

    I really don't want to have the pain of migrating OS again sooner than I need to hence I want to do the following:

    -Install Windows Server 2012 R2 OS instance
    -Install SQL 2008 R2 (buy 2012 license for later upgrade) Is this possible?

    The 2003 R2 Server is also a DC for our MIS domain

  10. #8
    Ghostgame's Avatar
    Join Date
    Jun 2012
    Location
    Ipswich
    Posts
    287
    Thank Post
    32
    Thanked 67 Times in 39 Posts
    Rep Power
    33
    It doesn't affect upgrades done by SOLUS2 or 3 (from what I have come across).

    SIMSInst.exe basically strings all the .exes in the setups folder (SIMSApplicationSetup.exe, SIMSDatabaseConfigurationSetup.exe, etc) together depending on what tick boxes you select in the 'Install Options' at the start of the wizard.

    If you select 'This computer will be used as a SIMS SQL Server', SIMSInst.exe can install the SQL instance, attach/create SIMS/FMS databases and then put in the SQL application files that SIMS needs. At the moment SIMSInst.exe is not configured/designed/written to do this for SQL2012 and does not even pick up that there might be an existing SQL2012 instance to put in the SQL application files that SIMS needs.

    Thats why you end up having to manually install the SQL instance, attach database, etc

    I would not install Windows Server 2012R2 OS. matt40k has already said why this is a bad idea.
    Windows Server "unsupported" would mean restoring the database onto a supported OS then replicating the issue before Capita would deal with any problems you log.
    If Capita won't support you, usually means your LA won't support you either.

    Install SQL 2008 R2 (buy 2012 license for later upgrade) Is this possible?
    Totally possible. Capita have developed a tool which would also help with migrating the databases over from SQL2008R2 to SQL2012 when you make the switch.

    I find it a bit remiss of your LA not to have mentioned that MS 2003R2 OS was no longer supported. We have been screaming at schools as soon as we found out.

SHARE:
+ Post New Thread

Similar Threads

  1. [ACS] Fresh Install Onto New Server - tips/gotchas/guides
    By sonofsanta in forum MIS Systems
    Replies: 14
    Last Post: 16th July 2013, 04:30 PM
  2. Migrating exchange 2007 to new server install
    By pettit87 in forum Windows Server 2008 R2
    Replies: 3
    Last Post: 23rd July 2010, 07:15 PM
  3. New servers, new scripts :(
    By Potato-Peeler in forum Windows
    Replies: 10
    Last Post: 28th July 2009, 05:47 PM
  4. New server and installation
    By Little-Miss in forum Hardware
    Replies: 5
    Last Post: 24th April 2009, 10:47 AM
  5. New Server: Install LNM?
    By woody in forum Learning Network Manager
    Replies: 3
    Last Post: 1st February 2007, 11:29 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
  •