AG Listener creation failed

  • Hi Folks,

    I'm using the following script to create AG listener. But it failed. Error has been attached. Any thoughts on this, Please share.

    USE [master]

    GO

    ALTER AVAILABILITY GROUP [MYAGNAME]

    ADD LISTENER N'MYSQLLISTENER' (

    WITH IP

    ((N'172.xx.x.xx', N'255.255.254.0')

    )

    , PORT=1433);

    GO


    Error details:

    Msg 41009, Level 16, State 7, Line 3

    The Windows Server Failover Clustering (WSFC) resource control API returned error code 5057. The WSFC service may not be running or may not be accessible in its current state, or the specified arguments are invalid. For information about this error code, see "System Error Codes" in the Windows Development documentation.

    Msg 19476, Level 16, State 3, Line 3

    The attempt to create the network name and IP address for the listener failed. The WSFC service may not be running or may be inaccessible in its current state, or the values provided for the network name and IP address may be incorrect. Check the state of the WSFC cluster and validate the network name and IP address with the network administrator.

    Msg 19476, Level 16, State 1, Line 3

    The attempt to create the network name and IP address for the listener failed. The WSFC service may not be running or may be inaccessible in its current state, or the values provided for the network name and IP address may be incorrect. Check the state of the WSFC cluster and validate the network name and IP address with the network administrator.

    Thanks!

  • Hi

    AG Listener creation failure is typically due to lack of permission for the Cluster Name Object (CNO) in Active Directory. Approach your Active Directory Administrator and request for permissions "Read all properties" and "Create Computer objects" to the CNO via the container.

    Please refer to the following links

    https://support.microsoft.com/en-au/help/2829783/troubleshooting-alwayson-availability-group-listener-creation-in-sql-s

    https://blogs.msdn.microsoft.com/alwaysonpro/2014/03/25/create-listener-fails-with-message-the-wsfc-cluster-could-not-bring-the-network-name-resource-online/

  • SQL!$@w$0ME - Sunday, September 3, 2017 9:35 AM

    Hi Folks,

    I'm using the following script to create AG listener. But it failed. Error has been attached. Any thoughts on this, Please share.

    USE [master]

    GO

    ALTER AVAILABILITY GROUP [MYAGNAME]

    ADD LISTENER N'MYSQLLISTENER' (

    WITH IP

    ((N'172.xx.x.xx', N'255.255.254.0')

    )

    , PORT=1433);

    GO


    Error details:

    Msg 41009, Level 16, State 7, Line 3

    The Windows Server Failover Clustering (WSFC) resource control API returned error code 5057. The WSFC service may not be running or may not be accessible in its current state, or the specified arguments are invalid. For information about this error code, see "System Error Codes" in the Windows Development documentation.

    Msg 19476, Level 16, State 3, Line 3

    The attempt to create the network name and IP address for the listener failed. The WSFC service may not be running or may be inaccessible in its current state, or the values provided for the network name and IP address may be incorrect. Check the state of the WSFC cluster and validate the network name and IP address with the network administrator.

    Msg 19476, Level 16, State 1, Line 3

    The attempt to create the network name and IP address for the listener failed. The WSFC service may not be running or may be inaccessible in its current state, or the values provided for the network name and IP address may be incorrect. Check the state of the WSFC cluster and validate the network name and IP address with the network administrator.

    Thanks!

    Is the WSFC cluster online?

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

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • Ricky Valencia - Sunday, September 3, 2017 9:48 PM

    Hi

    AG Listener creation failure is typically due to lack of permission for the Cluster Name Object (CNO) in Active Directory. Approach your Active Directory Administrator and request for permissions "Read all properties" and "Create Computer objects" to the CNO via the container.

    Please refer to the following links

    https://support.microsoft.com/en-au/help/2829783/troubleshooting-alwayson-availability-group-listener-creation-in-sql-s

    https://blogs.msdn.microsoft.com/alwaysonpro/2014/03/25/create-listener-fails-with-message-the-wsfc-cluster-could-not-bring-the-network-name-resource-online/

    Thanks Ricky!

  • Perry Whittle - Monday, September 4, 2017 5:24 AM

    SQL!$@w$0ME - Sunday, September 3, 2017 9:35 AM

    Hi Folks,

    I'm using the following script to create AG listener. But it failed. Error has been attached. Any thoughts on this, Please share.

    USE [master]

    GO

    ALTER AVAILABILITY GROUP [MYAGNAME]

    ADD LISTENER N'MYSQLLISTENER' (

    WITH IP

    ((N'172.xx.x.xx', N'255.255.254.0')

    )

    , PORT=1433);

    GO


    Error details:

    Msg 41009, Level 16, State 7, Line 3

    The Windows Server Failover Clustering (WSFC) resource control API returned error code 5057. The WSFC service may not be running or may not be accessible in its current state, or the specified arguments are invalid. For information about this error code, see "System Error Codes" in the Windows Development documentation.

    Msg 19476, Level 16, State 3, Line 3

    The attempt to create the network name and IP address for the listener failed. The WSFC service may not be running or may be inaccessible in its current state, or the values provided for the network name and IP address may be incorrect. Check the state of the WSFC cluster and validate the network name and IP address with the network administrator.

    Msg 19476, Level 16, State 1, Line 3

    The attempt to create the network name and IP address for the listener failed. The WSFC service may not be running or may be inaccessible in its current state, or the values provided for the network name and IP address may be incorrect. Check the state of the WSFC cluster and validate the network name and IP address with the network administrator.

    Thanks!

    Is the WSFC cluster online?

    Yes Perry, cluster is online.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply