Accessing SQL Server 2000 databases via HTTP

One of the new features of Microsoft SQL Server 2000 is that it supports XML, so users can access XML-enabled SQL directly via HTTP
Server2000 database. The implementation method is described below.
System environment: Windows2000 Server (contains IIS) MS SQL
Server2000
Database: Classic database sample included with SQL Server2000: NorthWind
First, configure IIS and SQL
Server Virtual
Domains
1. New file directory
Open Windows Explorer, and under Inetpubwwwroot, create a new directory Northwind:
C:inetpubwwwroot Orthwind
Create a new 2 subdirectories under the Northwind directory: template and Schema:
C:inetpubwwwroot wind Emplate, for placing XML templates;
C:inetpubwwwroot Windschema, which is used to place the schema file.
2. Map Virtual directories for IIS
In the SQL program group, select Configure
SQL XML Support in
IIS, select New-> virtual path under the default site, and then make a five-step standard configuration.
(1) in the "General" page, enter the virtual path name "Northwind" and map to the actual hard drive path, as shown in the figure.

alt= "" "Hspace=0 src="/upimg/20070212/11g214qpef1nw.jpg "Align=baseline
Border=0>

(2) in the "Security" page, select the appropriate login account number and password. In this case, the SYSTEM account SA is used, as shown in the figure.

Align=baseline border=0>

(3) on the Data Source page, select SQL
Server name or IP address, and select the database, as shown in the figure.

Align=baseline
Border=0>

(4) on the Settings page, select Allow URL query, allow template query, allow XPath, and allow post, as shown in the figure.

Align=baseline border=0>

(5) in "Virtual
Names page, define template, schema, and DBObject, and specify the actual hard drive path, as shown in the figure.

Align=baseline border=0>

Then, identify and close the window. The results are as shown.

Align=baseline width=500
Border=0>