Skip to content

Install Easit GO

Prerequisites

Database setup

  1. Create a new Database.
    1. You can give it any name you want (e.g EasitGO-Prod or EasitGO-Test).
    2. Set the collation to Finnish_Swedish_100_CI_AS.
  2. Create a new Login.
    1. Give the login any name you want (e.g EasitGO-DbUser-Prod or EasitGO-DbUser-Test)
    2. The Login need to use SQL Server authentication.
    3. Add a user mapping to the database you created in step 1 and give the mapping role membership to db_owner.
  3. Set Isolation mode (Microsoft Docs)
    1. Execute the SQL script below against the database.
    2.  1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
      DECLARE @DATABASENAME AS VARCHAR(255), @ALTERSQL AS VARCHAR(255)
SET @DATABASENAME=db_name()
IF (SELECT is_read_committed_snapshot_on FROM sys.databases
WHERE name=@DATABASENAME) = 0
BEGIN
SET @ALTERSQL = 'ALTER DATABASE ['+@DATABASENAME+'] SET SINGLE_USER WITH
ROLLBACK IMMEDIATE;ALTER DATABASE ['+@DATABASENAME+'] SET
read_committed_snapshot ON;ALTER DATABASE ['+@DATABASENAME+'] SET
MULTI_USER';
EXEC(@ALTERSQL)
END
IF (SELECT snapshot_isolation_state FROM sys.databases
WHERE name=@DATABASENAME) = 0
BEGIN
SET @ALTERSQL = 'ALTER DATABASE ['+@DATABASENAME+'] SET SINGLE_USER WITH
ROLLBACK IMMEDIATE;ALTER DATABASE ['+@DATABASENAME+'] SET
allow_snapshot_isolation ON;ALTER DATABASE ['+@DATABASENAME+'] SET
MULTI_USER';
EXEC(@ALTERSQL)
END
SELECT is_read_committed_snapshot_on, snapshot_isolation_state
FROM sys.databases
WHERE name = @DATABASENAME
      The expected result is is_read_committed_snapshot_on=1 and snapshot_isolation_state=1.

Disconnect from the database server and connect to the application server.

Application setup

  1. On the partition you prefer, create directory called Easit. (E.g D:\Easit).
  2. Expand the installation package provided by Easit to this directory.
  3. You will now have a directory called easitgo in the directory you created in step 1.
  4. If you plan to have more than one Easit GO running on the server you should rename the easitgo directory to something else. It is up to you what the name should be but we recommend something like EasitGOProd, EasitGOTest or just Prod, Test. We will from now refer to this directory as the System folder.
  5. Inside the System folder you have a directory called config, open it.
  6. Copy the license.xml provided by Easit to the config directory (e.g D:\Easit\EasitGOProd\config\license.xml).
  7. Right click on properties.xml inside the config directory and choose to edit it.
    1. Update the entry key dataSource.url with the details about your database server and database. 
      1
      <entry key="dataSource.url">jdbc:sqlserver://dbserver.domain.lan;instanceName=MSSQLSERVER;portNumber=1433;databaseName=EasitGO-Prod;encrypt=false</entry>
    2. Update the values for the entry keys dataSource.username and dataSource.password. 
      1
2
      <entry key="dataSource.username">myDbUsername</entry>
<entry key="dataSource.password">myDbUsersPassword</entry>
      The password will be encrypted once Easit GO starts so the password will NOT be save in plain text.
    3. Save your changes and close the file.
  8. Inside the System folder you have a directory called bin, open it.
  9. The files in this directory are used to install and run Easit GO as a Windows service.
  10. Right click on easitgo-service.xml and choose to edit it.
    1. Update the following XML elements to fit your needs. 
      1
2
3
      <id>easitgoprod</id> <!-- Specifies the ID that Windows uses internally to identify the service -->
<name>EasitGO-Prod</name> <!-- Short display name of the service, which can contain spaces and other characters -->
<description>EasitGO Prod</description> <!-- Long human-readable description of the service -->
  11. Save your changes and close the file.

Install Easit GO as Windows service

  1. Open PowerShell or CMD as administrator and navigate to System folder\bin.
  2. Run one of the following commands while in System folder\bin.
    1. PowerShell: 
      1
      PS D:\Easit\EasitGOProd\bin> .\easit-service.exe install
    2. CMD: easit-service.exe install

Start Easit GO

  1. Open PowerShell or CMD as administrator if not already open.
  2. Run one of the following commands.
    1. PowerShell: 
      1
      Start-Service -Name 'easitgoprod'
    2. CMD: 
      1
      sc start "easitgoprod"
    3. services.msc: Find the service for Easit GO, select it and click on start.

Give Easit GO a couple of minutes to start and you are done.

Further reading