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
SYMPTOMSWhile 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 CAUSEThis error occurs
because invalid SQL user credentials are supplied when you run a query by using an
IIS virtual directory. RESOLUTIONTo resolve this problem, follow these steps:
- Click Start, point to
Programs, point to Microsoft SQL Server, and
then click Configure SQL XML Support in IIS.
- 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.
- In the New
Virtual Directory Properties dialog
box, click the General tab. Provide the appropriate
details.
- On the Security tab, click to select the
Always log on as option.
- In
the Always
log on as
section, click to select SQL
Server.
- 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.
- Type or
select the valid values on the Data
Source, the Settings, the Virtual Names, and
the Advanced tabs. Click OK.
- Run the SQLXML template query from the browser.
REFERENCESFor
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: | Minor | Last Reviewed: | 10/22/2003 |
---|
Keywords: | kbtemplate kbSchema kberrmsg kbXML kbDatabase kbprb KB820874 kbAudDeveloper |
---|
|