SQL Server error report & quot; 21002: [SQL-DMO] user * already exists "how to solve it"

This article mainly explains the "SQL Server error report" 21002: [SQL-DMO] users * already exist "how to solve", the content of the explanation in the article is simple and clear, easy to learn and understand, now please follow the editor's train of thought to slowly deepen, together to study and learn "SQL Server error report" 21002: [SQL-DMO] users * already exist "how to solve" it!

Solution: 1. Open mssql Enterprise Manager → database → expand the problem database such as "mydb" → "user" → in the right window to select the problem user name such as: "* *" → right-click → to delete 2. The enterprise manager → security → login → selects the user name of the problem in the right window, such as: "*" → property → database access → click "mydb" → check below "public" and "db-owner" → to determine

Thank you for your reading, the above is the "SQL Server error report" 21002: [SQL-DMO] user * there is already a "how to solve" content. After the study of this article, I believe you have a deeper understanding of how to solve the problem that SQL Server error "21002: [SQL-DMO] user * already exists", and the specific use situation still needs to be verified in practice. Here is, the editor will push for you more related knowledge points of the article, welcome to follow!