IIS 5 and SQL 2000 are on 2 separate boxes. SQL server named instance is set
to both SQL and win security. both boxes are in the same domain. the virtual
directory on the IIS server is set with both basic and Windows
A domain account is created and added as a login to the SQL server and user
to a database. ASP page is set to use a trusted connection. But the
connection to the SQL server does not happen.
I already spent sometime trying to figure this out, but without results. Are
there any issues I need to check, any settings I need to set, or could
someone suggest a way to to troubleshoot this ?