none
How do I deploy a SSRS 2008 R2 file to Sharepoint 2010

    Question

  • Hi,

    I understand Sharepoint 2010 and SSRS 2008 R2 are successfully installed. I have fully tested my SSRS report locally, and I need to now deploy to sharepoint.

    With the upload approach; -
    I am struggling to know the best place to put the rsd file, and how to get the rdl file to point to this rsd file.

    With the deployment from BIDs approach; - I am struggling to figure out the format of the TargetDataSourceFolder, TargetReportFolder and TargetServerURL locations.

    Kind Regards,

    Kieran.

     


    If you have found any of my posts helpful then please vote them as helpful. Kieran Patrick Wood MCTS BI, PGD SoftDev (Open), MBCS, MCC http://uk.linkedin.com/in/kieranpatrickwood
    Tuesday, May 17, 2011 11:42 AM

Answers

  • Assuming you have a SharePoint Site with SSRS configured in SharePoint Integrated Mode, and using VS2008R2 BIDS, you created a .rdl file, here would be your configurations in the VS Project Properties:

    TargetDataSourceFolder: http://myserver/sites/test/dataconnections
    TargetReportFolder: http://myserver/sites/test/reports
    TargetServerURL: http://myserver/sites/test

    where "dataconnections" is the Data Connection Library you have created in your SharePoint Site (http://myserver/sites/test) and "reports" is a Report Library (or any Document Library) you created in the same site.

    Hope this helps.

    ~Ani

    Tuesday, May 17, 2011 12:14 PM
  • Hi Kieran,

    Can you please try these steps:

    1. Create a Report Server Project in BIDS, add a Shared Data Source, create a RDL file with the shared data source, build the project.

    2. Go to SharePoint site (if your site is in path http://myserver/sites/testsite, then there must be some root site present like http://myserver. Also "Report Server Integration Feature" should be activated in the Site Collection Feature page), open the data connection library, upload the .rds (shared data source) file in the library.

    3. Select the uploaded .rds file in the SharePoint data connection library (created using Data Connection Library template), click on "Edit data source definition", check the connection string, enter username/password (which must have access to the database) in the "Stored credentials" section and Check "Use as Windows credentials". Test the connection. Check the "Enable this data source" option. Also "Approve" this .rds file from the ECB menu.

    4. Go to SharePoint site, open the library (created using Doument Library or Report Library template), upload the .rdl (report) file in the library.

    5. Select the uploaded .rdl file in the SharePoint library, click on "Manage data sources" in the dropdown. Select the name of the Shared data source name, browse the uploaded .rds file in the "Data Source Link" and click OK.

    6. Now try to open the .rdl file by clicking on it. If your SSRS is properly configured in SharePoint Integrated mode, the report should open up in Report Server page (/_layouts/ReportServer/RSViewerPage.aspx).

    These are all the steps required to publish a report in SharePoint site. In case you are getting errors in any of the steps, please provide some screenshot/error details mentioning the step.

    Note: In "Central Administration" please also verify the followings:

    General Application Settings -> Reporting Services -> Reporting Services Integration: Please check if you have "Windows Authentication" as Authentication mode and the Report ServerWeb Service URL can be accessed where your SharePoint site can be browsed till report folder.

    Also, using "Microsoft SQL Server Management Studio", please try to open the Report Server as follows and check whether you can open it or not:

    Server type: Reporting Services; Server name: your SharePoint site where you are trying to publish the report; Authentication: Windows Authentication.

    The above two should work if your Report server integration is properly done.

    Thanks,

    ~Ani


    ~Ani
    Wednesday, May 18, 2011 12:32 PM

All replies

  • Assuming you have a SharePoint Site with SSRS configured in SharePoint Integrated Mode, and using VS2008R2 BIDS, you created a .rdl file, here would be your configurations in the VS Project Properties:

    TargetDataSourceFolder: http://myserver/sites/test/dataconnections
    TargetReportFolder: http://myserver/sites/test/reports
    TargetServerURL: http://myserver/sites/test

    where "dataconnections" is the Data Connection Library you have created in your SharePoint Site (http://myserver/sites/test) and "reports" is a Report Library (or any Document Library) you created in the same site.

    Hope this helps.

    ~Ani

    Tuesday, May 17, 2011 12:14 PM
  • Thanks Anicodie,

    The problem I have in more detail is getting the report (rdl) file to connect to a valid data source file; -

    Just to get up and running within the "Data Source Properties" dialog box;-

    1) I have selected "Use a connection embedded in my report"
    2) Selected connection type "Microsoft Analysis Services"
    3) Data Source myServer;Initial Catalog=AnalysisServicesDatabase
    4) Within the Connection properties dialog box I click "Test Connection", the result is connection succeeded.
    5) I clicked OK to return to the "Data Source Properties"
    6) I clicked on the "Test Connection" button.
    7) The result was "Connection Created Successfully"
    8) On trying to run the report an error returned; -

    "The report server has encountered a configuration error. Logon failed for the unattended execution account. (rsServerConfigurationError) Log on failed.
    Ensure the user name and password are correct. (rsLogonFailed)

    For more information about this error navigate to the report server on the local server machine, or enable remote errors."

    I then clicked on the Credentials tab within the Data Source Properties Dialog box.

    The following radio button was selected; - "Use current Windows user. Kerberos delegation might be required."

    Can you give me any help on getting an SSRS Data Source connection to work within Sharepoint 2010?

    Kind Regards,

    Kieran.

     


    If you have found any of my posts helpful then please vote them as helpful. Kieran Patrick Wood MCTS BI, PGD SoftDev (Open), MBCS, MCC http://uk.linkedin.com/in/kieranpatrickwood


    Tuesday, May 17, 2011 1:04 PM
  • Can anyone help me on this? This issue is still outstanding. I'm still not able to deploy SSRS 2008 R2 Reports to Sharepoint 2010. Either by deploying from BIDs or uploading the SSRS files from within Sharepoint.

    1) When I try and deploy from BIDs I get a log in prompt.

    1.1) After following the guidance in http://msdn.microsoft.com/en-us/library/bb326288.aspx

    "
    1.2) To find the path information for a new SharePoint library or for an unfamiliar site, open a browser and locate the SharePoint library where you want to publish your reports. If the library is empty, upload any file. Right-click the file and select Properties to open the Properties window. The address of the file contains the URL values that you need for a publish operation.

    "

    2) When uploading the SSRS files from within Sharepoint.

    2.1) To create the simpliest possible scenario I create an embedded data source and embedded data set.
    2.2) When I try and open the report from within Sharepoint I get the following; -

    ·         The report server has encountered a configuration error. Logon failed for the unattended execution account. (rsServerConfigurationError)
    o    Log on failed. Ensure the user name and password are correct. (rsLogonFailed)
    §  For more information about this error navigate to the report server on the local server machine, or enable remote errors


    2.2.1) I then looked at the server latest log under C:\Program Files\Microsoft SQL Server\MSR10_50.<instance name>\Reporting Services\LogFiles. This is a large text file, I wasn't able to find any obvious diagnostics which directly relate to my problem. But to be honest I am not sure what I am looking for.

    2.3) I later clicked the drop down button to the right of the report I deployed then selected "Manage Data Sources"
    2.3.1) I clicked on the name of the embedded data source.
    2.3.2) I clicked on the "Test Connection" button, green text appeared saying "Connection created successfully.".

    2.4.1) I edited the deployed report within Report Builder 3.0 launched within Sharepoint 2010.
    2.4.2) The query executed fine within the data set component of this report returning data.
    2.4.3) On clicking on the run button I get the following error; -
    "For more information about this error navigate to the report server on the local server machine, or enable remote errors
    ----------------------------
    Log on failed. Ensure the user name and password are correct. (rsLogonFailed)
    ----------------------------
    The report server has encountered a configuration error. Logon failed for the unattended execution account. (rsServerConfigurationError)"

    On reflection my question has drifted from "deploying a SSRS 2008 R2 report to Sharepoint 2010" to "Help Resolving Configuration Issues within SSRS 2008 R2 integrated within Sharepoint 2010" so I will ask a separate question within the SSRS forum.

    Kind Regards,

    Kieran.

     


    If you have found any of my posts helpful then please vote them as helpful. Kieran Patrick Wood MCTS BI, PGD SoftDev (Open), MBCS, MCC http://uk.linkedin.com/in/kieranpatrickwood




    Wednesday, May 18, 2011 8:29 AM
  • Hi Kieran,

    Can you please try these steps:

    1. Create a Report Server Project in BIDS, add a Shared Data Source, create a RDL file with the shared data source, build the project.

    2. Go to SharePoint site (if your site is in path http://myserver/sites/testsite, then there must be some root site present like http://myserver. Also "Report Server Integration Feature" should be activated in the Site Collection Feature page), open the data connection library, upload the .rds (shared data source) file in the library.

    3. Select the uploaded .rds file in the SharePoint data connection library (created using Data Connection Library template), click on "Edit data source definition", check the connection string, enter username/password (which must have access to the database) in the "Stored credentials" section and Check "Use as Windows credentials". Test the connection. Check the "Enable this data source" option. Also "Approve" this .rds file from the ECB menu.

    4. Go to SharePoint site, open the library (created using Doument Library or Report Library template), upload the .rdl (report) file in the library.

    5. Select the uploaded .rdl file in the SharePoint library, click on "Manage data sources" in the dropdown. Select the name of the Shared data source name, browse the uploaded .rds file in the "Data Source Link" and click OK.

    6. Now try to open the .rdl file by clicking on it. If your SSRS is properly configured in SharePoint Integrated mode, the report should open up in Report Server page (/_layouts/ReportServer/RSViewerPage.aspx).

    These are all the steps required to publish a report in SharePoint site. In case you are getting errors in any of the steps, please provide some screenshot/error details mentioning the step.

    Note: In "Central Administration" please also verify the followings:

    General Application Settings -> Reporting Services -> Reporting Services Integration: Please check if you have "Windows Authentication" as Authentication mode and the Report ServerWeb Service URL can be accessed where your SharePoint site can be browsed till report folder.

    Also, using "Microsoft SQL Server Management Studio", please try to open the Report Server as follows and check whether you can open it or not:

    Server type: Reporting Services; Server name: your SharePoint site where you are trying to publish the report; Authentication: Windows Authentication.

    The above two should work if your Report server integration is properly done.

    Thanks,

    ~Ani


    ~Ani
    Wednesday, May 18, 2011 12:32 PM
  • Thanks again Anicodie you clearly have spent quite a lot of time writing a reply. I'm working through your guidance in more detail.
    If you have found any of my posts helpful then please vote them as helpful. Kieran Patrick Wood MCTS BI, PGD SoftDev (Open), MBCS, MCC http://uk.linkedin.com/in/kieranpatrickwood

    Wednesday, May 18, 2011 2:00 PM
  • No issues... I was just wondering what is wrong at your side, because for last few days I am woking on SSRS/SharePoint 2010 integration and all is so smooth this side...

    Anyway go ahead and let us know if it helped.

    ~Ani


    ~Ani
    Wednesday, May 18, 2011 5:10 PM
  • I confirm that between myself and an on site Sharepoint Administrator we have following all the guidance you have suggested. The rsServerConfigurationError error is now resolved.
    If you have found any of my posts helpful then please vote them as helpful. Kieran Patrick Wood MCTS BI, PGD SoftDev (Open), MBCS, MCC http://uk.linkedin.com/in/kieranpatrickwood
    Wednesday, May 18, 2011 7:59 PM