+ Post New Thread
Results 1 to 7 of 7
MIS Systems Thread, New SIMS server install in Technical; I'm sorry to ask this, but I'm tearing my hair out... Exactly how do you install SIMS on a server? ...
  1. #1

    Join Date
    Sep 2013
    Posts
    11
    Thank Post
    1
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    New SIMS server install

    I'm sorry to ask this, but I'm tearing my hair out...
    Exactly how do you install SIMS on a server? What do you start with? SIMSINST choosing server options? When I run this it tells me that:
    MS SQL 2000 SP3 Desktop Engine Installation Package MISSING!
    SIMS Infrastructure: Package MISSING!
    SIMS SQL Applications: MISSING!
    Ok, so I try to run, SIMS Infrastructure. It installs .NET 3.5 and then disappears... without so much as a goodbye
    Then I try SIMS SQL App setup, and go back to square 1. Same messages from SIMSINST.
    I sure as hell am not going to run MS SQL 2000 SP3 Desktop Engine!!!
    I'm going round in circles and going
    My LEA sent me a setups folder in Sept, supposedly with the latest files. However SIMSINST is dated 2007. Is this correct? I'm thinking this is the problem.
    Searching this forum someone suggested running SIMSServerApplicationSetup - but I can't find it anywhere...
    If I can't figure it out soon, it's this:
    Can anyone save me from my fate???
    (btw I'm running server 2012 on a Hyper-V VM)

  2. #2

    3s-gtech's Avatar
    Join Date
    Mar 2009
    Location
    Wales
    Posts
    3,103
    Thank Post
    161
    Thanked 655 Times in 588 Posts
    Rep Power
    169
    Do you have SQL Server installed and running already?

  3. #3

    Join Date
    Sep 2013
    Posts
    11
    Thank Post
    1
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    I started by trying the 2012 Migration utility, which installed SQL2012. Then I thought, wait, there's no SIMS installed so it can't work. But I was told by an engineer that the Migration Utility would set it up and I didn't need to run SIMSINST. But it didn't work, so that's when I tried to run SIMSINST anyway. Then I uninstalled the lot and started from scratch, but that didn't work either!! Aaaagghh (Somewhere in the middle I succeeded in attaching a SIMS database using dbattach, so SQL was actually working, but without any SIMS infrastructure...

  4. #4

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,522
    Thank Post
    374
    Thanked 677 Times in 551 Posts
    Rep Power
    166
    Your setups folder is out-of-date (simsinst doesn't update via solus2), ask for the latest installable release.

  5. #5

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,956
    Thank Post
    775
    Thanked 1,487 Times in 1,234 Posts
    Rep Power
    367
    Plus, i would only install sql 2012 if you're current SIMS is already running on it.
    Usual process is take a fully patched server with SQL and run the installable ISO onto it.
    Run intermediate update ISOs until you get up to the version your DB is on.
    Restore your DB.
    Update connect.ini , open up firewalls, map drives, link to 3rd party systems...
    test test
    test

  6. #6

    Join Date
    Sep 2013
    Posts
    11
    Thank Post
    1
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Thanks Guys. So, you're recommending starting by installing SQL2008, get the latest SIMS server ISO from LEA, run updates (quite a lot of those perhaps!) detach and attach database, modify connect.ini etc and test from there. Then if all is working run the SQL2012 migration tool. Is that right? Thanks again!

  7. #7

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,956
    Thank Post
    775
    Thanked 1,487 Times in 1,234 Posts
    Rep Power
    367
    Quote Originally Posted by Philip60 View Post
    Thanks Guys. So, you're recommending starting by installing SQL2008, get the latest SIMS server ISO from LEA, run updates (quite a lot of those perhaps!) detach and attach database, modify connect.ini etc and test from there. Then if all is working run the SQL2012 migration tool. Is that right? Thanks again!
    Yep, and you can possibly avoid detach / reattach if you want, by just restoring a backup onto new install. If you find that the logins haven't come across then you could try a detach, or manually run the stored procedures that push the logins into the database.

  8. Thanks to vikpaw from:

    Philip60 (4th November 2013)



SHARE:
+ Post New Thread

Similar Threads

  1. [SIMS] Installing a new sims server
    By boolyn in forum MIS Systems
    Replies: 7
    Last Post: 9th November 2011, 12:32 PM
  2. [SIMS] New SIMS Server RAID 5 or 10
    By fiza in forum MIS Systems
    Replies: 10
    Last Post: 15th May 2011, 04:12 PM
  3. Replies: 4
    Last Post: 29th October 2007, 01:21 PM
  4. Installing a new SIMS server ... in exam season !!
    By bobwright in forum MIS Systems
    Replies: 8
    Last Post: 21st June 2007, 09:49 AM
  5. Installing a new sims server
    By wesleyw in forum MIS Systems
    Replies: 4
    Last Post: 22nd January 2007, 10:34 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
  •