Jump to content
Free PC Help Forum
Logging In to Free PC Help Forum Has Changed

Lesson Learned #294: Logins are not syncing in failover group

Guest Jose_Manuel_Jurado

By Guest Jose_Manuel_Jurado
in Microsoft Support & Discussions

 Share

Recommended Posts

Guest Jose_Manuel_Jurado

Guest Jose_Manuel_Jurado

Posted
Posted

This is because the Login is mapped to the "master" database of each server. So, when we configure FailOver Groups, only the users of the user database will replicate to the secondary server. You could find more information here: Configure security for disaster recovery - Azure SQL Database | Microsoft Learn

 

 

 

To avoid incorrect user errors, the case failover, you will have to manually create the Logins/Users of the primary server on the secondary server.

 

 

 

In the event that you have to “replicate” SQL Logins, you will have to create the Login with the same SID (security identification number) - Logins in secondary server not mapped correctly from primary server - Microsoft Community Hub

 

 

 

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.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
 Share
Go to topic listing
×
×
  • Create New...