Use the IIS virtual directory management utility for SQL Server

Use the IIS virtual directory management utility for SQL Server
Accessing Microsoft through HTTP? SQL Server? 2000 The appropriate virtual directory must be installed before the database is installed. In
On the computer, use the IIS virtual directory management utility for SQL Server (click "configure SQL xml support in IIS" in the "SQL Server tools" program group) to define
And register a new virtual directory, the so-called virtual root. This utility instructs IIS to create an association between a new virtual directory and a Microsoft SQL Server instance. This utility
For information on the user interface, see IIS virtual directory management utility.
The name of the IIS server and virtual directory must be specified as part of the URL. Information in a virtual directory (including logon, password, and access permissions) is used to establish a connection with a specific database.
And execute the query.
You can specify the URL:
Directly access database objects, such as tables.
In this case, the URL will include a virtual name of the dbobject type.
Execute the template file.
A template is a valid XML document composed of one or more SQL statements. When a template file is specified in the URL, the SQL command stored in the template file is executed. You can directly go to the URL
SQL query is specified, but this is not recommended for security reasons.
Execute the XPath query.
Perform an XPath query on the annotated ING architecture file specified as part of the URL.
Virtual name
To make template Files, ing schema files, or database objects (such as tables or views) part of a URL, you must create virtual names of the template, schema, and dbobject types.
. Specify the virtual name as part of the URL to execute the template file, perform XPath queries on the ING architecture file, or directly access the database.
The virtual name types (template, schema, dbobject) specified in the URL are also used to determine the file types (template files or ing schema files) specified in the URL ). For example,
The following URL uses a template to access the SQL Server database:
Http: // IISServer/nwind/TemplateVirtualName/Template. xml
TemplateVirtualName is a virtual name of the template type, used to identify the specified file (Template. xml) is a template file.
Create nwind virtual directory
Add information-SQL Server 2000 SP3.
In the following example, create the nwind virtual directory. When most of them are used to describe Microsoft? SQL Server? The nwind virtual directory is used in the example of URL access in 2000.
Before creating the nwind virtual directory, you need a physical directory associated with the virtual directory to be created (for example, C: InetpubWwwrootwind, where nwind is
The physical directory associated with the nwind virtual directory created in the following process ).