How to Deploy SSRS Report in Server

Deploying Reports in SSRS

Reports can be deployed either individually, or as part of 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.

If you would like to become SSRS (SQL Server Reporting Services) certified professional, then visit Mindmajix - A Global online training platform: "SSRS Online Training and Certification". This course will help you to achieve excellence in this domain.

There is also sometimes a 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 works, 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.

MindMajix YouTube Channel

                                                             (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:

report server

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
 SharePoint BizTalk Server
 Team Foundation Server BizTalk Server Administrator



Course Schedule
SSRS TrainingJun 01 to Jun 16View Details
SSRS TrainingJun 04 to Jun 19View Details
SSRS TrainingJun 08 to Jun 23View Details
SSRS TrainingJun 11 to Jun 26View Details
Last updated: 03 Apr 2023
About Author

Ravindra Savaram is a Technical Lead at His passion lies in writing articles on the most popular IT platforms including Machine learning, DevOps, Data Science, Artificial Intelligence, RPA, Deep Learning, and so on. You can stay up to date on all these technologies by following him on LinkedIn and Twitter.

read less