HPE NonStop SQL/MX Error – 21123 User user-name already exists in the database database-name.

In this blog post, let’s learn about the error message “21123 User user-name already exists in the database database-name.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.

Error Message

21123 User user-name already exists in the database database-name.

Reason for the Error

You specified an existing user in the database.

Solution

Specify an external user that is not associated with the database to the mxdbs command and retry the operation