Share via

SQL AG: Cluster IP address resource cannot be brought online because a duplicate IP address was detected on the network. Please ensure all IP addresses are unique.

Sue_8827 81 Reputation points
Nov 4, 2022, 4:34 AM

I built a SQL Cluster with always on availability groups, I am seeing the following error on the events

Cluster IP address resource cannot be brought online because a duplicate IP address was detected on the network. Please ensure all IP addresses are unique.

Cluster IP 10.1.10.91
257049-image1.png

256989-image2.png

You see in the image 2 that shows roles, the cluster IP is popping up under AG resource and its failing to bring it online. Can I remove this?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,208 questions
SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
543 questions
Windows Server Clustering
Windows Server Clustering
Windows Server: A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.Clustering: The grouping of multiple servers in a way that allows them to appear to be a single unit to client computers on a network. Clustering is a means of increasing network capacity, providing live backup in case one of the servers fails, and improving data security.
1,017 questions
{count} votes

3 answers

Sort by: Most helpful
  1. YufeiShao-msft 7,131 Reputation points
    Nov 4, 2022, 6:40 AM

    Hi @Sue_8827

    As the error message said, the virtual IP of the cluster should be unique, please check your virtual IP address, if the IP address is duplicated, you can consider changing the IP address, right-click the IP address, choose Properties, you can see the Static IP address and change it to make sure this new IP is unique on the network, if you change any of the settings, try to bring the resource online first
    https://www.mssqltips.com/sqlservertip/4220/change-the-virtual-ip-address-for-a-sql-server-failover-cluster/

    -------------

    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments No comments

  2. Olaf Helper 45,371 Reputation points
    Nov 4, 2022, 7:41 AM

    cannot be brought online because a duplicate IP address was detected on the network

    You get a clear error message, so check your network if the IP address is used elsewhere, e.g. ping the IP address with resolving to machine name.

    0 comments No comments

  3. Bjoern Peters 8,891 Reputation points
    Nov 4, 2022, 12:10 PM

    Hi @Sue_8827

    No, you can't just delete the IP address on the AG role.

    But you can remove the IP address from the listener of the AG and add another free IP address to the listener.

    0 comments No comments

Your answer

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