http://localhost/reportserver authentication issue with SharePoint integrated mode
Hi All,
A machine here configured with both SharePoint 2010 and SQL2008R2 SSRS in integrated mode works fine. I can browse any and all reports published to the document library and all is well.
However I cannot connect to the ReportServer virtual site. This is an issue as the intention was to utilise PerformancePoint to display the SSRS reports in a dashboard.
When I attempt to connect to http://ipaddress/reportserver or
http://fqdn/reportserver or
http://localhost/reportserver a login dialog box is displayed. No credential I enter satisfies this prompt.
Can anyone assist here?
thanks in advance,
Ash
November 10th, 2010 4:26pm
This might help you
http://blogs.msdn.com/b/bimusings/archive/2008/03/02/fun-displaying-ssrs-integrated-reports-using-performancepoint-sql-server-report-viewer.aspx
Gaurav Gupta http://sqlservermsbiblog.blogspot.com/
Free Windows Admin Tool Kit Click here and download it now
November 10th, 2010 4:50pm
This might help you
http://blogs.msdn.com/b/bimusings/archive/2008/03/02/fun-displaying-ssrs-integrated-reports-using-performancepoint-sql-server-report-viewer.aspx
Gaurav Gupta http://sqlservermsbiblog.blogspot.com/
November 10th, 2010 4:50pm
Hi,
Issue is that I cannot get to http://anything/reportserver
Free Windows Admin Tool Kit Click here and download it now
November 10th, 2010 5:12pm
Hi,
Issue is that I cannot get to http://anything/reportserver
November 10th, 2010 5:12pm
Hi AshVsAOD,
The issue might be caused by incorrect Kerberos configuration.
If the report server is configured to use RSWindowsNegotiate authentication, and the reporting services service is running under a domain account, the report server will require the client to use Kerberos authentication to connect to the server. In this case,
if the Service Principal Name(SPN) is not configured correctly in the domain controller(DC), we may get the login dialog promptting while accessing the report server(through Web Service URL).
In order to solve the issue, please force the report server to use the NTLM authentication instead:
Open the rsreportserver.config(By default, it can be found from <Install Dirver>:\Program Files\Microsoft SQL Server\MSRS10_50.<Instance Name>\Reporting Services\ReportServer)
Comment the element <RSWindowsNegotiate/>, which is under element <AuthenticationTypes>
Or, please register the SPN in the DC to fix the issue.
For more information, please see:
Authentication Types in Reporting Services:
http://msdn.microsoft.com/en-us/library/cc281310.aspx
If there is anything unclear, please feel free to ask.
Thanks,
Jin ChenJin Chen - MSFT
Free Windows Admin Tool Kit Click here and download it now
November 11th, 2010 12:42am