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

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