Public Health Emergency Preparedness

6.0  System Configuration and Administration Procedures

This section lists the steps needed to install and configure the questionnaire application. Installing and configuring SQL Server, IIS, OS, and applying service packs are beyond the scope of the document. The document will be written at the level of system administrators. 

The Deployment package includes following folder structure;

Sites/

 |____ CBRNESurveyApplication/

      |___ CBRNESurveyAdmin/

      |___ CBRNESurveyWeb/

      |___ Database        

      |___ Log    

CBRNESurveyAdmin/: This folder contains all the files and folder structure to set up the Survey Admin site.

CBRNESurveyWeb/: This folder contains all the files and folder structure to set up the Survey site.

Database/: This folder contains CBRNEDB.MDF and CBRNEDB.LDF files to set up the CBRNE SQL server database. It should be copied to a folder in the database server.

Log/: This folder is where the site will log run time exception.

The System Administrator should follow the package deployment instructions located in the next section to set up the applications.

Return to Contents

6.1. Package Deployment Instructions

The CBRNE Preparedness Questionnaire is a Web-based application built utilizing ASP.NET on the .NET Framework v 1.1 and SQL Server 2000. No client side plug-in or applet needs to be installed.

Return to Contents

6.1.1. Database Deployment Description

The CBRNE Preparedness Web Questionnaire database was developed using SQL Server 2000. This step assumes that a SQL Server 2000 database server is available for use and that the database administrator is familiar with using SQL Server 2000. In order to install the database, follow the steps below:

1. Copy the CBRNEDB.MDF and CBRNEDB.LDF files to the database server.
2. Using SQL Server Enterprise, attach the CBRNEDB database.

Associated Steps:

2a. Open the SQL Server Enterprise Manager, and identify the database server where you want to put your database.
2b. Right-click on the database folder, and from the "All Tasks" option, select "Attach Database." This is shown in Figure 2 below.

Figure 2. CBRNEDB Attachment

2c. Locate the "CBRNEDB.MDF" file on the server, select "sa" as database owner, and select "OK" to attach it to the database (Figure 3).

Figure 3. Database Attachment

3. Using the SQL Server Enterprise Manager, create a SQL server user account. An example could be "CBRNE_User." 

Associated Steps:

3a. Go to the "Security" folder, right-click, and select "New Login" (Figure 4).

Figure 4. SQL Server User Account

3b. In the "Name" field, enter "cbrne_user."  
3c. Under "Authentication," select "SQL Server Authentication," and enter a new password. 
3d. Next, select "CBRNEDB" as the default Database (Figure 5).

Figure 5. New Login

3e. Next, select the "Database Access" tab.
3f. Select the checkbox in the row next to the "CBRNEDB" in the "Database" column and "cbrne_user" in the "User" column. Then, select OK (Figure 6).

Figure 6. New Login

4. Add the cbrne_user to the web_user role of the CBRNE database. The web_user role, already within the database, has the minimal set of permissions required to access the database, execute stored procedures, and update tables.

Associated Steps:

4a. Go to the database labeled "CBRNEDB," and select the node titled "Roles." You will see a role called "web_user." Select the "web_user" role (Figure 7).

Figure 7. Web User Role

4b. Add "cbrne_user" to the "User" list, then select OK (Figure 8).

Figure 8: Web User Role

5. Process complete.

Return to Contents
Proceed to Next Section