Re: Access to SQL over web

I can do this for you, take this conversation offline,
I am in the UK and my office number is 02084017000 or use my email address
to email me.

--
Regards

Alex White MCDBA MCSE
http://www.intralan.co.uk

"Justin Hoffman" <j@xxxxx> wrote in message
news:d6b1l0$e6t$1@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> "Alex White MCDBA MCSE" <alex@xxxxxxxxxxxxxx> wrote in message
> news:%23%23HGb9LWFHA.3620@xxxxxxxxxxxxxxxxxxxxxxx
>> Hi Justin,
>>
>> VPN comes in several flavours, e.g. software,Hardware then pptp (non
>> certificates), L2TP (with certificates), if your hosting company was
>> running either Windows 2000 or 2003 server, then setting up RRAS (the
>> technology that allows for VPN connections). At a very basic level you do
>> not need any hardware other than the Windows 2000/3 server an internet
>> connection and Windows 2000 pro/server Windows XP at the client end.
>> Software level vpn implemented on MS software uses either Windows
>> authentication or RADUIS (what all the DSL providers use to authenticate
>> their DSL users).
>>
>> It is true to say that L2TP that uses certificates as part of it's
>> security is much better than PPTP in terms of security, but is much
>> harder to setup.
>> I understand VPN well enough to do my job, which includes connecting to
>> 100+ servers every single day via VPN to support and review them and to
>> then connect to PC's local on those networks.
>>
>> VPN does come with problems, like you have unhindered access to the
>> remote network, and if you had a virus it is very easy for that virus to
>> travel through the tunnel unhindered. Given my last comment if all your
>> remote computers are running Windows XP SP2, with a good virus product
>> then this is a good solution.
>>
>> Software VPN's do solve a lot of business problems, there are
>> advantages/disadvantages of both hardware and software VPN's, but to move
>> data sync'ing with a SQL server, Access MDB the idea does work, I have
>> several clients who I have custom written VPN connection software bound
>> into access within a module to auto dial and sync data.
>>
>> One of the major problems of exposing a SQL server directly on the web is
>> this what type of security is going to be used, SQL logins/Windows
>> Authentication. With SQL login's there are no lockouts based on getting
>> the password wrong x times, Windows Authentication, it means configuring
>> users on that server for each independent user.
>>
>>
>> --
>> Regards
>>
>> Alex White MCDBA MCSE
>> http://www.intralan.co.uk
>>
>
> Thanks for that. I wonder whether other hosting companies allow access to
> their SQL databases directly across the internet. Whenever these hosting
> companies mention SQL Server databases - this is one aspect they never
> seem to specify. Certainly fasthosts.co.uk did allow this and it mad it
> pretty handy for me and since the data was not sensitive and was only a
> published copy of our lan data, I didn't really have concerns. I guess
> other hosting companies must do similar things, but have not done much
> shopping around.
>


.

Relevant Pages

  • Re: Windows Authentication in asp.net 2005 to SQL Server?
    ... If the domains do not trust each other, Windows authentication is not going ... Basic authentication sometimes makes the need for Kerberos delegation go ... generic account to do the backend data stuff on our SQL Server. ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: Remote connection failed
    ... If you are going over a remote connection or are not logging ... into the domain where SQL Server is then no, Windows ... authentication won't work. ...
    (microsoft.public.sqlserver.connect)
  • Re: Changing passwords / Blocking SA login attempts
    ... I went into the Server Config properties and changed to Windows ... My login for Start and Run SQL server was in this format. ... I am supposing this was an SQL authentication, ...
    (microsoft.public.sqlserver.security)
  • Windows Authentication with IIS on separate machines
    ... Yes, setting Basic Authentication in IIS works, but the ... >in SQL server but doesn't work if user account was ... >imported from a Windows account. ...
    (microsoft.public.sqlserver.security)
  • Re: server authentication & ASP authentication
    ... on to the client workstation with an authorized Windows account. ... SQL Server with Windows authentication. ...
    (microsoft.public.sqlserver.security)
Loading