Help moving MSSQL DBs from Reseller-Center

D

david3rd

Perch
I still have some clients at Reseller-Center. For the last week they have had horrible problems with their MSSQL servers. First they said it was due to a new drive and had to reset users for DBs. Then they said it was due to an "oddity" with RAID. Then they said it was hackers.

I am trying to move the rest of my clients here to Jodo. I spoke with a Jodo rep who said they could move my DBs for me. But I figure out how to do it myself via DTS.

Here's the problem: Reseller-Center has now blocked access to their MSSQL servers to internal only. This blocked Enterprise Manager (which I use daily to work). I tried the cute little MSSQL manager that comes with Hsphere but it is horribly limited and doesn't seem to do DTS or anything close to it.

Does anybody know how I could possibly move my database??? Help!!!!
 
If you can get BAK files, we can restore, being that external access is off, DTS won't work.

If all else fails, try to install the SQL Web Data administrator from microsoft and see if you can get the SQL dump in text format that way.
 
Thanks!! I'll try that ASAP.

I had gotten one site's DB moved over before they closed things down. However, when I change the connection string to the new jodo database for this client, I get the following:

Microsoft OLE DB Provider for SQL Server error '80004005'
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.

Would this be related to the way they've locked things down? It was working yesterday.
 
Pretty sure I had the correct address - it had been working before they locked it up.

I will take another look when the open it back up.

Thanks!
 
They sent out an email that they had disabled all remote access to the SQL servers and would remain off until the problem was fixed. Fortunately, the only DB I have left is one a client is using for testing purposes. Unfortumately, they can no longer test the latest changes because I don't have access to update the DB directly with the latest table modifications.

I wouldn't hold my breath about getting access back anytime soon.
 
You must log in or register to reply here.
Back
Top