[sims] New SIMS server install

[Philip60]

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)

[3s-gtech]

Do you have SQL Server installed and running already?

[Philip60]

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...

[matt40k]

Your setups folder is out-of-date (simsinst doesn't update via solus2), ask for the latest installable release.

[vikpaw]

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

[Philip60]

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!

[vikpaw]

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.