Get the PDF

Install the database server

During a new installation, run the

AtHoc

setup kit on the database server. The setup kit supports both

Microsoft SQL Server

authentication and Windows authentication connections to SQL Server. A

Windows

authentication connection requires the user's computer or domain login to have a sysadmin login in

Microsoft SQL Server

The database server must be installed first when you install separate application and database servers. When installing both application and database servers on the same server (a “combo install”), they can be installed at the same time.

Download the

BlackBerry AtHoc

setup kit .zip file to the server.

Right-click the setup kit .zip file and select

Properties

General

Unblock

to unblock the file.

Extract the contents of the setup kit .zip file into a temporary directory.

Due to Windows OS file path length limitations, some of the included utilities may not extract correctly. To avoid this issue, use a short path for the extraction directory (for example, C:\setup). Keep the total number of characters to 20 or less, including the drive letter, colon, and slashes.

Use the

<setupkit_root>/user.yml

configuration file to provide product-specific setup parameters.

This file is included in the setup kit as a template with blocks of related parameters that are commented out and a brief description for each block. To use the parameters in a block, remove the # from the parameter, update it, and save the file.

YAML is indent-sensitive. When you remove the # from a parameter in the block, make sure that you keep the original indentation. You must also remove the # from the block header, even if you update only one parameter in the block. You can validate the YAML at before you save the file.

Uncomment the following lines in the user.yml file:

#------- Default roles if user did not select something else are app & db (combo)

selected_roles:
- db
#- app

args:
  user_input: user.yml

#------- Used in 'db' and 'app' roles. 
#------- SQL instance name for example MyServer\Optin_cfg ---------
#------- Used in 'db' and 'app' roles. For IWS, db_name will be ngaddata ---------
#------- Required On fresh install only or the first time running the setup kit  

  sql_server_instance: 'xyz'  # ** See Note below
  db_name: 'ngaddata'       # ** See Note below

  admin_db_auth: 'sql'    # ** See Note below
  admin_db_user: 'athocinstall'   # Windows user should be 'domain_name\User_name' format.  # ** See Note below
  admin_db_pw: ''       # * See Note below


#------- Used in 'db' & 'app' roles . App DB Authentication arguments.
#------- App DB authentication type: sql\windows. 
#------- When 'app_db_auth'= 'windows' the user should be in 'domain_name\User_name' format.
#------- When 'app_db_auth'= 'sql' 'app_db_user' is set automatically to 'ngad'

  app_db_auth: 'windows'  # ** See Note below
  app_db_user: 'athoc\athoc' # Windows user should be 'domain_name\User_name' format # ** See Note below
  app_db_pw: ''     # * See Note below



#----- Used in 'db' role. SQL DB folder path. Used on fresh installation or when moving DB to new server -----------

  db_dir: 'e:\Program Files (x86)\AtHocENS\Database'
  db_log_dir: 'e:\Program Files (x86)\AtHocENS\Database\Log'
  db_archive_dir: 'e:\Program Files (x86)\AtHocENS\Database\Archive'

#----- Used in 'App' role. App Install folder path. Used on fresh AND upgrade installation -----------

#  app_dir: 'E:\Program Files (x86)\AtHocENS'

#----- Used in 'db' role.
#----- System URL will be maintained in SYS_SYSTEM_TAB DB table in ngaddata -----------

  system_url: 'https://<hostname>.athocdevo.com'   # ** See Note below -- Fresh Install

Do one of the following:

Right-click the

SetupKit.exe

file from the root folder and run as an administrator.

Run Windows PowerShell as an administrator and then run the

.\SetupKit.exe

script to install the

AtHoc

database server.

The

SetupKit.exe

file starts the installation process and completes the following tasks:

Parses setup parameters from the

user.yml

file.

Creates log directory and writes to log files.

Installs each product in the following order: database, application, support modules.

Reports result and elapsed time.

When the installation is complete, the

BlackBerry AtHoc

is database installed and running.

Continue with the installation of the application server or servers, as described in Install BlackBerry AtHoc on a clustered database.

Section:

Install BlackBerry AtHoc

Install BlackBerry AtHoc on a clustered database