Posted on: 3/5/2011 8:39:19 AM | Views : 231

I am getting the following error when i try to open a sql server connection in from Web Application : ERROR [28000] [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. Authentication is set for Windows. How do I fix this?
 
<authentication mode="Windows"/> <identity impersonate="true"/> <authorization> <allow users="*"/> </authorization>  
MyConnection = New Odbc.OdbcConnection("DRIVER={SQL Server};SERVER=MyServer;Trusted_Connection=True;DATABASE=MyDatabase") ...

Go to the complete details ...