Run the following query on the database in question to “resync” this login information:

EXEC sp_change_users_login 'Auto_Fix', 'UserName', NULL, 'Password'

Make sure to replace UserName and Password with the appropriate login information. If you don’t know the current password and the user already exists, simply run the command without the NULL and Password fields.

2 Responses to “Fix SQL error: User, group, or role ‘‘ already exists in the current database Error: 15023”

Leave a Reply