Problem Description:

Usually we face this issue while dropping user from database which owns database roles and error code 15421 indicates issue of database role ownership which need to be modified.

Solution:

Run below query on database to check database … Read the rest

We were facing below error while trying to grant access to the database for specific login.

Problem Description:

Create failed for User (Microsoft.SqlServer.Smo)
SQL Server Error User, group, or role already exists in the current database. (Microsoft SQL Server, Error: … Read the rest