PRB: "Access Denied" Error When You Run the SQLXML Template Query in IIS (820874)



The information in this article applies to:

  • SQLXML 2.6
  • SQLXML 2.6 SP1
  • SQLXML 2.6 SP2
  • SQLXML 3.0
  • SQLXML 3.0 SP1

SYMPTOMS

While you run SQLXML template queries, URL queries, and XPath queries against Annotated XSD schemas in Internet Information Services (IIS), you receive the following error message:
HResult: 0x80004005. Source: Microsoft SQL isapi extension. Description: Invalid connection settings: access denied

CAUSE

This error occurs because invalid SQL user credentials are supplied when you run a query by using an IIS virtual directory.

RESOLUTION

To resolve this problem, follow these steps:
  1. Click Start, point to Programs, point to Microsoft SQL Server, and then click Configure SQL XML Support in IIS.
  2. In the IIS Virtual Directory Management for SQL Server wizard, right-click a Web site where you want to create the virtual directories, click New, and then click Virtual Directory.
  3. In the New Virtual Directory Properties dialog box, click the General tab. Provide the appropriate details.
  4. On the Security tab, click to select the Always log on as option.
  5. In the Always log on as section, click to select SQL Server.
  6. Type a valid user name for the SQL Server database in the User Name text box, and then type a valid password in the Password text box.
  7. Type or select the valid values on the Data Source, the Settings, the Virtual Names, and the Advanced tabs. Click OK.
  8. Run the SQLXML template query from the browser.

MORE INFORMATION

Steps to Reproduce the Behavior

  1. Perform steps 1 through 5 in the "Resolution" section of this article.
  2. Type an invalid SQL user name in the User Name text box, and then type an invalid password in the Password text box.
  3. Type or select the valid values on the Data Source, the Settings, the Virtual Names, and the Advanced tabs. Click OK.
  4. Run the SQLXML template query.

REFERENCES

For more information about creating the nwind virtual directory, visit the following Microsoft Developer Network (MSDN) Web site:For more information about the Security tab of the Virtual Directory dialog box, visit the following MSDN Web site:

Modification Type:MinorLast Reviewed:10/22/2003
Keywords:kbtemplate kbSchema kberrmsg kbXML kbDatabase kbprb KB820874 kbAudDeveloper