Skip to content
  • About Me
  • #SQLHelp
  • Training
  • SQLTools
  • AutoMon
  • jDBA
  • Tuning
  • Oracle
  • Freelance
  • Disclaimer and copyright
SQL Server Blog Forum

Guide to SQL Server DBAs and Developers

  • About Me
  • #SQLHelp
  • Training
  • SQLTools
  • AutoMon
  • jDBA
  • Tuning
  • Oracle
  • Freelance
  • Disclaimer and copyright
  • About Me
  • #SQLHelp
  • Training
  • SQLTools
  • AutoMon
  • jDBA
  • Tuning
  • Oracle
  • Freelance
  • Disclaimer and copyright
  • AlwaysON

    None of the IP addresses configured for the availability group listener can be hosted by the server Either configure a public cluster network 19456

    July 17, 2019

    Requirement: Remove a node from one of availability alwayson group and added it on another group. It was a multi-subnet and the node is a DR node on a different subnet. You have to remove the IP from the group in the windows cluster go to run — cluadmin.msc — click roles — click the group –> click on server name expand it — remove the IP of the node it could be offline. Once deleted add it on the other group by the listener or from the cluster. Background: It is a three node cluster two in same data center and third node is in DR data center. TITLE:…

    Read More
    Muthukkumaran No Comments

Search Box

Advertisements

Categories

  • AlwaysON
  • AutoMon
  • Azure
  • Backup/Restore
  • Basics for freshers
  • DBA
  • Docker
  • DR/HA
  • Indexes
  • Internals
  • Junior DBA
  • Microsoft
  • Oracle
  • Performance
  • PowerShell
  • Questions
  • Scripts
  • SQL party
  • T-SQL
  • VLDB

Archives

Top SQL server blogs

  • Adam Machanic
  • Amit Banerjee
  • Brent Ozar
  • Gail Shaw
  • Grant Fritchey
  • Paul White
  • Pinal Dave
  • SimpleTalk
  • Sqlblog
  • SQLskills
Powered by RAR Web Solutions