SQL Server Error User Group or Role Already Exists in the Current Database

The issue mainly occurred due to user privilege exist on the associated DB. So we need to remove this and need to alter the db privilege via SQL management studio

User group or role already exists in the current database

Step to solve the issue.

Step1. Login to the SQL server using windows authentication

Step2. Select the database that you want to remove the existing user.

While right clicking on the DB, you could see something like run a new query. Here put the following query & then click on execute

sp_change_users_login 'AUTO_FIX', 'your_db_user_name'

Once query is executed successfully, then map the user with DB,use dbowner option.

Make sense ? If you have any trouble ping me… 🙂