...
- Open SQL Server Management Studio
- Bring the zPre68... databases online
- 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
- 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
- There will be a number of messages here- don't be alarmed!
- Confirm that you can see the user in the single database and the appropriate permissions are in place
- Take the zPre68... databases offline
...