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

  1. No matter if some one searches for his essential thing, so he/she wants to be available that in detail, thus that thing
    is maintained over here.

  2. Hello,Nice to see tuis site up
    If you need to buyy a cccam premium subscription i reccomend cccamcloud(dot)com
    Ithink they are the only ones who sttill provide HD channels

    Allso visit my blog: http://cccamcloud.com/

  3. HELLO MONO usually some form of initiative relating to Creative Outlet Hogan and Art Director Wojtek Szklarski aka Finemaker. Wojtek has an all in one broad experience on the design; has created more and more artworks and for many local and international rest room.You can adjust to Hello Mono’s have

  4. Hi to every one, it’s actually a nice for me to visit this web page, it consists of helpful
    Information.

    My page :: major search engines

  5. lotto says:

    Niezwykle spojrzenie na historie, kazdy powinien przeczytac i zaznajomic sie z tematem.

    Feel free to surf to my site lotto

  6. Dian says:

    of knights, kings and queens or maybe a medieval fortified
    palace with a mote. Fraser Island beach houses are the
    perfect location to get a view of all the beaches
    surrounding the house. Thereafter, you approached that lesson on a different plane.

  7. Link exchange is nothing else however it is only
    placing the other person’s webpage link on your page at suitable place and
    other person will also do same for you.

  8. Hi, this weekend is good in favor of me, because this
    moment i am reading this impressive informative paragraph here at my residence.

    Here is my weblog … download music from youtube to computer

  9. Not everyone will be equally keen in investing
    their time with you, move on to others when you
    gets the hint from their body language. Kompas geologi BRUNTON 5008, 5006, 5010, Kompas
    SUUNTO. Apparently, the benefits of fruits can also help a diet program.

  10. Kourtney says:

    Valuable information. Fortunate me I found your website by accident, and
    I am shocked why this coincidence didn’t took place in advance!
    I bookmarked it.

    Stop by my homepage e cigarette jokes – Kourtney,

  11. Actually no matter if someone doesn’t know after that
    its up to other people that they will help, so here it
    occurs.

  12. Some great benefits of Softwood Casement Home windows

    There are many different Window Installation cincinnati Ohio possibilities, whether you’re in the process
    of making a brand new home otherwise you need windows for the existing home.

    Besides different styles, such as casement
    windows, double hung and sash, but additionally, there are a wide choice of materials from hard or soft wood to
    PVC, aluminium and more.

  13. kizi says:

    Remarkable things here. I’m very glad to peer your article.
    Thank you so much and I am having a look forward to touch you.
    Will you kindly drop me a mail?

  14. I know this website offers quality depending articles and additional
    information, is there any other website which offers such things in quality?

    My web-site: http://Catcamera.net/

  15. Zak says:

    Nice blog! Is your theme custom made or did you download it
    from somewhere? A theme like yours with a few simple tweeks would really make my blog jump out.
    Please let me know where you got your design. Bless you

  16. ???? ·? ???? ??????????? isn’t ???? ?????????????????? ? ?????????? ??????????????????????????????????????????????????????????????????????? ?????
    ??: ?????? ?? (http://www.tory-burcnja.jp)

  17. Why not team up with your canine friend and get a dress that matches your
    theme. Be patient, however, with dogs that aren’t used to wearing boots as such may take some time for them to get used to.
    Getting everything started can be a daunting
    task the feels overwhelming, but if you stick to it, then you will
    be rewarded in the end.

    My blog :: small dog clothes (http://lnwlilla.buzznet.com)

  18. I’ve read some excellent stuff here. Certainly price bookmarking for revisiting.
    I wonder how so much effort you set to make this sort of fantastic informative website.

  19. Mauricio says:

    One of the top rules of real estate investing before deciding what to buy is to indentify whom you are dealing with.
    Stay tuned forr more articles on Virtual Real Estate, internet real estate investing and this revolutionary new platform.
    If the investor qickly gives a discount, that’s when you will know
    how flexible he can be.

    Review my site; small business administration; Mauricio,

  20. 1 fellow was affected by tinnitus after a bullet struck this man in the helmet during the latest situations
    with the terrorist state and now he could be fully cured
    from buzzing in the ears after many years of being struck with tinnitus.

    You only need to follow some homemade practices which can help you in stopping your tinnitus.
    You will want to give this herb various weeks to do its function.

    my homepage pulsatile tinnitus fluid in ear

  21. I absolutely love your blog and find many of your post’s to be precisely what I’m looking for.
    can you offer guest writers to write content for
    you? I wouldn’t mind producing a post or elaborating
    on most of the subjects you write related to here.
    Again, awesome web log!

    my web page … ???? ????? ???????? ?????

  22. I’m gone to inform my little brother, that he should
    also go to see this website on regular basis to obtain updated from
    hottest news.

    Feel free to surf to my website … best personal injury attorneys

  23. It is strongly recommended that agents provide
    each client with a package prior to the actual listing
    appointment. Starting a new business can be a thrilling experience but demands a painstaking attention to
    detail. Getting listed with a good online business directory boosts the chances of
    being found out by people looking exactly for your kind of services and products.

  24. In this day and age it is widely accepted that one may use contemporary
    styling in order to achieve a desired finish. Don’t misunderstand this to mean that if you have a large
    yard you can’t have smaller features or garden decor.
    Having a strong background in construction and horticulture allow these spaces to become a reality.

    Feel free to surf to my blog post; landscape gardener cornwall [http://www.45so.com/member/space.php?uid=62335&do=blog&id=59580]

  25. Perhaps you had a fragmented family and never experienced
    consistency in your early years. With all the dueling monologues,
    there is no dialogue. Learn to be aware of your intuition, and you will get better over time.

  26. Lionel says:

    Již dál? necekejte, kontakty se sexy partnery jsou na
    dosah ruky. Pro nás, jakožt? seznamovací stránku, ?e prioritou najít vám sexy partnera
    k ?aší plné spokojenosti, ? zprostredkovat vám kontakty
    dle vašich predstav. Již dál? necekejte, žhavé schuzky se sexy partnery
    jsou na dosahh ruky.

  27. I know this site gives quality based articles and additional information, is there any other
    site which gives these kinds of information in quality?

  28. My partner and I stumbled over here different web page and
    thought I might as well check things out. I like what I see so i am
    just following you. Look forward to exploring your web page repeatedly.

  29. Duck in and out of cover until it’s clear, then move up to
    a display case. This may include operating process, budgets, extra services offered,
    experienced staff, storage facilities, pet care etc.

    He’ll need to know what’s up with you, but will be unable to call
    you without giving away his feelings.

    Feel free to visit my web site … storage companies in chelsea ma

  30. Helko there! I know this iis somewhat ooff topic
    but I was wondering if you knew where I could get a captcha plugin for my comment form?

    I’m using the same blog platform as yours and I’m having
    trouble finding one? Thanks a lot!

  31. The benefits of Softwood Casement Home windows

    There are numerous different Sliding Glass Doors Installation Akron Ohio possibilities, whether you’re in the
    process of making a fresh home or perhaps you need windows for your existing home.

    Apart from variations, like casement windows,
    double hung and sash, but you can also get
    lots of materials from hard or soft wood to PVC, aluminium and more.

  32. According to a 12th century Wicca spell and potion book, candle wax was believed to help regrow hair.
    Olive oil is absolutely wonderful and unfortunately overlooked as a fantastic,
    effective hair growth treatment. I didn’t like it but I learned to live with it
    ‘ until many years later (at age 32) my hair started
    falling out by the handfuls.

    Feel free to visit my blog post; natural hair growth products that work

  33. Hi to all, how is everything, I think every
    one is getting more from this website, and your views are
    good designed for new viewers.

  34. I was curious if you ever thought of changing the page layout of your site?
    Its very well written; I love what youve got to say.
    But maybe you could a little more in the way of content so people
    could connect with it better. Youve got an awful lot of text for
    only having one or two pictures. Maybe you could space it out better?

    Here is my homepage: frank Kern products; http://training.tonyrobbins.com/Interview-with-frank-kern-and-john-reese-2,

  35. Undeniably believe that which you said.
    Your favorite justification seemed to be on the net the easiest thing to
    be aware of. I say to you, I certainly get annoyed while people think about worries that they plainly
    don’t know about. You managed to hit the nail upon the top as well as defined
    out the whole thing without having side effect , people could take a signal.
    Will probably be back to get more. Thanks

  36. If you got to be so concerned he came into marketing the need
    for your sales language. It s a lot of value for a three-day stay at the
    last few years, with bouncy Sofia Vergara hair.
    On Sina Weibo, a house. 3 million for those functions, although it continued
    to gain new powers to do really well, including color and made shopping simpler, more consistent.

    He was the first two pages? Rick Perry’s letter to the URL.

    my page; sales transformation consultants

  37. The agency has their office at Dhaula Kuan I, Delhi Cantonment, New Delhi.
    There are a variety of different shipping services
    and options available, so you should shop around to find
    a service that is both affordable and timely. If you want to create your
    own package, here are some items you should include in order for it to
    be most effective and save you time.

  38. If you desire to grow your familiarity just keep visiting this web page and be updated with the
    newest gossip posted here.

  39. If sleep is posing a challenge for you now and you do not intend to pop in sleeping pills, you need to spend nights counting stars, as there are numerous ways that can help you with
    ideas on ‘How to Get to Sleep’. Inflating a balloon is also considered as a throat exercise and should be done five times to effectively strengthen the muscle.
    ZOLOFT not bothered serotonin reuptake inhibitor (SSRI) accredited by the FDA to take care
    of within adults Major Depressive Dysfunction (MDD), Obsessive-Compulsive Disorder (OCD),
    Social anxiety disorder, Posttraumatic Tension Disorder (PTSD), Premenstrual Dysphoric Disorder (PMDD),
    as well as Social Anxiety disorder.

  40. Asthma turens ouut to be comprised of several types and it’s also important foor doctors precisely to assess and diagnosse of
    the type of asthma their patient is suffering from. Your doctor might
    increase the medication until your sickness gets better.
    It can also help to control thee progression and severity of
    the disease.

    my blog … free website analytics tool

  41. I’m not one to lay our a fortune on maternity
    put on. My costs on all maternity clothing is simply improbable!

  42. Thanks in support of sharing such a nice thinking, post is fastidious, thats why i have read it
    completely

    My weblog :: best weight loss supplement for women

  43. Linwood says:

    I’m amazed, I must say. Rarely do I come across a blog that’s both equally educative and amusing, and let me
    tell you, you’ve hit the nail on the head. The problem is something that not enough folks are speaking intelligently about.

    I am very happy I stumbled across this during my search for
    something relating to this.

Add a Comment