Posted January 17, 20231 yr 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! Continue reading...
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.