| keithb 2005-09-13, 11:24 am |
| After following the Virtual Root setup instructions for SQLXML 3.0, Using
SQL Server Account type on the Virtual Root security tab, and executing the
following HTML query:
http://LT-E29961SERVER/nwind? sql=S...0AUTO&root=root
I get the following result:
ERROR: 500 Internal Server Error
HResult: 0x80004005
Source: Microsoft OLE DB Provider for SQL Server
Description: Login failed for user 'sa'. Reason: Not associated with a
trusted SQL Server connection.
If I change the Virtual Root security settings to use Windows Account Type
with the following user:
IUSR_LT-E29961SERVER
The same query returns this result
ERROR: 400.100 Bad Request
HResult: 0x80046000
Source: Microsoft SQL isapi extension
Description: Invalid connection settings: access denied
It looks like there is a problem with connection settings. This is all new
to me. I will appreciate any help that is offered.
Thanks,
Keith
|