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.

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