Logo 
Search:

MOSS Forum

Ask Question   UnAnswered
Home » Forum » MOSS       RSS Feeds

Getting Error while displaying SSRS reports on sharepoint site

  Asked By: Imdrajit    Date: Aug 19    Category: MOSS    Views: 5576

I am using MOSS 2007 with SQL Server 2005(Service Pack2). I have
successfully configured MOSS with SQL2005. On Sharepoint Server,we
have 2 sites.
1) http://portal (Which has windows-based Users)
2) http://portal:12345 (which has Form-based Users)

I created SSRS report and deployed it on the document library of
the http://portal and it's working fine. The same report is available
on the document library of http://portal:12345. But when I clicked on
report, it is giving me an error :"An unexpected error occurred while
connecting to the report server. Verify that the report server is
available and configured for SharePoint integrated mode." I have
below configuration in central Admin:

A)In, Manage Integration Settings section,I have selected "Windows
Authentication" as a Authentication Mode.
with this mode,Report works fine with windows based site but giving
an above error for form-based site.

I also tried with "Trusted Account" but with this,I am not able to
display report on both the above sites.

window-based site error:
"This data source is configured to use Windows integrated security.
Windows integrated security is either disabled for this report server
or your report server is using Trusted Account mode."

Form based site error:
"An unexpected error occurred while connecting to the report server.
Verify that the report server is available and configured for
SharePoint integrated mode."

B) In Grant Database Access section,I have selected server name with
default instance.

I have below question:

1) Does SSRS support Form-based Authentication in sharepoint?
2) Does SSRS support only default zone?

If yes then,Can you please suggest me, if I am missing anything in
configuration?

I would really appreciate if you would help me out with this.

Share: 

 

4 Answers Found

 
Answer #1    Answered By: Jason Anderson     Answered On: Aug 19

The problem is that your Forms based users don't have a Windows Identity, so
there is no identity that can be used to Impersonate them to the Report server.
I'm not sure how you would change the configuration to enable forms based users
to use SSRS. You could try clicking the rememberme check box when the FBA user
logs in. This generates a permanent cookie that associates the user with the
Computer account of the workstation they are logging in from. They can then use
that Windows identity for things like client integration. It may also work for
SSRS.

 
Answer #2    Answered By: Uttam Vanjare     Answered On: Aug 19

I found another issue which might help us to solve this problem.
when I run the report server url "http://portal/reportserver", it
shows me all the contents available for this site. But when I click
on the Doc Lib on which I have deployed report, it is giving me an
error

"An internal error  occurred on the report server. See the error log
for more details. (rsInternalError) Get Online Help
Error executing child request
for /ReportServer/Pages/ReportViewer.aspx.
The type
Microsoft.SharePoint.Portal.Analytics.UI.ReportViewerMessages,
Microsoft.SharePoint.Portal, Version=12.0.0.0, Culture=neutral,
PublicKeyToken=71e9bce111e9429c does not implement
IReportViewerMessages or could not be found".

 
Answer #3    Answered By: Jack Carroll     Answered On: Aug 19

Yes, SSRS supports both Windows and Forms. Both of the errors you
mentioned are pointing to your SQL Reporting Server configuration.
Looks like your databas is not setup for Integrated mode.

Go into 'Reporting Services Configuration manager' on your server and
under 'Database Setup', make sure Server Mode is set to 'SharePoint
Integrated'.If it is not setup this way, it is defiantely not going
to work.

Another thing i learned from MIcrosoft is that do not
enable 'Anonymous Access' for the report server site. Even though you
are using forms authentication, just use 'Windows Integrated' option
for security.

Also make sure that the account you are using for AppPool for your
application is authenticated through sharepoint. And also make sure
you actually type domain\account when authenticating because if you
don't, even though sharepoint  will ask you for a domain and
authenticate your account but then your app pool will just be setup
to run under accountname instead of domain\accountname and the reason
its important because when you are making a connection using forms
auth, it will cache your domain\accountname but if the app pool is
not setup with domain\accountname, it will fail to authenticate.

I hope this helps and i hope i have not confused you or anyone else.

 
Answer #4    Answered By: Chandrabhan Agarkar     Answered On: Aug 19

I checked the settings and everything is configured as per ur
suggestion. when I run the report server
url "http://portal/reportserver", it shows me all the contents
available for this site. But when I click on the Doc Lib on which I
have deployed report, it is giving me an error

"An internal error  occurred on the report server. See the error log
for more details. (rsInternalError) Get Online Help
Error executing child request
for /ReportServer/Pages/ReportViewer.aspx.
The type
Microsoft.SharePoint.Portal.Analytics.UI.ReportViewerMessages,
Microsoft.SharePoint.Portal, Version=12.0.0.0, Culture=neutral,
PublicKeyToken=71e9bce111e9429c does not implement
IReportViewerMessages or could not be found".

 




Tagged: