We have a application in vb6 on sql2K. We want to use mixed mode for sql authentication.It works fine for nt and windows when we are in single tier ir on terminal server .
When we want to use the same application on three tier it works fine for sqlserver authentication but it does not work for window authentication. It gives error:
Login failed for NTAuthority/Anonymous Logon.
We are using DCOM for multitier.