How To Install Report Server

May 9, 2020

SHORT INTRODUCTION

Since its introduction in 2004, SQL Server reporting services have changed quite a bit. Despite new analytics services such as Power BI, SSRS is still a popular tool for paged reports. In this article, Kashi Kellenberger describes the architecture of SSRS and guides you through installing the SSRS development environment on your workstation or laptop.

Package Requirement :-we need to required pacakges to installjava ,tomcat server ,postgresql and reprtserver all are part of the installation.

INSTALLATION:

Step1 - Update the packages and repository using the following command.

$ sudo yum -y update

Install JAVA

Step2 - Run the following command to download the RPM package.

$ sudoyum -y install wget

$ sudo wget --no-cookies --no-check-certificate --header "Cookie:oraclelicense=accept-securebackup-cookie" http://download.oracle.com/otn-pub/java/jdk/8u131-b11/d54c1d3a095b4ff2b6607d096fa80163/jdk-8u131-linux-x64.rpm

Step3 - check the Java version.

$ sudo java -version

Step4 - You will also need to check if JAVA_HOME environment variable is set. Run the following command for same.

$ sudo echo $JAVA_HOME

Step5 - If you get a blank output, you will need to manually setthe JAVA_HOME variable. Run the following command to edit .bash_profile using vim.

$ sudo vi ~/.bash_profile

Now add the following lines at the at the end of the file.

$ sudo export JAVA_HOME=/usr/java/jdk1.8.0_131/

$ sudo export JRE_HOME=/usr/java/jdk1.8.0_131/jre

Step6 - Now source the file using the following command.

$ sudo source ~/.bash_profile

Step7 - check if the environment variable is set or not.

$ sudo echo $JAVA_HOME

Install Tomcat Server

Step8 - Run the following command to create tomcat user and group.

$sudo groupadd tomcat

$ sudo useradd -M -s /bin/nologin -g tomcat -d /opt/tomcat tomcat

Step9 - Now download the Tomcat archive from Tomcat download page using the following command.

$sudo cd ~

$sudo wget http://www-us.apache.org/dist/tomcat/tomcat-8/v8.5.32/bin/apache-tomcat-8.5.32.tar.gz

Step10 - Now we will install the tomcat server in /opt/tomcat directory. Create a new directory and extract the archive using the following command.

$sudo mkdir /opt/tomcat

$sudo tar xvf apache-tomcat-8*tar.gz -C /opt/tomcat --strip-components=1

Step11 - Now provide the ownership of the files to tomcat user and group using the following command.

$sudochown -R tomcat:tomcat /opt/tomcat

Install PostgreSQL

Step12 - Run the following command to install PostgreSQL.

$ sudo yum -y install postgresql-server postgresql-contrib

Step13 - Now initialize the database using the following command.

$sudo postgresql-setup initdb

Step14 - Start and enable PostgreSQL database service.

$sudo systemctl start postgresql

$ sudo systemctl enable postgresql

Step15 - change the password of PostgreSQL root user called postgres using the following command.

$sudo sudo -u postgres psql postgres

$ sudo \password postgres

Enter \q buttons to exit Postgres shell.

Step16 - create a new database or user for ReportServer database reportserver.

$sudo sudo -u postgres createdb reportserver

$ sudo sudo -u postgres createuser -P -s -e reportserver

You will need to enter the password twice. You should get the following output.

$sudo sudo -u postgres createuser -P -s -e reportserver

Enter password for new role:

Enter it again:

Step17 - Now assign the database user to the database using following command.

$sudo sudo -u postgres psql

$ sudo GRANT ALL PRIVILEGES ON DATABASE reportserver TO reportserver;

exit the shell using \q.

Step18 - Now , edit a PostgreSQL configuration file so that the database can be connected without the postgres user. Edit the pg_hba.conf using any editor.

$sudo vi /var/lib/pgsql/data/pg_hba.conf

Find the following lines and change peer to trust and idnet to md5.

Once updated, the configuration should look like shown below.

Step19 - Now restart PostgreSQL server .

$sudo systemctl restart postgresql

Install ReportServer

Step20 - Run the following command to download ReportServer using following command.

$sudo wget https://downloads.sourceforge.net/project/dw-rs/bin/3.0/RS3.0.2-5855-2016-05-29-17-55-24-reportserver-ce.zip -O reportserver.zip

Step21 - Now remove everything in the web ROOT folder of Tomcat installation using the following command.

$sudo rm -rf /opt/tomcat/webapps/ROOT/*

Step22 - Now extract the ReportServer archive using the following command.

$sudo Yum install unzip -y

$ sudo reportserver.zip -d /opt/tomcat/webapps/ROOT/

Step23 - Copy the configuration file from the example files using the following command.

$sudo cp /opt/tomcat/webapps/ROOT/WEB-INF/classes/persistence.properties.example /opt/tomcat/webapps/ROOT/WEB-INF/classes/persistence.properties

Step24 - Open the persistence.properties file and provide the database information which we have created earlier.

$sudo vi /opt/tomcat/webapps/ROOT/WEB-INF/classes/persistence.properties

Now add the following lines at the end of the file only green lines.

$ sudo hibernate.connection.username=reportserver
$ sudo hibernate.connection.password=StrongPassword
$ sudo hibernate.dialect=net.datenwerke.rs.utils.hibernate.PostgreSQLDialect
$ sudo hibernate.connection.driver_class=org.postgresql.Driver
$ sudo hibernate.connection.url=jdbc:postgresql://localhost/reportserver

Change the username, password and database name according to the database set created by you.

Step25 - Now provide the necessary ownership using the following command.

$ sudo chown -R tomcat:tomcat /opt/tomcat/webapps/ROOT/

Step26 - Now initialize the ReportServer database using the following command.

$sudo psql -U reportserver -d reportserver -a -f /opt/tomcat/webapps/ROOT/ddl/reportserver-RS3.0.2-5855-schema-PostgreSQL_CREATE.sql

provide the password and it will run the DDL script to initialize the database.

Step27 - Create a new Systemd file using the following command.

$ sudo vi /etc/systemd/system/tomcat.service

Copy and paste the following content into the file.

[Unit]
Description=Apache Tomcat Web Application Container
After=syslog.target network.target

[Service]

Type=forking

Environment=JRE_HOME=/usr/java/jdk1.8.0_131/jre

Environment=CATALINA_HOME=/opt/tomcat

Environment=CATALINA_BASE=/opt/tomcat

Environment=’JAVA_OPTS=”-Djava.awt.headless=true -Xmx2g -XX:+UseConcMarkSweepGC

-Dfile.encoding=UTF8 -Drs.configdir=/opt/reportserver”‘

ExecStart=/opt/tomcat/bin/startup.sh

ExecStop=/opt/tomcat/bin/shutdown.sh

User=tomcat

Group=tomcat

UMask=0007

RestartSec=10

Restart=always

[Install]

WantedBy=multi-user.target

Step28 - Enable and Start the application using the following command.

$ sudo systemctl start tomcat
$ sudo systemctl enable tomcat
$ sudo systemctl status tomcat

Step29 - You can now access your application on the following URL.

http://your-server-ip:8080

username root and password root.

Tags:

No tags