locked
Server Network Address on Clustered Instance RRS feed

  • Question

  • Hi,

    I am looking to configure database mirroring and as part of this need to specify the server network address. The primary instance is on a 2 node cluster and the mirror data base is on a separate instance on a standalone server. When creating the server network address on the clustered instance should i specify the hostname\IP address of the SQL cluster and if so do I need to do this on both nodes in the cluster?

    Thanks 

    Sunday, April 13, 2014 8:47 PM

Answers

  • Hello.

    You need to specify SQL server Virtual cluster name not specefic node IP or hostname.For outside application this virtual name acts as Single SQL server


    Please mark this reply as the answer or vote as helpful, as appropriate, to make it useful for other readers

    • Proposed as answer by Sofiya Li Monday, April 14, 2014 9:04 AM
    • Marked as answer by AllyRussell Monday, April 14, 2014 9:53 AM
    Sunday, April 13, 2014 10:27 PM

All replies

  • Hello.

    You need to specify SQL server Virtual cluster name not specefic node IP or hostname.For outside application this virtual name acts as Single SQL server


    Please mark this reply as the answer or vote as helpful, as appropriate, to make it useful for other readers

    • Proposed as answer by Sofiya Li Monday, April 14, 2014 9:04 AM
    • Marked as answer by AllyRussell Monday, April 14, 2014 9:53 AM
    Sunday, April 13, 2014 10:27 PM
  • Thanks Shanky_621, exactly what i was looking for.
    Monday, April 14, 2014 9:53 AM