Lempster (5/10/2013)
On the mirror, did you also add the user as a member of the db_datareader and db_datawriter roles when you created it?
You didn't specifically answer my second question. Did you add the user to the two roles?
Also, are you using a Witness server and failing over automatically or are you invoking a manual failover?
Regards
Lempster