I am running SQL Server 2012 HAG group, and I am trying to restore a database to it. However when I execute the command on the primary replica:
exec sp_change_users_login 'update_one', 'topcatcleaning', 'topcatcleaning'
I get the following error:
Msg 15291, Level 16, State 1, Procedure sp_change_users_login, Line 114
Terminating this procedure. The User name 'topcatcleaning' is absent or invalid.
I checked the login exists in the HAG instance and the Primary replica, see screenshots, so I am unsure what to do from here.
Any assistance is appreciated.