Re: VB apps connecting directly to SQL 2000 via Internet

From: Jeremy Byrski (Jeremy.Byrski.NosPAm@vico-solutions.com)
Date: 09/06/02 

From: "Jeremy Byrski" <Jeremy.Byrski.NosPAm@vico-solutions.com>
Date: Fri, 6 Sep 2002 09:15:29 +0100

Thanks for you help Eirc.

Best regards,
Jeremy Byrski

"Eric Yang [MS]" <ericyan@online.microsoft.com> wrote in message
news:gqNyfsUVCHA.1712@cpmsftngxa08...
> Dear Jeremy,
>
> It is not recommended to run the SQL Server with its port directly open to
> the internet. The file wall is needed.
>
> In these situations, the common practice is to host a middleware component
> in the IIS and let the clients communicate with the component instead, and
> the component will talk directly to the SQL Server.
>
> You might also consider using Microsoft Remote Data Services (RDS). RDS is
> a Web-based technology that uses Microsoft Internet Information Services
> (IIS) and special ActiveX controls to bind data from an SQL data source to
> data controls on a Web page. RDS is integrated with ADO technology. For
> more information about RDS, see the RDS documentation in the Microsoft
Data
> Access Components (MDAC) SDK, located in the Platform SDK in MSDN Online.
>
> In addition, the following article about RDS should be of some help to
you.
> http://support.microsoft.com/support/kb/articles/q183/2/94.asp
>
>
> Sincerely,
>
> Eric Yang [MS]
> Microsoft Online Support Engineer
>
>
> Please do not send email directly to this alias. This is our online
> account name for newsgroup participation only.
> This posting is provided 'AS IS' with no warranties, and confers no
rights.
> Get Secure! - www.microsoft.com/security
>
>
>

Relevant Pages

  • RE: VB apps connecting directly to SQL 2000 via Internet
    ... It is not recommended to run the SQL Server with its port directly open to ... You might also consider using Microsoft Remote Data Services (RDS). ... a Web-based technology that uses Microsoft Internet Information Services ...
    (microsoft.public.sqlserver.security)
  • Re: what does the "Microsoft data access" "remote data services" add-in do?
    ... Microsoft does have a component called MDAC (data access) ... RDS was soon exploited in its early version. ... You say this is a "generic warning IE7 ...
    (microsoft.public.security)
  • Re: exploiting BID 529
    ... The script below uses an unsecured RDS install to attack a SQL Server ... can do with the right driver / DSN combination. ... and exploit internal database servers (of ...
    (Pen-Test)
  • Re: RDS Security issues
    ... Lyle is. ... and you're talking about DAPs with Jet back ... RDS is simply not involved when the back end is SQL Server. ...
    (comp.databases.ms-access)
  • Re: Deploying DAPs
    ... RDS has now been deprecated by Microsoft some years ago because of ... BTW, at this point, the journey with DAPs will not get easier or faster ...
    (microsoft.public.access.dataaccess.pages)