Getting Started

Running WordPress on SQL Server is a piece of cake.  The following should only take a few minutes:

(Note: Currently, WordPress on SQL Server isn’t integrated into the Web Platform Installer, hence the extra steps.  If you want to install WordPress on Windows and MySQL check this out.)

If you want more detailed instructions we wrote this article to help.

  1. Make sure you have PHP, SQL Server Express, PHP Driver for SQL Server and URL Rewrite installed.
  2. Download the WordPress on SQL Server Distribution and extract the files to your web directory (i.e. C://inetpub/wwwroot/wp-sqlsrv)
  3. Enable detailed IIS error messages by creating a web.config file in the root of your WordPress install (i.e. C://inetpub/wwwroot/wp-sqlsrv/web.config) with the following contents:
    <?xml version="1.0" encoding="UTF-8"?>
    <configuration>
    <system.webServer>
    <httpErrors errorMode="Detailed"/>
    </system.webServer>
    </configuration>
    
  4. Grant IIS write permission to your WordPress directory (C://inetpub/wwwroot/wp-sqlsrv/) by adding IUSR with Write permission through Windows Explorer.
  5. Browse to your installation directory (i.e. http://localhost/wp-sqlsrv/) and follow the on-screen installation instructions.
  6. Create a new SQL Server Login and Database if needed.
  7. Select the SQL Server (sqlsrv) driver option and continue with WordPress install.
  8. Remove detailed IIS error messages and add URL Rewrite rules by replacing the contents of your web.config with the following contents:
    <?xml version="1.0" encoding="UTF-8"?>
    <configuration>
    <system.webServer>
    <rewrite>
    <rules>
    <rule name="wordpress" patternSyntax="Wildcard">
    <match url="*"/>
    <conditions>
    <add input="{REQUEST_FILENAME}" matchType="IsFile" negate="true"/>
    <add input="{REQUEST_FILENAME}" matchType="IsDirectory" negate="true"/>
    </conditions>
    <action type="Rewrite" url="index.php"/>
    </rule>
    </rules>
    </rewrite>
    </system.webServer>
    </configuration>
    
  9. Enjoy running WordPress on SQL Server or SQL Azure!

More Details and Help

Check out this post for more detailed instructions.

Visit the forums for support.