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

This post has been republished via RSS; it originally appeared at: New blog articles in Microsoft Community Hub.

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!

Leave a Reply

Your email address will not be published. Required fields are marked *

*

This site uses Akismet to reduce spam. Learn how your comment data is processed.