I am trying to migrate an old, problematic Plesk server to a new one but there are some problems with SQL Server 2008.
Plesk couldn't migrate one of the DBs. So, I backed up the DB and restored on the new server. Then I tried to restore 'User Mappings' for the existing user but I got "User, group, or role already exists in the current database" error. I googled for solutions and found a few but they didn't work.
I tried to run the following procedure but no luck.
sp_change_users_login 'Auto_Fix', 'UserName'
I also tried to delete it's scheme as a solution but couldn't do it because - according to SQL Server - it's referenced by an object.
I don't want to change that object's user/scheme because I am afraid of to broke something.
What should I do?