+ Post New Thread
Results 1 to 4 of 4
MIS Systems Thread, SQL Database Migration-HELP!! in Technical; Has anyone succesfully migrated a SQL MSDE database over to SQL 2005 Express (for SIMS specifically). We have managed to ...
  1. #1
    Mr_M_Cox's Avatar
    Join Date
    May 2007
    Location
    Portsmouth
    Posts
    155
    Thank Post
    5
    Thanked 1 Time in 1 Post
    Rep Power
    0

    SQL Database Migration-HELP!!

    Has anyone succesfully migrated a SQL MSDE database over to SQL 2005 Express (for SIMS specifically). We have managed to do it however one done we can no longer log in to sims using any username or passwords. any feedback, advice or discussion would be really helpfull

    cheers

  2. #2
    ChrisP's Avatar
    Join Date
    Apr 2007
    Location
    norfolk
    Posts
    150
    Thank Post
    4
    Thanked 8 Times in 8 Posts
    Rep Power
    17

    Re: SQL Database Migration-HELP!!

    Still picking myself up off the floor for this one...



    KB72296 - Important Notes Regarding the Use of dbAttach from August 2007
    Created 08/08/2007
    Last Updated 16/08/2007

    Affected Products SIMS .net System Maintenance & Utilities
    Notes Important advice regarding the use of DBAttach from August 2007

    DBAttach.exe
    Advice From the SIMS 2007 August Main release onwards, we would like to remind System Managers that the only application that we support to attach and detach a database for SIMS .net and FMS 6.91 is dbAttach.
    Using any other application to detach and detach databases may cause errors when a user logs into a SIMS application.

    From the SIMS 2007 August Main release onwards if, having detached a SIMS database, you wish to re-attach it to a different SQL Instance and do not use dbAttach, all user passwords will be reset automatically, including the ‘Sysman’ user.

    This will affect any users who do not use Windows Authentication to log into SIMS .net. If you do not use Windows Authentication, the System Manager must log into SIMS .net (using sysman as the login name and password as the password) and then open the System Manager module. Select Focus | Users, make a note of all of the new passwords then inform all users of their new password.

    Those users who use Windows Authentication to log into SIMS .net will remain unaffected by this change in functionality, as their school network login credentials are used to log into SIMS .net.

    8O :? :cry:

  3. #3
    metalmonkey
    Guest

    Re: SQL Database Migration-HELP!!

    Might not be too bad. The upgrade doesn't modify the connect.ini.

    Check the one in C:\prog..files\SIMS\SIMS .net. This should say Redirect=S:\ (or somthing similar) but if it doesn't make due the servername and instance name is correct and goes to the new 2005 service.

    Do this same in your S:\SIMS folder. This is the main one. Again, check the servername and instance name. The DB name should still be SIMS.

  4. #4

    Join Date
    Mar 2007
    Posts
    20
    Thank Post
    2
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Re: SQL Database Migration-HELP!!

    ChrisP: We are upgrading 118 schools over the summer to the new sql version and despite using dbattach we have had that exact password problem occur on one or two sites. good fun !

    There may be an issue in that sims.net is moving to sql authentication and hence all thesecurity changes - leaving you with all passwords being reset - still checking on this as it sounds a pain in the butt.



SHARE:
+ Post New Thread

Similar Threads

  1. FMS Migration - SA
    By ndavies in forum MIS Systems
    Replies: 5
    Last Post: 10th December 2007, 01:13 PM
  2. Sophos SQL Migration
    By randle in forum Windows
    Replies: 2
    Last Post: 19th November 2007, 04:47 PM
  3. FMS migration
    By ndavies in forum MIS Systems
    Replies: 3
    Last Post: 3rd November 2007, 03:45 PM
  4. Problem after SQL Migration
    By Jawloms in forum MIS Systems
    Replies: 5
    Last Post: 24th October 2007, 04:06 PM
  5. Replies: 4
    Last Post: 28th February 2007, 10:37 AM

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
  •