306 Chapter 7 " Building a SQLXML Web Service Application NOTE Another way to create a SQLXML virtual directory is to use the IIS Virtual Directory Management for SQL Server object model. You can create a vir- tual directory in VBScript by using this object model. An advantage of using this method is that you can then create an installation script to set up the environment. For more details on how to use this method and create an installation script we urge you to refer to the SQLXML documen- tation, Creating the nwind Virtual Directory by Using the Object Model, located in the SQLXML help file that comes with the SQLXML Toolkit. Your server name will be at the highest level of the tree. After you have done this, go back to the SQL IIS configuration window and expand your Server name. Right-click on Default Web Site, and then select the option New Virtual Directory.This selection path is illustrated in Figure 7.6. We will now go through a series of options and set the values for each.The first step is to give your virtual root a name and location.The window for selecting the name and location of the Virtual Root Directory is shown in Figure 7.7. Select the Security tab. Here you will set the type of security you will use to access SQL Server; for the purpose of this example, use the SQL Authentication security.To do this, make sure that the Always log on as option is checked, and select the SQL Server option as your account type. Provide a username and pass- word (see Figure 7.8).You could use Windows Integrated Authentication, which means that you would need all associated rights within the domain for both the IIS server and SQL Server; however, for development purposes it is less convoluted to use SQL Authentication and separate the security element from the project. www.syngress.com Figure 7.6 Virtual Directory Menu