Installation of Jaspersoft 6.2 failed with the following error:
after executing install.bat:
Buildfile: C:\JASPER6.2\ca_install\build.xml
preinstallcheck:
[echo] Installation Component is:
[java] Initializing the Pre-Install Validation LOG file in ValidateAppServe
r Java
[java] Validation of Application server is completed Successfully
[java] Initializing the Pre-Install Validation LOG file in ValidateDbServer
Java
[java] Preinstall check failed with following errors -
[java] 16106: INVALID_APPSERVER_STATUS
[java] 16220: DBUSERNAME_INSUFFICIENT_RIGHTS
[java] 16220: DBUSERNAME_INSUFFICIENT_RIGHTS
[java] Java Result: 1
BUILD FAILED
C:\JASPER6.2\ca_install\build.xml:130: Preinstall check failed
This issue occurs because the user configured in the sample.properties doesn't have the correct grants to access the MS SQL to create a DB.
in sample.properties file the configured user as "dbUsername= xxxxx" must have roles: "public and dbcreator" to be able to create a the jaspersoft database in MS SQL.
Note: this is a pre-requisite to install Jaspersoft 6.2.