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… 🙂