Post reply

Sintax Error when trying to change the mirroring for dedicated network through a specific IP

  • June 10, 2015 at 12:33 pm

    #301394

    Hello All,

    Could someone help us with following issue?

    We have a database in SQL Server 2008 R2 with mirroring and want that replication is done by dedicated network.We stop the endpoint and when we try to run the following command, syntax error occurred:

    Msg 102, Level 15, State 1, Line 1

    Incorrect syntax near '192.168.1.14'.

    Could anyone help in telling what is the correct syntax of the command line below?

    ALTER ENDPOINT Endpoint_Mirroring AS TCP (LISTENER_IP = '192.168.1.14')

    Regards,

    Antonio

  • June 10, 2015 at 12:56 pm

    #1804458

    Enclose the IP with parentheses instead of single-quotes.

    Cheers!

  • June 10, 2015 at 1:07 pm

    #1804464

    Hi,

    The command worked with your tip by placing the parentheses

    Thank you,

    Antonio

Viewing 3 posts - 1 through 2 (of 2 total)

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