Skip Navigation

Install the database server

During a new installation, run the 
AtHoc
 Installer (MSI) on the database server. The MSI supports both 
Microsoft SQL Server
 authentication and Windows authentication connections to SQL Server. A 
Windows
 authentication connection requires the user's machine or domain login to have a login in 
Microsoft SQL Server
, and that login must be a sysadmin.
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.
  1. To start the installation, open an elevated command prompt, navigate to the folder with the .bat file, type the .bat file name, and press Enter to run it. The .bat file name follows the naming convention "BlackBerry_AtHoc_7.9.x.x_build.bat."
    The .bat file distributed with the MSI generates a log file of the installer actions. The log file, ATHOC_yyyy_mm_dd_hh_mm_AM|PM.log, is created in the root of the C: directory.
  2. To open an elevated command prompt, locate cmd.exe in the program search, right-click on cmd.exe and choose 
    Run as Administrator
    . If the 
    User Account Control
     window appears, click 
    Yes
     to run the Windows Command Prompt as Administrator.
  3. On the 
    Welcome
     screen, click 
    Next
    .
  4. Accept the Software License Agreement, and click 
    Next
    .
  5. Choose the 
    Database Server
     check box, and click 
    Next
    .
  6. Enter the server name of the database server and the instance name, if any, select the Authentication Mode, and provide the credentials, if required.
  7. To set up the password for the ngad database user, supply your own values or use the default values. Click 
    Next
    .
  8. To specify the folders to install the 
    BlackBerry AtHoc
     components in, click the associated 
    Change
     button to specify the 
    Microsoft SQL Server
     data folder and the Database archiving folder that you want. Optionally, click 
    Next
     to accept the default locations for both folders.
  9. Click 
    Install
     to begin the installation or click 
    Back
     to change the installation settings.
  10. When the installation completes, click 
    Finish
     to exit the Setup Wizard.
  11. Continue with the installation of the application server or servers, as described in Install BlackBerry AtHoc on a clustered database.