This was exactly what I needed to find my solution. I ended up finding the following article which made creating a login user with the matched SID very simple.

https://blog.sqlauthority.com/2015/04/18/sql-server-create-login-with-sid-way-to-synchronize-logins-on-secondary-server/

Thank you!

• This reply was modified 1 year, 10 months ago by Astroneil.