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)

8 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
    2. Sorry for too late.
      But now we facing the same issue, is there anyone who respond on this.
      We are facing same error on log file:
      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"

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

    ReplyDelete