Tuesday, September 25, 2012

SharePoint Integrated SSRS: BIDS Deployment: Multiple Login Prompts

Scenario
  • You are using SQL Server Business Intelligence Development Studio to deploy a report project to a  SQL Server Reporting Server in SharePoint Integrated Mode
  • You are attempting to use the SharePoint Server address with "/reportserver/" or the Report Library address. 
    • Note: BIDS asks for this format which may not work: "http://<servername>/reportserver"
Issue
  • You repeatedly receive "Reporting Services Login" authentication prompts when attempting to deploy and eventually fail to deploy
Resolution
  • Use "http://servername/" or "/_layouts/ReportServer" in the TargetServerURL path in the project properties
    • Ex: "http://intranet.company.com/" or "http://intranet.company.com/_layouts/ReportServer"
    • If you use the server name, make sure to include the trailing forward slash
  • Use the Report Library/Folder location in the Target*****Folder settings
    • Note: You can use folder paths if your library contains folders. 
      • Ex: ".../Reports/Folder1/Folder2"
  • Here's an example of the settings (Right Click the project and select properties)

7 comments:

  1. Hello Freeman, I have not yet succeeded in using ssrs 2008 because i get a login prompt to which i dont have the input.
    i am an administrator on my laptop, windows 7 ultimate, my account was added as sqlserver administrator at installation, i am using local system account on all my services, please help.
    (All my reports build successfully but i havenot deployed them.)
    Andre

    ReplyDelete
  2. I have also discovered that my homepage is blank wiouth links to the content, properties and site settings, please help me figure out what i need to do to get it running.

    ReplyDelete
    Replies
    1. Hi Andre,

      You may need to engage with a consultant. You can hire a SharePoint contractor through http://www.votematrix.com/ or you can try MS support.

      Good luck!

      Delete
  3. Thanks for pointing me in the right direction ... finally got it to deploy with the following configuration ... /localhost/sites/AdvWorks/TheBICentre/Data%20Connections for the Target Data source folder .... /localhost/sites/AdvWorks/TheBICentre/ReportsLibrary for the Target report folder and http://localhost/ReportServer for the Target Server URL

    ReplyDelete
  4. Hi Robert,

    I've tried your method but it still has not worked for me. I am able to upload the reports through the SharePoint interface but I cannot deploy them through Visual Studio.
    I am using SharePoint 2013 w/SSRS 2012. I also have Claims and Windows Authentication enabled. Here are my settings:

    Web Application = https://client.test.com/
    Site Collection = https://client.test.com/
    Site = https://client.test.com/Client1/
    Document Library = https://client.test.com/Client1/Reports/

    TargetDatasetFolder = https://client.test.com/Client1/Reports/Datasets
    TargetDataSourceFolder = https://client.test.com/Client1/Reports/DataSources
    TargetReportFolder = https://client.test.com/Client1/Reports/Reports
    TargetReportPartFolder = https://client.test.com/Client1/Reports/ReportParts
    TargetServerUrl = https://client.test.com/Client1/

    Is there anything that I have entered incorrectly? In the SharePoint logs I see the "Access Denied" error with the request targeting
    "SPRequest.OpenWeb: UserPrincipalName=, AppPrincipalName= ,bstrUrl=https://client.test.com/Client1/ReportService2006.asmx"

    ReplyDelete
    Replies
    1. did you make any progress on this?

      Delete
  5. This comment has been removed by the author.

    ReplyDelete