Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Deploying Sql Server Reporting Services reports on production boxes

How to deploy Sql server reports on productions boxes? Locally it's not a problem, I just specify the url and then right click on project and say deploy which deploy on my local server.

But it's not gonna be the case for the production server

like image 739
Miral Avatar asked Jan 22 '09 10:01

Miral


People also ask

How do I deploy an RDL file?

Firstly, open the RDL file of the report that you want to deploy in the report server from the Microsoft Report Builder tool. Then, connect it to the report server as depicted below by providing the report server URL and click on Connect. Then it starts connecting to the report server. Wait for a few minutes.

What are the different modes of deployment for SSRS?

A Reporting Services report server runs in one of two deployment modes; Native mode or SharePoint mode.


1 Answers

I recommend you create rs scripts that can be executed on production server. Take a look at Reporting Services Scripter. It's creates deployment scripts based on your current installation.

http://www.sqldbatips.com/showarticle.asp?ID=62

like image 163
João Vieira Avatar answered Sep 21 '22 02:09

João Vieira