ASP.NET and SQL Authentication: Login failed

[Guest]

I try to connect from an ASP.NET 1.1 app to a sql server 2000 on another
server with sql authentication. The DSN looks like
server=sqlserver;database=appdb;uid=test;pwd=password;
Both servers run with Win2K3. The sql server runs in mixed mode. When the
app tries to access the database I get the error "Login failed for user
NT-Authority\Anonymous". The user "test" was defined in sql server with
access rights to database "appdb".
I've read anywhere in the internet that this error message comes from a
problem with windows authentication, but I use SQL authentication.
Usimg the browser on the app server the application works fine.
What's going wrong when access the app from a client browser?

 

[Paul Clement]

¤ I try to connect from an ASP.NET 1.1 app to a sql server 2000 on another
¤ server with sql authentication. The DSN looks like
¤ server=sqlserver;database=appdb;uid=test;pwd=password;
¤ Both servers run with Win2K3. The sql server runs in mixed mode. When the
¤ app tries to access the database I get the error "Login failed for user
¤ NT-Authority\Anonymous". The user "test" was defined in sql server with
¤ access rights to database "appdb".
¤ I've read anywhere in the internet that this error message comes from a
¤ problem with windows authentication, but I use SQL authentication.
¤ Usimg the browser on the app server the application works fine.
¤ What's going wrong when access the app from a client browser?

I don't think you can do what you are requesting since your connection string is specifying SQL
authentication (not integrated Windows or trusted authentication).

If you need a trusted connection the following should help:

http://weblogs.asp.net/AChang/archive/2004/04/15/113866.aspx


Paul
~~~~
Microsoft MVP (Visual Basic)