GUI-Install CABI-Jasper 7.1.1 - DB Jasperserver cannot be created in mssql

[Peter Schmidt]

Hi,
tried to reinstall Jasper 7.1.1 - Server.
Old installation was on c:
New one should be on d:

Starting setup.bat from admin-CMD. My user is in group administrators.

Tried several:
1. I didn't remove DB jasperserver from mssql: GUI says that it exits and does not proceed
2. After renaming DB jasperserver to jasperserver_OLD GUI continues and installation starts.
2.1 But when install tries to install DB jasperserver it runs into error:

2020-09-17 18:08:48 INFO JasperInstaller:201 - pre-install-test-pro:
2020-09-17 18:08:48 INFO JasperInstaller:201 -
2020-09-17 18:08:48 INFO JasperInstaller:201 - recreate-js-db:
2020-09-17 18:08:48 INFO JasperInstaller:201 - [echo] Validating JasperServer database connection at jdbc:tibcosoftware:sqlserver://<server>:1433;databaseName=jasperserver;sendTimestampEscapeAsString=false. Phase: [before]
2020-09-17 18:08:48 INFO JasperInstaller:201 - [echo] About to validate JDBC jar existence
2020-09-17 18:08:48 INFO JasperInstaller:201 - [echo] Look in: D:/quellen/Jasper 7.1.1/buildomatic/conf_source/db/sqlserver/jdbc
2020-09-17 18:08:48 INFO JasperInstaller:201 - [echo] Found jar file: assuming OK
2020-09-17 18:08:48 INFO JasperInstaller:201 - [echo] Jar or Jars found: TIsqlserver-5.14.1.jar;jasperreports-pro-7.1.0.jar
2020-09-17 18:08:55 INFO JasperInstaller:201 - [advanced-sql] Failed to connect: [TibcoSoftware][SQLServer JDBC Driver][SQLServer]Die von der Anmeldung angeforderte jasperserver-Datenbank kann nicht ge��et werden. Fehler bei der Anmeldung.
2020-09-17 18:08:55 INFO JasperInstaller:201 - [echo] Connection failed:
2020-09-17 18:08:55 INFO JasperInstaller:201 - [echo] SQLState: 08001
2020-09-17 18:08:55 INFO JasperInstaller:201 - [echo] Vendor specific error code: 4060
2020-09-17 18:08:55 INFO JasperInstaller:201 - [echo] Message: [[TibcoSoftware][SQLServer JDBC Driver][SQLServer]Die von der Anmeldung angeforderte jasperserver-Datenbank kann nicht ge��et werden. Fehler bei der Anmeldung.]
2020-09-17 18:08:55 INFO JasperInstaller:201 - [echo] Database doesn't exist. Treating problem with JDBC connection as noncritical. Proceeding to next step
2020-09-17 18:08:55 INFO JasperInstaller:201 - [echo] Filtering properties (cleaning out blank spaces)
2020-09-17 18:08:55 INFO JasperInstaller:201 - [encrypt-props] The master properties have already been encrypted. To re-enable the encryption, make sure the passwords are in plain text, set master property encrypt to true and remove encrypt.done.
2020-09-17 18:08:55 INFO JasperInstaller:201 - [echo] chkIfPackageManagedTomcat: check if package managed tomcat
2020-09-17 18:08:55 INFO JasperInstaller:201 - [echo] Tomcat DBCP Factory: com.jaspersoft.jasperserver.tomcat.jndi.JSCommonsBasicDataSourceFactory
2020-09-17 18:08:55 INFO JasperInstaller:201 - [echo] chkAndSetLocaleDbSettings: parse: scripts.properties for db commands
2020-09-17 18:08:55 INFO JasperInstaller:201 - [copy] Copying 1 file to D:\quellen\Jasper 7.1.1\buildomatic\conf_source\db\sqlserver\jdbc
2020-09-17 18:08:55 INFO JasperInstaller:201 - [echo] chkIfPackageManagedTomcat: check if package managed tomcat
2020-09-17 18:08:56 INFO JasperInstaller:201 - [taskdef] Could not load definitions from resource org/jacoco/ant/antlib.xml. It could not be found.
2020-09-17 18:08:56 INFO JasperInstaller:201 - [echo] using settings file: D:/quellen/Jasper 7.1.1/buildomatic/build_conf/default/maven_settings.xml
2020-09-17 18:08:56 INFO JasperInstaller:201 -
2020-09-17 18:08:56 INFO JasperInstaller:201 - create-js-db:
2020-09-17 18:08:56 INFO JasperInstaller:201 - [echo] Creating database, js.dbName = jasperserver, create database jasperserver
2020-09-17 18:08:56 INFO JasperInstaller:201 - [echo] About to validate JDBC jar existence
2020-09-17 18:08:56 INFO JasperInstaller:201 - [echo] Look in: D:/quellen/Jasper 7.1.1/buildomatic/conf_source/db/sqlserver/jdbc
2020-09-17 18:08:56 INFO JasperInstaller:201 - [echo] Found jar file: assuming OK
2020-09-17 18:08:56 INFO JasperInstaller:201 - [echo] Jar or Jars found: TIsqlserver-5.14.1.jar;jasperreports-pro-7.1.0.jar
2020-09-17 18:08:56 INFO JasperInstaller:201 - [advanced-sql] Executing commands
2020-09-17 18:08:56 INFO JasperInstaller:201 - [advanced-sql] Failed to execute: create database jasperserver
2020-09-17 18:08:56 INFO JasperInstaller:201 -
2020-09-17 18:08:56 INFO JasperInstaller:205 - BUILD FAILED
2020-09-17 18:08:56 ERROR CABIUtil:109 - ErrorCode : 19033 ErrorMessage :
2020-09-17 18:08:56 ERROR CABIUtil:109 - ErrorCode : 19033 ErrorMessage :
2020-09-17 18:08:56 ERROR CABIUtil:109 - ErrorCode : 19033 ErrorMessage :
2020-09-17 18:08:56 DEBUG ProgressThread:88 - Error code from component install is: 1
2020-09-17 18:08:56 DEBUG ProgressThread:90 - Getting the error codes list from CABIInstallException object
2020-09-17 18:08:56 INFO ProgressThread:93 - Error code is: 19033
2020-09-17 18:08:56 DEBUG ProgressThread:95 - Error key is: ERROR_JASPERSERVER_INSTALL
2020-09-17 18:08:56 DEBUG ProgressThread:97 - Error message is: Error while installing CA Business Intelligence
2020-09-17 18:08:56 INFO ProgressThread:103 - 1

What does 19033 mean?
Any idea what I could do else?

Thanks,
Peter

------------------------------
Senior Technical Consultant
Fujitsu Services
------------------------------

[Peter Schmidt]

ah, found it - that hurts ;-)
I only renamed databas but didn't move the dataase themselves.

After moving jasperserver.mdf/ldf to jasperserver_OLD.mdf/ldf DB-create was running.

Regards,
Peter

------------------------------
Senior Technical Consultant
Fujitsu Services
------------------------------