Very Computer

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
authentication.
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 ?
Thanks

I have exactly the same problem, but my IIS server was on NT4. i have been told
that with IIS4, it's normal if it doesn't works ( see at :
http://support.microsoft.com/support/kb/articles/Q175/6/71.asp) Ass you can see,
separated servers + NT callenge/response (or intagreted security as it is called
in IIS5) have a problem together.
you may find some solutions here :
http://support.microsoft.com/support/kb/articles/q248/1/87.asp
but it's quite long and hard.

so i tryed with IIS5. but that doens't works again !
so i can't find a way to solve this problem too.
so my question for the newsgroup is : does it bugs with IIS5 ??? is there one
solution ???

Quote:-----Original Message-----

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
authentication.
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 ?
Thanks

.

by the way, if you find a way to solve this ... please tell me ! :o)

thanks

elise

Quote:-----Original Message-----

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
authentication.
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 ?
Thanks

.