Article ID: 820874 - Last Review: October 22, 2003 - Revision: 1.3

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

View products that this article applies to.
System TipThis article applies to a different operating system than the one you are using. Article content that may not be relevant to you is disabled.
Expand all | Collapse all

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
Back to the top

CAUSE

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

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.
Back to the top

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.
Back to the top

REFERENCES

For more information about creating the nwind virtual directory, visit the following Microsoft Developer Network (MSDN) Web site:
http://msdn.microsoft.com/en-us/library/aa275450(SQL.80).aspx (http://msdn.microsoft.com/en-us/library/aa275450(SQL.80).aspx)
For more information about the Security tab of the Virtual Directory dialog box, visit the following MSDN Web site:
http://msdn.microsoft.com/en-us/library/aa196946(SQL.80).aspx (http://msdn.microsoft.com/en-us/library/aa196946(SQL.80).aspx)
Back to the top
APPLIES TO
  • SQLXML 2.6
  • SQLXML 2.6 SP1
  • SQLXML 2.6 SP2
  • Microsoft SQLXML 3.0
  • Microsoft SQLXML 3.0 Service Pack 1
Back to the top
Keywords: 
kbtemplate kbschema kberrmsg kbxml kbdatabase kbprb KB820874
Back to the top