Cannot open user default database. Login Failed (Microsoft SQL Server, Error: 4064)

I don’t know exactly what caused this, but today I tried to start SQL Server 2005 Management Studio, and got the following error: Cannot open user default database.  Login Failed (Microsoft SQL Server, Error: 4064)

• When the “Connect to Server” dialog comes up, choose the Options>> button 
• Next to “Connect to database:” type in “master” rather
  Posted at 12pm on 12/30/08 | 1 comment | Filed Under: SQL Server 2005 read on