Skip Navigation
  1. BlackBerry Docs
  2. BlackBerry AtHoc
  3. BlackBerry AtHoc Delivery Services
  4. Notification Delivery Service Installation and Configuration Guide
  5. Configure Windows authentication

Configure 
Windows
 authentication

After you install 
NDS
, you can configure 
NDS
 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 of them).
    • 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. Click 
      Files
       and click the browse icon to select the username of the Windows service account.
      Database properties window
    5. Click 
      Browse
      .
    6. Select the 
      Windows
       service account username.
      The Browse for Objects window
    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 on the 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.
    4. Delete the SQL login info: User Id=ngad; Password=<
      ngadpassword
      >: 
      Provider=SQLOLEDB;Server=<server\instance>;Initial Catalog=ngaddata;User Id=ngad;Password=<
      ngadpassword
      >;
    5. Add the 
      Windows
       authentication parameter: Integrated Security=SSPI; 
      Provider=SQLOLEDB;Server=<server\instance>;Initial Catalog=ngaddata;Integrated Security=SSPI
      ;
    6. 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 on 
      AtHocDeliveryService
       and select 
      Properties
      .
    4. 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
      .