A
Adam Short
Hi,
I'm trying to use XMLHTTP to do an out of band call for the contents of
a drop down. Basically a user selects an item from a drop down, and the
onchange event fires an XMLHTTP request to the server for the contents
of a dependent drop down (in this case, the first drop down is
categories, the second is subcategories). In order to get the content of
the second drop down the asp.net app on the server needs to get data
from SQL Server (2000). When I run the app on my local machine, on my
local instance of IIS, it works great. As soon as I transfer it to the
server, it all goes wrong. When I select a value in the first drop down
I get an error telling me login failed for user "\" on the SQL server. I
take this to mean that my credentials aren't being properly passed from
my machine, to IIS on the server and then through to SQL Server (which
is on yet another machine). The rest of the app works perfectly, despite
the fact that IIS and SQL Server are on two different machines (there's
no reason they shouldn't be). The only bit that has problems is the
XMLHTTP bit. What am I missing? Is there something wrong with the way
I'm using XMLHTTP in this instance? I would have thought that once the
request gets to the server, the rest of the process would work just the
same as a normal web request, but it doesn't seem to. At some point I
lose my credentials, but I don't really know where. If I supply
credentials with the XMLHTTP request, it still doesn't work and I get
the same error, presumably because the credentials still aren't being
passed from IIS to SQL Server.
Can anyone provide any clues with this?
I'm trying to use XMLHTTP to do an out of band call for the contents of
a drop down. Basically a user selects an item from a drop down, and the
onchange event fires an XMLHTTP request to the server for the contents
of a dependent drop down (in this case, the first drop down is
categories, the second is subcategories). In order to get the content of
the second drop down the asp.net app on the server needs to get data
from SQL Server (2000). When I run the app on my local machine, on my
local instance of IIS, it works great. As soon as I transfer it to the
server, it all goes wrong. When I select a value in the first drop down
I get an error telling me login failed for user "\" on the SQL server. I
take this to mean that my credentials aren't being properly passed from
my machine, to IIS on the server and then through to SQL Server (which
is on yet another machine). The rest of the app works perfectly, despite
the fact that IIS and SQL Server are on two different machines (there's
no reason they shouldn't be). The only bit that has problems is the
XMLHTTP bit. What am I missing? Is there something wrong with the way
I'm using XMLHTTP in this instance? I would have thought that once the
request gets to the server, the rest of the process would work just the
same as a normal web request, but it doesn't seem to. At some point I
lose my credentials, but I don't really know where. If I supply
credentials with the XMLHTTP request, it still doesn't work and I get
the same error, presumably because the credentials still aren't being
passed from IIS to SQL Server.
Can anyone provide any clues with this?