Blog

How to Deploy SSRS Report in Server

  • (5.0)

Deploying Reports

Reports can be deployed either individually, or as part of a complete project deployment. In this tutorial, you will deploy the complete project to your local development machine.

Before deploying a project, you will need to set the target for deployment. On your local machine, as long as everything was set up using the default settings, the target will be HTTP://LOCALHOST/REPORTSERVER

Users will view and run reports from a similar URL: HTTP://LOCALHOST/REPORTS. It is worth checking that Reporting Services is running by visiting these two URLs in Internet Explorer now, to avoid problems later.

Enroll for Instructor Led SSRS Training

There is also sometimes an security issue that you might encounter. To avoid this, run Internet Explorer as an Administrator by right-clicking on the icon and selecting ‘Run as Administrator’.

If neither of the URLs work, you should open Reporting Services Configuration Manager and check that Reporting Services is running (this catches people out more than you might think!) and also check the URLs that were set up under Web Service URL and Report Manager URL.

All being well, the steps in this section should deploy your project to your local report server. Unfortunately, if you are deploying to a non-default location, you might encounter some issues. If this is the case, ask the person who manages the Report server for any specific settings you might need to supply.

Related Page: How To Publish Report To A Report Server In SSRS

Try it

1. In Solution Explorer, right-click on the project and select Properties.

2. In the window that opens, find the TargetServerURL property and set it to the Report Manager URL. The default is:
HTTP://LOCALHOST/REPORTSERVER

3. Click OK.

4. Right-click on the project name again and choose Deploy.

5. Open the Web Service URL HTTP://LOCALHOST/REPORTS to view your reports.

Frequently Asked SSRS Interview Questions & Answers

 

List of Related Microsoft Certification Courses:

 SSIS  Power BI
 SSAS  SQL Server
 SCCM  SQL Server DBA
 SharePoint  BizTalk Server
 Team Foundation Server  BizTalk Server Administrator

 


Popular Courses in 2018

Get Updates on Tech posts, Interview & Certification questions and training schedules