+ Post New Thread
Page 1 of 2 12 LastLast
Results 1 to 15 of 17
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 ...
  1. #1
    quietriot1983's Avatar
    Join Date
    Dec 2010
    Location
    Manchester
    Posts
    105
    Thank Post
    15
    Thanked 6 Times in 6 Posts
    Rep Power
    9

    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?

  2. #2

    creese's Avatar
    Join Date
    Feb 2009
    Location
    -28° 31' 48.89", +28° 25' 37.42" ... if only.
    Posts
    3,256
    Thank Post
    182
    Thanked 375 Times in 304 Posts
    Rep Power
    174
    Quote Originally Posted by quietriot1983 View Post

    So my question is, what is involved in starting a new SIMS environment from scratch? As if it's all brand new?
    Not a good idea IMHO. What about all your historic data? You are legally bound to keep this.

    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 10:40 AM.

  3. #3

    Steve21's Avatar
    Join Date
    Feb 2011
    Location
    Swindon
    Posts
    2,702
    Thank Post
    335
    Thanked 517 Times in 485 Posts
    Rep Power
    180
    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.

    Steve

  4. #4
    quietriot1983's Avatar
    Join Date
    Dec 2010
    Location
    Manchester
    Posts
    105
    Thank Post
    15
    Thanked 6 Times in 6 Posts
    Rep Power
    9
    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.

  5. #5
    Ghostgame's Avatar
    Join Date
    Jun 2012
    Location
    Ipswich
    Posts
    287
    Thank Post
    31
    Thanked 67 Times in 39 Posts
    Rep Power
    33
    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 11:23 AM.

  6. #6

    Join Date
    Sep 2006
    Location
    Reading
    Posts
    177
    Thank Post
    14
    Thanked 41 Times in 39 Posts
    Rep Power
    23
    Quote Originally Posted by quietriot1983 View Post
    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?
    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.
    Last edited by number34; 24th June 2013 at 11:53 AM. Reason: typo

  7. #7

    Join Date
    Apr 2010
    Posts
    2,058
    Thank Post
    83
    Thanked 188 Times in 155 Posts
    Rep Power
    84
    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?

  8. #8
    quietriot1983's Avatar
    Join Date
    Dec 2010
    Location
    Manchester
    Posts
    105
    Thank Post
    15
    Thanked 6 Times in 6 Posts
    Rep Power
    9
    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.

  9. #9

    creese's Avatar
    Join Date
    Feb 2009
    Location
    -28° 31' 48.89", +28° 25' 37.42" ... if only.
    Posts
    3,256
    Thank Post
    182
    Thanked 375 Times in 304 Posts
    Rep Power
    174
    Quote Originally Posted by quietriot1983 View Post
    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.
    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.

  10. #10

    Join Date
    Apr 2010
    Posts
    2,058
    Thank Post
    83
    Thanked 188 Times in 155 Posts
    Rep Power
    84
    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.
    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?

  11. #11
    Ghostgame's Avatar
    Join Date
    Jun 2012
    Location
    Ipswich
    Posts
    287
    Thank Post
    31
    Thanked 67 Times in 39 Posts
    Rep Power
    33
    Found a link for resetting your SA password on Asp.net forum.
    Hope this helps.

  12. #12
    CAM
    CAM is offline

    CAM's Avatar
    Join Date
    Mar 2008
    Location
    Burgh Heath, Surrey
    Posts
    4,201
    Thank Post
    841
    Thanked 377 Times in 292 Posts
    Blog Entries
    60
    Rep Power
    285
    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.

  13. #13

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,641
    Thank Post
    685
    Thanked 1,400 Times in 1,160 Posts
    Rep Power
    353
    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.

  14. #14

    Sylv3r's Avatar
    Join Date
    Jul 2005
    Location
    Co. Durham
    Posts
    3,215
    Thank Post
    372
    Thanked 380 Times in 338 Posts
    Rep Power
    148
    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#

  15. #15

    jinnantonnixx's Avatar
    Join Date
    Mar 2011
    Location
    In the Calamatorium.
    Posts
    1,997
    Thank Post
    115
    Thanked 508 Times in 343 Posts
    Blog Entries
    2
    Rep Power
    286
    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 07:31 PM.

SHARE:
+ Post New Thread
Page 1 of 2 12 LastLast

Similar Threads

  1. [SIMS] Installing SIMS from Solus3 on non-domain member PCs
    By mtillbrook in forum MIS Systems
    Replies: 7
    Last Post: 7th May 2013, 10:12 AM
  2. Replies: 2
    Last Post: 14th January 2013, 11:25 AM
  3. [SIMS] Assessment from scratch
    By SID6581 in forum MIS Systems
    Replies: 5
    Last Post: 20th September 2010, 04:30 PM
  4. Group Policy Starting from Scratch
    By karldenton in forum Windows
    Replies: 15
    Last Post: 25th May 2010, 03:09 PM
  5. Replies: 3
    Last Post: 22nd February 2010, 05:39 PM

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
  •