Login failed database mirroring from application RRS feed

  • Question

    I have database mirroring set up on server A and Server B(sql 2005 sp3-9.0.4035)
    the database is principal on server- A and
    the database is mirror on server- B.
    We have one user 'test' with same SID on both servers.

    This 'test' user tries to connect to principal database
    from ADO.NET application.
    In the DSN file we have server A as principal

    from the front-end the process runs fine but it gives error saying
    'the server is not responding, try to connect to server failed.'
    when i check error log files on sql server i cant see any error msgs
    but i opened error log files on mirror server-B, I can see this error
    Error: 18456, Severity: 14, State: 16.
    Login failed for user 'test' [Client : 192.168.1.XXX]

    I search on state-16 but name of the db in DSN is correct and we didnt specify failover
    partner name in our DSN then why its going to server-B(mirror) and try to connect?
    How can I stop this problem?
    Friday, October 16, 2009 9:45 PM