SQL server cluster error

Hussain Bazzar 21 Reputation points
2021-02-14T10:06:16.89+00:00

I Have two SQL server (one of the server on live subnet ) and another SQL server in DR subnet )
When try to add the listener IP address it gives me the error number: 19456

SQL Server | Other
0 comments No comments
{count} votes

Accepted answer
  1. Sean Gallardy - MSFT 1,901 Reputation points Microsoft Employee
    2021-02-14T12:40:53.567+00:00

    When try to add the listener IP address it gives me the error number: 19456

    Error 19456:

    None of the IP addresses configured for the availability group listener can be hosted by the server '%.*ls'. Either configure a public cluster network on which one of the specified IP addresses can be hosted, or add another listener IP address which can be hosted on a public cluster network for this server.

    It's pretty straight forward. It's giving you the server for which you didn't specify an IP address in the listener configuration that the server given could bind to an interface. Basically you're missing an IP in another subnet, the one which that server exists. Get another IP from the subnet which that server can bind to a cluster interface and add it to the listener.

    1 person found this answer helpful.
    0 comments No comments

0 additional answers

Sort by: Most helpful

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.