SSRS Report Deployment

When you finish developing a report, you need to deploy it in order to make it available to the appropriate people. We will show you step by step included with to solve the Permission Granted in your deployment and also Data Source Credential not meet the requirement.

Deploy report in Visual Studio

1- First, we need to set Target Server Location for deployment.
Go to Visual Studio -> Right Click on the first node -> Properties

2- Your default will look something like this. TargetServerURL is empty. We need to set the location based on your report manager.

3- Now, we are going to get the TargetServerURL. 

Open your Reporting Services Configuration Manager -> go to Tab Web Service URL -> Copy URL -> Paste it in Report Properties located in VS (picture 2).

*Note: Before copy the URL, please test the link first by clicking on it. If you have not done any deployment yet, you will see something like this.

After deployment, you will see all folder and sub folder with the link for each of the reports.

4- Before we going to deploy the reports, double check your data source just to be sure.

Right click DataSource on the left of your screen -> Data Source Properties.

This is where and how you choose your type of DataSource. You could do Embedded Connection or Shared Data Source. We choose to use a Shared Data Source.

5- Let's go for the Deployment. To do this, Right click on the first node -> Deploy.

Sometimes, you might see Permission Granted to User.

Just close your VS. Open back your VS as Administrator.

To differentiate VS is as Administrator or not, just look at the on top of the VS. For administrator, it will stated as Administrator.

Now, you can re-do Step 5 to deploy the report. You will see deploy succeed.

Deployment have successfully deployed. Now, we need to make sure that the reports can be view in the server. 

1- Open your Reporting Services Configuration Manager -> go to Tab Report Manager URL -> Click the link / Copy the link and open it in IE.

And you will see Folders and sub-folders that you have been deployed. 

2- Click on the report folder -> click the report to view. 

3- If you receive User does not have permission, Close IE, and Open IE as Administrator.

4- However, if you receive something about Data source credentials do not meet the requirement to run this report like picture below: 

5- You need to check related data source that is required by the report.

Go to Report Manager -> Data Source Folder -> DataSource

6- This is where we can set for type of the credential either to let user keep on inserting the credential or have set it in the server. By default, report server will choose credential are not required. 

7- For better solution, we choose for the credential to be stored securely in the server. Run test connection. 

Choosing Credential not required will show this error: 

We have check Data Source in the Report Manager, now we also need to check DataSource in the report itself. 

1- Right click report in the Report Manager -> Manage

2- Go to Tab Data Sources. 

3- If the data sources not showing the same setting with your report in VS, change the setting according your VS report setting. For us, we used a shared data source. 

Choose a shared data source radio button -> Browse

4- Choose Data Source location. 

5- Go back to Home -> Click on the report -> Insert parameter (if required).

Now, you can see your report in user view. So, this is the way to deploy your report(s).

*EXTRA NOTES*

If you notice, there are 2 URL located in Reporting Services Configuration Manager. 

• Report Manager URL : Http://servername/reports
• ReportServer URL : http://servername/reportserver 

1.Report Manager is a convenient web user interface to the Report Server that enables you to view and administer your reports, data sources, and report resources. 

2.Report Server is the web service application that functions as your programmatic gateway to the SQL Reporting Services engine. When browsing to the Report Server, you will be shown the contents of your individual Reports directory. This is the location you will deploy to.