Sql Backup And FTP

Welcome Guest Search | Active Topics | Log In | Register
New Topic Post Reply
Suddently cannot connect to database Options · View
Previous Topic · Next Topic
Guest
#1 Posted : Saturday, October 29, 2011 9:53:18 AM Quote
Rank: Guest

Groups:

Joined: 8/10/2009
Posts: 725
I've been using the scripted backup for a remote SQL Server database (hosted on a shared server) for several months. Suddenly, a few days ago, I started to receive "cannot open the default database" message. The one thing that always has troubled me is that I cannot specify the default database in my connection parameters, which seems to be the reason I'm having a problem.

does anybody have an idea of how to get around this?
Back to top
  |
mikeshilov
#2 Posted : Monday, October 31, 2011 9:56:51 AM Quote
Rank: Administration

Groups: Administrators

Joined: 8/12/2009
Posts: 271
When do you receive this error?
Back to top
 Report Abusive | Report SPAM
ruslan
#3 Posted : Monday, October 31, 2011 10:01:55 AM Quote
Rank: Administration

Groups: Administrators

Joined: 8/10/2009
Posts: 368
When you drop database that was your default - you get this problem. To fix it, run sp_defaultdb. BTW this has nothing to do with our program.
Back to top
 Report Abusive | Report SPAM
Quick Reply Show Quick Reply
New Topic Post Reply
Forum Jump  
You can post new topics in this forum.
You can reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You can create polls in this forum.
You can vote in polls in this forum.