Share via

SQL Always on, failover cluster. DR node IP is adding itself to DNS

Sue_8827 81 Reputation points
2021-05-17T00:34:22.417+00:00

Hello,
I configured a 2019 SQL Always on with 3 nodes, 1 DR node and a FSW. For whatever reason either randomly or during failover to other secondary nodes the DR IP is adding itself to DSN automatically. Why is this happening?

Windows for business | Windows Server | Storage high availability | Clustering and high availability
Developer technologies | .NET | Other
SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

Answer accepted by question author

CathyJi-MSFT 22,431 Reputation points Microsoft External Staff
2021-05-17T09:48:45.94+00:00

Hi @SushmaPeddi-7734,

>during failover to other secondary nodes the DR IP is adding itself to DSN automatically.

I could not fully understood this situation. Did you mean the virtual IP for the AG name flips to the DR site? Could you share us some screenshot about DR IP is added to DSN? Please mask the sensitive information for security.

If I misunderstood, please let me know.

Please check if the thread Multi-Subnet AG - DNS flips to secondary IP could give you some idea.

If the response is helpful, please click "Accept Answer" and upvote it, as this could help other community members looking for similar queries.

Was this answer helpful?

0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.