.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
MarieAdela
Imran Ghani
Post New Web Links

Installation of SSRS 2008 in SharePoint integrated mode

Posted By:      Posted Date: October 21, 2010    Points: 0   Category :Sql Server
 
Hi All,

I have got a server (Windows Server 2003 x64) which has the Office SharePoint server 2007 and SQL Server Reporting Services 2008 (in SharePoint Integrated mode) installed in a stand-alone machine (System configured and installed by some other guy). We want to use the SSRS 2008 in SharePoint integrated mode.

I want to make sure that installation and configuration of system is done properly. But i am a starter, so i don't know much where to start.

Please help me which points i have to check to make sure that system is configured properly.

Also i visited the server and found the followings:
1. In central administration, under Application Management tab, Report Services section is not there. ( I think SSRS 2008 AddIn is not installed)
2. Single MSSSQLServer is created for SQL Server 2008, SSRS 2008 and Office SharePoint Server 2007 (Not sure Please let me know where i can confirm this)

Any help is appreciated.

3.

Thanks, Cool Developer


View Complete Post


More Related Resource Links

Upgrade from SQL Server 2005 to SQL Server 2008 from SharePoint 2007 SSRS 2005 integrated mode

  

I"m attempting to upgrade from SQL Server 2005 to SQL Server 2008 R2 x64 Enterprise on a server running Windows Server 2003 x64 Enterprise, SharePoint 2007 Enterprise, and SQL Server 2005 and SSRS 2005 Enterprise running in integrated mode.

I installed the Microsoft SQL Server 2008 SP2 Reporting Services Add-in for Microsoft SharePoint Technologies from here: http://www.microsoft.com/downloads/en/details.aspx?FamilyID=35c3a13f-4b5e-4d4a-86e4-07ee307b9638&displaylang=en.

When attempting to install Report Builder 2.0, I get the error "Reporting Services Add-in for SharePoint products and technologies is not installed."

When I try to run a report (existing 2005 reports already deployed), I get the error: "Operation is not valid due to the current state of the object." The log has repeating ReportingServicesService.exe errors: #20015: Cannot open "Resources.en-US.resx": no such file or folder, and: Localized resource for token 'ManageDatasetCaching_Desc' could not be found for file with path: "C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\12\Template\Features\ReportServer\ItemCustomActions\ecbExtension.xml" among other things.

I've tried rec

Setting Title on SSRS (SharePoint Integrated Mode) subscription.

  
I have some subscriptions in SSRS where the report goes directly to a Document Library on Sharepoint.  The subscription works fine, however, I would like to have the Title of the report be the current date that the report is run.  Is there a way to put a formula such as =[today] in the Title field of the File Options section on the Subscription properties?  I have tried this but either it is not possible or I am not using the correct syntax.  Thanks, Tim Olig

Sharepoint and SSRS Sharepoint integrated mode, any side effect ?

  
Hi, We planned to switch from native mode to sharepoint integrated mode our SQL Server Reporting Server. But it is a production server, so we liked to know if any side effect can happened on existing report and if it is possible to switch an existing database into sharepoint integrated mode ? Thanks, Mathieu Perrin.

SSRS 2008R2 - go back to parent report does not work sharepoint integrated mode

  
I'm currently using SharePoint Foundation 2010 with SQL Server 2008R2 with the SharePoint RS add-in. I have a report with a drilldown to another report.  I can drill down correctly to the other report.  But when I do the "go back to parent report" it will take me back to the parent report, but when I try to drilldown again to another report, I get the following error. "Message: Sys.WebForms.PageRequestManagerParserErrorException: The message received from the server could not be parsed. Common causes for this error are when the response is modified by calls to Response.Write(), response filters, HttpModules, or server trace is enabled. Details: Error parsing near ' <!DOCTYPE html PUB'. Line: 5 Char: 62099" When I run this report in VS 2008 or Report Builder 3, I have no problems drilling down and back and forth. I only have an issue when I deploy the report to SharePoint.  I have also accessed the RDL directly outside of a webpart page, but still get the same error. Wondering if anyone else is experiencing this issue?

