SQL Server - create user for a local Windows login from another instance (AlwaysOn)
To pre-provision the local Windows database accounts, add the local Windows database users to the database before you add the database to the AG. Steps below.

create the new database on the secondary
create the secondary node local login and database user
backup the database and drop from the secondary
restore the database to the primary
create the primary node local login and database user
add the database to the AG
backup the database and transaction log
restore the database and log backups to the secondary WITH NORECOVERY