Skip Navigation
  1. BlackBerry Docs
  2. BlackBerry AtHoc
  3. BlackBerry AtHoc Delivery Services
  4. MSI NDS OPM Installation Guide
  5. Configure Windows authentication

Configure 
Windows
 authentication

After installing 
NDS
, you can configure it to use 
Windows
 authentication for SQL authentication.
  1. Create a 
    Windows
     service account with the following access and privileges:
    • Have SQL access and be the database owner of the three ngdelivery databases.
    • Be able to run the athocdelivery service on the 
      NDS
       server.
    • Be able to run the IIS application pools on the 
      NDS
       service. There should be two application pools.
    • Have full access to the 
      c:\windows\temp
       folder.
    • Have full access to the folders where the databases reside.
  2. Change the owner of the databases from 
    ngad
     to the 
    Windows
     service account:
    1. Open 
      Microsoft SQL Server
       Management Studio.
    2. Expand 
      Databases
      .
    3. For each ngdelivery database, right click and select 
      Properties
      .
    4. On the 
      Database Properties
       window, click 
      Files
       and click the browse icon to select the username of the 
      Windows
       service account.
    5. Click 
      Browse
      .
    6. On the 
      Browse for Objects
       window, select the 
      Windows
       service account username.
    7. Click 
      OK
      .
  3. Update the database connection string in the System Registry.
    1. Open the Registry:
      1. Click 
        Start
         and type 
        regedit
        .
      2. Right-click the regedit icon and click 
        Run as administrator
        .
    2. In the 
      Registry
      , navigate to 
      HKEY_LOCAL_MACHINE
       > 
      SOFTWARE
       > 
      Wow6432Node
       > 
      AtHocServer
      .
    3. Under 
      AtHocServer
       change the values of OleDbConnectionString:
      • Delete the SQL login info: User Id=ngad;Password=<
        ngadpassword
        >; 
        Provider=SQLOLEDB;Server=<server\instance>;Initial Catalog=ngaddata;User Id=ngad;Password=<
        ngadpassword
        >;
      • Add the 
        Windows
         authentication parameter: Integrated Security=SSPI; 
        Provider=SQLOLEDB;Server=<server\instance>;Initial Catalog=ngaddata;Integrated Security=SSPI;
      • Click 
        OK
         and exit 
        Regedit
        .
    4. Optionally, for 
      AtHoc
       authentication through 
      Windows
      , modify the service login to use the domain account.
      1. From the database server, click 
        Start
         and open the 
        Control Panel
        .
      2. Click 
        System and Security
         > 
        Administration Tools
         > 
        Services
        .
      3. Right click 
        AtHocDeliveryService
         and select 
        Properties
        .
      4. On the 
        AtHocDeliveryServices Properties
         window, select the 
        Log On
         tab.
        The default setup is “Local System Account”.
      5. To modify the account information for 
        Microsoft SQL Server
         
        Windows
         Authentication, select 
        This Account
        .
      6. Fill in your 
        Windows
         Service Account credentials and click 
        OK
        .