Cannot open user default database (HELP)

Hi!

I wanted to throw the database and replace it with a dump I created from another one.

So, in SQL Server Management Studio, I connected to my Database and applied the following command:

USE MASTER
GO
ALTER DATABASE SQL2008_832326_liveandes
SET SINGLE_USER WITH ROLLBACK IMMEDIATE;
DROP DATABASE SQL2008_832326_liveandes
GO

This returned an error.
Afterwards I saw the same DB but now it also said (Single User). The problem is, any action I try to do, like opening my application or just logging in, results in an error of "Cannot open user default database: login failed". Because of this, I can't create a restore for my database. What can I do now?

Any help would be greatly appreciated. Thanks!

 

If you are trying to alter your on-line DASP SQL Server DB remove 'USE MASTER'
I haven't tried but I'd be surprised if we can run DROP also.

 

Here's the thing:

I've tried to use the SQLServer 2008 Tools from the site and tried to make a restore from a bak file, but it tells me that the service has failed.
Heck, I even tried resetting the DB, but it says that the service is unavailable.

What can I do?

Thanks for the help!

 

Bummer. Another user in the forums recently posted the same problem.
Open a Support ticket from your Control Panel.
All the best,
Mark

 

Yeah, I already did

Somehow, the backup just worked, so we averted a serious crisis

Thanks for the help!
Jose