Post
Ask Question

SSRS (1) --- Server Setup: SSIS, SSAS, and SSRS

Note: this article is published on 08/04/2024.

This series of articles will discuss SQL Server Reporting Services, including the related Services:

A - Introduction

The services discussed include:

  • SSIS --- SQL Server Integration Services
  • SSAS --- SQL Server Analysis Services
  • SSRS --- SQL Server Reporting Services
  • SSDT --- SQL Server Data Tools

This article will be the first article in this series, and it will discusses the Server Instalation and Configuration. The next article will discuss the client (development environment) Setup, and the last article will discuss the report build and deploy. The content of this article:

  • A - Introduction
  • B- SSIS (SSAS) Installation
  • C - SSRS Installation and Configuration
    • C.1 - Installation
    • C.2 - Configuration --- Report Server Configuration Manager
      1. Setup Service Account
      2. Setup Web Service URL
      3. Setup Web Portal URL
      4.  Setup Database
    • C.3 - Results
      • Database
      • SSRS Web Service
      • SSRS Web Portal

B - SSIS (SSAS) Installation

Following the article:

We run SQL Server inslatter to add the SQL Server Services into an existing SQL instance (Developer Edition). Choose Custom Mode:

By using the custom mode, you can choose to add more features:

If you previously installed a custom mode, and installed the whole features:

You need to make sure the following features are installed:

  • Under Shared Features, select Integration Services.
  • Under Shared features, optionally select Client Tools SDK to install managed assemblies for Integration Services programming.
  • Under Instance Features, optionally select Database Engine Services to host the SSIS Catalog database, SSISDB, to store, manage, run, and monitor SSIS packages.
  • Under Instance Features, optionally select Analysis Service

If you installed a basic mode, Add the features that were not installed, like this:

Installing:

Done

C - SSRS Installation and Configuration:

We start from here:

Following the instruction page from the link:

C.1 - Installation:

  • Install:

  • Choose Developer Editioin:

  • Click Configue report server to start to configure:

C. 2 - Configuration:

  • We got Report Server Configuration Manager:

  • 1. Setup Service Account: choose the default, otherwise, the user must have the admin right:

  • 2. Setup Web Service URL: choose the default: ReportServer
    • This site will be used to deploy the Report Service File

  • 3. Setup Web Portal URL: choose the default Reports
    • This site will be used to view the Report

  • 4. Setup Database => Change Database

  • 4-1. Change Database:
    • Choose Create a new report Server Database: you should choose this option especially when you setup it the first time, because you have to have a Report Server Database that includes the Report contents:

  • 4-2. Change Database
    • Set up Database Server: choose the default user

  • 4-2-1. Test Connection:

  • 4-3. Change Database
    • Set up Database: choose the default (SQL 2022, name as SSISDB)

  • 4-3-1. Change Database
    • Set up Database: choose the default (SQL 2019, name as ReportServer)

  • 4-4. Change Database
    • Set up Credentials: choose the default

  • 4-5. Change Database
    • Summary

  • 4-6. Change Database
    • Process

  • 4-7. Done for Setup Database 

C.3 -1 Results

  • Database
    • A database SSISDB, and a temp database SSISDBTempDB created

  • SSRS Web Service --- for deployment

  • SSRS Web Portal --- for Browsing

 

References:


Similar Articles