ssrs and sharepoint 2010 integrated mode

  

 

Hello,

 

I have a ssrs server deployed in integrated mode with sharepoint ..and i have a couple of reports deployed to sharepoint server..Now when i go to sharepoint site and view the reports then the first time it displays them correctly but when i change some parameter and then click apply then it stops and gives me this error.

 

 

 

Webpage error details

 

 

 

User Agent: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 6.1; WOW64; Trident/4.0; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; Media Center PC 6.0; InfoPath.3; .NET4.0C; .NET4.0E)

 

Timestamp: Wed, 20 Oct 2010 14:52:43 UTC

 

 

 

 

 

Message: 'null' is null or not an object

 

Line: 5

 

Char: 27772

 

Code: 0

 

URI: http://test/ScriptResource.axd?d=Py4uDiRG2xcvSKHQoIG5g7XQIl5Ag_3lpZ_2Whd1GKKqcTDzhhbCKzFkdTe3TFZhlvdrXwq3AK-BAMlv5dvADnjhvAReAHeQZLVkLZNeJ2l9TrQuyz4nUfdaZJ1fTgf4jaPnY19Pqz2WZRnQEqe62-zPhqV08iSTnjrTH7ETAAD9jDjV0&t=5c2f384e

 

 

 


ssrs and sharepoint 2010 integrated mode

  

Hello,

I have a ssrs server deployed in integrated mode with sharepoint ..and i have a couple of reports deployed to sharepoint server..Now when i go to sharepoint site and view the reports then the first time it displays them correctly but when i change some parameter and then click apply then it stops and gives me this error.

 

Webpage error details

 

User Agent: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 6.1; WOW64; Trident/4.0; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; Media Center PC 6.0; InfoPath.3; .NET4.0C; .NET4.0E)

Timestamp: Wed, 20 Oct 2010 14:52:43 UTC

 

 

Message: 'null' is null or not an object

Line: 5

Char: 27772

Code: 0

URI: http://test/ScriptResource.axd?d=Py4uDiRG2xcvSKHQoIG5g7XQIl5Ag_3lpZ_2Whd1GKKqcTDzhhbCKzFkdTe3TFZhlvdrXwq3AK-BAMlv5dvADnjhvAReAHeQZLVkLZNeJ2l9TrQuyz4nUfdaZJ1fTgf4jaPnY19Pqz2WZRnQEqe62-zPhqV08iSTnjrTH7ETAAD9jDjV0&t=5c2f384e

 

Can somebody please tell me whats happening.

 


500 Error generating SSRS Report in SharePoint Integrated Mode

  

Our environment looks as follows:

- MOSS 2007 Site/Central Admin (Enterprise) on Server A

- SQL Reporting Services 2008 R2 on Server B

- Report created on workstation using Report Builder 3.0

- SharePoint Library (with Promoted InfoPath fields) is the XML datasource

 

The report generates perfectly fine in development, but once loading the RDL up to the SP Site we get the following error when trying to view:

 

An error occurred during client rendering.

The remote server returned an error: (500) Internal Server Error.

 

Using this generic information we have checked into numerous apparent fixes, from confirming settings in the Central Admin, to changing the Zone Authentication to NTLM, to ensuring Anonymous Access is disabled, as well as some tweaks in IIS, etc.

We're still not having any luck getting the report to generate.

Any assistance would be greatly appreciated.


SSRS SharePoint Integrated Mode

  

Hi Everyone,

We have an SSRS instance under SharePoint Integrated Mode. I just want to know what my options are for deploying SSRS reports. Would it be ok if I don't install SharePoint on the SSRS box? SSRS and SharePoint are on different hardware. Please advise.

Thanks in advance.

 


