28 reputation
3
bio website
location New Jersey
age
visits member for 2 years, 1 month
seen Apr 1 at 13:28

Apr
16
awarded  Popular Question
Oct
5
comment SQL Server ODBC Mirror/Failover Partner
Ok so the only way to do this on 2008 R2 is to manually create and monitor the accounts on the mirror?
Oct
4
comment SQL Server ODBC Mirror/Failover Partner
Thanks Max, it turned out that simply supplying the mirror server name in the ODBC client dialog (my screenshot in the question) allowed us to fail over correctly. The issue turned out to be not having user permission on the mirror server. Our database is mirrored but the user accounts are not. Maybe this can be solved by mirroring the system databases?
Oct
4
awarded  Scholar
Oct
4
accepted SQL Server ODBC Mirror/Failover Partner
Sep
5
awarded  Student
Aug
22
asked SQL Server ODBC Mirror/Failover Partner