I could not connect to my SQL Server DB hosted at webhost4life.
It was a real pain using the web based interface provided by webhost4life. I tried to check the online help files and opened a ticket with the help desk and did not get very far.
I wanted to backup the entire DB for a dotnetnuke upgrade to DNN V 3.1 and could not get this done via webhost4life's interface.
After 45 minutes of working with an agent on a ticker going back and forth I decided to poke around and found that the default database was not set. I found the following with a google search and microsoft had the answer posted.
WORKAROUND
If the user's default database no longer exists, or has been marked suspect, use the ISQL command line utility to change the user's default database to a database that is currently available for a connection.
| 1. |
At a command line prompt, type the following and then press ENTER: C:\>isql -E
|
| 2. |
At the isql prompt, type the following and then press ENTER: 1>sp_defaultdb 'user's_login', 'master'
|
| 3. |
At the second prompt, type the following and then press ENTER:2>go |
The user can now connect normally.