ODBC SQL Driver (Login) issue

[gregas]

I've got a 3-tier ASP/VB/SQL system with standard login. Three different environments: local, test, production. Test and Prod login works fine. Logging onto the local environment (my machine) generates this error:

[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.)

Where do I make the change?

Thanks for your attention.
asg

 

[Cagliostro]

don't use NT autentification. John Fill

ivfmd@mail.md

 

[gregas]

I switched to basic auth in IIS. Yet, I am still getting the problem.

asg

 

[DonP]

When I set UID=sa;PWD=; I was able to log right on. Just be sure these are set in that part of your ODBC connection. Don
don@ctagroup.org

http://www.helpscc.org/

Experienced in HTML, Perl, VBScript, PWS, IIS and Apache. Run OS/2 Warp 4, BeOS v5 and Windows NT (only when I have to!)

 

[gregas]

Don-

Thanks for the reply. Turns out the development server's IIS was fiddled with -- had to reset my DSN entries -- all good now! Cheers -asg