Lesson Learned #288:Server principal 'XXX' is not able to access the database under current security
Published Jan 17 2023 10:52 AM 2,822 Views

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!

Version history
Last update:
‎Jan 17 2023 10:52 AM
Updated by: