System.Data.SqlClient.SqlException: Login failed for user NT AUTHORITY\ANONYMOUS
I have a web application (ASP.NET / framework 2.0 / Windows Server 2003) on one machine, i.e. Web Server and corresponding database (SQL Server 2005) on second machine.
If I access the application from Web Server, it works fine, but when I access from a third client machine it gives following error
-----------------
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
-----------------
I think this has some thing to do with the permissions to access DB from client machines
my Web.config file has following things added
------------------
<add name="ConnString" connectionString="workstation id=MY_WORKSTATION;packet size=4096; integrated security=SSPI;data source=MY_DB; persist security info=False;initial catalog=MY_CATALOG"/>
<system.web>
....
<identity impersonate="true"/>
....
</system.web>
------------------
Moreover, the SQL Server is configured as per following link
"http://support.microsoft.com/kb/914277"
Please guide
Regards
Sachin

