Derik Whittaker

Thoughts on Software Development, .Net, OOP, Design Patterns and all things cool

IOC(SM):MOC(RM):TDD(NU):SCC(Svn):ORM(L2S):XPP(-):XPP(+):DDD(T+)

How to Login to SQL Management Studio if your default database has been deleted.

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,

Published Feb 19 2008, 07:01 AM by Derik Whittaker

Filed under: sql2005, HowTo

Comments

DotNetKicks.com said:

You've been kicked (a good thing) - Trackback from DotNetKicks.com

# February 19, 2008 9:13 AM

Joe Webb said:

Nice tip. Thanks for sharing.

Joe

# February 19, 2008 12:28 PM

» Daily Bits - February 20, 2008 Alvin Ashcraft’s Daily Geek Bits: Daily links, development, gadgets and raising rugrats. said:

Pingback from » Daily Bits - February 20, 2008 Alvin Ashcraft’s Daily Geek Bits: Daily links, development, gadgets and raising rugrats.

# February 20, 2008 11:55 AM

PartialClass said:

:).. i needed that

# February 21, 2008 2:43 AM

Jack Daniels said:

default database name 'master'

# March 3, 2008 12:04 PM

Oxycontin vs. oxycodone. said:

Oxycodone and oxycontin. Compare oxycontin to oxycodone. Is oxycodone and oxycontin the same.

# November 8, 2008 2:55 AM

Name (required)

Your URL (optional)

Comments (required)

Remember Me?

Enter the numbers above:

Add

About Derik Whittaker

Derik is a .Net Developer/Architect specializing in WinForms working out the northern suburbs of Chicago. He is also believer and advocate for Agile development including SCRUM, TDD, CI, etc.

When Derik is not writing code he can be found spending time with his wife and young son, climbing on his bouldering wall, watching sports (mostly baseball), and generally vegging out.