Writings

Installing WordPress on SQL Server

Before you read this article, please note: the easiest way to install WordPress on SQL Server or SQL Azure is to use the Getting Started page. If you’re still having trouble or want more details, read on!

These instructions assume you’re installing WordPress on Windows 7 or Windows Server 2008 or 2008 R2. If you’re installing WordPress in a Windows share hosting environment, many of these same concepts apply.

Here’s a summary of the steps:

  1. Install the Prerequisites
  2. Configure a Database
  3. Download the WordPress on SQL Server Distribution
  4. Configure IIS
  5. Install WordPress
  6. Remove IIS Detailed Errors and Configure URL Rewrite

1. Install the Prerequisites

Use the Microsoft Web Platform Installer. Be sure you have:

  • II7 or above (Windows Vista, Windows 7, Windows Server 2008, Windows Server 2008 R2)
  • PHP 5.2 or above
  • SQL Server Express 2008 w/Tools or above
  • PHP Driver for SQL Server v1.1 or above
  • URL Rewrite 2.0 or above

Get Products with Web Platform Installer

Click here to install all these products with the Web Platform Installer.image

Click on the Get the Microsoft Web Platform button and accept the prompts to install WPI.

image

Click on the bar at the top of the browser to install the add-on.

image

Follow the onscreen prompts and grant permission for the site to open WPI.

image

image

Once the Web Platform Installer downloads and installs all the prerequisites, it will prompt you to configure your SQL Server Express install.

image

Choosing Mixed Mode Authentication and providing an (sa) password will make your web development easiest.

The Web Platform Installer will now download all the bits and prerequisites.

image

Once the download is complete, it will automatically install and configure the software.

image

image

Now you’re ready to run web applications on the Microsoft Web Platform.

2. Configure a Database

In this step, you’ll create a database and a database user for your WordPress install.

Start by running SQL Server Management Studio from your start menu.

image

You’ll be prompted to log on to SQL Server.

image

Connect to your database using Windows Authentication and .SQLExpress for the Server name.

image

Create a new database Login by expanding the Security. Right click on Logins to select New Login.

image

Supply a Login name; select SQL Server authentication; provide a Password and uncheck User must change password at next login. You can leave the rest of the defaults.

Now you need to create a database.

image

Create a new Database by right clicking on Databases to select New Database.

image

Enter a Database name and specify the Login name of the user you created above.

Now you’re ready to proceed with the WordPress install.

3. Download the WordPress on SQL Server Distribution

Go to the Download page and select the standard or Multi-User Distribution from the box on the right side of the page.

image

This will take you to the SourceForge download page for the current version.

image

If you try to save the ZIP file directly to your IIS directory, you’ll probably get a permissions error like below.

image

Save the ZIP somewhere else on your machine, extract the files and copy them into the C:inetpubwwwrootwp-sqlsrv folder.

image

image

image

4. Configure IIS

The most common issue I’ve discovered involves WordPress’ use of HTTP errors.

Enable IIS Detailed Error Messages

When trying to install WordPress for the first time,you might get an IIS 500—an internal server error that says,“There is a problem with the resource you are looking for, and it cannot be displayed”.

image

WordPress is designed to throw an HTTP 500 error if a wp-config.php file is not detected. The problem is that the default install of IIS 7 is overriding HTTP errors for external users as to now show detailed information about the server.

You can temporarily override this behavior during the installation process by telling IIS to show Detailed errors. Do this by creating a web.config file in the root of your WordPress install with the following content:

<?xml version="1.0" encoding="UTF-8"?>
<configuration>
    <system.webServer>
        <httpErrors errorMode="Detailed"/>
    </system.webServer>
</configuration>

Grant IIS Write Permissions to WordPress Folder

Next, you need to ensure your IIS has write permissions to your WordPress installation folder. 

NOTE: If IIS does not have write permissions to your WordPress folder you will get caught in a loop where you enter your database credentials then get taken back to the initial installation screen. 

By default IIS runs as IUSR so you must add this user with Write permission through Windows Explorer.  Browse to the installation folder, right click on the wp-sqlsrv folder and select the Security tab.

image

Click the Edit button, select Add, then type IUSR for Enter the object names to select.  Click on Check Names and IUSR should now be underlined. 

image

When you click OK the top window will close.  Make sure to give this user Write permissions by selecting the checkbox.

image

5. Install WordPress on SQL Server

Browse to the root of your WordPress install, which in my case is http://localhost/wp-sqlsrv/.

image

Follow the prompts until you’re asked for database information.

image

Specify the Database Name, User Name and Password you created while configuring the database. For the default SQL Server Express install, you will enter .SQLExpress for the Database Host.

Select the sqlsrv driver for Database Type. This will use the PHP Driver for SQL Server, which was developed and maintained by the SQL Server team.

You should see the screen below, with an option to Run the install.

image

If you don’t see this screen and are taken back to the first screen of the install, that means your web server doesn’t have permission to write to the directory (See step 4).

image

You can get information on IIS security here.

If the install is moving forward, you’ll just need to enter your blog information and receive the admin password.

image

Now WordPress should be up and running on SQL Server!

image

The last step is to update your web.config to remove the IIS Detailed errors and enable URL Rewrite.

6. Remove IIS Detailed Errors and Configure URL Rewrite

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>

Now enjoy using WordPress on SQL Server!

For Support

If you’re still having issues, please using the WordPress on SQL Server forums on SourceForge.

