RE: VB apps connecting directly to SQL 2000 via Internet

From: Eric Yang [MS] (ericyan@online.microsoft.com)
Date: 09/06/02 

From: ericyan@online.microsoft.com (Eric Yang [MS])
Date: Fri, 06 Sep 2002 02:15:10 GMT

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: .NET
    ... >> know a lot better than Thomas on the subject. ... > Microsoft changing the fact that the message from Microsoft a few years ... claim that "SQL Server was going to be a .Net app"? ... Microsoft Unveils Vision for Next Generation Internet ...
    (borland.public.delphi.non-technical)
  • Re: VB apps connecting directly to SQL 2000 via Internet
    ... Jeremy Byrski ... > the component will talk directly to the SQL Server. ... > 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: SQL Server Transaction Log Viewer
    ... SQL Server could not provide such ... Lumignet's Log Explorer for SQL Server is one of the famous ... Microsoft is providing this information as a convenience to you. ... software found on the Internet, and Microsoft cautions you to make sure ...
    (microsoft.public.sqlserver.tools)
  • RE: secure sql server 2000 over the internet
    ... user to connect to SQL Server when they VPN to SBS. ... configure the server publishing rules to open the ports to the internet. ... Publishing a SQL Server Computer with ISA Server 2004 ... Microsoft CSS Online Newsgroup Support ...
    (microsoft.public.windows.server.sbs)
  • PASS/TechNet SQL Server security chat tomorrow w/great hosts
    ... SQL Server Security Architecture and Best Practices ... Whether your SQL databases are accessed from the Internet or used ... Girish Chander, Microsoft, Program Manager for Security in SQL Server ...
    (microsoft.public.sqlserver.security)