SQL Login Account Fails to Login After Failover

Discussion in 'microsoft.public.sqlserver.clustering' started by Greg, May 8, 2009.

  1. Greg

    Greg Guest

    Current Environment:
    SQL 2005 Enterprise x64 SP2 Active / Passive cluster running on Windows
    2003 Server.

    Problem:
    Need to apply OS patches and SP3.

    Symptoms:
    When the SQL instance is running on node 1 of the cluster my SQL Login
    account runs normally. When the SQL instance is failedover to node 2 the
    following error is displayed.

    "The user is not associated with a trusted SQL Server connection."

    I've verified that the server is running mixed mode authentication.

    We normally failover the cluster for OS patches to reduce (darn near
    eliminate) downtime during the patch process. Obviously SP3 will require a
    reboot, so downtime is inevitable with that. Node 2 has been successfully
    patched, we just need to failover and patch Node 1 before apply the SQL SP.

    Any guidance will be appreciated.
     
    Greg, May 8, 2009
    #1
    1. Advertisements

  2. Verify that the SQL Service on both nodes is running on the same domain
    account.

    Also check that the cluster service accounts match across all nodes.

    Finally, check domain account memberships for the SQL Specific
     
    Geoff N. Hiten, May 8, 2009
    #2
    1. Advertisements

  3. Greg

    Greg Guest

    Thanks for the reply.

    The service is using the same domain account on both nodes.

    "... for the SQL Specific" what?
     
    Greg, May 8, 2009
    #3
  4. Greg

    Linchi Shea Guest

    From my own experience, this is most likely an AD issue. But I'm curious
    whether you have found the root cause in your particular case.

    Linchi
     
    Linchi Shea, Jun 2, 2009
    #4
  5. Greg

    Greg Guest

    No, the root cause of the problem has not yet been identified. Thanks for
    the AD pointer, i will look there when I have time, and the Domain Admin
    isn't looking. ;)
     
    Greg, Jun 5, 2009
    #5
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.