August 15, 2001 at 7:20 am
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.
August 15, 2001 at 7:49 am
When you do the 3 tier, the MTS login must have an account on SQL Server. Have you checked this?
Steve Jones
August 15, 2001 at 8:16 am
Thanks for the quick reply.
We don't have MTS .we are using only DCOM to connect.
We have client machine(dll's and exe) that is connected to the second machine through DCOM . The second machine has exe's as well as sql installed.
August 15, 2001 at 9:27 am
Usually when you connect through a COM object, the object proxies the user account. In other words, the user account is not used to connect to SQL Server, the account under which the object is running is used.
I am not sure with DCOM, but I think that this will inherently run under the MTS account under W2K. Not sure about NT.
Steve Jones
August 15, 2001 at 5:22 pm
Might take a look at DCOMCNFG.exe. Its a jungle though.
Andy
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply