Skip Navigation U.S. Department of Health and Human Services www.hhs.gov
Agency for Healthcare Research Quality www.ahrq.gov
Archive print banner
Operations Manual

Public Health Emergency Preparedness

This resource was part of AHRQ's Public Health Emergency Preparedness program, which was discontinued on June 30, 2011, in a realignment of Federal efforts.

This information is for reference purposes only. It was current when produced and may now be outdated. Archive material is no longer maintained, and some links may not work. Persons with disabilities having difficulty accessing this information should contact us at: https://info.ahrq.gov. Let us know the nature of the problem, the Web address of what you want, and your contact information.

Please go to www.ahrq.gov for current information.

1.0. Introduction

1.1.  Purpose

The Operations Manual identifies and describes hardware and software requirements to set up a .NET architecture Web site. The manual includes the files and steps that will allow a Federal- or State-level IT administrator to deploy the Web questionnaire site for the Preparedness for Chemical, Biological Radiological, Nuclear, and Explosive (CBRNE) Events: Questionnaire for Health Care Facilities.

Return to Contents

2.0. System Overview

The CBRNE Preparedness Questionnaire is a Web-enabled data collection tool. It enables users to submit information about their hospital facilities using a Web browser. A separate survey administration site enables a survey administrator to log in and view the number of submitted questionnaires, change his/her password, and download submitted questionnaire data. The survey site was developed on the .NET platform.

Figure 1 illustrates where the hardware is located and how it communicates.

Figure 1. CBRNE Preparedness Questionnaire Architecture

Figure illustrates questionnaire architecture. Survey Users and Survey Administrators (represented by blue figures) submit information via HTTP/S to a CPU labeled 'IIS 6.0.'  The CPU then sends information to another CPU labeled 'SQL Server 2000.' The two CPUs are in a yellow box labeled 'CBRNE Preparedness Web Survey.'

Return to Contents

3.0.  Hardware and Software Descriptions

The list below describes the general design decisions for the application:

  • Microsoft .NET technology (C#, ASP.NET, ADO.NET) will be used to implement Web pages and data access to an SQL server database.
  • Microsoft Internet Information Server (IIS 6.0) will be used as a Web server for the application.
  • Microsoft Windows 2003 server.
  • Microsoft SQL Server 2000 Server.
  • Microsoft .NET Framework 1.1.
  • Microsoft Data Access Component (MDAC) 2.7 or higher.
  • SQL server view and stored procedures are developed to handle data retrievals and updates in the SQL server database.

Return to Contents

3.1.  Hardware Requirement for Web and Database Servers

The Web site can run on a single server that has IIS 6.0 and SQL Servers installed on it, or it can be run on a standalone Web server that utilizes a SQL Server on a different server. Both servers require a Microsoft Windows Server operating system (OS). The following table describes the recommended hardware for the Windows Server 2003 Standard Edition or higher:

For Web Server

Component Requirement
Computer and processor 133-MHz or faster processor for x86-based PCs; 733-MHz for Itanium-based PCs; up to eight processors supported on either the 32-bit or the 64-bit version
Memory 128 MB of RAM minimum required; maximum: 32 GB for x86-based PCs with the 32-bit version and 64 GB for Itanium-based PCs with the 64-bit version
Hard disk 1.5 GB of available hard-disk space for x86-based PCs; 2 GB for Itanium-based PCs; additional space is required if installing over a network

For SQL Database Server—SQL Server 2000 

Component Requirement
Computer and processor 133-MHz or faster processor for x86-based PCs; 733-MHz for Itanium-based PCs; up to eight processors supported on either the 32-bit or the 64-bit version
Memory 128 MB of RAM minimum required; maximum: 32 GB for x86-based PCs with the 32-bit version and 64 GB for Itanium-based PCs with the 64-bit version
Hard disk 1.5 GB of available hard-disk space for x86-based PCs; 2 GB for Itanium-based PCs; additional space is required if installing over a network

Return to Contents

3.2. Commercial Software Requirement for Web and Database Servers

Operating System for Web and Database Servers Windows 2000 Server or Windows 2003 Server
Database Server SQL Server 2000 Standard Edition

For the Web server: If you have been directed to do a server installation, you must have the following software installed in addition to the typical installation requirements:

  • Microsoft Data Access Components 2.6; Microsoft Data Access Components 2.7 SP1 or higher is recommended. This is for applications that use data access and is a prerequisite for the .NET Framework.
  • Internet Information Services (IIS) version 5.0 or later. To access the features of ASP.NET, IIS with the latest security updates must be installed prior to installing the .NET Framework. The Application uses .NET Framework 1.1.
  • ASP.NET is supported only on the following platforms: Microsoft Windows 2000 Professional (Service Pack 3 recommended), Microsoft Windows 2000 Server (Service Pack 3 recommended), Microsoft Windows XP Professional, and Microsoft Windows Server 2003 family.

Note: If you have existing hardware/software for the .NET 1.1 Web server/SQL server, such as Windows 2000 server with 1.1 NET framework and MDAC properly installed, the application should operate. Server install and configuration should include all known Microsoft recommended security patches.

Return to Contents

4.0. Interfaces with other Systems and Databases

The Web server should have connection to the SQL database server. The application uses an ADO.NET database layer to interact with the SQL server database. The site does not interact with any other systems.

Return to Contents

5.0. Access and Authentication Requirements

In order for the questionnaire application to access the SQL server, a SQL server user account is required. Details on the Database Deployment Description are located in Section 6.1.1.

The questionnaire site allows anonymous users to access the Web site. The administration site uses .NET form authentication, so a username and password is required to enter the site. The initial username and password for the admin site is surveyadmin/changepassword, which can be changed by the administrator at a later date.

Return to Contents
Proceed to Next Section

 

The information on this page is archived and provided for reference purposes only.

 

AHRQ Advancing Excellence in Health Care