Hello:
I am running IIS 5.0. I am trying to call an ASP page that connects to SQL server based on the user's NT authentication. Once I put the page on the inetpub and running it locally from the same machine where the page is located, everything works fine. However, if I am trying to access the same page from a different machine, no data is returned. I have full access on both the machines.
I have the connection string in the asp file as follows:
"Provider=SQLOLEDB.1;Persist Security Info=True;Initial Catalog=database1;Data Source=xxx.xxx.x.xx;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=;Use Encryption for Data=False;Tag with column collation when possible=False;Integrated Security=SSPI;"
And, I have the IIS security set up as Integrated Windows Authentication and have the anonymous access box unchecked
Any suggestion and recommendation is greatly appreciated.
I am running IIS 5.0. I am trying to call an ASP page that connects to SQL server based on the user's NT authentication. Once I put the page on the inetpub and running it locally from the same machine where the page is located, everything works fine. However, if I am trying to access the same page from a different machine, no data is returned. I have full access on both the machines.
I have the connection string in the asp file as follows:
"Provider=SQLOLEDB.1;Persist Security Info=True;Initial Catalog=database1;Data Source=xxx.xxx.x.xx;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=;Use Encryption for Data=False;Tag with column collation when possible=False;Integrated Security=SSPI;"
And, I have the IIS security set up as Integrated Windows Authentication and have the anonymous access box unchecked
Any suggestion and recommendation is greatly appreciated.
