MIS Systems Thread, Starting SIMS from scratch? in Technical; Currently we use SIMS only in the office, and the new head wants it on her laptop, and she wants ...
24th June 2013, 11:36 AM #1
Starting SIMS from scratch?
Currently we use SIMS only in the office, and the new head wants it on her laptop, and she wants the teachers to use attendance instead of paper registers. Trouble is, I've inherited this system from the LA, and as such don't have the sa password. This means when we back up, I've had to script it to stop the SIMS services, copy the relevant folders/files and then restart the services...not ideal! Also, this means I can't use dbattach to transfer the entire database to a new office machine (seeing as they are stopping XP support).
So my question is, what is involved in starting a new SIMS environment from scratch? As if it's all brand new?
24th June 2013, 11:38 AM #2
Not a good idea IMHO. What about all your historic data? You are legally bound to keep this.
Originally Posted by quietriot1983
I'm not highly technical but I'm sure a better alternative would be to change the password. I'm sure there is a way, or get it from the LA.
From the Capita website:
The SIMS Service desk CANNOT advise customers on how to do this as this is a Microsoft product. If you require assistance on resetting your SA password please contact Microsoft via their website.
Last edited by creese; 24th June 2013 at 11:40 AM.
24th June 2013, 11:40 AM #3
Unless it's changed there's a few threads on here about resetting SA passwords for SIMs.
Not sure if starting a whole new database setup etc would need relicensing etc if anything is changing that much.
24th June 2013, 12:06 PM #4
Hmm. Might be a no-go then.
I did hear somewhere that you could install SQL and set up new sa/admin accounts before copying and pasting the .mdf and .ldf files across...not sure how legit that is though.
24th June 2013, 12:09 PM #5
You will need your databases if your doing a SIMS migration (I'm assuming your keeping the domain name the same). Just make sure that if you change the server name, that it is also changed in the connect.ini.
You can install SQL on the new server and with a new SA account, attach the databases with dbAttach.
As for the teachers doing attendance, its just a case of installing the SIMS .net client on your teachers workstations and making sure that SIMS .net can communicate with your SIMS server (if you have two domains, you put the IP address in connect.ini file instead of the server name).
Last edited by Ghostgame; 24th June 2013 at 12:23 PM.
24th June 2013, 12:21 PM #6
You say it is used in the office, do you mean on a standalone machine or a network? If it is networked then you just(!) have to set up the laptops as SIMS workstations and sort out users etc. I would assume your LA would support this.
Originally Posted by quietriot1983
Last edited by number34; 24th June 2013 at 12:53 PM.
24th June 2013, 12:25 PM #7
If it was me I would be getting the sa password sorted asap. it could cause you all sorts of issues without it. For example if your sims backup is not using the SA account is it actually backing up all the sims user accounts or just the data?
24th June 2013, 12:38 PM #8
I have exhausted options for getting hold of the sa password. LA are no help as we are a 'black sheep' school who opted out of RM's managed service, so they try to make it as difficult as possible for us.
24th June 2013, 12:40 PM #9
If they have it and are making it difficult for you to manage your data... They could be on dodgy ground. Maybe some pressure high up... mention of the Data Protection Act.
Originally Posted by quietriot1983
24th June 2013, 12:44 PM #10
That is no different than them not giving you the server admin password and probably not legal. They also should have kept an up to date list of passwords on school property. Have you tried the school safe? I have exhausted options for getting hold of the sa password. LA are no help as we are a 'black sheep' school who opted out of RM's managed service, so they try to make it as difficult as possible for us.
24th June 2013, 01:06 PM #11
Found a link for resetting your SA password on Asp.net forum.
Hope this helps.
24th June 2013, 01:25 PM #12
Will this help? I think I did this before on a test database:
Resetting the SA password for SQL Server
You need to connect to it using Windows Authentication so it uses the local admin account on the server for management tasks, such as resetting administrator passwords.
You only need to install SIMS Server in one place though and having a copy of the database on a laptop would be a gross violation of data protection, encrypted or not. Plus SIMS server will cripple it and the data will not match up with what is on your main server if something changes (which it will). Look into remote access like VPN if someone wants access to SIMS outside of school.
24th June 2013, 04:16 PM #13
Part of the installation, leaves a file called ChSAPwd.exe in the server binn folder under your SQL instance - not sure on the syntax but i'm sure it's covered here. I'm guessing it's there on all install types even Express.
I wouldn't bother though, if you're going to be migrating to a new machine, do a clean install yourself with a new SA password and then attach the files from the old server after turning services off.
I don't think the plan was to put a server install on the laptop was it? Just to access from the laptop...
The only thing that might sting you is the logins might not carry forward.
Also, you should be able to get a system manager backup, at least from sysman 6 it worked fine as system manager user, and you can just restore that to the new server, so you don't even have to turn your old setup off.
24th June 2013, 07:31 PM #14
This is what I have used in the past and worked well.
osql -SERVER\SIMSSQL2008 -E -n -Q”sp_password @old =null, @new= 'NewSAPassword1#' , @loginame = 'sa'”
This command assumes that
The server name is SERVER The instance name is SIMSSQL2008 The sa username is sa The new sa password is NewSAPassword1#
24th June 2013, 08:29 PM #15
As @CAM says, the way back in is with an administrative Windows account.
Also, your backup method would get you shot at dawn for a month. Just kidding.
Once you have the sa back under your control, you can use the free tool 'SQLCMD' to backup your database either from the server or a workstation. You don't need to suspend the SQL service to do this. SQL backups can run at any time, even if the server is in full flow.
In the example in the link below, you don't even need sa as it uses the '-E' switch which uses a Windows account.
Backup and Restore Your SQL Server Database from the Command Line
Last edited by jinnantonnixx; 24th June 2013 at 08:31 PM.
By mtillbrook in forum MIS Systems
Last Post: 7th May 2013, 11:12 AM
By bunny in forum MIS Systems
Last Post: 14th January 2013, 12:25 PM
By SID6581 in forum MIS Systems
Last Post: 20th September 2010, 05:30 PM
By karldenton in forum Windows
Last Post: 25th May 2010, 04:09 PM
By dlethe in forum O/S Deployment
Last Post: 22nd February 2010, 06:39 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)