How do I resolve SQL Server User Mapping Error 15023?

The error message "User, group, or role already exists in the current database" typically occurs in SQL Server when attempting to create a database user, group, or role with a name that is already in use within that specific database. This can also arise when a login exists at the server level, but the corresponding user in a specific database (especially after a database restore) is "orphaned" – meaning it's not correctly linked to its server-level login.

To resolve this issue, consider the following:

 

MSSQL tidak bisa setting dbowner