How do you install Jaspersoft using a reporting database on a SQL Server named instance

Document ID : KB000030995
Last Modified Date : 14/02/2018
Show Technical Document Details

Summary:

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?

Instructions:

  • 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.
  • Do not include '\<named instance>' as part of the SQL server hostname.
  • For example selecting static port with a value of 52000 was created through the SQL Server configuration then the following steps will be as follows:-
  • Select Installation Mode

 1) Standalone
 2) Cluster 

  • Choose option [1]: 
  • Select Database Type
     1) Oracle
     2) MSSQL 
  • Choose option [2]: 
  • Enter SQL Server Database Hostname [SQLServerHost] : 
  • Enter SQL Server Database Port Number [52000] : 
  • Enter Jaspersoft Database Name [ppm_jaspersoft] : 
  • Enter Jaspersoft Database Username : ppm_jaspersoft 
  • Enter Jaspersoft Database Password : ********
    Validating Jaspersoft Database Connection....
    Jaspersoft Database Connected Successfully. 
  • Enter Apache Tomcat Directory [C:\Tomcat\apache-tomcat-7.0.55] : 
  • Enter Jaspersoft web app Name [reportservice] : 
  • Enter Jaspersoft web app Port [8080] : 
  • Do you wish to configure Email? (y, [n])


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