Re: MSSQL servers - no longer open to outside on new and old will be set this way soo
main reason we haven’t done is google. Anywhere we map IPs google will pick them up.
I like the idea, but we have been very cautious, even putting the network status post with the mappings to customer only after 48 hours public.
Re: MSSQL servers - no longer open to outside on new and old will be set this way soo
I see, that’s understandable. But still, you could make a specific thread for reference material like that, even if it’s just has one long post. Restricted to customers only.
It would be useful. First post is the reference material, and customers can post ideas for additions after that, which are then added to the first post. Just an idea. 
It would really be useful having one page to read for all those little things we need to remember.
Re: MSSQL servers - no longer open to outside on new and old will be set this way soo
Agreed, maybe a customer only Knowledgebase?
Re: MSSQL servers - no longer open to outside on new and old will be set this way soo
Well, doesn’t have to be anything complicated. You already have customer-only forums, so just a single stickied thread in there would be enough for now I think. Then perhaps a link to it on your main support page so people know it’s there.
That would, imo, be better than a “searchable knowledgebase”, since it’s a case of you don’t know what you don’t know. So much better just as a page of info to read. It’s not that much.
Coz you see I didn’t even know about that mssql backup page you have (eg. mssql3.g********.com/mssql/Backup.aspx) - only discovered that thanks to virtual’s question a few posts back. Is there also a restore page?
That’s a friggin awesome service, it means we can hand over db backup responsibility to clients! Well done, I haven’t seen that in any other hosting provider. One suggestion is that you zip up the bak file before sending to the browser, and allow zipped ones to be uploaded for restore. Bak files tend to compress a lot, so it would save time and bandwidth.
Re: MSSQL servers - no longer open to outside on new and old will be set this way soo
I also noticed that cluster 1 doesn’t seem to have the backup/restore page. I tried:
http://mssql5.m****here.biz/mssql/Backup.aspx
No luck.. is there one for cluster 1 dbs?
Re: MSSQL servers - no longer open to outside on new and old will be set this way soo
CL1 has them as well but will be more standardized after migration.
http://mssql5.jodoshared.com/mssql/Backup.aspx
Use your service domain for it.
It only does Dbs up to about 50MB on restores however, backups up to about 150..and it doesn’t yet work on Windows 2008 R2, so mssql4 on CL2 doesn’t work 
I did that before I knew of issues on it.
Re: MSSQL servers - no longer open to outside on new and old will be set this way soo
Great, thanks. More than thanks, it’s an awesome function! Pity about the upload size restriction but probably would be quicker just to zip it up and send to support for a restore. Just FYI, for some reason browsing to that url just sits there for about 30 second before the page comes up. The cluster 2 ones seem fine.
[ed] 2 more FYI’s:
Re: MSSQL servers - no longer open to outside on new and old will be set this way soo
1a correct the logo is on g******** only, and really just a sample
2. the logo is a configuration by host header and it doesn’t accept a blank one, so you have to configure for any url hitting it, a pain to be useful
Re: MSSQL servers - no longer open to outside on new and old will be set this way soo
Just wondering.. I’ve found that using MS SQL Mgmt Studio with those proxy servers is slower than when I was connecting to the db servers directly. Is there any way to speed up response times a little? Connecting, modifying tables, etc. takes much more time as it’s communicating back and forth with the servers. Any improvements which could be made there would be much appreciated. It’s not terrible, but definitely slower than before.
Re: MSSQL servers - no longer open to outside on new and old will be set this way soo
http://mssql4.g********.com/mssql/Backup.aspx
mssql4 has java script error other wise backup is working, i have open ticket [JH #KLN-18155-236] but that java script error on download click is not resolved yet. If i bypass JavaScript error using firebug i can download backup.
http://mssql1.g********.com/mssql/Backup.aspx
After migration mssql1 backup is still broken
Does not download backup, it submit page and just display same screen again with no error message and no download.
Re: MSSQL servers - no longer open to outside on new and old will be set this way soo
thanks for the info, I wasn’t aware that mssql4 was working to that point.
MSSQL1 I will check as well, it is a bit hard for us to debug these sometimes as we don’t have a direct user login to test on them, I’ll check it out and let you know an update.
Re: MSSQL servers - no longer open to outside on new and old will be set this way soo
I’ve also run into a problem with the backup page. The resulting bak file refuses to restore to my local instance.
Started a separate thread about it here..
http://support.jodohost.com/showthread.php?t=22267
Re: MSSQL servers - no longer open to outside on new and old will be set this way soo
I can’t seem to get http://mssql4.g********.com/mssql/Backup.aspx working, is there a workaround? virtual states a few posts back that he got backup working on mssql4. Can anyone describe how did he got it working?
Re: MSSQL servers - no longer open to outside on new and old will be set this way soo
He disabled the javascript that prevents the button form being clickable. It is embedded in a precompiled file, and I am trying to get it resolved but not my code to fix.
Re: MSSQL servers - no longer open to outside on new and old will be set this way soo
@Stephen → I can help to fix script if you can share it with me.
In fact long time back i had offered help to add Zip function to backup for faster backup download.
Ok, what i was doing was hack it is not permanent solution, i spent some time and found actual issue for mssql4 is file
http://mssql4.g********.com /mssql/ajax/_Backup,App_Web_backup.aspx.cdcab7d2.ashx
is missing
it is available for http://mssql3.g********.com /mssql/ajax/_Backup,App_Web_backup.aspx.cdcab7d2.ashx.
Checkout what you have missed to copy at mssql4, there is nothing required to be fixed in script it is issue of some missing file.
Re: MSSQL servers - no longer open to outside on new and old will be set this way soo
I’m unable to get to any of my databases on mssql12 via Visual Studio this morning. What is the new method for connecting to them since I see you migrated them last night.
Re: MSSQL servers - no longer open to outside on new and old will be set this way soo
the redirect for it will be done shortly.
Re: MSSQL servers - no longer open to outside on new and old will be set this way soo
Hi Stephen,
Thanks for getting redirect done. And for this mssql12, does it run SQL2005 or SQL2008 now?
Regards, Jan-Pieter
Re: MSSQL servers - no longer open to outside on new and old will be set this way soo
I have updated the list with MSSQL4 and MSSQL12 CL1 redirect ports.
It still runs 2005, MSSQL13 which is just launched runs 2008 R2.
Web backup/restore still isn’t done on MSSQL12, that is a task to handle today.
Re: MSSQL servers - no longer open to outside on new and old will be set this way soo
Not trying to be a stickler, but this should really be a sticky.