Cannot select SQL Server when installing Jasper Server r7.2

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 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 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.  

Environment

Release : 17.3

Component :  CA Business Intelligence 7.2

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:

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

 

Additional Information

The above installation scenario with Jasper 7.2 applies to new installations.  You should be able to install Jasper 7.1.1, then upgrade to Jasper 7.2, which will retain the SQL Server element.