Category: 3. Pre-requisite


Create user: WordPressUser

  • Access SQL Server 2008 Management Studio
  • Connect to the database server
  • Go to:
    • Security > Logins
  • Create new user: WordPressUser
  • Select SQL Server Authentication
    • Untick: Enforce password expiration
    • Accept defaults
    • Click OK button

Create database: wordpress

  • Go to: Database > wordpress
  • Add WordPressUser as Owner of wordpress database

Install: SQL Server Native Client

An Application Pool is used to separate sets of IIS Worker processes that share the same configuration & application boundaries.  It is automatically created when the website above is created.

    • Go into: Application Pools
    • Select: WordPress Application Pool
    • Go to: Advanced Settings > Identity > Custom Accounts
    • With Domain Admin Rights, enter username & password of account

Reference

http://www.dotnetfunda.com/interview/exam1414-what-is-application-pool-in-iis-.aspx

Retrieved 18:24 p.m. 05/06/2011

The WordPress website needs to be created in its own folder with the IIS Manager pointing to it.

Create folder: wp-sqlsrv

  • Access IIS Manager
  • In C: drivefollow path to: inetpub > wwwroot
  • Create a folder called: wp-sqlsrv
  • Set permission levels in the folders properties by:
    • Right-clicking on the wp-sqlsrv folder
    • Scroll down & select Properties
    • Go to Security tab
    • Grant local IUSR account Write Access to the folder

 Create website: WordPress.html

  • Access IIS Manager again
  • Add a new website called: WordPress
  • Point to the folder just created: C:inetpubwwwrootwp-sqlsrvWordPress.html
    • Go to: Bindings section
    • Create IP Address or hostname of server: 192.168.5.48

Select Application Pool

An Application Pool is used to separate sets of IIS Worker processes that share the same configuration & application boundaries.  It is automatically created when the website above is created.

  • Go into: Application Pools
  • Select: WordPress Application Pool
  • Go to: Advanced Settings > Identity > Custom Accounts
  • With Domain Admin Rights, enter username & password of account

Reference

http://www.dotnetfunda.com/interview/exam1414-what-is-application-pool-in-iis-.aspx

Retrieved 18:24 p.m. 05/06/2011

In order to follow the instructions in this User Guide, it is assumed that an IIS has been previously installed & configured correctly.

Note

In order for an IIS to be satisfactorily installed, the following minimum requirements were necessary.

Reference

http://www.microsoft.com/windowsserver2008/en/us/system-requirements.aspx
Retrieved 11:46 a.m. 9/03/2011

Component Requirements
Minimum Notes
Processor 1.4 GHz (Single x64 processor)1.3GHz (Dual Core) Itanium-Based Systems require an Intel Itanium 2 processor for Windows Server 2008 R2 with SP1
Memory 512 MB RAM Maximum Limits:8 GB (Foundation) or

32 GB (Standard) or

2 TB (Enterprise, Datacenter & Itanium-Based Systems)

Disk Space Requirements 32 GB or greater 16 GB of RAM computers need more disk space for paging, hibernation & dump files
Display Super VGA (800 × 600) or higher resolution monitor
Other Caddy, DVD Drive, Keyboard, Compatible pointing device & Internet access