Please correct me if this is a wrong forum for this question.
i am not sure if this is a sql problem or it is by design but this is what we are currently having:
We have a database mirroring setup (between server1 and server2) and all works fine when the database runs on the server1. The original intend was to always run this database as a Prin***l on server1.
But, when the database fail over to server2 we are seeing lot's of errors (Msg 18456, Level 14, State 1, Server , Line 1 Login failed for user '' ) on server1 but not on server2 (now Prin***l) and the application continue to work without any problems.
The question is why we are seeing the login failed errors on the server1?
Is this by design that application still think that this database is still located on server1, then tried to connect to server1 and if it can't connect then it tries to connect to server2?