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
    The 
    Windows
     domain name of the application server
    Domain Account Name
    Name of the Windows domain account
    DomainAccountPassword
    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 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.