- Getting started
- System components and configuration
- BlackBerry AtHoc account requirements
- Install BlackBerry AtHoc
- Upgrade BlackBerry AtHoc
- Postinstallation or upgrade configuration
- Set antivirus file exclusions for database log and tempDB files
- IIS postinstallation checklist
- Application pool configuration tables
- Table 1: Application pool configuration
- Table 2: Application Pool - Web application associations for the AtHoc website - Enterprise configuration
- Table 3: AtHoc services application pool configuration
- Table 4: Application pools - web application association for AtHoc services web site
- IIS handler mappings
- Verification checklist
- Application pool configuration tables
- (Optional) Enable message termination
- (Optional) Enable and enforce the TLS 1.2 protocol
- (Optional) Configure the application server for Windows authentication
- (Optional) Configure client certificates on the application server
- (Optional) Set the SSL client certificate
- (Optional) Install certificates for cloud delivery services
- (Optional) Configure new access card formats for operator auto-login
- (Optional) Enable FIPS on each application server
- (Optional) Archive and MAS export service account requirements
- Configure .NET framework to use a web proxy
- (Optional) Restore the XML files for duplicated devices
- (Optional) Set up error pages for Self Service throttling
- (Optional) Set up error pages for Self Service throttling
- Advanced server configuration
- IIS 8.5 Security Technology Implementation Guide
- Server STIG
- IISW-SV-000103: Enable log file and Event Tracing windows
- IISW-SV-000107: Sufficient web server log records for location of web server events
- IISW-SV-000108: Sufficient web server log records for source of web server events
- IISW-SV-000110: Sufficient web server log records to establish the outcome of web server events
- IISW-SV-000111: Sufficient web server log records to establish identity
- IISW-SV-000112: Web server must use Event Tracing for Windows logging option
- IISW-SV-000120: Samples, examples, and tutuorials must be removed from production server
- IISW-SV-000124: Web server must have MIMEs that invoke OS shell programs disabled
- IISW-SV-000146: Web server must not impede ability to write log record content to an audit log
- IISW-SV-000153: Web server must maintain the confidentiality of controlled information during transmission
- IISW-SV-000154: Web server must maintain the confidentiality of controlled information during transmission
- Application STIG
- IISW-SI-000206: Enable log file and Event Tracing windows
- IISW-SI-000209: Sufficient website log records to establish identity
- IISW-SI-000210: Sufficient website log records to establish identity
- IISW-SI-000211: Website must use Event Tracing for Windows logging option
- IISW-SI-000214: Website must have MIMEs that invoke OS shell programs disabled
- IISW-SI-000228: Non-ASCII characters in URLs must be prohibited
- Server STIG
- Verifying BlackBerry AtHoc is operational
- Appendix A: Troubleshooting
- Appendix B: Organization duplicator object management
- BlackBerry AtHoc Customer Support Portal
- Legal notice
- BlackBerry Docs
- BlackBerry AtHoc
- BlackBerry AtHoc 7.9
- Installation and Configuration Guide
- Install BlackBerry AtHoc
- Database server configuration
- Microsoft SQL Server settings
Microsoft SQL
Server settings
Microsoft SQL
Server
settingsFollow these steps for any edition of
Microsoft SQL
Server
:- Ensure that the TCP/IP protocol is enabled. This setting is available in theMicrosoft SQL ServerConfiguration Manager.
- Enable the database instance to accept both local and remote connections. This setting is available on the Connections page in the properties for theMicrosoft SQL Serverinstance.
- TheMicrosoft SQL ServerBrowser service is required if you have installed a database instance and the TCP port is dynamic. Turn on the service in Service Manager. Ensure that theMicrosoft SQL ServerBrowser service is started in Windows Services manager and that it has the same Startup type as theMicrosoft SQL Server(MSSQLSERVER) service.
- New installation of theBlackBerry AtHocdatabase and some operations such as archiving require that theMicrosoft SQL Serverservice account has permission to create files in directories that it does not have permission to write to by default. For example, when you install the database to the default location, C:\Program Files (x86)\AtHocENS\Database, the service account must have permission to create files there. Ensure that theMicrosoft SQL Serverservice account has permission to write to these locations, or change it to Local System account. You can find theMicrosoft SQL Serverservice account in the Windows Services manager.
- EnableMicrosoft SQL Serverupdates by MSI. To ensure that the MSI can reconfigure the system during installation (to prevent an “Ad hoc update to system catalogs is not supported” error), run the following SQL under DB Master before a new installation or upgrade:sp_configure 'allow updates', 0; reconfigure;
The
BlackBerry AtHoc
installer creates databases and sets up the ngad user account and AtHoc
server role. The ngad user account is created as a member of the AtHoc
server role. Database access is granted to the AtHoc
server role instead of giving direct access to the ngad database. If a database restore is performed manually and the ngad user account is missing, you can run the SQL stored procedure ATH_CREATE_USERS in the msdb database to create it. You might need to grant ngad permission to some stored procedures as well. Contact BlackBerry AtHoc
customer support for information about using this stored procedure.