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
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,059 questions
0 comments No comments
{count} votes

Accepted answer
  1. Sean Gallardy - MSFT 1,886 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.

    0 comments No comments

0 additional answers

Sort by: Most helpful