[dba-Tech] VPN on a virtual Windows 2008 server...and RemoteDesktop

Steve Erbach erbachs at gmail.com
Wed Jan 18 15:44:33 CST 2012


I have some familiarity with IronSpeed. As I think over the possibilities,
converting it all myself is a very desirable prospect.  Even though
IronSpeed has excellent visuals, this is more of a query and reporting
application than a data entry application. There certainly is a data entry
component but its value comes from the data analysis and reporting.

Thank you very much for your comments.


Steve Erbach
Neenah, WI

On Wed, Jan 18, 2012 at 3:32 PM, Jim Lawrence <accessd at shaw.ca> wrote:

> Well I am very glad to hear that. I am well aware of the limits of a large
> commercial hosting site and they are very judicious on how much resources
> they dispense and the prices they charge.
> In the long run I have found if you or your company have long term goals
> and
> a solid business plan, it is best to invest at the start and roll your own.
> There are some application out there that promise to make the conversion of
> an Access project to web based easy. How good they are I would not know.
> http://tinyurl.com/7om8gdq
> http://tinyurl.com/7bbp4xq
> ..and thoughts about migration.
> http://tinyurl.com/6ouuask
> Starting a business up with no money is a very difficult process and a
> process in which no one gets paid for a while and might never get paid or
> they may just strike it lucky...those are the risks. (...have been there
> and
> done that a number of times...)
> The bottom line there is no cheap, fast with good results way to do this.
> Jim
> -----Original Message-----
> From: dba-tech-bounces at databaseadvisors.com
> [mailto:dba-tech-bounces at databaseadvisors.com] On Behalf Of Steve Erbach
> Sent: Wednesday, January 18, 2012 12:56 PM
> To: Discussion of Hardware and Software issues
> Subject: Re: [dba-Tech] VPN on a virtual Windows 2008 server...and
> RemoteDesktop
> Jim,
> We haven't painted ourselves into a corner.  My client -- the owner of the
> app I wrote -- was hoping to offer the application via the Internet without
> first having to convert it to an ASP.NET/SQL Server web app.  I've quoted
> him on that, but it was a bit high for his blood. It's been a while since I
> made that quote (3 years or so) and I know more about .NET and SQL Server
> so I'm going to re-visit it.
> One option is to continue marketing the application as a stand-alone or
> LAN-based Access app as it has been for years.  Of course, keeping everyone
> at the same revision level is a challenge.
> He recently left the company he was working for after 24 years due to
> re-org. Now he wants to devote his energies to this side business that he's
> had all these years. My app is a very large part of that. That's why he'd
> hoped (me too!) that we could do an interim "Internet" solution with Remote
> Desktop.
> I got confirmation from GoDaddy that the plan my client purchased (at my
> recommendation for about $41 a month) isn't sufficient enough to allow a
> VPN to be set up nor can Windows Remote Access Server be set up on it.
>  Have to upgrade to a full dedicated server at about triple the price. I
> think he should also hire a network guru to assist in setting up VPN and
> Remote Access...if we go that way.  What you said about the resource
> requirement is important.
> Thanks, Jim.
> Steve Erbach
> Neenah, WI
> On Wed, Jan 18, 2012 at 1:22 PM, Jim Lawrence <accessd at shaw.ca> wrote:
> > Hi Steve:
> >
> > I am a little late to this discussion so most has already been said.
> >
> > First: MS always has two term server connection, on their servers,
> designed
> > mostly for administration support. Any other terminal licenses must be
> > purchased separately.
> >
> > Second: I have not worked much with MS terminal services but have done a
> > bit
> > with Citrix (the MS terminal server core is Citrix) as related to some
> > large
> > clients (various banks). I have not been to the Toronto hosting sites but
> > have received a few pictures, from friends and the BE is huge. It takes a
> > lot of muscle to handle many remote sessions.
> >
> > Third: Hamachi is now owned by LogMeIn. I met with the owners of the
> > original company as they are from Vancouver. Hamachi works because it
> > accesses addresses and ports outside scan range (In the 5.xx.xx.xx range)
> > and these ports are usually not blocked by the hosting routers. The only
> > way
> > these ports can be setup, is to remote-in to remote your server, then you
> > install Hamachi and it then monitors the new port, it generates, allowing
> > remote access. Then the new port can be used for connecting. Note your
> > hosting company may have blocked the Hamachi working ports as that may be
> > considered a security violation.
> >
> > Aside: The DBA web site is in virtual drive and it is managed through a
> > secure Hamachi connection. Of course web sites are designed to handle
> > hundreds of sessions with minimal impact...thanks to IIS (or Apache).
> >
> > A question: Unless you remote host company is specifically setup to
> manage
> > multiple remote sessions, like a full terminal server installation, the
> > impact on their system would be dramatic or you remote performance would
> be
> > throttled down... I did not remember hearing if that is the type of
> hosting
> > you have purchased.
> >
> > I really do hope you have not painted yourself into a corner with this
> > contract but the good news is that there are alternatives but they are
> not
> > quick or easy.
> >
> > Jim
> >

More information about the dba-Tech mailing list