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

  1. Mas tanto si nosotros hemos hecho realidad su proyecto web, como si ya dispone de su
    propia página web, le ofrecemos nuestros servicios de posicionamiento y promoción web mediante optimizaciones SEO (optimización para motores de búsqueda).

  2. I blog frequently and I genuinely appreciate your content.
    The article has truly peaked my interest. I will bookmark your blog and keep checking for new information about once per week.
    I subscribed to your Feed as well.

  3. According to the American Holistic Health Association,
    living a holistic lifestyle improves the health and wellness
    of a person.

  4. It’s an remarkable piece of writing in favor of
    all the online people; they will obtain benefit from it I am sure.

  5. In each, the “board” is made up of a group of tiles; tile the starting format is fixed although random,
    while in Carcassonne the game is played by “making”
    the tile-by- in Settlers of Catan. Although it’s no panel; the pieces themselves
    equally form the layout and can go within it hive, a strategy
    game as transferring pieces using tiles, has strategic and physical components just like chess.

  6. Can I just say what a relief to find someone who actually
    understands what they’re talking about online. You certainly understand how to bring a problem to light and make it important.
    More and more people need to read this and understand
    this side of the story. It’s surprising you aren’t more
    popular since you most certainly possess the gift.

  7. Nevertheless, popular US advertising powerhouses including
    ESPN, FOX Activities, Univision and NBC Activities are getting all-in for baseball as attendance at 2014 Major League
    Baseball (MLS) functions increases to only over 19,000 lovers per sport, and domestic TV viewership increases
    by more than 50 percent within the 2013 time.
    For Tostao, Rivellino, Clodoaldo, Gerson, Jairzinho and Carlos Alberto were a number of the greatest
    players to actually play the game.

  8. Wow, fantastic weblog layout! How long have you ever
    been running a blog for? you made blogging look easy.
    The full look of your site is wonderful, let
    alone the content material!

  9. Your style is unique in comparison to other folks I have read stuff from.
    Thank you for posting when you’ve got the opportunity, Guess I’ll just book mark this web site.

  10. What’s up colleagues, its wonderful post regarding educationand completely explained,
    keep it up all the time.

  11. I’m gone to say to my little brother, that he should also pay a visit this web site on regular basis to obtain updated from
    most up-to-date reports.

  12. ??? says:

    Admiring the hard work you put into your website and
    detailed information you present. It’s nice to come across a blog every once in a
    while that isn’t the same unwanted rehashed information. Excellent read!
    I’ve saved your site and I’m including your RSS feeds to my Google account.

  13. SEO Nova says:

    I pay a quick visit each day some blogs and blogs to read
    content, but this blog provides feature based posts.

    My web-site SEO Nova

  14. Domingo says:

    Greate article. Keep writing such kind of information on your page.
    Im really impressed by it.
    Hello there, You’ve done a great job. I will definitely digg it and individually suggest to my friends.
    I’m confident they’ll be benefited from this website.

  15. dubai safari says:

    What’s Going down i’m new to this, I stumbled upon this I’ve found It absolutely useful and it has helped me out loads.
    I’m hoping to contribute & assist different customers
    like its helped me. Good job.

  16. La aplicación, sigue los partidos de fútbol y nos
    envía una alerta” cuando ocurre algo esencial,
    incluso si no estamos conectados a Tjekfutbol.

  17. I do trust all the concepts you’ve introduced on your post.
    They’re very convincing and will certainly work.
    Still, the posts are too brief for starters.
    May you please prolong them a bit from subsequent time?

    Thanks for the post.

  18. Depending on the type of care a person chooses, there may be risks
    in using certain complementary or alternative treatments.

  19. I think the admin of this website is truly working hard in support of his web page,
    because here every data is quality based stuff.

  20. Why users still use to read news papers when in this technological world all is existing
    on web?

  21. bs tbs ??? says:

    ????????????????????????
    ???????????????????????????????
    AKB?CD???????????????????????????

    How To Find A Good Massage Therapist ‘ 5 Answers Any Good Therapist
    Should Know. Look for chapters on various kinds of writing for example travel,
    humor and business writing. bs tbs ??? ???? ??? ???? Your final
    rating must be a recommendation to readers whether should buy the game, rent it only, or maybe plain forget about it.
    Essays ought to be a great little bit of information devoid of the grammatical errors with regards
    to punctuations, right purposes about strained,
    nouns, adjectives yet others.

  22. Professional and singer Patrick Bruel ended up being
    one among France’s biggest stars over the ’90s, first making their name being a teen idol
    and leading a return to traditional French chanson from the new millennium.

    Bruel was created Patrick Benguigui inside Tlemcen, Algeria, on,
    may 14, 1959. The father abandoned the family when Patrick was a year old, in addition to 1962, after Algeria acquired its independence, his mother moved to
    France, settling inside Paris suburb regarding Argenteuil.
    A fine soccer player in the youth, Patrick first
    decided upon the idea of being artist having seen Michel Sardou perform in 1975.

    As good fortune could have it, acting would bring him his first achievement;
    first-time overseer Alexandre Arcady ran an advertisement seeking a man using a French-Algerian (or “pied-noir” in German slang) accent for his video Le Coup dom Sirocco.

    Benguigui (as he was still called) responded and
    won the business. The year, he spent a in New york, where he met Gérard Presgurvic,
    later to get his primary songwriter.

    Source: http://www.tanveersoft.com/mobilego-android-free-3-3-0-23-full-version/

  23. Cuba News says:

    Superb blog! Do you have any suggestions for aspiring writers?
    I’m hoping to start my own website soon but I’m a little lost on everything.
    Would you advise starting with a free platform like WordPress or
    go for a paid option? There are so many options out
    there that I’m completely confused .. Any suggestions? Many thanks!

  24. Aracely says:

    I am in fact thankful to the holder of thjs website who has shared this impressive article at at this place.

    My page – roc lake (Aracely)

  25. dmv pa says:

    What’s up, this weekend is fastidious in favor of me, since
    this occasion i am reading this enormous educational piece of writing here at my residence.

  26. pbrowery.pl says:

    Drobiazgowe teksty, dobra tematyka

    My site pbrowery.pl

  27. tan says:

    Only use those that have a color guide, which will help you
    see where you applied the lotion. New to the market is a Bikini Thief St Barts tankini in a
    two piece. Why bother to spend tens of thousands of dollars, after all, on something you
    may only need to use for a limited time.

    My weblog tan

  28. Now I am going away to do my breakfast, after having my breakfast coming over
    again to read additional news.

  29. I have fun with, cause I found just what I used to be looking for.
    You have ended my four day lengthy hunt! God Bless you man. Have a nice day.
    Bye

    My weblog convergys jobs philippines

  30. whoah this weblog is excellent i like reading your posts.
    Keep up the good work! You know, lots of persons are hunting round for this information, you could aid them
    greatly.

  31. brief says:

    Best Feature: Wi-Fi Internet Connectivity available virtually anywhere inside the USA – while for the move.

    a) Turn in your computer and, once it’s thrilled, click ‘Network Places’ to find every one of
    the available Wi-Fi internet networks in that location.

    If you might be not fortunate enough to possess Froyo or simply want the ability to wirelessly tether over Wi-Fi or Bluetooth,
    this is the app to suit your needs (provided you happen to be
    rooted). One thing that peaks many people’s interest is learning how
    to turn off Wi-Fi over a PC. Wifi extender netgear price But
    the things have changed now; cell phones with Wi-Fi feature are
    actually a ruler of mobile internet.

    Articles work to suit your needs 24-7 Once a piece of writing is up, it will keep working
    to suit your needs as long because it remains in cyberspace.

    This usually created by agency staff who project the
    quantity and types of staff needed and also have already established salary rates and benefit packages for anyone
    staff. Netgear wifi extender dropping connection brief
    Possible consequences of not served in the correct script
    too and quite depressing. Only the future will tell what this
    easy furniture will look just like a century from now.

  32. Michel says:

    Awesome website you have here but I was curious if you knew of any community forums that cover the same topics talked
    about here? I’d really like tto bee a part of
    group where Ican get comments from other experienced individuals that share the same interest.

    If you have any recommendations, please let
    mme know. Cheers!

  33. Hello to every , since I am really eager of reading
    this website’s post to be updated daily. It includes pleasant data.

  34. Nancee says:

    A fascinating discussion is definitely worth comment.
    I think that you should publish more on this topic, it may not be a taboo matter but generally people do not talk
    about such issues. To the next! Best wishes!!

  35. Nichole says:

    Another popular bundle is the Xbox 360 Ultimate bundle.
    spends, though interestingly Japan also comes in second with regards to connection speed.
    Of course there is much more to the LG Optimus 7 than just the operating
    system.

    My blog: microsoft point gratuit xbox 360 (Nichole)

  36. Wake up now says:

    Good day very nice blog!! Guy .. Excellent .. Wonderful ..
    I’ll bookmark your web site and take the feeds also?
    I’m satisfied to find a lot of useful information here within the publish, we
    want work out more techniques on this regard, thanks
    for sharing. . . . . .

  37. methodist says:

    I like the valuable information you provide for your articles.

    I’ll bookmark your weblog and test again here frequently.
    I am moderately sure I will be informed many new stuff right right here!
    Best of luck for the following!

Add a Comment