SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Integrating to SharePoint 2010 - blank page!!


Integrating to SharePoint 2010 - blank page!!

Author
Message
amirhh2000
amirhh2000
SSC-Enthusiastic
SSC-Enthusiastic (114 reputation)SSC-Enthusiastic (114 reputation)SSC-Enthusiastic (114 reputation)SSC-Enthusiastic (114 reputation)SSC-Enthusiastic (114 reputation)SSC-Enthusiastic (114 reputation)SSC-Enthusiastic (114 reputation)SSC-Enthusiastic (114 reputation)

Group: General Forum Members
Points: 114 Visits: 98
Hi,

I am trying to integrate an ssrs2008 with sharepoint 2010. I did all steps like:
- change SSRS to Integrated mode
- join SSRS server to sharepoint farm
- install ssrs add-in in the sharepoint server
- Install WFE in ssrs server
and stock at the level I want to add ssrs server in the sharepoint central managment.

When I click the SSRS url it asks for the windows credential which is a good thing but when I enter the windows login and password it will not accept that and asking again and again for the windows login and after 4 - 5 times I'll face a blank page. I checked the log and it's says permission error!! As I am sure the windows login is OK and I can connect to other sharepoint websites with the same windows login what is missing here? I reckon the problem should be in SSRS server!!!

I should say when I again change SSRS back to the native mode it works fine! Any idea?

Many thanks,
Amir
davoscollective
davoscollective
SSCommitted
SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)

Group: General Forum Members
Points: 1687 Visits: 1008
Sharepoint also lets you use "Report viewer" and "Report list" webparts directly in a page setup. I prefer these to using integrated mode because it is so much simpler. If you don't have them on your sharepoint you might need to install them from the sharepoint designer.

It lets you then embed a report directly in a sharepoint page by just giving the report part some settings such as the report manager URL and the report folder/name.

Permissions on the sharepoint page still apply, as well as permissions in SSRS report manager.
amirhh2000
amirhh2000
SSC-Enthusiastic
SSC-Enthusiastic (114 reputation)SSC-Enthusiastic (114 reputation)SSC-Enthusiastic (114 reputation)SSC-Enthusiastic (114 reputation)SSC-Enthusiastic (114 reputation)SSC-Enthusiastic (114 reputation)SSC-Enthusiastic (114 reputation)SSC-Enthusiastic (114 reputation)

Group: General Forum Members
Points: 114 Visits: 98
Hi,

Thank you so much for the reply and great suggestion!

At last I found what was the issue with the blank page... It was mode of authentication which was set to Windows Negotiate instead of NTLM.

In Reporting Services Server, there is a config file “reportserver.xml” located in "\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\ReportServer\"


In this file there is a line specified authentication mode which for us was set to
• windows negotiate first priority
• NTLM second priority

To solve the issue I just removed windows negotiate!!!
davoscollective
davoscollective
SSCommitted
SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)

Group: General Forum Members
Points: 1687 Visits: 1008
Good to know, thanks for letting us know how you fixed it , that will certainly help other people with a similar issue.



You would need to have Kerberos set up on your domain in order to use Negotiate, and it's a headache!
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search