MS SQL Basics Tutorial: HTTP-based data access

Source: Internet
Author: User

In addition to XML technology, Microsoft SQL Server 2000 developers also use HTTP ACCESS9 as a core feature of SQL Server 2000. This allows users to put SQL Server on a URL so that developers and potential end users can simply access SQL Server through a single URL. In this section we mainly introduce the following three questions: How to create a virtual directory HTTP syntax http access ability 20.4.1 create a virtual directory

Before you can use HTTP to access a SQL Server 2000 database, you must first create a virtual directory (virtual directory) using IIS specifically provided for SQL Server, while ensuring that the operating system you are using supports the IIS server. The primary purpose of creating a virtual directory is to establish a new connection between the instance of SQL Server and the newly created virtual directory. Here's a concrete example of what to do to create a virtual directory.

(1) Select the Configure SQL XML Support in IIS option in the SQL Server Tool program.

(2) Open the server icon for which you want to create a virtual directory, and then select the Manage Site icon. Right-click the icon to select New in the pop-up menu, clicking Virtual Directory.

(3) Select the General tab page, as shown in Figure 20-3.

(4) This tab is used to give the path of the virtual directory to use when HTTP accesses the database data and the virtual directory. The real directory mainly holds the files to be accessed through the virtual directory, and the template file (template files) and the annotation matching mode file (annotated mapping schema files) are also stored in the directory. In this example, we enter VirtualRoot in virtual Directory Name and E:inetpubwwwroot virtualroot in local Path.

(5) Select the Security tab page, as shown in Figure 20-4.

This tab page is used to define the authentication method for logging in three IIS authentication modes altogether. Always Log on as

Windows and SQL Server accounts match the anonymous access mode of IIS authentication security. Anonymous access means that anyone can access a virtual directory, but any client accessing the server must provide the correct account number and password to be able to log on successfully. Where the SQL Server option indicates that all users of the virtual directory can use the SQL Server logon account when SQL Server logon is specified, and that the Windows option specifies a Windows account for all users who use the virtual directory. By default, the default user iusr_servername is used when installing IIS.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.