Post reply

Mirroring Endpoint Port Number

  • November 30, 2012 at 9:11 pm

    #267084

    Dear,

    I want to configure database mirroring with automatic failover option. That is why I want to make my PC as Principal and another PC as Mirror (Default Instance) and Witness (Named Instance).

    Now my query is should the endpoints remain same or different?

    Please help me.

    Regards,

    Akbar

  • November 30, 2012 at 11:01 pm

    #1564622

    If you are talking physically different hardware (could be two separate VM's on the same box as well), then they can be the same. If the instances are on the same hardware, they need to be different.

  • December 1, 2012 at 4:55 am

    #1564634

    I am using one PC for Principal and other PC for Mirror and Witness. That means there are two different hardwares. One contain one instance and other contain two instances.

  • December 1, 2012 at 6:04 pm

    #1564661

    Knowing that one system has one instance of SQL Server installed (default instance?) and another has two instances installed (a default and a named instance?), we now need to know which instances are you trying to mirror databases?

  • December 1, 2012 at 9:57 pm

    #1564672

    Thank you Lynn Pettis.

    I want to configure mirroring default instance (Principal) to default instance (Mirror) and named instance will Witness. Principal will reside on one System and Mirror and Witness will reside on other system.

  • December 2, 2012 at 8:12 am

    #1564693

    The two default instances can use the same port value for database mirroring. The named instance on the second system has to use a different port since it is on the same physical hardware as the default instance.

  • December 2, 2012 at 10:58 am

    #1564702

    Thank you, Boss. I have tried in the way you mentioned. In configuring mirroring I left service accounts box blank. But when I click on Start Mirroring, I get an error message something like "The server network address “TCP://SQLServer:5023? can not be reached or does not exist. Check the network address name and that the ports for the local and remote endpoints are operational. (Microsoft SQL Server, Error: 1418)"

    I can not get the problem. Please help me.

  • December 2, 2012 at 9:08 pm

    #1564726

    See this link.

    http://www.sqlsoldier.com/wp/sqlserver/troubleshooting-atabasemirroringerror1418

  • December 3, 2012 at 2:22 am

    #1564766

    Now I have done.

    I have changed local service account to domain account and created domain account login with windows authentication. That's it.

    Thank you all.

Viewing 9 posts - 1 through 8 (of 8 total)

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