SQL server system requirements

FH Web requires the following software.

• For networking, Microsoft .NET Framework 2.0 and 3.5 are both required.
• Microsoft SQL Server 2008 R2 or SQL Server 2012.

• Microsoft SQL Server 2008 R2 Express or SQL Server 2012 Express.

  Note: Express versions of SQL Server database are limited to 10 GB.

Caution: SQL Server 2008 R2 Express Edition is included with FH Web, but lacks many of the administrative features of SQL Server 2008 R2. Microsoft SQL Server 2008 R2 is purchased and configured separately from FH Web, and provides full-featured database management to the qualified SQL Server administrator.

The hardware requirements for the server depend on the SQL software package you install to manage your FH Enterprise database. Hardware requirements for SQL Server are available from Microsoft at http://www.microsoft.com/sql/, or from your local Microsoft reseller. Your actual hardware requirements may be higher, based on the number of concurrent users or other applications running on the server, server configuration, and network configuration.

Tip: To qualify for U.S. General Services Administration (GSA) pricing, be sure to specify that you are a government entity when purchasing your SQL software package. You may save money by purchasing hardware and software as part of a package.

Note: If you use FH to collect data from multiple departments, such as collecting state NFIRS transaction files or county EMS incident reports from area agencies, you should exceed the recommended hardware requirements if possible.

Tip: Use an uninterruptible power supply (UPS) with your server in case of power failure.