I have trouble setting up mirroring sessions on SQL 2005 servers (high availability : principal+mirror+witness).
When I use the "sa" login in my ADO connection string, failover mgnt is fine : my app switches from the principal to the mirror (the new principal).
When I connect with a "foo" login, nothing works and my app doesn't switch, even as "foo" can access read/write to the mirrored database on the principal.
When I do a "SELECT * FROM sys.endpoints" connected as "foo", I can't see my endpoint, which may be a clue to the solution.
The problem is the mirroring assistant doesn't ask me to set rights to "foo", and I think it works with "sa" only because "sa" is ... well, "sa".
What can I do to allow "foo" to be a legitimate mirroring user ?
Thank you for your help.
When I use the "sa" login in my ADO connection string, failover mgnt is fine : my app switches from the principal to the mirror (the new principal).
When I connect with a "foo" login, nothing works and my app doesn't switch, even as "foo" can access read/write to the mirrored database on the principal.
When I do a "SELECT * FROM sys.endpoints" connected as "foo", I can't see my endpoint, which may be a clue to the solution.
The problem is the mirroring assistant doesn't ask me to set rights to "foo", and I think it works with "sa" only because "sa" is ... well, "sa".
What can I do to allow "foo" to be a legitimate mirroring user ?
Thank you for your help.
