Microsoft KB Archive/820874

= PRB: &quot;Access Denied&quot; Error When You Run the SQLXML Template Query in IIS =

Article ID: 820874

Article Last Modified on 10/22/2003

-

APPLIES TO


 * Microsoft SQLXML 3.0
 * Microsoft SQLXML 3.0
 * Microsoft SQLXML 3.0
 * Microsoft SQLXML 3.0
 * Microsoft SQLXML 3.0 Service Pack 1

-



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.



Steps to Reproduce the Behavior

 * 1) Perform steps 1 through 5 in the &quot;Resolution&quot; 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.

