XML and SQL Server 2000
| Before we can accomplish anything productive, it is necessary to create a virtual directory from which to work. This directory is also known as the virtual root and must be registered on a server running IIS. (The terms virtual root and virtual directory are used synonymously.) TheVirtual Directory Management Utility, which creates an association between the virtual root and a Microsoft SQL Server instance, is the tool we'll use. When you install SQL Server 2000 on your application server, it installs the Configure SQL XML Support in IIS option on the SQL Server menu. This option gives you the capability to create a virtual root for SQL Server 2000. After you create this root, you can configure virtual names and directories used to identify the location of your templates, schemas, and objects through this menu option as well. All current Web servers have the capability to implement virtual directories. These configuration steps only configure SQL Server to point to the virtual root and directories contained in IIS. If these configuration steps are not completed, then the examples later in this chapter will not work. You can create the virtual directory using these methods :
In this chapter, we cover the IIS Virtual Directory Management Utility, which is installed as part of the SQL Server general installation. Then, we'll move on to the Object Model. |