Today I had a weird issue, I could not log into SQL Management studio because my default database had been deleted (it was no longer needed). Every time I would try to log in, I would get the following dialog.
At first I was kind of stumped, I did not know what to do other then email the DBA to ask him to re-map my account to another database. Then it hit me, there has to be a way to change databases. Sure enough there was a way, but it did not work the first time I tried it.
When I tried to select a new database from the drop down I got the following error message.
Now I was stumped on what to do, then it dawned on me. Simply type the name of the DB I wanted to connect to in the drop down, don't try to 'select' it. That worked..... YEA
Hopes this helps someone else in the future.
Till next time,
02-19-2008 7:01 AM