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


Post New Web Links

SSRS SP1 and Sharepoint 2007 build 6529 Integration

Posted By:      Posted Date: October 16, 2010    Points: 0   Category :SharePoint
 
Scenario is single server (VM for dev)

Windows Server 2008 SP2 x86
Sharepoint 2007 build 6529
SQL Server 2008 w/SP1 integrated, SSRS, SSIS, SSAS

Kerberos configured for all Sharepoint services and working, SPNs set on machine account for kernel mode auth

SSRS configured to use service acct

get an error occurred during client rendering.  I also cannot get to the SSRS web service url .../ReportServer

Now i switch the account to networkservice, which contains the spn in AD as a sideeffect, i get the .../ReportServer page, but still the same error in MOSS.  Am i missing something?  I have read articles that state that using NetworkService on a single server with MOSS and SSRS is not supported as that account is explicitly denied access, which ironically both services could use the SPN, but how would i configure SSRS's service account?  also, i see the subsite in MOSS .../ReportServer in both scenarios, however because it's MOSS i am unsure if this is the correct behavior as everything i have seen suggests that a new IIS site needs to be created for SSRS.  If this is the case, where is the integration point in MOSS?


View Complete Post


More Related Resource Links

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


Problem Integration SQL Reporting Service 2005 and SharePoint 2007

  
Hello, I'm trying to make our SQL Reports available on our SharePoint report center. I have SQL 2005 (sp3) report server that resides on a different server than our SharePoint 2007 server. So in our SRS Configuration Tool, we changed the database mode for SharePoint integration (before, we only had it in native mode), so we created a new database for this SharePoint Integration type. Next, I installed the Report Server Add-in for SharePoint 2007 server and it was successful. However when configuring the Report Server, we got stuck at the step "Grant Database Access". For some reason we keep getting error message "Named instance not found" We already installed Service Pack 3 on the Report Server... I heard that the problem is because the mismatched version between the Report Server Add-in in SharePoint and the SQL RS version... but I don't think this is the case for us. Do we need to install WSS on our Report Server too?     Another question: We already integrate our Report Server with Microsoft Dynamics CRM 4.0. However I see that when the Report Server is in the SharePoint Integration mode, all the reports in CRM don't work (because Report Manager is no longer available in this mode). Do you think it would be the best practice to install a copy of Report Server instance in our SharePoint 2007 server? Thank you, greatly appreciate all your hel

Problem Integration SQL Reporting Service 2005 and SharePoint 2007

  
Hello, I'm trying to make our SQL Reports available on our SharePoint report center. I have SQL 2005 (sp3) report server that resides on a different server than our SharePoint 2007 server. So in our SRS Configuration Tool, we changed the database mode for SharePoint integration (before, we only had it in native mode), so we created a new database for this SharePoint Integration type. Next, I installed the Report Server Add-in for SharePoint 2007 server and it was successful. However when configuring the Report Server, we got stuck at the step "Grant Database Access". For some reason we keep getting error message "Named instance not found" We already installed Service Pack 3 on the Report Server... I heard that the problem is because the mismatched version between the Report Server Add-in in SharePoint and the SQL RS version... but I don't think this is the case for us. Do we need to install WSS on our Report Server too?     Another question: We already integrate our Report Server with Microsoft Dynamics CRM 4.0. However I see that when the Report Server is in the SharePoint Integration mode, all the reports in CRM don't work (because Report Manager is no longer available in this mode). Do you think it would be the best practice to install a copy of Report Server instance in our SharePoint 2007 server? Thank you, greatly appreciate all your hel

Sharepoint 2010 integration with Office 2010, 2007,2003

  
hi, i am looking, if some one know about the details or link, for the details about the Sharepoint 2010 integration with Office 2003, 2007 and 2010 versions. We will be migrate in couple of months to 2010 but we have mixed flavor of the office version in our environment. We have 2003, 2007 and 2010. Is their any blog post or anyone know what is now possible with 2010 but not in the 2007 or 2003. like a comparison chart.   thanks WSi am at entry level administrator

How to pass current user's login name as parameter to a RDL . (SSRS integration with sharepoint)

  
I have a webmethod which has two parameters. One is for year and another is for Currently logged in user. I call this method in RDL file. From RDL File how can we pass Currently logged in user's login name? I tried  with USER!UserID. It is passing the USERID but i need to pass the login name(SPWEB.currentuser.loginname)  

Building SSRS reports based on SharePoint 2007 lists

  
Hi,   I'm building a SSRS report, and I want to get data out of a SharePoint 2007 list. The difficulty I'm facing is the following: The SharePoint server is behind an ISA Server, and is configured for Form-Based Authentication. Is there a way to keep the FBA and retreve information out of a SharePoint list with reporting services?   Kind Regards,  AVermaas    

Problem configuring SSRS 2008 with sharepoint 2007 on Windows server 2008

  
Hi All - I am unable to integrate SSRS 2008 with sharepoint 2007. I am new to this part please correct em if am wrong. I have 2 servers one for SQL and one for MOSS MOSS server. Windows server 2008 MOSS 2007 .Net 2008 with basic sql 2005 which comes default WSP builder Everything is working fine SQL server: Windows Server 2008 SQl server 2008 and configured SSRS BIDS. When I am trying to install SSRS plugin for MOSS it is not accepting on both the machines. Please help me if am missing something here. I configured sucessfully on one server but havent done on multi server environment. please help me.   Thanks Saritha    saritha k

Parameter value filter based on user in SSRS (SharePoint Integration mode)

  

