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.
Step1 - Update the packages and repository using the following command.
Step2 - Run the following command to download the RPM package.
Step3 - check the Java version.
Step4 - You will also need to check if JAVA_HOME environment variable is set. Run the following command for same.
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.
Now add the following lines at the at the end of the file.
Step6 - Now source the file using the following command.
Step7 - check if the environment variable is set or not.
Install Tomcat Server
Step8 - Run the following command to create tomcat user and group.
Step9 - Now download the Tomcat archive from Tomcat download page using the following command.
Step10 - Now we will install the tomcat server in /opt/tomcat directory. Create a new directory and extract the archive using the following command.
Step11 - Now provide the ownership of the files to tomcat user and group using the following command.
Step12 - Run the following command to install PostgreSQL.
Step13 - Now initialize the database using the following command.
Step14 - Start and enable PostgreSQL database service.
Step15 - change the password of PostgreSQL root user called postgres using the following command.
Enter \q buttons to exit Postgres shell.
Step16 - create a new database or user for ReportServer database reportserver.
You will need to enter the password twice. You should get the following output.
Enter password for new role:
Enter it again:
Step17 - Now assign the database user to the database using following command.
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.
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 .
Step20 - Run the following command to download ReportServer using following command.
Step21 - Now remove everything in the web ROOT folder of Tomcat installation using the following command.
Step22 - Now extract the ReportServer archive using the following command.
Step23 - Copy the configuration file from the example files using the following command.
Step24 - Open the persistence.properties file and provide the database information which we have created earlier.
Now add the following lines at the end of the file only green lines.
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.
Step26 - Now initialize the ReportServer database using the following command.
provide the password and it will run the DDL script to initialize the database.
Step27 - Create a new Systemd file using the following command.
Copy and paste the following content into the file.
Description=Apache Tomcat Web Application Container
Environment=’JAVA_OPTS=”-Djava.awt.headless=true -Xmx2g -XX:+UseConcMarkSweepGC
Step28 - Enable and Start the application using the following command.
Step29 - You can now access your application on the following URL.
username root and password root.