I have a big problem.
I have IIS 6.0 on first server and MS SQL 2000 on second. I'm trying do
create virtual directory for page with XML query.
I have SOAP 3.0 and SQLXML 3.0 installed.
a) in IIS 6.0 manager I set Integrated Windows Authentication
b) in SQL i'm trying to do it on Northwind database. I have full permission
to db (set manually)
c) in IIS Virtual Directory Managment for SQL Server i have Integrated
Windows Authentication too, in settings tab all is checked.
I don't know what is going on. Locally this page loads. But when I try to do
it by network, there is an error (under the text).
When I restart IIS, i can (only from two accounts - normal users, SQL
Northwind admins) access to this page, but when i try from other, there is
an error and i must restart once more.
Here is an error.
ERROR: 400.100 Bad Request
HResult: 0x80004005
Source: Microsoft SQL isapi extension
Description: Invalid connection settings: access denied