SQL Server 2008 Preparation

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

• Download Web Platform Installer from website, go to: http://www.microsoft.com/web/downloads/platform.aspx
• Locate: SQL Server Native Client
• Install this as well

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

Internet Information Server (IIS) Preparation

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:\inetpub\wwwroot\wp-sqlsrv\WordPress.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

Internet Information Server (IIS) Assumption

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