Skip to main content
Windward

Install Javelin 2014

Overview

This document walks you through installing the Windward Javelin product on your own server.

 

 

Components

  • The Javelin Installer - InstallJavelin.exe
  • A Javelin license key

 

Prerequisites

  • Windows operating system (Windows Server 2008 or higher )
  • Microsoft Internet Information Services (IIS)
  • .NET Framework 4.5.1 or newer
  • Microsoft SQL Server 2008/2012 (any edition, including Express)​
    • NOTE: During the SQL Server installation you must select the mixed mode authentication and enter a password for your SQL Server Administrator account.

 

Installation

1.     Run the InstallJavelin.exe executable.

2.     Click “Next” at the Welcome screen.

3.     On the End-User License Agreement screen, select “I accept the terms of the License Agreement” and then click “Next.”

4.     On the Custom Setup screen, select the install location. Then click “Next.”

5.     On the “Ready to Install” screen, click “Next” to begin the installation.

6.     When the install is complete, close the installer.

 

This will have installed the Javelin files to your system (defaulting to ‘C:\Program Files (x86)\Windward Studios\Windward Reports Javelin’ or ‘C:\Program Files\Windward Studios\Windward Reports Javelin’).

 

 

There are three steps we must take to finish deploying Javelin:

A. Create the Javelin database

B. Deploy the Javelin web application, and

C. Set up the scheduler service.

 

In the following sections, the following should be replaced to match with your configuration type.

 

  • server       - refers to the SQL Server instance name running on your machine. For example,  MachineName/SQLEXPRESS or MachineName.
  • user id      - refers to the username set up to access the Javelin database in server  . Default user you will create in the next section is javelin_db_user
  • password  - refers to the SQL Server password of the Javelin database user. Default password you will create in the next section is javelin.

Create the Javelin database

1.     In the install directory, there is a file called CreateJavelinDatabaseAndTables.sql. You will want to run this script to create the Javelin database. 

        There are two recommended ways to run this.

  • If you have SQL Server Management Studio (SSMS) installed, open the script using SSMS and execute it.
  • Run the script from the command line using the ‘osql’ command.
  • Ex. ‘osql –Usa –Ppassword –i CreateJavelinDatabaseAndTables.sql’

2.     Create javelin user (optional)

  • In your SQL manager, create a user called “javelin_db_user” with password “javelin”. Give it full access to the Javelin database.

    You can create the user in SQL Server Management Studio, by right clicking on Security under you SQL Server instance and select New Login.

    In the Login- New window, under General tab  enter the Login name of the user and select SQL Server authentication and provide the password

    you want to use. Then under the User Mapping page, select Javelin database and assign the data base role as db_owner.

           

  • If you do not create a javelin_db_user and prefer to use an existing valid user, replace instances of “javelin_db_user” in the following configuration steps with the valid user that has full access on the Javelin database.

 

Configure and deploy the Javelin web application

1. In the install directory, there is a directory called JavelinWebApplication. Copy the contents of this folder to the directory where you store your IIS web application files. The application pool must be configured to support .NET Framework 4. (Javelin 12.5 and older can use .NET Framework 2.)

  • For example, you can copy all of the files to ‘C:\inetpub\wwwroot’.

2. Configure the “web.config” file.

  • Replace "[ [LICENSE] ]" with your license key.
  • Ex. <add key="license" value="bHtzLjSa8TwnWysGZbHlvj2B5T53uzsdJzqxHDzK+61kYaUc/SNnrycq4Q0mi+ENOeHnLH95uSx2u/sdOeHnLDxQcRR0sreePHIlBnYAFTU9wfUULxp7LCcYcYRrSysuZ8m7nrSL+Zx3JSDGHSJKDGlSdkjfhdKJhsdfhkSDJfhKSJdfhskdjfhSKDJfhdksjdfhKSJDFHskSJDFHSKDJFHKSDFHJSKDfioshfskjfhSDF1OvMcdTC5Dnb44z12AAUXPcH1FH/Iu64nKikFLMMlLn0iqbY2mXsfdiAHPT3B9RRuSfGsN8o/t2zzbQ080e2Gbeh7rCa78QQ54ecsPFAxFCfh8Z9n+uOEdkCtFyae4TQ"/> (Not a valid key. For illustration purposes only.)

  • Modify the connection string in the <connectionStrings> section to point to your Javelin database server.
  • Ex. <add name="Javelin" providerName="System.Data.SqlClient" connectionString="server=MYSERVER;database=Javelin;user id=javelin_db_user;password=javelin"/>

 

 

Configure and start the Javelin scheduler service

Step 1

In the install directory, there is a directory called JavelinService. There are two configuration files we need to make modifications to.

 

Javelin.Server.Service.exe.config

 

Modify the connection string in the <connectionStrings> section to point to your Javelin database server.

 

Ex. <add name="Javelin" providerName="System.Data.SqlClient" connectionString="server=MYSERVER;database=Javelin;user id=javelin_db_user;password=javelin"/>

 

Modify the mail settings in the <mailSettings> section to point to your mail server (by changing host, port, username, and password).

 

Ex. <network host="mail.windward.net" port="25" defaultCredentials="false" userName="WINDWARD\javelin_test_account" password="pr1mary_p@ssword"/>

 

quartz.config

 

Modify the “quartz.dataSource.JavelinDS.connectionString” value to be the connection string to the Javelin database.

 

server=MYSERVER;database=Javelin;user id=javelin_db_user;password=javelin

 

Step 2

Next, Start the Javelin scheduler service.

 

Open the Start menu and select “Control Panel.”

 

If your “View by:” in the upper right is set to “Category” then select “System and Security.”

 

Open “Administrative Tools.”

 

Open “Services.”

 

Scroll down to “Windward Javelin Server” and click on “Start the service.”

 

Note: If you encounter any issues starting the Javelin service check your event viewer logs under Windows Logs->Application for errors.

 

Testing the installation

If the install and configuration was completed without error, you will be able to go to the browser on the machine with Javelin installed and load associated web pages (“http://localhost/”).

 

The default user installed has the following login:

Username: admin

Password: test

 

 

(Optional) Outward Facing Web Service

If your Javelin installation can be accessed by un-trusted users, you will want to enable SSL and change the default scheduler service account password.

 

The default account information for the scheduler service account is:

 

Username: wr_scheduler_user

Password: 12!Scheduler!34

 

Enable SSL

Set a SSL certificate for the web application in IIS.

 

Stop the “Javelin Server” service.

 

Modify “web.config” in the location of the Javelin web application.

 

Comment out the section following “<!-- Uncomment below two lines for HTTPS -->”.

 

Modify the “Javelin.Server.Service.exe.config” in the location of the Javelin scheduler service.

 

Modify the value for “JavelinWebServiceUrl” to use HTTPS.

Ex. <add key="JavelinWebServiceUrl" value="https://localhost/JavelinRestService.svc/v1"/>

 

Modify the value of “JavelinSslSubject” to the subject from the certificate.

Ex. <add key="JavelinSslSubject" value="GRUMBLE"/>

 

Start the “Javelin Server” service.

 

Change the default scheduler service account password

 

Stop the “Javelin Server” service.

 

Change the password for the user “wr_scheduler_user”.

 

Modify the “Javelin.Server.Service.exe.config” in the location of the Javelin scheduler service.

 

Modify the value for "JavelinWebServiceUrl" to the new password.

Ex. <add key="JavelinSchedulerUserPW" value="other_password"/>

 

Start the “Javelin Server” service.

  • Was this article helpful?