So you are logged on to SQL Management studio.
The user you are logged in as has database X as the default database
Now you detach that database... and you are stuck - the connection fails, you can't do anything.
A warning would have been nice.
SOLUTION: Connect as another user and set the default database to something else then re-connect.