Lesson Learned #288:Server principal 'XXX' is not able to access the database under current security

Today, we got a service request where our customer got the following error message: The server principal 'XXX' is not able to access the database 'master' under the current security context

Our customer is implementing a geo-replication and when they try to connect and following the Configure security for disaster recovery - Azure SQL Database | Microsoft Learn they got this error message. 

We were able to identify the issue and fix it. The issue is with the login created on secondary SQL server with wrong SID, and after matching SIDs, issue resolved.

Following the steps explained in this link Configure security for disaster recovery - Azure SQL Database | Microsoft Learn we were able to fix this issue. 

Enjoy!