Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  1. Open SQL Server Management Studio
  2. Bring the zPre68... databases online
  3. Go to the affected login at the server level, enter the proprieties for the user and select the User Mapping option, then update the User column in the zPre68... database/s the user is authorised to

    Image Added
  4. Run the following script (in the single database) C:\SynUpd\DatabasePatcher\SingleDBConvert\60 Add Z System Users and Copy Users and Roles\02_MigrateDatabasePrincipalsToSingleDB.sql
    1. There will be a number of messages here- don't be alarmed!
  5. Confirm that you can see the user in the single database and the appropriate permissions are in place
  6. Take the zPre68... databases offline

...