Rendering Reports in Reporting Services 2008 in Sharepoint Integrated Mode

  

I have created a site collection using the Report Center template. I successfully deployed my VS2008 Reporting Servivces project to the Sharepoint site. However, when I goto the reports library and attempt to run a report I get "unknown error" message"

Also, I can create a dashboard consisting of one of my reports. However, when I attempt to view the reports via the dashboard, I get the following error message:

An error occurred during client rendering.

The target location you specified is not supported by the report server. A report definition (.rdl), report model (.smdl), resource, or shared data source (.rsds) file must be located within a library or a folder within it.


SSRS 2008 R2 running in SharePoint 2010 Integration mode - Not able to schedule reports.

  

Hi,

I am unable to schedule report am getting following error when trying to schedule an SSRS report from ReportViewer Webpart in SharePoint 2010.

  • The current action cannot be completed. The user data source credentials do not meet the requirements to run this report. Either the user data source credentials are not stored in the report server database, or the user data source is configured not to require credentials but the unattended execution account is not specified. (rsInvalidDataSourceCredentialSetting)

I have SSRS 2008 R2 running in SharePoint 2010 Integration mode on Win 2008 R2 System.

I have also setup the unattended execution account from the Reporting Services Configuration Manager, which has appropriate privilates on the database to generate report.

Also, I have reporting webservice setup @ following url (am using the named instance of SQL Server):

http://<Servername>/ReportServer_SQLSERVER97170

Am able to view the report from report viewer webpart but unable to schedule it.

Kindly let me know what's going wrong.

Thanks in Advance,

Sachin R. Chavan.


Sachin R. Chavan.

Cannot export from a Report in SharePoint integrated mode in a server hardend environment

  

We have installed Reporting Services 2008 integrated with MOSS with SQL Server 2008 on a 64 bit platform.

The environment has worked fine in test (but the servers are not hardend).

With the production environment, any attempt to export from a report into another format (eg excel, tiff etc) results in an unexpected error within SharePoint requiring closing the browser and reopening.

There are no details behind the error. We can also find no traces of the error within any of the logs (SharePoint, Reporting Services, Windows event log etc)

