+ Post New Thread
Results 1 to 13 of 13
MIS Systems Thread, SIMS server installation in Technical; Hi Everyone. Firstly, apologies if this has already been covered! I have been trying to move SIMS from an old ...
  1. #1

    Join Date
    Jan 2010
    Location
    Slough
    Posts
    99
    Thank Post
    17
    Thanked 4 Times in 4 Posts
    Rep Power
    19

    SIMS server installation

    Hi Everyone.

    Firstly, apologies if this has already been covered!

    I have been trying to move SIMS from an old server to a new one. The main problem I have is that the new server is running Windows Server 2008 64 bit edition. My problem lies with the fact that I don't have the SQL Express 2005 64bit installer.

    I know I can donload it from Microsoft but that will only install a database instance with the default name and not the correct one for SIMS.

    Does anyone have the SIMS 64 bit SQL Express 2005 installer file?? If not, can anyone tell me how to either create a new instace or to change the name of the existing instance of a SQL Expresss 2005 installation?

    This is really urgent so if anyone can help me I really would appriciate it!!!

    Thanks!

  2. #2

    nephilim's Avatar
    Join Date
    Nov 2008
    Location
    Dunstable
    Posts
    11,096
    Thank Post
    1,428
    Thanked 1,692 Times in 1,265 Posts
    Blog Entries
    2
    Rep Power
    363
    My advice would be to get Capita on the phone! They'll be able to advise you better as they deal with this day in day out.

  3. #3

    creese's Avatar
    Join Date
    Feb 2009
    Location
    -28 31' 48.89", +28 25' 37.42" ... if only.
    Posts
    3,036
    Thank Post
    167
    Thanked 343 Times in 278 Posts
    Rep Power
    168
    I would take the time, a couple of hours, to migrate the existing to 2008 and deattch/attach the database to the new server. You are going to have to do it in the next few months anyway.
    Last edited by creese; 14th June 2010 at 12:32 PM.

  4. #4

    FN-GM's Avatar
    Join Date
    Jun 2007
    Location
    UK
    Posts
    15,387
    Thank Post
    797
    Thanked 1,585 Times in 1,388 Posts
    Blog Entries
    10
    Rep Power
    427
    You dont want to be using SQL 2005. after a certian date this year sims requires SQL 2008. You should use 2008 not 2005.

  5. #5

    Join Date
    Jan 2010
    Location
    Slough
    Posts
    99
    Thank Post
    17
    Thanked 4 Times in 4 Posts
    Rep Power
    19
    I don't have the sql migration wizard program to do the migration to 2008 though so I was just going to get it setup to start with for 2005 and then look at migrating it.

  6. #6
    Sarconia's Avatar
    Join Date
    Mar 2010
    Location
    London
    Posts
    315
    Thank Post
    15
    Thanked 34 Times in 31 Posts
    Rep Power
    15
    Have Capita ever provided a 64bit SQL Express 2005 installer? I'm actually not too sure... I've never seen this file. What is stopping you from installing the 32bit version, does it not work with Server 2008 64bit? Even if you did have the 64bit SQL Express installer, you'd need to install a 32bit instance as SIMS will not work on a 64bit instance. (The last time I tried it anyway).

    As for renaming an instance, once it's been installed with the given name there isn't any way to change it.

  7. #7

    localzuk's Avatar
    Join Date
    Dec 2006
    Location
    Minehead
    Posts
    17,089
    Thank Post
    511
    Thanked 2,308 Times in 1,784 Posts
    Blog Entries
    24
    Rep Power
    803
    What value would a 64bit install of SQL Express have anyway? You're still limited to 1GB memory usage, and 4GB database size anyway...

  8. #8

    Join Date
    Jan 2010
    Location
    Slough
    Posts
    99
    Thank Post
    17
    Thanked 4 Times in 4 Posts
    Rep Power
    19
    Hmm, why do Capita have to be awkward!
    The 32 bit installer doesn't work unfortunatly! Thanks for the suggestion though.

  9. #9

    localzuk's Avatar
    Join Date
    Dec 2006
    Location
    Minehead
    Posts
    17,089
    Thank Post
    511
    Thanked 2,308 Times in 1,784 Posts
    Blog Entries
    24
    Rep Power
    803
    Information here about installing SQL Express 2005 on Server 2008 R2 - Tim's trash of thoughts: SQL Server 2005 Express Edition on Windows 2008 x64

    But as creese and FN-GM say - you should really be migrating to SQL 2008 anyway, as this is a requirement from October IIRC.

  10. #10

    creese's Avatar
    Join Date
    Feb 2009
    Location
    -28 31' 48.89", +28 25' 37.42" ... if only.
    Posts
    3,036
    Thank Post
    167
    Thanked 343 Times in 278 Posts
    Rep Power
    168
    Quote Originally Posted by localzuk View Post
    Information here about installing SQL Express 2005 on Server 2008 R2 - Tim's trash of thoughts: SQL Server 2005 Express Edition on Windows 2008 x64

    But as creese and FN-GM say - you should really be migrating to SQL 2008 anyway, as this is a requirement from October IIRC.
    There are problems with SIMS on 2008 R2

  11. #11

    localzuk's Avatar
    Join Date
    Dec 2006
    Location
    Minehead
    Posts
    17,089
    Thank Post
    511
    Thanked 2,308 Times in 1,784 Posts
    Blog Entries
    24
    Rep Power
    803
    Quote Originally Posted by creese View Post
    There are problems with SIMS on 2008 R2
    Ah, I wrote R2 but meant 64bit (not R2).

  12. #12

    creese's Avatar
    Join Date
    Feb 2009
    Location
    -28 31' 48.89", +28 25' 37.42" ... if only.
    Posts
    3,036
    Thank Post
    167
    Thanked 343 Times in 278 Posts
    Rep Power
    168
    Those damn keys, never do what you think. ;-)

  13. #13

    Join Date
    Jan 2010
    Location
    Slough
    Posts
    99
    Thank Post
    17
    Thanked 4 Times in 4 Posts
    Rep Power
    19
    thanks for all your suggestions - I think I've sorted it. I found a slightly different version of the SQP express installer which does actually allow the user to specify a name for the instance that it creates. I've created a SIMS instance and it seems to have worked and therefore solved my problem!!

SHARE:
+ Post New Thread

Similar Threads

  1. SIMS security - sims installation policy
    By tech-man in forum MIS Systems
    Replies: 6
    Last Post: 27th January 2010, 09:37 AM
  2. sims.net installation on server 2008
    By maark in forum MIS Systems
    Replies: 9
    Last Post: 2nd December 2009, 09:39 AM
  3. Sims installation issue on server
    By Avalon in forum MIS Systems
    Replies: 2
    Last Post: 17th October 2009, 09:15 PM
  4. Sims new installation
    By kcymer in forum MIS Systems
    Replies: 4
    Last Post: 2nd June 2009, 01:48 PM
  5. Replies: 4
    Last Post: 29th October 2007, 12:21 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
  •