ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Cannot select SQL Server when installing Jasper Server r7.2/7.9

book

Article ID: 225046

calendar_today

Updated On:

Products

CA Service Management - Service Desk Manager CA Service Desk Manager

Issue/Introduction

Installing CA Business Intelligence JasperServer r7.2/7.9 and we are not seeing an option to use MS SQL as the database, it only allows to select postgreSQL. 

In the past when we installed CABI r7.1.1 we had an option to chose the database type like MSSQL, Oracle, postgreSQL.

Cause

Jasper Server 7.2/7.9 installer only allows one to select the postgreSQL database.  In order to perform an install using SQL Server, there are manual steps which are available to install Jasper 7.2/7.9.  

Environment

Release : 17.3

Component :  CA Business Intelligence 7.2/7.9

Resolution

Please note that the install instructions have not been certified or tested by Broadcom and come from Tibco.

The instructions can be located here:

7.2:

https://community.jaspersoft.com/documentation/tibco-jasperreports-server-installation-guide/v720/installing-war-file-using-js#warfiledist_4279087660_1148723

7.9:

https://community.jaspersoft.com/documentation/tibco-jasperreports-server-installation-guide/v790/installing-war-file-using-js#warfiledist_4279087660_1148723