Skip Navigation
  1. BlackBerry Docs
  2. BlackBerry AtHoc
  3. BlackBerry AtHoc Delivery Services
  4. Notification Delivery Service Installation and Configuration Guide
  5. Install NDS components in standalone mode
  6. Install the database servers

Install the database servers

As an installer, you must have the following items:
  • SQL Server sysadmin (SA) and Windows admin rights
  • A password for the NGAD, the owner of the 
    BlackBerry AtHoc
     “ng” databases
  • Full control for the directory in which the database installation scripts are located. Right-click on the directory and open the properties to verify.
  • Full control of the database directory folder that contains the .ldf, .mdf, and .ndf files. Right-click the directory and open the properties to verify.
For more information about installing the databases, see the 
readme
 files in each database folder.
If the application server and the database server are on the same server, do not perform steps 1 and 2.
  1. Log in to the 
    BlackBerry AtHoc
     database server.
  2. Copy the AtHocENS folder and subfolders to the Program Files folder, see Prepare the NDS installation file.
  3. Navigate to the AtHocENS folder.
  4. Right-click the AtHocENS folder, click 
    Properties
     > 
    Security
     to check if you have the 
    Write
     permission as an administrator and user.
  5. Create a new 
    Database
     folder.
  6. Right-click the 
    Database
     folder, click 
    Properties
     > 
    Security
     to check if you have the 
    Write
     permission as an administrator and user.
  7. Run the script on the 
    BlackBerry AtHoc
     database server.
    1. Navigate to the following folder: 
      <AtHocENS>\DeliveryServer\Installations\DatabaseServer
    2. Right-click the 
      OnPremiseDBInstallation.bat
       file and click 
      Edit
       to edit the following parameters in the installation script:
      Parameter
      Description
      <
      databaseServerInstance
      >
      The IP address and instance of the 
      NDS
       server
      <
      saPassword
      >
      The system administrator password
      <
      saName
      >
      The system administrator account name.
      <
      ngadPassword
      >
      The password for the ng database administrator. If the ngad user has been created, this password is not used to override the existing ngad password.
      <
      databaseDirectory
      >
      The directory for MSSQL database, such as 
      <
      AtHocENS
      >\Database
      . Used only for new installations.
      <
      ngdeliverydb
      >
      ngdelivery_<
      plug-in
      >
       where 
      <
      plug-in
      >
       is the name of related plug-ins.
    3. Click 
      Save
       to save the changes.
    4. Run the following script as an administrator: 
      OnPremiseDbInstallation.bat
    5. After the script runs, go to the folder for each database and open 
      runsql.log
       to check for any issues in the installation.
The following databases are installed using the 
OnPremiseDbInstallation.bat
 script:
  • ngdelivery
  • ngaccount
  • ngdiagnostic
  • ngcommon
  • ngdeliverylog