[sims] SIMS Migration to new server - fresh install

[superaz300]

Hello Guys,

 

I am planning my summer holiday project of moving our existing SIMS server to a completely new fresh install on Windows Server 2016 and onto a new piece of hardware. The SIMS server is currently joined to our old ADMIN DOMAIN and I will be putting the new server on our curriculum domain, with a different server name.

 

So, today I have being playing in a test environment. I got the installable version of SIMS for Capita, and I installed it on Server 2016, and upgraded SQL from the express to our licenced edition due to the size of our SIMS DB.

 

As I was installing SIMS, I told the installer I didn't want to create a DB, and that I would mount one later. After the SIMS 2013 Installable version installed, I ran the 2018 Spring Upgrade to updates the file server to the new files, and our current live SIMS DB is on Spring 2018.

 

I used DBAttach to restore a SIMS DB from a backup, I copied our latest backup file from our live SIMS server onto the new test one which ends in a .bak file. It restored, but error-ed regarding creating SQL User Logins for all my users. I opened SIMS, and I couldn't login, just get Wrong Username/Password.

 

I do apolagise, I am completely new to SIMS and my knowledge is limited, which is why I am experimenting now and documenting as I go along.

 

Any help or advice is greatly appreciated.

 

Many Thanks

James

[FN-GM]

Did you properly detach the database from the old server or just use a backup?

[superaz300]

Did you properly detach the database from the old server or just use a backup?

 

Thank you for your reply. Ohhh, that could be my issue. I just restored from a scheduled backup file and didn't detach anything. If that's the case though, what's the idea of the backup file, as in can it not be used to recover a server?

 

Many Thanks

James

[FN-GM]

Im not an expert in that area so I don't really know why it is like that.

 

I used trusted logins so it isn't a big deal for me.

 

You might be able to go into the SQL management studio and reset the password to your login. Although I am not 100% sure.

[superaz300]

Im not an expert in that area so I don't really know why it is like that.

 

I used trusted logins so it isn't a big deal for me.

 

You might be able to go into the SQL management studio and reset the password to your login. Although I am not 100% sure.

 

No worries, I will look into this tomorrow.

 

Thanks for your reply anyways

 

James

[Greg]

How are your backups created, the SIMS passwords are not stored in the SIMS database by default.

 

You can transfer them into the SIMS database by running the following in SSMS

EXEC sims.sims.db_p_transfer_login

 

You can add an OSQL command to your backup script to transfer them daily to cover any changes, otherwise the passwords stay with the SQL instance - not good for DR

OSQL -S YourSIMSServerName\Uour SIMSDatabaseName -E -Q "EXEC sims.sims.db_p_transfer_login"

[tj2419]

Sorry to change the subject but we are about to do this. We are planning to transfer the SQL licence from our previous server to our new one.

 

Where can I find an installer for the full version of SQL. Do you install the express version then upgrade? What licence information does it require?

 

Ours was previously installed via LEA, hence the lack of info, which I will need to find.

 

Cheers

[Banjo]

You will need to download the same version as what you have installed, these are available from the microsoft website. Use the Eval version and enter you licence key. We use Standard Edition for secondary schools and (free) Express for primary. I think you will need to uninstall the old version to stay within the licencing T&Cs.

 

Edited June 29, 2018 by Banjo

[ICT_Pro]

Hi

We are looking to install new server in holidays as well. Please can you share the link to download installer for new SIMS Server and if there is any installation guide available. Thanks

Edited July 6, 2018 by ICT_Pro

[elsiegee40]

Hi

We are looking to install new server in holidays as well. Please can you share the link to download installer for new SIMS Server and if there is any installation guide available. Thanks

 

Can’t you get that from Capita support?

 

EduGeeks cannot share materials that are only available through a paid service agreement with a supplier.

[ICT_Pro]

I have logged the request with Capita yesterday but no response yet.

[swiftysw1]

Any reply?

[lmrogers]

I know this is an old thread but could be helpful. I have been looking for the same information and found this on Capita's website.

 

https://support.capitasoftware.com/csm?sys_kb_id=f33cf374db3d0094003c4872ba961922&id=kb_article_view&sysparm_rank=9&sysparm_tsqueryId=d9f6a49fdbf91c50a4c170c4f39619b3

 

Should be of help and it's open to the public, no need to sign into Capita support or anything.