## Answer Repair the user mapping with the ALTER USER command. --- ## Summary When you restore the SQL Server "[Backup](/en/manual/faq-backup-and-restore)" file obtained with [FAQ: I want to backup Pleasanter' DB data regularly (SQL Server)](faq-backup-schedule) 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](faq-backup-and-restore). 1. Execute the following SQL in SSMS. ``` Use [Implem.Pleasanter] EXEC sp_change_users_login 'Report' ``` 1. 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. 1. Execute the SQL in 2 again and repeat step 3 until no results are displayed. ## Related Information <div id="ManualList"><ul><li><a href="/en/manual/faq-backup-and-restore">FAQ: How to backup and restore Pleasanter's DB data</a><span>08.14.2024 up</span></li> <li><a href="/en/manual/faq-backup-schedule">FAQ: I want to backup Pleasanter' DB data regularly (SQL Server)</a><span>12.19.2024 up</span></li></ul></article></div><input id="SearchTextHidden" type="hidden" value="" />