+ Post New Thread
Results 1 to 6 of 6
MIS Systems Thread, Sims/SQL/Server 2008 in Technical; Hello, My server has just died and the new one has arrived but I have no install guides for installing ...
  1. #1

    Join Date
    Jun 2010
    Location
    eastbourne
    Posts
    10
    Thank Post
    13
    Thanked 2 Times in 1 Post
    Rep Power
    9

    Sims/SQL/Server 2008

    Hello,

    My server has just died and the new one has arrived but I have no install guides for installing SQL 2008.

    Does anyone have any guides which will help me install sql 2008 r2 and sims install on server 2008 R2 64bit?



    Cheers

  2. #2

    Join Date
    Nov 2009
    Location
    Manchester
    Posts
    1,049
    Thank Post
    6
    Thanked 199 Times in 179 Posts
    Rep Power
    52
    I was told by a Capita employee, that you have to use SQL 2008 (not 2008 R2) as it isn't officially supported yet but it should be soon.

    Basically install SQL, note down the server name, admin name and password etc. Install SIMS itself (to allow you to test), then use the DBackup tool to restore the "backup". You should then be able to connect, it really should be that simple.

    Just make sure you are installing the same version of SIMS as your datbase was when the old server broke.

  3. Thanks to Achandler from:

    ev32 (6th February 2012)

  4. #3

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,848
    Thank Post
    671
    Thanked 1,383 Times in 1,145 Posts
    Rep Power
    350
    Both windows 2008 R2 and Server 2008 R2 are supported.
    There are quite a few threads on here with regards reinstalling a sims server, you can just follow the same setup for installing a test server if that's what the thread mentions.
    Some things to look out for, when you install SQL, take note of the warning about allowing / opening the ports on windows firewall, or whatever firewall you replace it with, you need to do this to enable comms.
    If you can keep the same name as old server that will save you having to fiddle with mapped drives and the connect.ini
    You can download ISO for new install from SupportNet to do a clean install, then run ISOs for the updates e.g. latest autumn 11 or whichever you want to get to. Then use dbattach to drop your backup on to it. If you do end up having a newer version installed it's okay, if you just run a dbupgrade and it will update it. A good time to upgrade if you were holding off

  5. Thanks to vikpaw from:

    ev32 (6th February 2012)

  6. #4

    Join Date
    Nov 2009
    Location
    Manchester
    Posts
    1,049
    Thank Post
    6
    Thanked 199 Times in 179 Posts
    Rep Power
    52
    We moved in September 2011, so SQL 2008 R2 support must have come into place in the last update.

  7. #5

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,848
    Thank Post
    671
    Thanked 1,383 Times in 1,145 Posts
    Rep Power
    350
    Quote Originally Posted by Achandler View Post
    We moved in September 2011, so SQL 2008 R2 support must have come into place in the last update.
    Since Spring 2011 release. Though many have been using it on the sly for a while

  8. #6

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,848
    Thank Post
    671
    Thanked 1,383 Times in 1,145 Posts
    Rep Power
    350
    I found this document, which was for the migration to 2008, got it from forums on SupportNet, not sure who from, and may have edited it since. Anyhow, it has some guidance for the sql install. Just ignore the bits about going to the other manual, the key bit is about which parts to install when going through the wizard.

    SQL 2008 Install from SupportNet.pdf

  9. Thanks to vikpaw from:

    ev32 (7th February 2012)

SHARE:
+ Post New Thread

Similar Threads

  1. [SIMS] Sims/SQL/Server 2003
    By mm3 in forum MIS Systems
    Replies: 1
    Last Post: 20th December 2011, 03:34 PM
  2. Replies: 21
    Last Post: 18th January 2011, 12:20 PM
  3. [SIMS] SIMS.Net / SQL Server 2008 Service Pack 2 (SP2)
    By Minkus in forum MIS Systems
    Replies: 5
    Last Post: 13th December 2010, 02:34 PM
  4. [SIMS] SIMS SQL 2005 --> 2008 migration
    By cookie_monster in forum MIS Systems
    Replies: 7
    Last Post: 29th July 2010, 02:24 PM
  5. SIMS & SQL Server
    By tscnmuk in forum MIS Systems
    Replies: 16
    Last Post: 20th July 2007, 12: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
  •