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.
We are using SQL server 2008.
Is there a known issue with a database restore “returning “ a very short time before the restored database is up and running.