User, group, or role & #39; test & #39; already exists in the current database, error 15023, exists15023

User, group, or role 'test' already exists in the current database, error 15023, exists15023
Directory

• Directory
  • Error Message
  • Solution
    • -Method 1
    • -Method 2

Error Message

Solution-method 1

Create a user account without authorization, and then associate the account with the corresponding database user using the following SQL statement. This avoids re-authorization.
USE {target database}
EXEC sp_change_users_login 'Update _ one', '{username already exists in the target database}', '{username created }'

-Method 2

Before creating a user account (or authorization), delete the user account with the same name in the corresponding database.

The owner of the restored database is an isolated user.
Query analyzer and execute the following statement to find the isolated user
'Exec sp_change_users_login' Report"

Organized from Network