Server Installation: Difference between revisions

From EPOD
No edit summary
No edit summary
Line 1: Line 1:
==Required Components==
*Database
*ASP .NET 2 - 3.5
*IIS
*External IP/URL
*Access to the machine
==Installation Process==
*Access the machine via RDP
*Copy all installation files to the Remote Host, this should include ePOD_WebApp, a SQL Folder and a PDA Folder and any required installation files (wkhtmltopdf, xferapp, sqlexpress)
==SQL Server Config==
==SQL Server Config==
*Install SQL Express - with Tools
*Install SQL Express - with Tools if required
*Create User - EPOD
*Setup to use the default instance and default users
*Restore Default DB
*Enable TCP/IP  
*Enable TCP/IP  
*Enable PipedNames  
*Enable PipedNames  
*Add firewall expections to the programs and ports (1433)
*Add firewall expections to the programs and ports (1433)
==Database Setup==
*On the selected database.
*Create User - epod / eP0D1234.
*Open the SQL script within the SQL folder copied to the remote host.
*Check the two file paths at the top of this file match the directories for the install (only appliable to SQL Server installations).
*Run the SQL script within the SQL folder copied to the remote host.
*Grant the user created Owner rights to the database.
*Create the default site (either through MetaData sql script or manually)
*Create a default user of ADM for this site


==ASP. Net==
==ASP. Net==
*Install .Net 3.5 framework
*Copy all of the ePOD_WebApp folder to the desired hosting directory
*Create the new .Net website
*Install .Net 3.5 framework, the system will work fine on .Net 2
*Check this has registered with IIS
*Open command prompt
*Navigate to the frameworks folder (C:\Windows\Microsoft.NET\Framework)
*Select your versions folder
*Run regiis -i
*Create a new application pool called ePOD and select the relevant framework
*Select advanced settings on the application pool and settup the applications pool identify, this should default to ApplicationPoolIdentify, which is fine
*Create the new .Net application, pointing to the ePOD_Webapp Folder, using the above application pool
*Bind to a external IP/URL (depends on routing)
*Bind to a external IP/URL (depends on routing)
*Setup application Pool (default if no other applications)
*Apply ASP user permissions (IIS_USRS) to all files in the directory
*ASP user permissions to all files in the directory
*Allow annoymous access  
*Allow annoymous access  
*Add Default document as login.aspx
*Add Default document as login.aspx
Line 18: Line 45:
==Miscellaneous==
==Miscellaneous==
*Ensure MS Excel is installed - only for legacy versions
*Ensure MS Excel is installed - only for legacy versions
*Setup Mail Server Configuration
*Setup Mail Server Configuration within the Web.config file
*Setup scheduled service for auto export - only if required


[[Category:WI 287575 EPOD Development and Release Process|500]]
[[Category:WI 287575 EPOD Development and Release Process|500]]

Revision as of 14:40, 3 April 2012

Required Components

  • Database
  • ASP .NET 2 - 3.5
  • IIS
  • External IP/URL
  • Access to the machine

Installation Process

  • Access the machine via RDP
  • Copy all installation files to the Remote Host, this should include ePOD_WebApp, a SQL Folder and a PDA Folder and any required installation files (wkhtmltopdf, xferapp, sqlexpress)

SQL Server Config

  • Install SQL Express - with Tools if required
  • Setup to use the default instance and default users
  • Enable TCP/IP
  • Enable PipedNames
  • Add firewall expections to the programs and ports (1433)

Database Setup

  • On the selected database.
  • Create User - epod / eP0D1234.
  • Open the SQL script within the SQL folder copied to the remote host.
  • Check the two file paths at the top of this file match the directories for the install (only appliable to SQL Server installations).
  • Run the SQL script within the SQL folder copied to the remote host.
  • Grant the user created Owner rights to the database.
  • Create the default site (either through MetaData sql script or manually)
  • Create a default user of ADM for this site

ASP. Net

  • Copy all of the ePOD_WebApp folder to the desired hosting directory
  • Install .Net 3.5 framework, the system will work fine on .Net 2
  • Check this has registered with IIS
  • Open command prompt
  • Navigate to the frameworks folder (C:\Windows\Microsoft.NET\Framework)
  • Select your versions folder
  • Run regiis -i
  • Create a new application pool called ePOD and select the relevant framework
  • Select advanced settings on the application pool and settup the applications pool identify, this should default to ApplicationPoolIdentify, which is fine
  • Create the new .Net application, pointing to the ePOD_Webapp Folder, using the above application pool
  • Bind to a external IP/URL (depends on routing)
  • Apply ASP user permissions (IIS_USRS) to all files in the directory
  • Allow annoymous access
  • Add Default document as login.aspx

Miscellaneous

  • Ensure MS Excel is installed - only for legacy versions
  • Setup Mail Server Configuration within the Web.config file
  • Setup scheduled service for auto export - only if required