We have a classic ASP application. I'm trying to clone it on the same server, with the same instance of IIS7, so we have a dev version. I copied the files, and duplicated all of the configuration that I can find in IIS manager.
The problem is DB access. The new copy is using the same Application Pool as the old one and the same connection string, but when I create ADODB.Connection
and call conn.Open(str)
with the same old connection string, that call throws "Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'."
.
That is not the user account the application pool is using, but that seems not to matter.
"Provider=SQLOLEDB;Data Source=OURSVR;Initial Catalog=OURDB;Integrated Security=SSPI;"
So: How do you force Classic ASP to impersonate a user account other than NT AUTHORITY\ANONYMOUS LOGON
?