title: Cannot open user default database. Login failed. SQL 2005
body: <p>I have taken a copy of a database home with me so I can do some testing. However when I try to run a stored procedure I get Cannot open user default database. Login failed.. </p>
  
  <p>I have checked and checked and checked I can open tables in the databases login to sql management studio and access the default as well as other databases any ideas?</p>
  
  <p>Possibly a corrupt user it was from sql 2000 at work to 2005 at home</p>