I've got a crawler application that runs on a WFE, queries SharePoint, and then tries to report findings to the database on a seperate server. Despite using integrated security = SSPI in my connection string, and impersonating a user with valid credentials, the connection is attempting to use the Anonymous user and therefore getting denied.

Nobody has any ideas?

OK, last try... this is a very important issue for me, and I am at a standstill. Please let me know if any additional information will be helpfull.

Hi Justin,

Would you please let me know why SQL authentication is not an option in your case? Besides, are you sure you are successful in accomplishing in impersonating a valid user?

Please refer to the following two articles and see if it can help you in impersonating.

http://support.microsoft.com/kb/306158
http://msdn.microsoft.com/en-us/library/ms998292.aspx#paght000008_step2

In the first kb article, there's sample code on impersonating.


Best regards,
Bruce Zhou

---

Please mark the replies as answers if they help and unmark if they don't.

If Justin's organization is anything like mine, the DBAs require all connections to the database to come from a Windows account.

There seems to be some serious conflict within Microsoft as to which method is the best practice. Various Microsoft applications force you one way or the other and their internal philosophical turf war has spilled over to their customers who are left to sort out the incompatibilities.