none
Sql Server Mirror port no RRS feed

  • Question

  • Hi All,

    Sql Server Port no is 1433 and principal,mirror port no is 5022, 5023 on mirroring. can we configure mirroring using 1433,1434 Instead of 5022 and 5023?


    Raveendra

    Monday, May 28, 2012 6:17 AM

Answers

  • Hi Raveendra,

    The TCP port number for database mirroring endpoint uniquely identifies a specific server instance. You can specify the port number by manual other than the default one, but it must be the one not used by any other applications. Since 1433 and 1434 are dedicated to SQL Server default instance and SQL Brower, they cannot be used for database mirroring.


    Stephanie Lv

    TechNet Community Support

    • Marked as answer by Stephanie Lv Monday, June 4, 2012 8:03 AM
    Tuesday, May 29, 2012 5:38 AM
  • Hi!

    Being a bit more precise, based on Stephanies comment: You can of course specify any port whatsoever for DB mirroring, as long as the port is not used by something else. So if you don't need the SQL Browser you can of course disable it and use 1434 for mirroring. If your SQL Server does not listen on port 1433 (or only listens on 1433 on one specific IP) you can of course also use 1433 for mirroring (or 1433 on any IP other than the one that SQL uses.) The question is: Why would you?

    Lucifer

    • Marked as answer by Stephanie Lv Monday, June 4, 2012 8:03 AM
    Tuesday, May 29, 2012 6:48 AM

All replies

  • 5022 and 5023 are mirroring endpoints no? This endpoint needs to be able to bind to the specified port. Do you see in the error.log that mirroring instance listens on 5022 port?

    Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/

    Monday, May 28, 2012 6:33 AM
  • Hi Raveendra,

    The TCP port number for database mirroring endpoint uniquely identifies a specific server instance. You can specify the port number by manual other than the default one, but it must be the one not used by any other applications. Since 1433 and 1434 are dedicated to SQL Server default instance and SQL Brower, they cannot be used for database mirroring.


    Stephanie Lv

    TechNet Community Support

    • Marked as answer by Stephanie Lv Monday, June 4, 2012 8:03 AM
    Tuesday, May 29, 2012 5:38 AM
  • Hi!

    Being a bit more precise, based on Stephanies comment: You can of course specify any port whatsoever for DB mirroring, as long as the port is not used by something else. So if you don't need the SQL Browser you can of course disable it and use 1434 for mirroring. If your SQL Server does not listen on port 1433 (or only listens on 1433 on one specific IP) you can of course also use 1433 for mirroring (or 1433 on any IP other than the one that SQL uses.) The question is: Why would you?

    Lucifer

    • Marked as answer by Stephanie Lv Monday, June 4, 2012 8:03 AM
    Tuesday, May 29, 2012 6:48 AM
  • Hello Ravi,

    If you are configuring Database Mirroing on a Single Server, between two different instances then you normally require two different ports. However, if you want to configure Database Mirroring between two different servers, you can use the same port on both the servers for endpoint communication.

    Is there any specific reason, why you want to use the port 1433/1434? As mentioned by the other Experts, you can pick any unused port on the server.


    SKG: Please Marked as Answered, if it resolves your issue. (b:http://sudeeptaganguly.wordpress.com )

    Wednesday, May 30, 2012 6:44 AM