We're using the DVWP to display information contained in a SQL table on a SharePoint page. It's a simple farm - SharePoint 2007 web/app on a single server, and SQL 2008 on another server. We use Windows authentication in the webpart. For most of our users, things work fine. But for some users, the web part does not render but displays the following message:
Bamboo Error - Message :SetWorkOn Data; : GetKeyFieldsName::
On the SQL side, the following error appears:
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. Reason: Token-based server access validation failed with an infrastructure error. Check for previous errors.
Any help would be greatly appreciated - thanks!
Per our online documentation:Select the Windows Authentication option if you always want to use the current user to access the SQL database. You must have enabled Windows Authentication as the Authentication Mode in SQL Server to use this option, and SQL Server must be installed on the same server as the Web front-end server (such as in a standalone SharePoint installation). For additional details:http://store.bamboosolutions.com/onlinedoc/#appid=3903&anchor=sql
Unfortunately this means we do not fully support "Windows Authentication" in your environment because of a problem called "round robin" where credentials become "Lost" between servers communication.
I'm not entirely clear why it works some users and not others tough, that is a puzzle. Bamboo recommends that you use the SQL Login credentials instead of using "Windows Authentication" option.
If you have any further questions or problems, please let us know.
I appreciate your answer. What's interesting is that this has been working great in our SharePoint installation for the last 3 years - and only started to come up with issues when we migrated from Windows Server 2003 to Windows Server 2008 R2 DCs.
I'd like to do more troubleshooting - can you give me more insight on why the messages "SetWorkOnData" and 'GetKeyFieldsName" are apperaing.