Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

.net failover partner

Options
  • 23-10-2007 11:05am
    #1
    FindingNemo
    Closed Accounts Posts: 345 ✭✭


    If you have sql 2005 database mirroring set up with automatic failover,
    and you have a .net application reading from the db, is the only thing you need in your connection string "failover partner = xxxxxx" for the app to continue working ?
    Is there anything else I need to know ?


Comments

  • Options
    #2
    Ginger
    Registered Users Posts: 2,931 ✭✭✭Ginger


    Make sure that you have your logins correct on both servers... Mirroring is on a per DB rather than server basis. SO make sure that the login that you are using can access the database on both servers

    Also make sure that the keyword you are using, is the correct one for the type of connection string you are using


  • Options
    #3
    FindingNemo
    Closed Accounts Posts: 345 ✭✭FindingNemo


    Ginger wrote: »
    Make sure that you have your logins correct on both servers... Mirroring is on a per DB rather than server basis. SO make sure that the login that you are using can access the database on both servers

    Done this
    Ginger wrote: »
    Also make sure that the keyword you are using, is the correct one for the type of connection string you are using

    Not sure what this means ?

    Thanks


  • Options
    #4
    Ginger
    Registered Users Posts: 2,931 ✭✭✭Ginger


    Depending on the connection string, the keyword failover partner may or may not have a space in it. Thats all...

    In ODBC its Failover_Partner and ADO is Failover Partner


  • Options
    #5
    FindingNemo
    Closed Accounts Posts: 345 ✭✭FindingNemo


    ah cool, gotcha, thanks for the reponses.

    what line of work are you in anyway Ginger, you seem very thorough and knowledgable

    I'm guess IT anyway !!!!!!!!!!!!!!!!!!!!!!:cool:


Advertisement