Skip Navigation

Configure
AtHoc
database operations to use
Windows
authentication

Run the configuration script on each application server so that
AtHoc
database operations use
Windows
authentication. This script ensures a trusted connection from the application server to connect to database server. All
AtHoc
applications need to run under a
Windows
domain account.
  1. From the application server, open a command prompt and run as administrator.
  2. Navigate to the following directory:
    <%AtHocENS%>\ServerObjects\Tools\
    .
  3. Run the following script, using 32-bit version of cscript:
    setWindowsAuth.vbs <%DomainName%> <%Domain AccountName%> <%DomainAccountPassword%>
    .
    Where:
    • DomainName is the
      Windows
      domain name of the application server.
    • Domain Account Name is the name of the Windows domain account.
    • DomainAccountPassword is the password of the Windows domain account.
The script makes the following updates:
  • Creates a
    Windows
    domain account as a login and a new "
    AtHoc
    " database server role in the SQL server. The
    Windows
    domain account is created as a member of
    AtHoc
    server role.
    Database access is granted to the
    AtHoc
    server role instead of giving direct access to the
    Windows
    domain account. This login is given ownership to all
    AtHoc
    databases.
    If for any reason a database restore is performed manually and the
    Windows
    domain account user account is missing, it can be created by running the ATH_CREATE_USERS SQL stored procedure in the msdb database. To return to SQL authentication by using ngad login, use the ATH_CREATE_USERS stored procedure.
    Contact
    BlackBerry AtHoc
    customer support for information about using this stored procedure.
  • Updates the connection string for
    BlackBerry AtHoc
    to use a trusted connection.
  • Modifies all
    AtHoc
    application pool identities in IIS to use the new domain account.
  • Modifies the Anonymous account in IIS from IUSR to the new domain account.