+ Post New Thread
Page 1 of 2 12 LastLast
Results 1 to 15 of 16
MIS Systems Thread, SIMS migration - help needed! in Technical; Hi there As it was the weekend, I thought lets kick off the SIMS migration remotely. I'm currently half way ...
  1. #1

    Join Date
    May 2007
    Location
    Hale Barns
    Posts
    211
    Thank Post
    39
    Thanked 8 Times in 2 Posts
    Rep Power
    16

    SIMS migration - help needed!

    Hi there

    As it was the weekend, I thought lets kick off the SIMS migration remotely. I'm currently half way through it and it was going swimmingly until when the SQL2005migration utility asks me for an sa password. None of us know it so we guessed it as blank. This prompts us for a database name BUT the list is empty...so I thought, ok maybe wrong password, I've since changed the sa password ...to an obvious choice..for now...and still the list is empty.

    Capita posted the following, vague instructions

    KB72251 - No database appearing in the dropdown box - Running the SIMS SQL Migration Utility

    --------------------------------------------------------------------------------
    Created 07/08/2007
    Last Updated 07/08/2007


    --------------------------------------------------------------------------------
    Affected Products SIMS .net Installation & Upgrade

    --------------------------------------------------------------------------------

    Notes When running the Migration utility after entering the SA username and password
    Click Connect
    There is no database appearing in the drop down box.
    --------------------------------------------------------------------------------

    Advice Please close the Migration tool and then re-run the exe.


    If the database still does not appear then you will need to do the following


    Stop the SQL Server


    Copy the SIMS.mdf and SIMS.ldf


    Re-start the SQL Server


    Remove SQL Server via Add / Remove programs


    Re-name the Microsoft Sql Server folder to Microsoft SQL Server old (If there is more than one instance of SQL 2000 on the machine then you will need to re-name the MSSQL$SIMS folder to MSSQL$SIMSold)


    Install a new instance of SQL 2000


    Does this look advisable...I REALLY don't want to screw up SIMS for now
    Any advice greatly appreciated

    Nick

  2. #2

    tech_guy's Avatar
    Join Date
    May 2007
    Location
    That little bit in the middle of Little Old England
    Posts
    8,136
    Thank Post
    1,913
    Thanked 1,345 Times in 743 Posts
    Blog Entries
    3
    Rep Power
    395

    Re: SIMS migration - help needed!

    Whoa you're brave doing it remotely!

  3. #3

    Join Date
    May 2007
    Location
    Hale Barns
    Posts
    211
    Thank Post
    39
    Thanked 8 Times in 2 Posts
    Rep Power
    16

    Re: SIMS migration - help needed!

    LMAO
    I'm sweating buckets...but it seems to have gone fine up to this point...

  4. #4

    Join Date
    May 2007
    Location
    Hale Barns
    Posts
    211
    Thank Post
    39
    Thanked 8 Times in 2 Posts
    Rep Power
    16

    Re: SIMS migration - help needed!

    ...cue someone to say "Brave or Stoopid"

  5. #5

    Join Date
    Sep 2007
    Location
    Hertfordshire
    Posts
    1
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Re: SIMS migration - help needed!

    Hi Nick

    Try logging in to Sims and out again, then run the migration utililty again. Not sure why, but this worked for me

  6. #6

    Join Date
    May 2007
    Location
    Hale Barns
    Posts
    211
    Thank Post
    39
    Thanked 8 Times in 2 Posts
    Rep Power
    16

    Re: SIMS migration - help needed!

    AWESOME! advice here doesn't get any better! your advice fixed my issue. why is SIMS such an inconsistent and devilish beast to deal with...really frustrates me at times..

    thanks for your help! it SEEMS to have worked...tomorrow morning is the pudding proving i guess....

  7. #7
    zag
    zag is offline
    zag's Avatar
    Join Date
    Mar 2007
    Posts
    3,765
    Thank Post
    898
    Thanked 417 Times in 350 Posts
    Blog Entries
    12
    Rep Power
    87

    Re: SIMS migration - help needed!

    Do you need the SA password for the migration? I have no idea what that is!

  8. #8

    tech_guy's Avatar
    Join Date
    May 2007
    Location
    That little bit in the middle of Little Old England
    Posts
    8,136
    Thank Post
    1,913
    Thanked 1,345 Times in 743 Posts
    Blog Entries
    3
    Rep Power
    395

    Re: SIMS migration - help needed!

    Sims.Net Support at the LEA should have it on record for you.

  9. #9

    Join Date
    May 2007
    Location
    Hale Barns
    Posts
    211
    Thank Post
    39
    Thanked 8 Times in 2 Posts
    Rep Power
    16

    Re: SIMS migration - help needed!

    Our password turned out to be blank. Try this first and if it then moves onto asking what database you want to migrate, you've cracked it!

  10. #10

    Join Date
    May 2007
    Location
    Hale Barns
    Posts
    211
    Thank Post
    39
    Thanked 8 Times in 2 Posts
    Rep Power
    16

    Re: SIMS migration - help needed!

    ..I changed the password now of course...

  11. #11
    apeo's Avatar
    Join Date
    Sep 2005
    Location
    Lost
    Posts
    1,612
    Thank Post
    95
    Thanked 115 Times in 111 Posts
    Rep Power
    42

    Re: SIMS migration - help needed!

    Wow remote migration.. i do alot remotely but i wouldnt even think of doing a major job like that remotely but im glad it was sorted in the end.

    You dont need to contact your LEA as you can change the sa password yourself if you dont know what it is. Question is should i really announce in public? Im not sure but there may even be a thread that mentions how you reset the sa password. PM me if you want to know how to reset the sa password.

    EDIT: Ok my post was late and you sorted it already. Its funny how the sa password is often blank.

  12. #12
    DMcCoy's Avatar
    Join Date
    Oct 2005
    Location
    Isle of Wight
    Posts
    3,456
    Thank Post
    10
    Thanked 494 Times in 434 Posts
    Rep Power
    112

    Re: SIMS migration - help needed!

    Just a note to keep an eye out if you use dbattach to automate backups, the september release seems to broken (for me), it was happily working with version 1.6 of dbattach but with 1.7 it won't accept any user I try as valid - including SA and the Administrator :|

  13. #13
    apeo's Avatar
    Join Date
    Sep 2005
    Location
    Lost
    Posts
    1,612
    Thank Post
    95
    Thanked 115 Times in 111 Posts
    Rep Power
    42

    Re: SIMS migration - help needed!

    Dont use DBAttach to do backups myself, i just stop the service altogether... Thanks for the warning tho.

  14. #14

    Join Date
    Sep 2007
    Location
    Somerset
    Posts
    62
    Thank Post
    5
    Thanked 15 Times in 12 Posts
    Rep Power
    17

    Re: SIMS migration - help needed!

    Quote Originally Posted by DMcCoy
    Just a note to keep an eye out if you use dbattach to automate backups, the september release seems to broken (for me), it was happily working with version 1.6 of dbattach but with 1.7 it won't accept any user I try as valid - including SA and the Administrator :|
    I have had confirmation from Capita that dbAttach (1.7.1) no longer works when trying to create backups using the SA login. This is currently being worked on.

  15. #15

    Join Date
    Jan 2007
    Location
    Enfield, London
    Posts
    159
    Thank Post
    7
    Thanked 3 Times in 3 Posts
    Rep Power
    17

    Re: SIMS migration - help needed!

    Quote Originally Posted by apeo
    Dont use DBAttach to do backups myself, i just stop the service altogether... Thanks for the warning tho.
    This was an OK plan up to August if you had the diskspace for copies or could control the backup window.

    Under the new system passwords are tied to the RDBMS/server and not the database. So you may have to hand out new passwords o staff after a bare metal recovery or transfer to another server. Oh joy

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

Similar Threads

  1. Ease of SIMS migration to SQL 2005
    By Ric_ in forum MIS Systems
    Replies: 12
    Last Post: 29th February 2008, 02:06 PM
  2. Replies: 1
    Last Post: 21st December 2007, 03:21 PM
  3. SIMS Migration help
    By randle in forum MIS Systems
    Replies: 17
    Last Post: 10th November 2007, 12:00 PM
  4. Downloading SIMS Migration toll via SOLUS
    By randle in forum MIS Systems
    Replies: 5
    Last Post: 26th October 2007, 09:17 AM
  5. SIMS - Migration to new Domain
    By Gatt in forum Windows
    Replies: 2
    Last Post: 20th December 2006, 01:06 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
  •