SQL Server has been configured to use named instances with dynamic port numbers instead a default instance and a static port number. Attempting to install Jaspersoft using a SQL Server named instance for the database results in the following error message:
BUILD FAILED
c:\Clarity_temp\install.xml:159: Unable to connect Jasper Database
ERROR: java.sql.SQLNonTransientConnectionException: [CA Clarity][SQLServer JDBC Driver]Conflicting connection information. When the instance name is specified, it is invalid to specify the port number.
How do you install Jaspersoft using a reporting database on a SQL Server named Instance?
The named instance must be on a static port (named instances use dynamic ports by default). So to workaround this error add a static port number for the SQL Server named instance.
1) Standalone
2) Cluster
Updating property file: c:\Clarity_temp\buildomatic\default_master.properties
Updating property file: c:\Clarity_temp\buildomatic\default_master.properties
Updating property file: c:\Clarity_temp\buildomatic\default_master.properties
Copying file for adding CALL prefix at the end of line
Copying 1 file to c:\Clarity_temp\buildomatic
Copying c:\Clarity_temp\resources\js-ant.bat to c:\Clarity_temp\buildomatic\js-ant.bat
install:
-------------------------------------------------------------------------------
You chose the following:
App server Location = C:\Tomcat\apache-tomecat-7.0.55
Database Type = SQL Server
Database Hostname = <SQL Server Host>
Database Port = 52000
Jaspersoft Database Username = ppm_jaspersoft
jaspersoft web app Name = reportservice
Jaspersoft Install Mode = standalone
----------------------------------------------------------------------------------
All being well this time the Jaspersoft server installation continue to end with a large number messages in between but with final message that reads
##############################################
The jasper web app url can be access from the following url
http://<server name>:8080/reportservice
##############################################
j_install:
BUILD SUCCESSFUL
Total time: 19 minutes 19 seconds