No Failover and client crashes ODBC DSN Setting for Failover in connection String RRS feed

  • Question

  • We have set up Mirroring with a witness server and everything works fine when we failover from the SQL Management console.

    However, if we failover when our Maccola client is connected, the client blows up - clearly because it can no longer connect to the database.

    The ODBC DSN used by the Maccola client shows a checkbox for the 'select a failover server' but the checkbox is grayed out.

    Also the summary of settings for the DSN at the end of the wizard reveals that the failover to server (y/N) option is set to N.

    The default setting for this DSN is 'populate the remaining values by querying the server' but it doesn't appear to be getting the settings for failover from the server or any other interactive DSN settings either. The server is clearly set for mirroring.

    Another suspicious item is that the DSN cannot connect to the server with SA permissions, even though the server is set to mixed security and we use the correct authentication.

    Is it possible that the client MACHINE is not authenticating with the domain or sql server properly. We are logged into the client with the domain account that is the SQL admin account on the sql server box.

    We should be able to interact with the sql server settings through the ODBC DSN on the client shoulnd't we?

    Are we missing a service pack on the client?



    Saturday, March 3, 2007 6:08 AM

All replies

  • Have you referred to Maccola vendor in this case about the compatibility, I would guess this is to with that drivers.
    Monday, March 19, 2007 3:58 PM