- The requirement is to install Jasper server CE 7.8 with MSSQL repository database. Jasper server 7.8 platform support documentation says it supports MSSQL server as repository database.
- I tried Jasper server installation using WAR file method. But in the <jasperreports-server-cp-7.8.0-bin\buildomatic\install_resources\sql > directory, i don't find any ddl and other scirpts related to MSSQL.
- Is it possible to install Jasper Server CE 7.8 with MSSQL repository? How do we install the same?
Any help is appreciated.
I also found another document.
--> CHAPTER 3 INSTALLING THE WAR FILE DISTRIBUTION
--> 3.2 Applications Supported by the WAR File Distribution
--> 3.2.1 Database and Application Server Support
--> Database = PostgreSQL,MySQL
--> 3.3 Installing the WAR File Using js-install Scripts
--> Table 3-1 Sample Values for the default_master.properties File
--> Database = MySQL
In other words, I thought I could make MySQL the repository DB by editing the 'default_master.properties File' appropriately and installing it.
For your reference
Thanks for sharing the document!
Jasper CE provides the SQL scripts to configure PostgreSQL and MySQL as repository db. But Jasper CE doesn't provide scripts and properties file to configure Microsoft SQL server as repository db.
Jasper commercial edition supports Microsoft SQL server as repository.