Post reply

Availability Group Listener Port

  • October 26, 2014 at 7:20 pm

    #312076

    Hi,

    So I have Availability groups configured as well as the Availability Group Listener, what I would like to know if anyone has had any experience with it is if I want to change the port that the listener is listening on, do I need to reboot the server or is it dynamic across the board ?

    Hope this helps...

    Ford Fairlane
    Rock and Roll Detective

  • October 27, 2014 at 7:24 am

    #1754921

    after a port change i would restart the listener using

    ALTER AVAILABILITY GROUP group_name RESTART LISTENER ‘dns_name’

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

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

  • October 27, 2014 at 5:17 pm

    #1755068

    Thank you for the reply !!

    Hope this helps...

    Ford Fairlane
    Rock and Roll Detective

  • October 27, 2014 at 5:42 pm

    #1755071

    Please excuse my newbie question....

    ALTER AVAILABILITY GROUP N'Microsoft SQL Server (CLIENT-AGL-SOSS)' RESTART LISTENER 'RHSPSQLOC00-001'

    Msg 102, Level 15, State 1, Line 1

    Incorrect syntax near 'Microsoft SQL Server (CLIENT-AGL-SOSS)'.

    How would I reference the group name then ???

    Hope this helps...

    Ford Fairlane
    Rock and Roll Detective

  • October 27, 2014 at 6:26 pm

    #1755076

    Resolved..

    ALTER AVAILABILITY GROUP [Microsoft SQL Server (CLIENT-AGL-SOSS)] needed [ ]

    Hope this helps...

    Ford Fairlane
    Rock and Roll Detective

  • October 27, 2014 at 9:39 pm

    #1755084

    😉

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

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

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

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