[sims] New SIMS server (clean install on a new VM)

[mb2k01]

Hi All,

 

As our current support providers (I better not mention them... yet!) aren't being very helpful, I thought I would ask here.

Has anyone got a set of instructions or rough guidance on steps required to build a brand new SIMS server?

 

Essentially our current server, while virtualised, is probably the oldest VM we have still running. We would like to commission a brand new server for SIMS, do a clean install and copy the database across etc.

We've actually got as far as I've just described - but when we try and log in with a known user it says their password is incorrect...

 

We're assuming we're missing something in terms of having to tweak a setting / change a server name somewhere, but as no one (support co or Capita) appear to be able to help, I'm hoping someone on here knows!

 

Cheers

[LTurner3692]

May sound silly but out of interest have you reset said persons password?

[FishCustard]

You need to run the following command on the old system, then re-do the transfer:

 

[color=#333333]osql -S%COMPUTERNAME%\SIMS2008 -Usa -Psa_password_here -n -Q"exec sims.sims.db_p_transfer_login"[/color]

if you have FMS, you'll also want to run

osql –S[color=#333333]%COMPUTERNAME%[/color]\sims2008 [color=#333333]-Usa -Psa_password_here -n [/color]-Q"exec ccsfms.sims.db_p_transfer_login"

Edited January 29, 2019 by FishCustard

[Atomic_Zombie]

How did you take the backup of the current server? If not done properly it will lose all the Passwords for users.

 

Edit: as FishCustard mentioned above.

Edited January 29, 2019 by Atomic_Zombie

[mb2k01]

You need to run the following command on the old system, then re-do the transfer:

 

[color=#333333]osql -S%COMPUTERNAME%\SIMS2008 -Usa -Psa_password_here -n -Q"exec sims.sims.db_p_transfer_login"[/color]

if you have FMS, you'll also want to run

osql –S[color=#333333]%COMPUTERNAME%[/color]\sims2008 [color=#333333]-Usa -Psa_password_here -n [/color]-Q"exec ccsfms.sims.db_p_transfer_login"

 

At the moment we're wanting to keep the old system operational to test the theory that we can move - i.e want the move to the new server to be largely unnoticed by end users.

Will running that command on the existing/old server cause the existing system to stop working in anyway?

[TwistedHelixis]

Will running that command on the existing/old server cause the existing system to stop working in anyway?

 

You should be fine on a live system. I run one similar as a task. All it does is copy the passwords from the SQL database an into the Sims database. We also do one for FMS

[mb2k01]

You should be fine on a live system. I run one similar as a task. All it does is copy the passwords from the SQL database an into the Sims database. We also do one for FMS

 

Perfect, thanks. We'll give it a go!

[FishCustard]

You should be fine on a live system. I run one similar as a task. All it does is copy the passwords from the SQL database an into the Sims database. We also do one for FMS

 

^this^

[mb2k01]

Thanks guys. The above has worked!

The power of EduGeek strikes again... 10mins after asking here I get the answer.... compared to several days of asking current support provider (and being told it probably needed to be additionally chargable advice!!) and historical asking of Capita Support too!