Putting backend on to an ISP

[p]

I'm looking at the possibility of moving an Microsoft SQL Server
express database onto my ISP because when remote users log-in through
VPN they are getting kicked off sporadically etc. etc.

I have microsoft SBS R2 running the office and would think about
opening a port and exposing the sql database over IP but do not have a
full time IT staff that could deal with breakdowns/attacks etc. etc.
Would an ISP allow me to simply transmit my SQL data here to their
servers then re-link the users front ends with that of the ISP?

Could someone explain to me my options?

 

[Albert D. Kallal]

I'm looking at the possibility of moving an Microsoft SQL Server
express database onto my ISP because when remote users log-in through
VPN they are getting kicked off sporadically etc. etc.

Well, it not necessarily clear that using your ISP is going to work better.

however, you have to make sure you pick a ISP that supports your software.
Some ISP's use IBM webshere systems, some use Sun, some using Linux, and
some use Microsoft web servers.

Would an ISP allow me to simply transmit my SQL data here to their
servers then re-link the users front ends with that of the ISP?

They might if you were running a web based front end. Normally they don't do
that. And, if they *did*, it would likely be a vpn connection from your
system to their web server. And, again, I don't see how this would be more
reliable (and secure) then your current setup anyway.

However, you asking in the wrong newsgroup. This newsgroup is devoted to
Microsoft ms-access, the desktop database that ships with office. So, you
REALLY REALLY REALLY are asking the question in the wrong place.

I would suggest you phone and talk to your isp and see what they offer you.
Unfortunately, you not going to do this by the seat of your pants, and if
you don't have budgets and money to hire someone, you much wasting yours and
others peoples time.

 

[Sylvain Lafontaine]

A better idea would be to see why your users are getting kicked off
sporadically from the VPN. If you are presently using a software VPN, look
into the possibility of buying a physical box.

Most ISP will refuse to let you connect directly or indirectly to one of
their SQL-Server boxes; either through their firewall or by using a VPN.
Some will let you go through to it by using a VPN but at a much higher cost;
so solving your own VPN problems could be more cost effective in the long
term. However, ISP that will offer you access through a VPN will usually do
so with an installation good enough so that your users won't get kicked off
sporadically; so if all you want is to leave your problems behind - even at
an higher cost - this might be the perfect solution for you.

 

[Sylvain Lafontaine]

Also, if you are not actually using a commercial access for your own
internet access, many providers will automatically disconnect you at
(ir)regular intervals in order to try to lower down the bandwith
consumption. Maybe this is why your users are knocked out sporadically.

 

[David W. Fenton]

Could someone explain to me my options?

Well, if you had full Win2K3 Server instead of the crippled SBS, I'd
suggest Windows Terminal Server as a far, far better option.

But you don't, so I won't.

 

[Tony Toews [MVP]]

Well, if you had full Win2K3 Server instead of the crippled SBS, I'd
suggest Windows Terminal Server as a far, far better option.

But you don't, so I won't.

How is SBS crippled?

A friend happily purchased another copy of Win 2003 Server, added it
to his domain and users are hitting it from job sites all around
western Canada. Including, in some cases, cell phones.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[David W. Fenton]

How is SBS crippled?

You can't use it as a Terminal Server.

A friend happily purchased another copy of Win 2003 Server, added
it to his domain and users are hitting it from job sites all
around western Canada. Including, in some cases, cell phones.

It's not SBS, obviously.