Comprehensive Guide to Successful SQL Server Reporting Services Setup

Table of Contents

• Introduction
• Registration
• Using Advanced Installer
  • GUI
  • Working with Projects
  • Installer Project
    * Product Information
    * Resources
    * Package Definition
    * Requirements
    * User Interface
    * System Changes
    * Server
    * Internet Information Services Page”)
    * ODBC
    * SQL Databases
    * Database server
    * SSRS Deployments
    * Edit SSRS resources dialog
    * SQL Operations
    * SharePoint Page
    * Silverlight Page
    * Custom Behavior
  • Patch Project
  • Merge Module Project
  • Updates Configuration Project
  • Windows Store App Project
  • Modification Package Project
  • Optional Package Project
  • Windows Mobile CAB Projects
  • Visual Studio Extension Project
  • Software Installer Wizards - Advanced Installer
  • Visual Studio integration
  • Alternative to AdminStudio/Wise
  • Replace Wise
  • Migrating from Visual Studio Installer
  • Keyboard Shortcuts
  • Shell Integration
  • Command Line
  • Advanced Installer PowerShell Automation Interfaces
• Features and Functionality
• Tutorials
• Samples
• How-tos
• FAQs
• Windows Installer
• Deployment Technologies
• IT Pro
• MSIX
• Video Tutorials
• Advanced Installer Blog
• Table of Contents

Disclaimer: This post includes affiliate links

If you click on a link and make a purchase, I may receive a commission at no extra cost to you.

SSRS Deployments

This section allows you to configure SSRS deployments which will be executed during installation. You might use it if the installation needs to upload reports, datasets or data sources to an instance ofMicrosoft SQL Server Reporting Services.

To create a new deployment use the [New SSRS Deployment ] toolbar button or the “New deployment” context menu item.

To impersonate the current user, use the “Impersonate installing user” context menu option. You can check this option if you want to run the deployment as the user installing the application, not under the Local System account.

General

Server URL

URL of the Report Server Web Service (e.g.http://localhost:80/ReportServer\_INSTANCENAME ). Edit this field using Smart Condition Edit Control .

Reports folder

The name of the target folder where the reports will be deployed. Edit this field using Smart Condition Edit Control .

Dataset folder

The name of the target folder where the datasets will be deployed. Edit this field using Smart Condition Edit Control .

Datasource folder

The name of the target folder where the datasources will be deployed. Edit this field using Smart Edit Control .

Condition

The condition for reports deployment. Edit this field usingSmart Condition Edit Control .

Remove resources when uninstalling application

By enabling this option all reports’ resources are removed during uninstall.

Resources

Here you can add and edit the files needed for the deployment (report, dataset and datasource files).

Adding a new resource

Select your resources using the [Add… ] button.

Editing an SSRS deployment

Use the [Edit… ] button, the “Edit…” context menu item or press theSpace key while an element from the list is selected. The Edit SSRS resources dialog dialog will be displayed allowing you to edit the properties of the resource’s deployment.

Removing an SSRS deployment

To remove an existing resource use the [Remove ] button.

You can target the deployment to a server that is running on a different machine than the one where the installer is running, only if the machines are connected to the same domain.

For performing the deployment, Advanced Installer uses a tool which is part of the Reporting Services component of the SQL Server. Therefore you must have an instance of the SQL Server installed on the machine where you are running the install package.

For more detailed help, please press the F1 key.

Topics

• Edit SSRS resources dialog
  Edit SSRS resources dialog

Did you find this page useful?

Please give it a rating:

Thanks!

Report a problem on this page

Information is incorrect or missing

Information is unclear or confusing

Something else

Can you tell us what’s wrong?

Send message

Also read: