PDE

Pennsylvania Department of Education

[APP]Deployment Document

Version 1.0

Prepared by

Center for Data Quality and Information Technology

333 Market Street

Harrisburg, PA, 17126

Last Updated Date: April 1, 2014

[APP] Deployment DocumentPA Department of Education

About this document

This document describes the system configuration and implementation requirements for [APP] Application and applicable web services to move to deployment environment. This document is focused on [APP] Application specific details. Microsoft and other system software product deployment, maintenance, upgrades are not part of this documentation.

This document is useful to developers, project team members and whoever is doing deployment and maintenance of [APP] application.

Version History

Version / Updated By / Updated Date / Description / Reference
1.0 / Sharon Clark / 4/1/2014 / Updated server naming standards, software versions, and DBA steps / Sections 1, 2, 4.1.1, 5.1.1, 7.2
1.1

References

The following are sources of information for this document:

Source / Information
[APP]High Level Design Document

ConfidentialPage 1

[APP] Deployment DocumentPA Department of Education

Contents

1.Deployment Overview

2.System Hardware/Software Requirements

2.1Internet Server/Web Server

2.2Database Servers

3.Check System Hardware and Software

3.1.1Check Hardware/Software installed on the machine

3.1.2Check the Database Connectivity from Web Server

4.Database Deployment

4.1.1Database Deployment

4.1.2[APP] Batch Job Deployment

4.1.2.1Deploying the SSIS package

5.Application Deployment

5.1Configuring Web Site

5.1.1How to Create & Configure a Web Site

5.1.2How to Create a Application Pool

5.1.3Specify Application Pool for the web site

5.1.4Hosting Web Application on more than one Server

5.2Registering third party DLL

6.Configuration Files (Web.Config)

6.1Settings for [APP] Application:

7.Appendix

7.1Summary of steps for Deployment team

7.2Summary of steps for DBA team

ConfidentialPage 1

[APP] Deployment DocumentPA Department of Education

1.Deployment Overview

The following system hardware needs to be checked as part of [APP] deployment:

Production Servers:

Server / Purpose / Network Setup
Name of the web server> Ex: EDCTCIS / Production Web Server / IP: IP address
Name of the database server> EDCTCSQ / Production Database / IP: IP address

Naming standard for Server Names at Managed Services Lite (MSL) is:

ED– EDucation

IS- Internet (Web) Server

SQ- SQL Server

S- Staging

P- Production

Naming standard for Server Names at PDE is:

ED – EDucation

WEB- Internet (Web) Server

SQL- SQL Server

D- Development

T- Test

P- Production

The following applications/web services need to be deployed/configured as part of [APP] deployment:

Application / Description / Server / Responsibility
Name of the applicationEx: APP / Web Server / Deployment Team
Name of the web serviceEx: APPWebService / PDEWeb services Web Server / Deployment Team
Name of the batch jobEx: eGrants Batch Job / [APP] DB / Database Administrator

The following databases need to deployed/configured as part of [APP] deployment:

Database / Description / Server / Responsibility
Name of the database> Ex: APPDB / [APP]database / Name of the database server> Ex: EDCTCSQ / Database Administrator

ConfidentialPage 1

[APP] Deployment DocumentPA Department of Education

2.System Hardware/Software Requirements

2.1Internet Server/Web Server

Software Requirements:List down all the software requirements for the application. This could be a operating system, web server, third party software etc. as mentioned below

Microsoft Windows Server 2008 SP 1

Microsoft .NET Framework v 4.5

IIS 7.5

Hardware Requirements:List down all the hardware requirements for the application. This could be machine configuration like dual core quad band, virtual load balancing servers etc. as mentioned below

4 GB RAM

Load balanced servers etc.

2.2Database Servers

List down all the software and hardware requirements for database server as mentioned below

Software Requirements:

Microsoft Windows Server 2008 SP 1

Microsoft SQL Server 20__

Hardware Requirements:

3.Check System Hardware and Software

3.1.1CheckHardware/Software installed on the machine

List down the steps that you want to perform to check if appropriate software/hardware is installed on the machine

3.1.2Check the Database Connectivity from Web Server

List down the data connectivity properties to be tested (if any) in specific steps for the application before the application is hosted. Example:

Using Data link Properties test the database connectivity from the web servers.

  1. Create APP.udl on the desktop of Web Server

Right click on the desktop  New  Text Document

Type APP.udl  click Yes to change the file extension

  1. Double click to open the APP.udl
  2. Click on the Provider Tab
  3. Select Microsoft OLE DB Provider for SQL Server
  4. Click on the Connection Tab
  5. Select or enter a server name: EDCTCSQP
  6. Enter information to log on to the server: Select the radio button “Use a specific user name and password”

Enter User name and Enter password…

  1. Select the database on the server: APP
  2. Click on the “Test Connection” button
  1. Click on OK.

4.Database Deployment

4.1.1Database Deployment

List down specific steps to be carried out to deploy the database(s) used by the [APP]

EXAMPLE:

The following database(s) have to be deployed

Database / Server Location / Server Name / Database Version
APP / PDE / Name of the server> Ex: EDCTCS / SQLServer 20__

4.1.2[APP] Batch Job Deployment

List down specific steps to be carried out to deploy the batch jobs used by the [APP]

EXAMPLE:

4.1.2.1Deploying the SSIS package

The SSIS package created contains a file with an extension ‘..SSISDeploymentManifest’. Double click on the file and follow the screen instructions.

Steps:

1. Click Next

2. Select ‘SQL Server Deployment’ from the options provided and click ‘Next’

3. Select a folder to deploy and click ‘Next’

4. Click ‘next’

5. A configuration file is seen, and in the ‘Configurations’ section select ‘Property’. Modify the following colored in Red:

6. Click ‘Next’ and ‘Finish’.

5.Application Deployment

List down specific steps to be carried out to deploy the web application

EXAMPLE:

5.1Configuring Web Site

5.1.1How to Create & Configure a Web Site

  1. Start Internet Information Services (IIS) Manager:
  2. From the Start Menu:Settings  Control Panel  Administrative Tools  Internet Services Manager.OR
  3. Right Click on the My Computer (Server Machine Name i.e. EDCTCIS) and select manage  Opens Computer Management screen  Expand Services & Application  Expand Internet Information Services (IIS) Manager.
  4. Click on the Web Service Extensions folder  On the right hand side make sure following Web Service Extension are “Allowed”

Web Service Extension / Status
Active Server Pages / Allowed
ASP.NET v1.1.4322 / Allowed
ASP.NET v2.0.50727 / Allowed

If not right click on the Web Service Extension & click Allow

  1. Create the Web Site for APP:
  2. Select the Web Sites folder from the left hand side pan
  3. Right click on the Web Sites and select New  Web Site
  4. It will open Web Site Creation Wizard. Click Next on the wizard
  5. Web Site Creation Wizard Web Site Description:
  6. Enter the name of the website “APP”. Click on the Next button.
  7. Web Site Creation Wizard IP Address and Port Settings:
  8. Enter the IP address to use for this Web Site: Select (All Unassigned)
  9. Leave the TCP port as the default entry of 80.
  10. Enter the host header for the site. This should be the full web address for the site without the “ e.g., .
  11. Click on the Next button.
  12. Web Site Creation Wizard Web Site Home Directory:
  13. Click on the Browse button to Browse for the Folders.
  14. Select the APP folder from <directory path>
  15. Make sure that the “Allow Anonymous access” to this Web Site checkbox is Checked
  16. Click on the Next button.
  17. Web Site Creation Wizard Web Site Access Permissions: Allow the following permissions

Permissions / Allow
Read / Checked
Run scripts (such as ASP) / Checked
  1. Click on the Next button & then on Finish button to complete the Web Site Creation.
  1. Web Site “APP” and will be visible under Web Sites folder.
  2. Set up Permissions for Web Site “APP”
  3. Right click on the Web Site APP & select Permissions
  4. Make sure following permissions are set up

Permissions / Allow
Administrators / Full Control
ASP.NET Machine Account (EDCTCISP\ASPNET) / Read & Execute
List Folder Contents
Read
CREATE OWNER / Special Permissions
Internet Guest Account (EDCTCISP\IUSR_EDCTCISP) / Read & Execute
List Folder Contents
Read
SYSTEM /
  1. Modify
  2. Read & Execute
  3. List Folder Contents
  4. Read
  5. Write

USERS /
  1. Read & Execute
  2. List Folder Contents
  3. Read
  4. Special Permissions

Note: If you are setting up the permissions very first time on the fresh server, most likely you may have to Add only two (2) Permissions i.e. ASPNET & Internet Guest Account & set up the permissions. Use “Add…” button to add the permissions.

  1. If the permissions are missing or not setup, then setup the same using the Add button. For Example:
  2. Click on the Add button to open the “Select Users or Groups” dialog box
  3. In the window for the “Enter the object names to select”, enter the name ASPNET & click on the “Check Names” button.
  4. Click on the OK button.
  1. Set up SSL Certificate for Web Site “APP”
  2. Remove Integrated Windows authentication:
  3. Right click on the Web Site APP & select Properties:
  4. Select the tab “Directory Security”
  5. In “Authentication and access control” section, clicked on the “Edit…” button to Open & edit Authentication methods for APP.
  6. Uncheck Integrated Windows authentication.
  7. Click on the OK button.
  8. Set Up SSL Certificate
  9. On the “Directory Security” tab
  10. In the “Secure Communications” section, click on the button “Server Certificate…” to open Web Server Certificate Wizard. Click on the Next button.
  11. It will open the “Web Server Certificate Wizard”
  12. Click on the Next button to go to “Server Certificate”.
  13. Select radio button option “Import a certificate from a .pfx file”
  14. Click on the Next button to go to “Import Certificate”
  15. Create a folder, “Certificate Folder”, in a drive on webserver.
  16. Copy the certificate file on the Web Server into Certificate Folder.
  17. Click on the Next button to go to “Import Certificate Password”
  18. Provide the password in the textbox.
  19. Click on the Next button to go to “SSLPort”
  20. In the textbox for SSL port this web site should use: enter 4101.
  21. Click on the Next button to go to “Imported Certificate Summary”
  22. Verify the Information, make sure that the Issued To filed is displaying the web site URL ()
  23. Click on the Next button & then on the Finish button to complete the Web Server Certificate Wizard.
  24. Verifythe SSL Certificate for Web Site “APP”
  25. On the “Directory Security” tab
  26. In the “Secure Communications” section, click on the button “View Certificate…” to open & verify the Certificate that you have installed just now.
  27. It will open the “Certificate” dialog box.
  28. Verify the installed certificate & click on OK button to close the dialog box.
  29. Set up Web Site Identification & Adding Host Identification:
  30. On APP Properties, go to “Web Site” tab.
  31. In the “Web site identification” section, click on the button “Advanced…” to open “Advanced Web Site Identification”
  32. Opens “Advanced Web Site Identification” dialog box
  33. In “Multiple SSL identities for this Web site” section, click on the “Add…” button to open “Add/Edit Web Site SSL Identification”

In “IP Address:” dropdown Select (All Unassigned)

SSLPort:4101

Click on the OK button.

  1. Click on the OK button.
  1. Verify ASP.NET tab
  2. On APP Properties, go to “ASP.NET” tab
  3. Verify that the 2.0.50727 is selected in the ASP.NET Version: dropdown.
  4. Enable the Content Page
  5. On APP Properties, go to “Documents” tab
  6. Make sure that the “Enable default content page” is checked
  7. Make sure that the “default.asp” is the first page in the list box.
  8. Click OK to close the APP Property dialog box.

5.1.2How to Create a Application Pool

  1. In IIS right click on the Application Pools folder and choose New Application Pool….
  2. This will open the “Add New Application Pool” dialog box.
  3. Enter “APP” in the Application Pools ID
  4. Keep default setting for rest of the options
  5. Click on OK button to close & create the new application pool.
  6. This will create & display APP as a new Application Pool on left hand side window under “Application Pools”

5.1.3Specify Application Pool for the web site

  1. In IIS, open the Web Sites node.
  2. Right Click on the APP & open APP properties
  3. Go to the “Home Directory” tab
  4. In Application Settings section – Select APP from the “Application pool” dropdown list.
  5. Check to see if Application name: is “Default Application” if so:
  6. Change (type) the application name to APP
  7. Click on the OK button to close the APP Properties.

5.1.4Hosting Web Application on more than one Server

Please repeat the steps in section5.1 for the other web servers if any.

5.2Registering third party DLL

List down the purpose and steps to register third party DLL used by the [APP]>

6.Configuration Files (Web.Config)

6.1Settings for [APP] Application:

List down the configuration setting [APP] will use and provide with a sample [APP] configuration file

7.Appendix

7.1Summary of steps for Deployment team

List down any additional deployment information you want to provide for the [APP]

7.2Summary of steps for DBA team

List down any additional database deployment information you want to provide for the [APP]

1.Create the necessary SQL Logins as per PDE Naming Standards - AppName_AppUser, AppName_RptUser, and/or AppName_WsvUser (Ex: IC_AppUser, IC_WsvUser)

2.Make sure the SQL Logins have been given the appropriate permissions on the required Databases and Database Objects.

3.If a new server, Create the ASPState Database to hold session state on SQL Server. Use the following command to setup the database:

aspnet_regsql.exe -S servername -E -ssadd -sstype p

END OF DOCUMENT

ConfidentialPage 1