Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2005 Forums  Other SQL Server Topics (2005)  sporadic connection problem with delegation

Author  Topic  kemerd Starting Member 1 Post Posted - 2008-09-11 : 05:34:28 Hello, I am working on a smart client application which uses WCF to connect to our middle tier that runs on MS IIS 6.0. The server components then connect to SQL Server 2005 on behalf of the smart client, using AD delegation level impersonation. Everything works fine, except for sporadic DB connection problems that we face. I see the following error message 5-6 times a day in my log files. (the application have around 400 potential intranet users and around 100 of them use it on a specific day) Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. I talked to several of the users. They reported that once they get this connection error, they can no longer work with the application. I discovered that after a "log off/log on sequence" the application starts to connect to the database as usual. That makes me suspect that there may be a bug in SQL server or active directory delegation infrastructure. Has there been such a bug reported? Do you have a workaround (other than asking the users logoff and log on)? Thank you, Kemal Erdogan