Tuesday, March 5, 2013

SSRS Deployment

How to Deploy in SSRS
  1. If you have followed the steps in Configure Deployment, then this will be one of the easiest things you will do. And you will love it.
    1. Click the Configuration Manager drop down in your toolbar and select the desired environment
      1. NOTE: This is critical. Make sure you select the correct environment. You should have already have configured this before this step. If you don't think you have, please go configure it.
    2. There are three options for deployment:
      1. Deploy full project
        1. In your Solution Explorer, right-click on your project and click Deploy
      2. Deploy one project item
        1. In your Solution Explorer, right-click on a specific project item and click Deploy
          1. i.e. DatasetName.rsd, or ReportName.rdl, or DataSourceName.rds
      3. Deploy multiple project items
        1. In your Solution Explorer, use Ctrl and select multiple project items and click Deploy
    3. Your Output will show your Build and Deployment.
    4. Here is a successful output:
------ Deploy started: Project: ProjectName, Configuration: Stage ------
Deploying to ReportServerUrl
Deploying report '/ProjectName/ReportName'.
Deploy complete -- 0 errors, 0 warnings
========== Build: 1 succeeded or up-to-date, 0 failed, 0 skipped ==========
========== Deploy: 1 succeeded, 0 failed, 0 skipped ==========

You have now deployed! You can verify it by clicking on the ReportServerUrl in the output

4 comments:

  1. I am Using SQL SERVER DATA TOOLS 2012.I am using Server DataBase.
    I created One RDL file ,But if i am trying to Deploying the RDL File I am getting the Error like this.["The permissions granted to user 'Server\Venkat' are insufficient for performing this operation."].I am new to Reports[SSRS].So please Help me anyone .
    Regards
    Bhargav Reddy.

    ReplyDelete
    Replies
    1. Are you the server administrator? This likely means that in Report Manager, the account you are deploying with doesn't have the appropriate permissions. So you will need to work with your server administrator to ensure that you are setup properly.

      Delete
    2. No ,I am not a Server Administrator but if i am trying to deploying the Project Or Report I am Getting
      This Error .
      Could not connect to the report server http //NAT2/ReportServer. verify that the target server url and have the permissions to connect to the report server.
      Additional Information[
      the server committed a protocol violation. section=responsestatusline(microsoft.status.reportingservices.designer 11.0)]
      So What Permissions i want to give .I am new to SSRS Reports.So please help me anyone.

      Regards
      Bhargav Reddy.

      Delete
  2. The url you posted isn't valid, not sure if it was just a typo, or that is what you actually have in the settings. http://someserver/reportserver should work depending on how it was installed. Http//won't work.

    I'll get back to you on ther permissions, but I would imagine you at least want publish permissions.

    ReplyDelete