So I signed up for Windows shared hosting a few months ago.  Through a one month testing period, and another month live, I connected to the SQL server database remotely.  When talking to tech support about various issues it was made clear how I was connecting to the database, and at one point they even gave me recommendations on software I could use to import remotely.

Two weeks ago they shut off my ability to connect remotely because "it was a glitch" and shouldn't have been allowed in the first place.

My hosting is now worthless to me, as the SQL web admin stuff they have through Plesk is absolutely unusable for what I do.  I went back and forth with tech support and eventually they just said "too bad, can't help you"

There is a lot of expense that goes into transfering a live website.  The website is my job, and how I make a living..  transferring websites around takes a lot of time.  I went through a one month testing period to make sure I wouldn't have to move again..  this after testing for a month each on two other hosts that I ruled out.

So my options are move again or pay 5x more for hosting.

Apparently VPS hosting is a self-managed sort of thing..  On top of everything else I do I have to become a server admin (which isn't made clear on the sales portion of the website, only when reading posts in the forums).  If I don't want to be a server admin I have to pay even more for the hosting?

I get sucked in to what I percieve to be a perfect situation at a good price only to have it pulled out from under me and presented with an alternative that costs 6X more.

Thanks.  I guess.

As angry as this post seems (it seems angry because it is), there is a legitimate question:  What am I suppose to do?

Support didn't say to "do" anything.  Support said (and I'm paraphrasing, and perhaps editorializing)  I'm sorry you've spent so much time and money transferring your website to our hosting under the impression that the method you have used (and the only reasonable method) for maintaining your database we will no longer allow you to use.  It was our fault, you shouldn't have been able to remotely connect to the database before, and we're sorry that you relied on that when setting everything up. 

That was basically it.  They didn't even suggest VPS.  That was sales when I called them.  When I was testing I avoided hosting providers that would not let me connect remotely..   and here I am.  I'll post a ticket number when I get back in.

Hi FarquarQuoc,

I am sorry to hear about this situation. Although what would be our live, if we don't have make choices. Have you tried the MyLittleAdmin scripts at http://lesuth.lunarpages.com/mylittleadmin3/ which has much more functionality than the web MSSQL management script provided with Plesk?

Hello,


I apologize, if it sounded like that, there was no such intention. Remote access to MSSQL from Internet is disabled on all MSSQL servers setup for shared accounts for security purposes and, when it was found that it is not on the server you use, this was fixed.


A lot of scripts for catalogues have a feature to search items by some characteristic for modification. If your example is the only operation you need to have remote MSSQL access for, did you consider realizing the same feature for your site as this appears to be a cheaper solution than upgrading or moving and will allow you to do the modification from any computer even without MSSQL management software as well as program the most frequent updates for quick lunch.