I'm porting an application from Windows NT 4.0 sp 6/ IIS 4.0/SQL Server sp3/SQLXML30 sp1
to Windows server 2003/IIS 6.0/SQL Server 2000 sp3/SQLXML 3.0 sp2.
The application is devoleped using ASP page accessing SQL Server with XML templates
called by ASP script and Java script. I attach a sample of the code I have used in the ASP page.
SCRIPT ASP
<%
var xmlDoc = Server.CreateObject("MSXML2.DOMDocument");
var xslDoc = Server.CreateObject("MSXML2.DOMDocument");
xmlDoc.async = false;
xslDoc.async = false;
var fileXML="Q_CLI_Clienti_Lista.xml";
var fileXSL="Q_CLI_Clienti_Lista.xsl";
xmlDoc.load("http://srv01/SQL/t/"+fileXML);
xslDoc.load(Server.MapPath("/myapplication/SQL/template/"+fileXSL));
Response.Write( xmlDoc.transformNode(xslDoc));
xmlDoc.Close;
xslDoc.Close;
%>
JAVASCRIPT
function RiaggiornaServizi_1Can(IDC,STATO) {
var xmlDoc = new ActiveXObject("MSXML2.DOMDocument");
var xslDoc = new ActiveXObject("MSXML2.DOMDocument");
xmlDoc.async = false;
xslDoc.async = false;
var fileXML="QSP_CLI_Clienti_LISTA.xml?";
var fileXSL="QSP_CLI_Servizi_1Can.xsl";
var parametri="TIPO="+STATO;
parametri+="&IDCAN="+IDC;
xmlDoc.load("http://srv01/SQL/t/"+fileXML+parametri);
xslDoc.load("/AppEvolve/SQL/template/"+fileXSL);
var obj=document.all(String(IDC));
obj.innerHTML=xmlDoc.transformNode(xslDoc);
xmlDoc.close;
xslDoc.close;
}
The application is currently working on the NT 4.0 enviroment.

While porting the application in the new enviroment I'm facing with this problem:
- if I select "Windows Integrated Authentication" (as in the old system) in the virtual directory SQLXML (to access the XML templates)
the application do not work (XML templates return no data)
- if I select "Always log on: Windows: IUSR_mypc" on the server the application works completely
but when accessing from any other client in the Intranet only XML templates run from ASP script
return data while XML templates run from the client with java script do not return data because
errors HTTP 404 (file or directory not found) or HTTP 401.2 (Access denied) are always returned

I will appreciated if somebody can help me to solve this problem.