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

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

How to add SSRS Integration to an existing SharePoint 2010 farm

Posted By:      Posted Date: April 14, 2011    Points: 0   Category :C#

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?

View Complete Post

More Related Resource Links

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.


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



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):


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.

Video: SharePoint 2010 Integration with PowerShell

Learn about the new PowerShell integration in SharePoint 2010, which brings SharePoint administration in line with other server products such as Exchange. Understanding PowerShell is a must-have skill for SharePoint 2010 developers. (Length: 19:52)

Facebook integration with sharepoint 2010

how can I show my facebook posts in sharepoint 2010?

Failed to change Farm Account in Sharepoint 2010 server, now Central Administration is not accessibl

Hello, I have a problem, that I no longer can access Central Administration Website, only the Sharepoint itself. I was running installation of Sharepoint 2010 Server with administrative account ImTheAdmin, who is a Domain Admin in the domain on one of the Windows 2008 R2 member servers. Besides that, I made ImTheAdmin the primary administrator of the Sharepoint. ImTheAdmin became the only user of this Sharepoint 2010 server after installation.  I installed everything on one box with default installation settings. I used builtin SQL server, not Standard or Enterprise. What then happened is: Using ImTheAdmin account, I opened Central Administration Website, and it said, that I need to change the Farm Account, for the account for Farm was the default one (I think it was network service). So I created a regular domain user MYDOMAIN\SharepointFarmAccount. The account name was too long to be as a Windows 2000 name, so it showed there without last 't', e.g. MYDOMAIN\SharepointFarmAccoun. I thought, Windows 2000 is long gone, so I didn't pay much attention, I think everywhere the account SID is important. I don't know if that is the real problem with my failure later, but it might be one of the reasons. I put MYDOMAIN\SharepointFarmAccount down in to the form of Central Administration Website, added the check mark, that it would react to password changes, and pre

Add existing sharepoint web application to the new Sharepoint farm

Hi professionals:   Currently, we got our own sharepoint intranet and sharepoint reporting server in NZ. Now, We want to have seperate sharepoint intranet and report site in Australia. I created a new farm based on a australia server. So how can I add the existing share point intranet and sharepoint report site to this new Australia sharepoint farm?   Thanks in advanceDavid Chen

Sharepoint 2010 Business Intelligence integration with datasources other than MS SQL Server

I want to Implement Business Intelligence by SharePoint 2010 on top of data sources other than MS SQL Server or MS Analytics Services ( cubes ), for example Oracle RDBMS and Oracle OLAP ( cube ) or Teradata. Quesiton : Is there any way to do this, if the is, how do I bring metadata to sharepoint BI or how do I make SharePoint BI to see other data source. I've looked at Busines Data Connectivity in Visual Studio, but that is more for two way integration and didn't seem like a good or easy way just to bring new data sources to SharePoint BI I found some tool from third party company "BDC Meta Man" which created metadata layer for Oracle RDBMS in SharePoint, but I thought there must be a way to do it by using Microsoft tools

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

Integration of Windows live Id authentication with Sharepoint 2010?

Dear folks,   please give me some details about Integration of Windows Live Id authentication With SharePoint 2010? Thank you Regards Immanuel c

SharePoint 2010 AD FS 2.0 Integration - login works then fails, looping back to the adfs server

Hello, I setup SharePoint 2010 Claims auth with AD FS 2.0 following this post: http://blogs.technet.com/b/speschka/archive/2010/07/30/configuring-sharepoint-2010-and-adfs-v2-end-to-end.aspx.  I have no access to the ADFS server, but I think they followed the steps as outlined.  If I do an iisreset (or just recycle the app pool of the SharePoint site) I can login successfully using the remote credentials.  Also I can under security in SharePoint search for and find users and roles from the remote ADFS server. If I close my browser, open a new browser and go to the site I am prompted to login again (this is fine).  I do, using the same credentials, and the login fails because I am redirected between the SP and ADFS servers until the ADFS server stops the redirecting.  I have been doing some digging and I found this post: http://blogs.technet.com/b/speschka/archive/2010/08/09/setting-the-login-token-expiration-correctly-for-sharepoint-2010-saml-claims-users.aspx, which describes the situation I have in point # 3 at the bottom.  I have tried setting the token time out as low as 1 second but this hasn't helped. I have also, just to see, tried setting all the other lifetime settings to 1 second - but no luck.  Because the initial login works I think the setup is correct, but something is maintaining some state that is causing the loop

Migrating large, existing company share drives to SharePoint 2010.

My company has terabytes of documents stored out on a large share drive.  In implementing SharePoint 2010, one of the great features with documents is versioning, permissions etc.  Currently I'm planning on each department to slowly upload documents to SharePoint 2010 under their department sites/site collections as it makes sense and of course create any new documents there in their site document libraries.  99% of every document uploaded to SharePoint will be from this old share drive.  Is there a better way to migrate this content into SharePoint than having people upload documents individually (or "upload multiple files")?  I know I can add the share drive to the SharePoint search results, or add links to the share drive location, but we really need the versioning on documents and have things show up in SharePoint like it normally would in a list.  Any guidance is much appreciated. Thanks!

Cannot Add Second FE Server to SharePoint 2010 Farm

Hi folks Well I thought I would add my problem to the others that are also experiencing this issue. I actually reported somthing similar to this forum in Feb 2010 when I was trying the beta version out. I upgraded our WSS farm to SPFS 2010, the upgrade worked, well kinda. Basically our second WFE server would not join the farm after installing the 2010 binaries and runnng the configuration tool and it was complaining with the following error: 07/31/2010 14:35:59  11  INF                              Calling SPFarm.Local and SPServer.Local to get the local farm objects 07/31/2010 14:35:59  11  INF                              SPFarm.Local returned null.  This usually means that the server is not joined.  But, you can delete a server from the configdb without unjoining, which would mean that this machine still thinks it is joined. 07/31/2010 14:35:59  11  INF                              Trying to access th

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)  

Problems with Report Services 2008 Integration in Sharepoint Foundation 2010

hi Folks, i ihave tried to solve my problem with this entry, but it has not fixed the issue. I would like to integrate RS in a Sharepoint Foundation 2010 environment, but when try to integrate the RS in Central Administration I am receiving the following error, see pic: Central Administration jpg When I try to access direct the RS Url the I get an access denied error please help.   thx a lot

Office Integration with SharePoint 2010

Hi,   Can you please provide me a presentation which talks about Integration of different Office Suites with SharePoint 2010.   Regards, Garima

SharePoint 2010 - The license state for the current server doesn't match the farm's license state.

I already have a SharePoint 2010 server built, up and running. Yesterday I built a brand new server Windows 2008 and installed all necessary windows updates. Then I joined the server to the domain where the other SharePoint 2010 box is. Today, I installed all necessary pre-requisites for SharePoint 2010 including the KB971831. After that I installed SharePoint 2010 binaries on the new server. When I run the configuration wizard now, it sees the database server with the configuration database, but will not allow me to join the new server to the farm. I get the following error in the diagnostic logs. Resource retrieved id ConfigurationDatabaseTaskConnectFailConfigDisplayLabel is Failed to connect to the configuration database. 02/18/2010 17:54:12 8 INF Leaving function StringResourceManager.GetResourceString 02/18/2010 17:54:12 8 ERR Failed to connect to the configuration database.   An exception of type System.InvalidOperationException was thrown. Additional exception information: The current server cannot be joined to this farm because the set of installed products does not match the products installed in the farm.   The license state for the current server doesn't match the farm's license state. System.InvalidOperationException: The current server cannot be joined to this farm because the set of installed products does not match the products installed in the farm.

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...


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