Login sometimes failing immediately after restoring a database
- by Ian Ringrose
We have a set of automated tests that restore a database then run some .net code against the database. Sometimes after the database is restored the login from Ado.net fails. If I re-run the test, then the restore and login works OK. The restored database looks OK when viewed with Management Studio.
This is only an problem on some machines. …