Skip to content

Unable to connect when restoring files backed up on another server (SQL Server)

Answer

Repair the user mapping with the ALTER USER command.

Summary

When you restore the SQL Server "Backup" file obtained with FAQ: I want to backup Pleasanter'' DB data regularly (SQL Server) to a Pleasanter in another environment, you may not be able to log in even if you have not changed the user ID or password. This is because the mapping between the restored database user and the server login user is inconsistent.

Operation Procedure

  1. Restore the dump file according to FAQ: How to backup and restore Pleasanter''s DB data.
  2. Execute the following SQL in SSMS.
    Use [Implem.Pleasanter]
EXEC sp_change_users_login 'Report'
  3. If Implem.Pleasanter_User or Implem.Pleasanter_Owner (or both) are displayed in the result of 2, execute the following command.
    Use [Implem.Pleasanter]
ALTER USER {username*1} WITH LOGIN = {username*1}

    *１：Enter the user name as "[Implem.Pleasanter_User]" or "[Implem.Pleasanter_Owner]". If both are displayed in 2, execute the ALTER USER statement for each user.
  4. Execute the SQL in 2 again and repeat step 3 until no results are displayed.