Comments 675 Comments - Join the conversation

  1. hcg diets says:

    What’s up to every , for the reason that I am really eager of reading this blog’s post to be updated on a regular basis.
    It contains nice material.

  2. Hello, for all time i used to check blog posts here early
    in the daylight, since i like to learn more and more.

  3. Hi there! I know this is kind of off topic but I was wondering if you knew where
    I could locate a captcha plugin for my comment form?
    I’m using the same blog platform as yours and I’m having difficulty finding one?
    Thanks a lot!

    Feel free to surf to my web page: click here to find out more

  4. Hello every one, here every person is sharing these knowledge, therefore it’s fastidious to read this blog,
    and I used to pay a quick visit this webpage daily.

    My site equideow hack généRateur gratuit

  5. Excellent post. I was checking constantly this blog and I’m impressed!
    Extremely helpful information specifically the
    last part :) I care for such information much.
    I was looking for this particular information for a long time.
    Thank you and good luck.

  6. Hello to every one, the contents present at this web site are truly awesome for people knowledge, well, keep up the nice work fellows.

  7. Hulda says:

    Hello, after reading this amazing paragraph i am too cheerful to share my knowledge here with colleagues.

  8. If some one desires expert view concerning
    blogging and site-building after that i propose him/her to
    go to see this webpage, Keep up the fastidious job.

    my web site engagement rings three stone princess cut diamond rings

  9. An impressive share! I’ve just forwarded this onto a colleague who has been doing a
    little homework on this. And he in fact bought me
    lunch because I stumbled upon it for him… lol.
    So let me reword this…. Thank YOU for the meal!!
    But yeah, thanks for spending some time to talk about this issue here on your web
    page.

    my web blog: kite shops in los angeles ca

  10. Please come discuss with one of our Montreal search engine marketing
    expert for all your web site referencement needs.
    Not only does it help you search for and find that hidden campsite in the woods and the quiet stream in the mountains where
    there are holiday cabins, but it also helps you find that friend you lost touch with who now works in a
    refugee camp in a little known third country in Africa. Web search engine optimization is considered a standard today.

    Feel free to surf to my website site commerce

  11. I am truly grateful to the owner of this web site who has shared this
    wonderful paragraph at at this place.

    Feel free to surf to my web page: ableton live 9 patch

  12. This is a great tip particularly to those fresh to the blogosphere.
    Simple but very accurate information… Thank you for sharing this one.
    A must read post!

    Look into my web-site; déménageur sherbrooke

  13. I like the helpful info you provide in your articles.
    I’ll bookmark your blog and check again here
    regularly. I am quite certain I will learn lots of new stuff
    right here! Good luck for the next!

  14. Offering full-screen access to your friends’ status updates
    (also available via the app’s widget) and full profile information as well
    as messages and pictures, the app is a suitable mobile alternative to the full version. Chrome for Android’s feature is currently optional, and not accessible via the program’s settings, but might one day be turned on and available by default or through the U.

    This form of attack simply means that the program is placed
    between the sender and the recipient.

  15. Thankfulness to my father who stated to me regarding this website, this blog is in fact awesome.

  16. Now the very first matter you must do straight away soon after the collision is speak to your insurance policies business.

    However, even in some jurisdictions that do not require a party to claim fault of their partner, a court may still take into account the behavior of the parties when dividing property,
    debts, evaluating custody, and support. Not at all, in many occasions, car accident lawyers perform a vital role in increasing the claimant.

  17. Any time you approve our comment, we can provide $0.01 to a
    wonderful cause.

  18. nnnx says:

    Other states vary, and if you live in a state that allows you to do it with a treasurer’s deed,
    they ask for around $200-$400. Whatever your reasons
    are, you have to face the reality of taxes. Also, project sites with difficult access maybe be considered complex, as well.
    In general, the interest rate is a bit higher than average for
    restaurants due to the fact that they are single-tenant properties.
    PRESENTATION – MUNICIPAL INFORMATION SYSTEMS ASSOCIATION OF CALIFORNIA (MISAC) AWARD FOR EXCELLENCE IN
    INFORMATION TECHNOLOGY PRACTICES. So what are the factors that lead to business investment stand out.
    On the other hand, they are suggested to be made use of
    only in the prescribed ranges so that they do not inhibit the action of other hormones.

    o Net lease: Opposed to a gross lease, this is where
    the tenant pays the rent plus a portion of the maintenance fees, insurance premiums and other operating
    expenses. The wheelchair accessible minivans can be bought in all budgets.
    Real estate investors that target the Saint Petersburg area probably
    know what they will be doing every Monday night.

    Feel free to visit my web-site nnnx

  19. Daniel says:

    Hmm is anyone else having problems with the pictures on this
    blog loading? I’m trying to figure out if its a problem on my end or if it’s
    the blog. Any feedback would be greatly appreciated.

  20. Likewise, a natural method to thicken hair is to make sure one’s diet is rich in protein, crucial fats and oils, and other
    essentials. It is usually recommended that it should be applied
    during morning and evening hours in order to stimulate hair growth.

    “Although Hypotrichosis simplex is very uncommon, it may prove critical in our search for an understand of the mechanisms of hair growth,” says project leader Dr.

    Feel free to visit my website: hair restoration in michigan

  21. web site says:

    That is very interesting, You are an overly professional blogger.
    I’ve joined your feed and look ahead to seeking extra of your wonderful post.
    Additionally, I’ve shared your web site in my social networks

  22. Thankjs for the auspicious writeup. It actually was a amusement accoun it.Loook advanced to
    mire introduced agreeable from you! By the way, how can we bbe in contact?

  23. Hi there! Would you mind if I share your blog with my facebook group?
    There’s a lot of people that I think would really appreciate your content.

    Please let me know. Thanks

    Feel free to surf to my page: demenagement sherbrooke

  24. dirtbike says:

    This is my first time visit at here and i am genuinely happy
    to read all at single place.

    Here is my web-site :: dirtbike

  25. Victoria says:

    Excellent, what a website it is! This web site provides useful facts to us,
    keep it up.

    My blog post blade kites 2014 (Victoria)

Add a Comment