Post reply

connection strings in case of failover

  • May 13, 2012 at 9:11 pm

    #257884

    Hi All, I am so confused about configuring connection string when we want to configure db mirroirng or replication. how application will detect that it needs to send the connection to new (failover) server? might be a silly questions for all the gurus out there... please advise

  • May 14, 2012 at 2:52 pm

    #1487399

    Your connection string should have a failover partner parameter in the connection string if you are connecting with ADO.Net or SQL Native Client. Replication does not have that type of parameter in the connection string.

    A quick google search shows you how to connect. http://www.connectionstrings.com/sql-server-2005

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

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