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 1,287 Comments - Join the conversation

  1. Very quickly this site will be famous among all blogging users, due to it’s good content

  2. Steffen says:

    This site was… how do I say it? Relevant!!
    Finally I have found something which helped me. Appreciate it!

    Also visit my blog; frank kern high paid advisor (Steffen)

  3. domain says:

    Good blog you’ve got here.. It’s difficult to find quality writing like yours these days.
    I really appreciate individuals like you! Take care!!

  4. This is very interesting, You are a very skilled blogger.
    I’ve joined your rss feed and look forward to seeking more of your fantastic post.

    Also, I have shared your site in my social networks!

    Here is my webpage; consulting class frank kern

  5. Amos says:

    What a stuff of un-ambiguity and preserveness of valuable know-how
    regarding unpredicted emotions.

  6. Gia says:

    Hello Dear, are you truly visiting this web page on a regular basis,
    if so then you will definitely obtain pleasant know-how.

    Feel free to surf to my website – dayz download [Gia]

  7. Hi i am kavin, its my first time to commenting anyplace,
    when i read this piece of writing i thought i could also create comment due to this brilliant article.

  8. Just because an online shops states they have cheap high end watches does not mean they have replica.
    The arrangement in the gear train is dependent upon the amount of torque to be transmitted, the orientation of the input
    along with the output shafts, and also the size of the gear box.
    Besides the fashion tendencies, there exists another reason why an analog watch is usually preferred over the digital one.
    The neat thing about the phone is that it is
    extremely user friendly in the sense that it may tied across
    the wrist. It’s a great deal of hassle to measure information until you have
    a product just like the heart pulse watch that it
    is possible to look down at easily and simply tell what your heart rate could be the moment.

  9. I love your blog.. very nice colors & theme. Did you make this website yourself or did you hire someone to do it for you?
    Plz answer back as I’m looking to design my own blog and would like to find
    out where u got this from. cheers

  10. Hello everyone, it’s my first go to see at
    this web page, and article is really fruitful in support of me, keep up posting such posts.

  11. We stumbled over here by a different web page and thought I should check things out.
    I like what I see so i am just following you. Look forward to looking at your web page for a second time.

  12. You actually make it seem so easy with your presentation but I to find this topic to be actually one thing which I
    believe I would never understand. It sort of feels too complicated and very
    wide for me. I’m having a look ahead to your subsequent publish, I will try to get the dangle of it!

  13. Albert says:

    Boom Beach is a fight approach sport the location you battle an epic struggle
    in opposition to the evil Blackguard.

  14. That is a very good tip particularly to those new to the blogosphere.

    Short but very precise information… Many thanks for sharing this one.
    A must read article!

  15. Hi there, this weekend is fastidious in support of me, for
    the reason that this occasion i am reading this great educational
    article here at my house.

    my web page … Cristine I. Tuter

  16. Fantastic site loads of great steam shower info here

    Take a look at my blog post: steam shower spares (http://airtelhelp.com/member.php?action=profile&uid=2812)

  17. Bing.Com says:

    What’s Going down i’m new to this, I stumbled upon this I’ve discovered
    It absolutely helpful and it has aided me out loads.
    I hope to give a contribution & aid other users like its aided me.
    Great job.

    my web blog :: Bing.Com

  18. Be proud and confident, hone your powers that you have naturally and
    emphasize your qualities and if you follow the guidelines I have given you here they will dramatically make you more attractive to any man no matter what you think
    you look like, we all have faults that we are not happy with but that is what makes us so unique.

    Being of Italian decent, speaking with my hands
    is a natural habit. You are going to be able to make that
    happen tonight and you are going to give him something that will be out of this world.

  19. What’s up i am kavin, its my first occasion to commenting anywhere, when i read this article
    i thought i could also create comment due to this brilliant post.

    my blog :: Athletic Greens best greens superfood supplement

  20. I believe this is one of the such a lot vital info for me.

    And i am satisfied studying your article. However want to remark on some
    normal things, The website taste is ideal, the articles is in reality nice : D.
    Excellent process, cheers

  21. Have you ever considered writing an e-book
    or guest authoring on other websites? I have a blog based upon on the same
    ideas you discuss and would love to have you share some stories/information. I know my audience would appreciate your work.
    If you’re even remotely interested, feel free to shoot me an e-mail.

  22. Hotline Miami is a cross acquire game, so if
    you own it on PS3 or PS Vita then you currently personal it on PS4.

    Here is my site … hotline miami wrong number download for pc

  23. Bill says:

    Why users still use to read news papers when in this technological world everything is available on net?

  24. Paul says:

    It is so easy and straight up if you just know what to
    do. With the mlm business opportunity, you might also adopt an automated
    process for sign ups using this internet mlm
    marketing system which starts once your prospect reaches Google and
    people get to search using a specific keyword in order to look for what you.
    com is one of those trusted websites for mobile recharge, 3g plans, data card recharge or to pay post paid bills.

  25. Confirm this review and we’ll heal an imaginary dog!

  26. It can even search engine optimization purchase it online.
    However, it is quite search engine optimization a design company having hosting area.

    You can search for a person faster. Raycap is recognized as providing them more visible to the information technology
    has both been a key driver of today, it is easy to create content with search engines.
    Repetition is the effectiveness of the page to another in a poor
    one, but you may lose money.

    Stop by my web page: site optimization

  27. Stante se soucástí obrovské komunity ? najdete partnera,
    po jakém toužít?. Existuje spousta duvodu, proc používat seznamky proo
    domluvení dobrodružství. Nebaví vás sex s partnerem,
    který nedokáž? splnit ?aše sexuální prání.

  28. I really like what you guys are up too. This type of clever work and reporting!
    Keep up the very good works guys I’ve added you guys to blogroll.

    my weblog; Credible Free Casino Slots Casino Site

  29. Fantastic beat ! I wish to apprentice while you amend your website, how could i subscribe
    for a blog website? The account helped me a acceptable deal.

    I had been tiny bit acquainted of this your broadcast provided bright clear idea

  30. juresta says:

    Wij zijn 3 jaar klant geweest bij Juresta Nederland
    bv. Wij hebben veel klachten over Juresta, ze werpen veel hindernissen op als ze moeten incasseren.
    Juresta kwam meestal bij ons zeuren dat het een niet haalbare incasso was en dat wij Juresta
    moesten betalen. Als we dan toch wilden doorzetten lieten ze de incasso zaak versloffen. Een ander probleem was dat Juresta wil dat voordat
    ze iets aan hun klant uitkeren dat die klant allemaal fax formulieren verstuurt.

    En ze lieten het ons niet weten als er geld op de rekening bij Juresta binnenkwam.

    Wij adviseren iedereen een ander incassobureau te zoeken, wij zijn nu bij een ander bureau zeer tevreden.

  31. Other issues such as for example herpetic whitlow , herpes gladiatorum , ocular herpes , cerebral herpes
    disease encephalitis , Mollaret’s meningitis , neonatal herpes , and perhaps Bell’s palsy are all due to herpes
    simplex viruses.

  32. pinterest says:

    Make your images, videos, and infographics easy to pin by
    placing them on the page rather than displayed as a background.
    Google+ is a social networking site that has a range of different features that you can use to connect
    with patients and other healthcare professionals.
    It’s not always easy, but if the material is for something truly important, it’s the wisest step
    to take.

    Have a look at my homepage :: pinterest

  33. I am really grateful to the holder of this web site who has shared this fantastic piece of writing at at this time.

  34. Timothy says:

    My brother suggested I might like this website.
    He was entirely right. This post actually made my day. You cann’t
    imagine simply how much time I had spent for this information! Thanks!

    Feel free to surf to my webpage :: programa de dj (Timothy)

  35. Unquestionably believe that which you stated. Your favourite reason seemed to be
    on the internet the easiest thing to take note of.
    I say to you, I definitely get annoyed even as other
    people consider worries that they just do not recognise about.
    You managed to hit the nail upon the top as well as outlined out the entire thing with no need side-effects , other folks can take a signal.
    Will probably be again to get more. Thanks

    My blog post – 100% capture (http://voi.Vortaloptics.net)

  36. Real Gucci shoes also have the words “Gucci Made in Italy” stamped
    on the heel of its lining. Relentless was now full of “old”
    players who weren’t interested in playing, but were interested in keeping the power.
    Most of them will, as it is a matter of your external appearance and they understand the consequences of a bad tan.

    My web blog: spray tans in arab al

  37. Hi there mates, good paragraph and fastidious arguments
    commented at this place, I am truly enjoying
    by these.

Add a Comment