Web Application Connection to Mirrored Database RRS feed

  • Question

  • I know this is a deprecated feature but we are interested in using SQL Mirroring use SQL 2012 Standard for some in house web applications. My developer came from a place where he just used a SQL Cluster IP to configure his web applications to connect to. How is this done in a mirrored database for the application to be aware of the mirrored server and database? I have searched the forums and I haven't found a definite answer yet. Thanks for any assistance!
    Thursday, September 22, 2016 2:16 PM


  • Hi BoomChuck,

    To make the application aware of database mirroring, you will need to specify failover partner attribute as well as server name in connection string. I would suggest you review BOL for more detailed instructions.

    If you have any other questions, please let me know.

    Friday, September 23, 2016 5:51 AM