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.
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;
CBRNESurveyAdmin/: This folder contains all the files and folder structure to set up the Survey Admin site.
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:
- Copy the CBRNEDB.MDF and CBRNEDB.LDF files to the database server.
- Using SQL Server Enterprise, attach the CBRNEDB database.
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
- Using the SQL Server Enterprise Manager, create a SQL server user account. An example could be "CBRNE_User."
3a. Go to the "Security" folder, right-click, and select "New Login"
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
- 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.
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
- Process complete.
Return to Contents
Proceed to Next Section