MSSQL Prerequisites§
MSSQL Setup§
Instructions below authored by SmartPTT team and may not comply with all the policies and capabilities of your organization:
- Enabling MSSQL Server Autostart
- Remote access enablement:
- Creating MSSQL users for SmartPTT (if SQL authentication is required).
- Limiting MSSQL memory consumption
- Limiting database size for SmartPTT
Tools§
MSSQL prerequisites imply the use of the following tools:
-
Proper edition of MSSQL server. For non-production purposes, use one of the following editions:
- MSSQL Express:
- MSSQL Developer:
-
SQL Server Configuration Manager. Included in your SQL server installation package.
-
Microsoft SQL Server Management Studio.
Networking§
Quality§
General network quality requirements apply.
- Packet loss is 0 to 2.5%.
- Two-way delay is 0 to 90 msec.
- Jitter is 0 to 90 msec.
Bandwidth§
- At least 200 kbps per 1,000 subscribers at disabled monitoring interface.
- At least 200 kbps per 1,000 subscribers at disabled monitoring interface.
Firewall§
Unlock the following network ports on the SmartPTT server host:
- TCP port 1433.
- UDP port 1434.
Unlock the following network ports on the Dispatcher App host:
- TCP port 1433.
- UDP port 1434.
Unlock the following network ports on the MSSQL server host:
- TCP port 1433.
- UDP port 1434.
For details, see the following tables.
| Port Number | Protocol | Direction | Application | Quantity |
|---|---|---|---|---|
| 1433 | TCP | Outbound | RadioService.exe | 1 |
| 1433 | TCP | Inbound | RadioService.exe | 1 |
| 1433 | TCP | Outbound | RSConfigurator.exe | 1 |
| 1433 | TCP | Inbound | RSConfigurator.exe | 1 |
| Port Number | Protocol | Direction | Application | Quantity |
|---|---|---|---|---|
| 1433 | TCP | Outbound | client.exe | 1 |
| 1433 | TCP | Inbound | client.exe | 1 |