WordPress Installed on IIS 7.5 with SQL 2005 or 2008

Here is a quick layout of instructions in installing WordPress on Windows 2008 R2 IIS 7.5 with SQL 2005 or 2008

Download wp-sqlsrv-2.9.2-beta-0.8.8.zip This is a special version of Wordpress that allows you to connect to a SQL server... or cluster... :) why not?!

Unzip files to C:\inetpub\WPOnSQL

Open IIS Mgr -

Open your Web Platform Installer > Web Platform > Database > Customize > Microsoft Drivers for PHP for SQL Server 2.0. Install this thing before you create your site.

Create new site

Enter Site Information
Website:  New Web Site
WordPress application name:  /
Web Site Name: blog.boneyard.org
Physical Path:  c:\inetpub\blog.boneyard.org
IP Address:  All Unassigned
Host Name:  wponsql.boneyard.org
Click OK

****folder permissions of Modify, Read & Execute, List Folders, Read and Write on the c:\inetpub\SiteName folder to ServerName\IUSR

Go to your SQL box, open SQL Mgmnt studio and create a new database. Then create a SQL user that has dbo privs on that database. Then from your IIS, you can test your connection using ODBC manager.

Open site in a browser

The wp-config file will be missing, so let the site walk you through providing it with the database servername, database, and sql credentials

Create Configuration File > Lets Go >

Database Name: TEST

Username: sqlgod

Database Host: databaseservername\instancename

Database Type: SQL Server Using PHP Driver

Table Prefix: wp_

Click OK - the click Run the Install
Blog Title:  Wordpress on SQL Blog
Your E-mail:  admin@boneyard.org
Click Install WordPress

Login to Wordpress

Logout and do the following

http://blog.obxbill.com/?p=582

Click Dashboard and then Updates

An updated version of WordPress is available.
Click Update Automatically
After you see "WordPress updated successfully", click Go to Dashboard