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

  1. Incredible points. Great arguments. Keep up the good spirit.

  2. laugh says:

    This type of fence is often referred to as an invisible fence.
    No amount of eye liner and mascara can ultimately hide what the eyes
    are truly saying. Fun Zone contains different types of jokes, and various
    kinds of cartoons within it.

  3. pbrowery.pl says:

    Nadzwyczaj atrakcyjny tekst, zalecam ludziom

    My blog pbrowery.pl

  4. Thank you a bunch for sharing this with all of us you really recognise what you are speaking approximately!
    Bookmarked. Please also consult with my web site =).

    We could have a hyperlink change contract between us

  5. Liliana says:

    This information is worth everyone’s attention. When can I find out more?

    My blog – company search, Liliana,

  6. loans says:

    I know this website provides quality depending content and extra information, is there any other website which presents these kinds of data in quality?

  7. Wow, that’s what I was exploring for, what
    a stuff! existing here at this webpage, thanks admin of
    this web site.

  8. Generally I don’t read article on blogs, butt I wish to
    say hat this write-up vey pressured me to take a look at
    annd do it! Your writing taste hass been amazed me. Thank you, very nice article.

    Feel free to visit my bloog :: ahli seo medan

  9. Thankfulness to my father who informed me on the topic of this web site, this blog is genuinely awesome.

  10. Or, perhaps you’re one of those students who desires a challenge, or
    even a good addition to your résumé for Grad school.
    You can know all the ins and outs of business and can run a restaurant without fail; but would you know
    the first thing about installing the kitchen grills. What you
    give away doesn’t have to be costly, but it must be valuable.

  11. Ebony says:

    Or, perhaps you’re one of those students who desires a
    challenge, or even a good addition to your résumé for Grad
    school. When job offers do come and I’ll admit, some companies may
    fear hiring you because they fear a former owner being
    an employee, negotiate the best salary you can along with the best
    benefits you can for you and your family. A
    customer is injured while using a product you sold and files a claim for
    indemnity.

  12. Then send the postcard to all of the addresses in your area, and try to draw customers in. Platforms: Android, Blackberry, i – Phone, i – Pad,
    Windows Phone. Before you do this, examine the publication online to ensure that its
    website is user friendly.

  13. Thanks , I’ve recently been searching for info approximately this topic for a long time and
    yours is the greatest I’ve found out till now. But, what about the conclusion? Are you certain in regards
    to the source?

  14. If plumbing plan review you feel uncomfortable, then choose a different one in the South Yorkshire area.

  15. Family Time- Many moms yearn to stay at home with their
    children. I personally highly recommend Perry Marshall’s Definitive Guide
    to Google Ad – Words (I am in no way affiliated with Perry Marshall).
    ” This make it work regardless attitude is what propels all successful people forward.

    my blog post company directory wordpress

  16. Buford says:

    Magnificent beat ! I wish to apprentice while you amend your site,
    how can i subscribe for a blog site? The account aided me a acceptable deal.
    I had been tiny bit acquainted of this your broadcast offered bright clear concept

  17. Yet, there are grants that are made for equipment
    and training. A lot of people have small business ideas that they often fail to put into practice either
    because they lack the money to make an investment or because the
    fear to lose everything. Two: Increase in income – When you
    are able to increase your traffic to the business, you will easily be able to
    also increase your income.

  18. adesk 123 says:

    wp-sqlsvr File removed???

  19. adesk 123 says:

    Hi everyone,

    Current version is down ?? I cant download the file: http://sourceforge.net/projects/wp-sqlsrv/files/

  20. *Reads and clears all common, annd some manufacturer, specific DTCs.
    This is one off the areas that most desserve the attention of the law.
    Totally individuals whho absolutely love the ckst large applying simple aand easy primary, effective, safe practices, whatever the decision cobcerning contrast expectations or referral ,
    can simply sem self-lies.

    Here iss my blog post; My Online Business membership

  21. It is banned to eat any animal meat, but we can obtain animal protein from eggs.
    ‘ If individuals deny themselves the required share of their nutritional typing,
    as in the case of Angelina Jolie, then illnesses may come about such as anxiety, depression, cardiovascular problems
    or others. Reasons for quick reduction in weight
    while following Navratra diet are:.

  22. I have read some good stuff here. Certainly price
    bookmarking for revisiting. I surprise how much effort you place
    to create such a fantastic informative site.

    my blog … english bulldog statue

  23. You actually make it appear really easy along with your presentation but
    I to find this topic to be really something which I think I might by no means understand.
    It kind of feels too complicated and very broad for me.

    I am looking forward for your next publish, I will attempt to get the hang of
    it!

  24. My brother recommended I may like this blog. He was totally right. This submit actually made my day. You can not consider simply how a lot time I had spent for this information! Thank you!|

  25. Kristeen says:

    Hi to every , since I am in fact eager of reading this web site’s post to be updated regularly. It consists of pleasant information.

  26. Mose says:

    What’s up mates, its impressive post regarding teachingand entirely defined, keep it up all the time.

  27. Harris says:

    Excellent blog! Do you have anny hints for aspiring writers?

    I’m planning to start my own website soon but I’m a little lost on everything.
    Woould you propose starting with a free platform like WordPress
    or go for a paid option? There aare so many choices out there tyat I’m totally confused ..

    Any suggestions? Thanks!

  28. Bring a large saucepan of water to the boil and
    add salt (preferably large grain sea salt). The tea can also relieve joint
    inflammation and arthritis. We ended the
    evening with Pineapple Sage tea (the leaves were picked right outside the back door and seeped in boiling water)
    and a block of 70% dark chocolate.

  29. Julian Mings says:

    If some one needs to be updated with latest technologies therefore he must be pay a quick visit this site and be up to date every day.

  30. Then send the postcard to all of the addresses in your area, and try to
    draw customers in. A lot of people have small business ideas that they often fail to put into practice
    either because they lack the money to make an investment or because the fear to
    lose everything. Always choose a new account, and look for a specialized bank whenever possible.

  31. The following are the benefits that you have to be aware of the most.
    A lot of people have small business ideas that they often fail to put into practice either because they
    lack the money to make an investment or because the fear to lose everything.
    Selling the same things, to the same market, in the same way.

  32. Look into their years of experience in managing small business accounts
    so that you can get professional advice on various financial
    matters. Further, amount of loan must be need-based, subject to ceiling of Rs 25,000 per borrower for purchase of machinery or
    equipment etc, and meeting working capital requirement
    of one operating cycle. Typically, this
    works well if we are involved in a solid networking and we reciprocate, by referring clients to those other businesses.

  33. Thanks , I have recently been looking for info about this topic for a while and yours is the greatest
    I have came upon till now. However, what concerning the conclusion? Are you certain in regards to the supply?

  34. This info is invaluable. Where can I find out more?|

  35. Generally I do not learn article on blogs, but I would like to say that this write-up very forced me to check out and do it! Your writing taste has been amazed me. Thank you, quite nice article.

  36. Valuable info. Fortunate me I found your site accidentally, and I am stunned why this accident did not took place earlier! I bookmarked it.

  37. Greate post. Keep posting such kind of information on your site. Im really impressed by your site.

Add a Comment