• resolved with the below query

    USE [database];

    Go

    sp_change_users_login @Action= 'update_one', @UserNamePattern=,

    @LoginName=[loginname];

    GO