In this blog post, let’s learn about the error message “15110 – The proposed new database owner is already a user or aliased in the database.” in Microsoft SQL Server, the reason why it appears and the solution to fix it.
SQL Server Error Message
15110 – The proposed new database owner is already a user or aliased in the database.
Reason for the Error
SQL Server Error Msg 15110 occurs when you try to change the owner of a database to a user or alias that is already a user or alias in the database. In other words, the proposed new database owner is already a login account that has been granted access to the database, either directly or through a group membership.
This error can occur for a few reasons, including:
- The proposed new database owner is already a member of the database roles or schema.
- The proposed new database owner is a login that already exists in the database.
- The proposed new database owner is a member of a Windows group that has been granted access to the database.
Solution
To resolve this error, you need to choose a new database owner that is not already a user or alias in the database, or remove the existing user or alias from the database roles or schema, or remove the user or alias login from the database or revoke its access, or remove the user or alias from the Windows group that has been granted access to the database.
You can also check the SQL Server logs to see if there are any other errors or warnings that might be related to the issue, or consult the SQL Server documentation or online forums for further assistance.