Hello..we have a reuirement where we have to filter the parameter value in the drop down based on the user who is accessing the report. We have form and Windows authenication enabled in the SharePoint site (some users will be from inside the network using windows and some will be accessing the site using internet using the Form Authentication).

Please let me know what would be the best way to handle this reuirement? Do we need to create a separate table  and store the User Information along with the parameter values they have access to, pass the userid from Report to db and then fileter the records using this table? OR Can we create a SharePoint List to maintain the user access information and then directly fetch the user information from the list using T-SQL to filter the records?

Please let me know your suggestion...

 


Looking for guidance: Integrated SharePoint SSRS migration and upgrade from 2007 to 2010

  

Our existing prod farm is MOSS 07 with an integrated SSRS instance using SQL Server 2008, both on Windows Server 2003 64bit boxes. SharePoint databases are on a different SQL Server 2008 server.

I have built a new SharePoint 2010 farm on Windows Server 2008 R2 boxes, using a single SQL Server 2008 R2 Enterprise server as the backend for both SharePoint databases and Reporting Services (installed in Integrated mode). We are going to be using the database-attach method of upgrading our SharePoint farm.

Is there any specific guidance out there on exactly how to migrate/upgrade Reporting Services in this scenario? I've read through some of the MSDN content (How To: Migrate a Reporting Services Installation) but nothing seems to deal specifically with doing this when in Integrated mode with SharePoint. Our business heavily relies on SSRS reports in SharePoint and also shared and custom report subscriptions via email.

We do have a dev SharePoint 2010 farm in a similar configuration that I can test migration/upgrade steps. Thanks.


SSRS Reports Not updating in Sharepoint 2007

  

Hello All,

I created some reports in SSRS 2008, The reports data source is a live transactional data source. The reports are to auto refresh every minute displaying any new info that  was put on to the system in the last minute. The auto refresh property on each report is set to 60 sec. to trigger the refreshing of the reports.

The problem: when i run the reports in the report manager the every thing works fine, the report runs, refreshes, and the figures are updated.

I am now displaying these reports in Sharepoint 2007 via the "report viewer" facilitated by the RSWebPart that i installed on the Sharepoint instance. 

The reports are displayed fine in the viewer, but my problem is that it does not auto refresh with the updated info.

I CANNOT FIGURE OUT HOW TO GET THIS TO HAPPEN, PLEASE ANY HELP WOULD BE APPRECIATED!!

I figure it is a caching issue but how to get around? HELP!


automating build process for sharepoint 2007

  

Hello Folks,

 

I am trying to automate the build process in my sharepoint 2007 environment. I have all my visual studio project files (solution files) and I also have some batch script files which have to run on the server.

 

CAn somebody suggest me what is the best practice to promote the code to different environments using automated build environments.

 

thanks in advance


Sharepoint 2010 Integration with SSRS

  

When you install SSRS as sharepoint 2010 integrated are then able to create reports using data (lists) from sharepoint?   Currently I use access/excel to make more advanced SSRS type reports with logic.   I know you can do it directly on Sharepoint with VS, but I just need quick and dirty ways to do it that I can teach to others quickly.

Thanks!


Can't see any data after publish SSRS report to Sharepoint 2007

  

Hi,

I'm using SSRS 2008 R2 , MOSS 2007 and report Builder 3.0 To generate cascading reports with sharepoint 2007 lists.

I'm able to filter and see the data correctly within report builder .

But if i upload the same RDL file to Sharepoint library and then tries to view the report,i'm not getting any data.(absolutely zero records) 

I'm using Report builder 3.0 and sharepoint list as connection string.

Interestingly, if i'm ising XML as a connection string to pull sharepoint list data and then publish the report to sharepoint, i'm able to see the data within sharepoint correctly and i'm able to use the cascading filter and can view the correct data.

Please advice on why i'm not able to see the data if i'm using the connection string" sharepoint list "

This issue is same even if i'm using BIDS 2008 and sharepoint list as connection string.

i would like to use sharepoint list as connection string because of the ease of using it.

Thanks in advance!!

 


Best Regards, Ashok Yadala | Senior SharePoint Consultant

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

How to add SSRS Integration to an existing SharePoint 2010 farm

  

Note to Administrator: this post is regarding SharePoint 2010, but I was unable to select 2010 for the forum when creating the thread.  Please feel free to move it to the appropriate forum.

pre-2010 Moderator Note: I don't understand why not. Please in a later post add a paragraph with how you created the thread.

I've found some instructions on TechNet for configuring SSRS Integration with SharePoint 2010, however they all assume you are starting from scratch.  I have a production two-server farm up and running: a web front end and a database server (SQL 2008 R2).  Reporting Services is enabled and the SP-Integrated database created on the SQL server.

I tried installing the WFE bits on the SQL server and adding the server to the farm, but I encountered errrors trying to add it to the farm.  Does anyone have instructions for adding SSRS Integration to a production farm?



Congnos 10 Developer webparts integration with SharePoint 2007

  

Hi,

Can anyone tell me the steps to configure and integrate IBM Congos webparts with SharePoint 2007?

Regards,

Ranjana


ssrs with sharepoint 2007 for FBA user

  
I have SQL Server 2008 on different server and sharepoint 2007 on different server. i have to put the SSRS report on the sharepoint site. i have user the report viewer in the site and add the ssrs report url to the report viewer it work. but when the FBA user login to that page it asked for the authentication so how to resole that problem. that FBA user does not have to give the login and he can see the report on the site.  

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