locked
Publish reports with custom authentication? RRS feed

  • Question

  • When publishing reports from Visual Studio, does VStudio authenticate with SSRS/Reportingservice2010?  What permissions are required to publish reports?

    thanks

    scott

    Wednesday, February 18, 2015 2:37 PM

Answers

  • It will prompt you for username and password when you deploy reports, if configured properly.

    What happens when you deploy reports?


    Regards,
    Vishal Patel
    Blog: http://vspatel.co.uk
    Site: http://lehrity.com

    • Marked as answer by scott_m Monday, February 23, 2015 4:19 AM
    Thursday, February 19, 2015 10:52 AM

All replies

  • Yes it will require permission. I will normally create folder and then grant Publisher or Content Manager to users so that they can deploy. Dont forget to run BIDS as Administrator if you see any error. Below is text from here....

    s Olaf posted, one possibility reason is that you don’t have the permission to deploy reports to Report Server. Generally, Reporting Services in native mode includes five default Item-level roles which are Brower, Content Manager, My Reports, Publisher and Report Builder. If users want to deploy reports to Report Server, first we should assign an Item-level role for those users. Such as Content Manager, My Reports or Publisher, those Item-level roles have the permission to deploy reports to Report Server. So, please ensure you have permission to deploy reports to Report Server.
    For more information about setting Item-level permission on a Report Server, please refer to the article below:
    http://msdn.microsoft.com/en-us/library/aa337471.aspx

    If you are an administrator and the Operating System is one of Windows Vista, Windows 7, Windows 2008 or Windows 2008R2, and the User Account Control(UAC) is enabled, another reason is UAC lead to this issue. If you want to deploy reports to Report Server, you can right-click Business Intelligence Development Studio tool, and then select Run as administrator. For more information about configure a Report Server for local administrator, please refer to the article below:
    http://msdn.microsoft.com/en-us/library/bb630430.aspx



    Regards,
    Vishal Patel
    Blog: http://vspatel.co.uk
    Site: http://lehrity.com

    Wednesday, February 18, 2015 4:36 PM
  • We are using FormsAuth custom authentication with SSRS. How do you pass custom auth credentials to ReportService2010.asmx when publishing reports from VS2013?  When connecting from SSMS to SSRS, there is an option for FormsAuthentication credentials.  I see no such option when publishing reports from VS2013:

    VS2013 Report / Project properties

    Connect to SSRS from SSMS via FormsAuth
    • Edited by scott_m Thursday, February 19, 2015 4:26 AM
    Thursday, February 19, 2015 4:23 AM
  • It will prompt you for username and password when you deploy reports, if configured properly.

    What happens when you deploy reports?


    Regards,
    Vishal Patel
    Blog: http://vspatel.co.uk
    Site: http://lehrity.com

    • Marked as answer by scott_m Monday, February 23, 2015 4:19 AM
    Thursday, February 19, 2015 10:52 AM
  • In stepping through the code, it appears that Visual Studio unsuccessfully invokes the ReportingService2010 LogonUser soap action with empty userName/password like 3 times.  Then the next time, Visual studio display a modal dialog box asking for user credentials.  It sure would be nice to have the VS2012 credentials correct the first time.  Is there a good way in visual studio to specify the credentials prior to deploy so we don't flood the log with needless login failures?

    Thursday, February 19, 2015 9:16 PM