AlwaysOn Setup New User on Read Only Replica
All you need is to create the same login on the second server preserving it’s sid, and you can do this first by copying the login’s sid from sys.server_principals and then by creating the same login using with sid like this: Example: On Primary Database: On Read Only Replica Database: Sources: https://dba.stackexchange.com/questions/174946/creating-a-sql-login-and-user-on-an-alwayson-replica