SharePoint and Reporting Services: User cannot be found

While configuring SQl Reporting Services-SharePoint Integration you may encounter an issue “User cannot” be found. As the error suggests the issue here is that the user (author) of a SharePoint web site cannot be found. When Reporting Services tries to render a page, it seems to read the Author field of every web site of all site collections in all web applications. If the author cannot be resolved in just one web site(the user had been deleted), this fails. The following blog has more details with code sample as to how to restore the author of a SharePoint site collection and make the report services run in integration mode with SharePoint.

Related Post

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.