When the report is opened directly from Reporting Services (ie http://servername:8080/reportserver) the report exports fine. Similarly, if the report is opened directly from Report Builder 2, or through opening Report Builder 2 from SharePoint there is no issue. This issue only happens when the report is invoked directly through SharePoint.

 

We can only assume that this issue has something to do with server hardening/UAC as we have

SSRS 2008 R2 and sharepoint 2007 report builder problems

  

I upgraded our enterprise sql server 2008 to sql server 2008 r2 last weekend.  Along with this i installed the report builder 3.0 on the servers as well and the updated ssrs add in for sharepoint.  The upgrade went fine, no errors that i could find.  The problem is now when i go to a library that has the report builder content type enabled and click report builder report under new it does not load report builder 3.0.

I updated the custom report builder url in central administration from /_vti_bin/ReportBuilder/ReportBuilder_2_0_0_0.application to /_vti_bin/ReportBuilder/ReportBuilder_3_0_0_0.application

however when i do click the new report builder report it kicks me over to http://company.com/ReportServer_MossEnt  which itemizes out each individual sharepoint site in the farm.

Is the integration of ssrs 2008 r2, sharepoint 2007 and report builder 3.0 work?  did i install the wrong version of the report builder add in?  The above is the only problem i am having now.

all servers are server 2008, 64 bit and moss 2007 enterprise with sp2 & april 2010 cu


Subscriptions cannot be created, Sharepoint Integrated mode

  
Error when I try to add subscription: "Subscription cannot be created because credentials used to run this report are not stored." I have SSRS 2005 and WSS 3.0 both installed on a Windows 2008 x64 Server.  SQL 2005 is the database, which his on a 2nd server (also Win 2008 x64). I'm able to publish reports to sharepoint.  I'm able to view them in sharepoint web parts, but only when I set the credentials for the datasource to "stored connections" and check both "Use as windows credentials" and for "Set execution context to account". Everything I read seems to say that I have to use Stored Credentials.  That's what I'm doing though.... necessary in order for me to view the reports within sharepoint.   Other environment things that may be important: The Report Server App Pool is using a domain account.  The same one I'm using to execute the report.  The WSS Content App Pool and the Sharepoint Central Admin App Pool are also using domain accounts.  However all 3 are using different accounts.  I see reference to Kerberos vs. NTLM authentication.  Up to this point I've not had to completely understand that.  So the only thing I do understand about that is that in my Sharepoint Central Admin --> Application Management, Auth Type: Windows; Anonymous is NOT checked, an

SSRS integrated mode email subscription to AD dist group

  
I have MOSS 2007 running SQL 2008 SSRS integrated mode and have created some reports and report subscriptions. Everything is working great. Now I want to use an Active Directory Distribution Group as a recipient for a report subscription - does not work, however the "last results" show no error. Try again using Dist Group in TO: field but adding regular email in CC: field...only email in CC field receive report, again all successful. Does SSRS integrated mode support AD distribution groups? if so is there any special setup required? Thanks LmmMmmm...yummy...

Schedule reports with integrated authentication SSRS 2008

  
Hi All,  Having an issue with SSRS 2008 at the moment, trying to setup subscriptions. Our system is configured so that any one of 10 users can login to the SSRS website using their windows domain account, and then launch report builder to design and save reports.  This all works very well, however, they have a problem when trying to setup subscriptions - the famous "Subscriptions cannot be created because the credentials used to run the report are not stored....." What the message says is true - the credentials are not stored as they are supplied by the user when they login to report builder. Is the /any/ workaround at all that doesn't involve storing the credentials?  It seems totally crazy that they cannot be prompted for them when setting up the subscription.  For this application its 100% essential to make the user provide their credentials when running reports, because they each see a filtered subset of the data in the report model (this is controlled DB side depeding on the login account), so their domain account needs to be passed to SQL server to enable this filtering to work.  If we saved their credentials then they would see all the data..and thats nasty. The only workaround I can come up with would be to create  a separate datasource for each user and upload a separate model, but thats really nasty to be hones

SSRS 2008 R2 - Sharepoint list item hyperlink bug?

  
I have created a report based on a sharepoint list and I am using a subscription in WSS 3.0 to email the report to the users once a week. I want one column in the report to act as a hyperlink to the sharepoint list item but in the email version of the report, the URL has the list item ID repeated twice, which renders the link invalid. Initially, I tried using the 'Encoded Absolute URL' from the sharepoint list query to populate the hyperlink but this just gives a 404 NOT FOUND error and I have found documented in several places on the web that this link only works with document libraries. So instead, I decided to create the URL for the action using an expression, like this: ="http://myserver/mysite/Lists/mylist/DispForm.aspx?ID=" & ListItemID.Value This works perfectly in the development environment and when people run the report for themselves in the sharepoint document library where it is deployed but, for some reason, if I send the report on a schedule then I get the ID parameter repeated at the end twice. Like this: http://myserver/mysite/Lists/mylist/DispForm.aspx?ID=999&ID=999 I have tried rendering the report in several different formats (Word, PDF, MHTML, HTML) and they all seem to work fine in the development and when run within SharePoint but not when they are rendered and emailed using the scheduler. Is this a bug or am I missing so

SharePoint Integrated Mode

  
Has anyone successfully configured SharePoint integrated mode in SQL Server 2008?  When browsing to the web service url, it throws an Object Reference Not set to an instance of an object with no other information given.  This is a very common error which i trust everyone experiences.  I would just like the resolution.  I've seen many posts on forums regarding this exact error with absolutly NO solutions.  Since I cannot browse to the web service URL, trying to view a report in SharePoint is secondary.   
Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend