SharePoint 2010

SharePoint 2010 Security (Prompts for Login) Issue with SSRS report with Out of Box Web Part


 

Problem:

If you have a SSRS Customized Report (.RDL).  and a web part with association on one of the report. When you  try visit the page you are prompted for credential.

My Data Source Properties are as per below

Use this user and Password

  user name: domain\myadminuser

  password:****

Selected: use as windows authentication

Selected: Impersonate

Cause & Solution:

In the cases I have seen, the problem is due to Kerberos authentication.  Kerberos is an authentication protocol that allows clients that create authentication tokens to associate a specific destination to that token.  In the failure case there is a mismatch between the destination specified in the token and the report server process configuration.  Due to this mismatch, the underlying Kerberos authentication scheme supported by Windows prevents report server from authenticating the user

Find more info here:

http://blogs.msdn.com/b/lukaszp/archive/2008/03/26/solving-the-reporting-services-login-issue-in-the-february-ctp-of-sql-server-2008.aspx

Advertisements

One thought on “SharePoint 2010 Security (Prompts for Login) Issue with SSRS report with Out of Box Web Part

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s