Post reply

SQL 2k5 connection

  • August 2, 2007 at 11:37 am

    #179931

    Is there a tool to test connection strings to SQL2k5 mirrored databases?

  • August 3, 2007 at 9:03 am

    #724547

    Do you need to test the application's connection string to the mirror, specifying the failover or do you plan on retrieving the failover as part of the initial connection process?

    Do you have a witwness configured for automatic failover or do you plan on either manual sql failover or manual application reconnect to the failover?

     

    [font="Arial"]Clifton G. Collins III[/font]

  • August 3, 2007 at 9:21 am

    #724560

    I do have a witness configured for automatic failover.

    The application's connection string specifies the server & failover partner.

    When I set the database on the connection string's server to failover, the application isn't connecting to the Principal database on the connection string's Failover Partner.

    What I'm trying to do is determine if the connection string is the problem, or something in the application that I need to have our developers resolve. Hence my question about a tool to test the connection with. Retrieving data from either server isn't necessary, but confirming a connection was made is.

  • August 8, 2007 at 7:35 am

    #725431

    How is the connection string testing going?

    [font="Arial"]Clifton G. Collins III[/font]

  • August 8, 2007 at 7:53 am

    #725436

    I got it resolved. Problem was in the application.

    I created a web page to dynamically build a grid view, using a connection string that was exposed on the web page.

    Thanks

    BigSam

Viewing 5 posts - 1 through 4 (of 4 total)

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