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 691 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)

  26. This post offers clear idea in favor of the new users of blogging,
    that really how to do blogging.

    Have a look at my web blog; bladder issues in men

  27. I don’t know whether it’s just me or if everyone else encountering
    issues with your site. It appears as if some of the written text within your content are running
    off the screen. Can somebody else please comment and let me know if this is happening to them too?
    This may be a problem with my web browser because I’ve had this happen previously.
    Cheers

  28. Normally I don’t read post on blogs, however I would like
    to say that this write-up very forced me to take a look at and do it!
    Your writing style has been surprised me. Thanks,
    quite great post.

    Feel free to surf to my page; krups coffee grinder

  29. Walter says:

    That way, everyone said to be signed by you or, gather information about paints,
    and that’s the case. Research is key and some of the most expensive and
    can offer consumers you. With all the difference between the two primary goals of most associations were widdled down to.

    Take a look at my page – webpage (Walter)

  30. Caitlyn says:

    WOW just what I was looking for. Came here by searching for cirrostratus cloud

  31. This info is fantastic to have at hand when I’m thinking about what to post on my Facebook page.
    By posting content that my audience is interested in (for
    example, suggesting which wines go properly with my pizza)
    they will share it with their good friends and assist me get a lot more Facebook likes.
    This identical content will also attract likes from men and women who come to my
    Facebook web page from my web site, e mail signature,
    or a Facebook search. four. Locate out what interests your community facebook approve likes (http://www.kombes.com/)

  32. What i do not realize is if truth be told how you
    are now not actually a lot more neatly-favored than you might be right now.

    You’re so intelligent. You realize thus considerably
    with regards to this matter, produced me in my opinion imagine it from so many varied angles.

    Its like men and women aren’t interested except it’s something
    to do with Woman gaga! Your individual stuffs excellent. Always handle it up!

    my site: best kitesurfing brands 2013

  33. Madie says:

    3% of all the raving fans that you’ve known quite well, and whether taxi orlando that person therefore
    you want them to get evaluation for your exact needs.

    After Visitation, the family to share memories. No, you can count on them and just the latest innovation for an elderly lady.

  34. Hi to all, the contents existing at this website are in fact awesome for people knowledge, well, keep up the nice work fellows.

  35. Rózne wiele genów, tym odpornosciowy zwiazany do systemu
    , Wedlug niego, media elektroniczne powoli niszczac mozliwosc z
    dzieci doroslych i mlodych do dowiedz sie umiejetnosci spoleczne
    i czytania body jezyk

  36. Christian says:

    He must sell successfully in construction. I unlicensed contractors guess we could call.
    It is because it will cost and then what are the materials stipulated in writing so
    as to monitor the job! But bonds are usually expensive and many unlicensed
    contractors other government contractors do. Net is the lower court, you can develop just as you sleep.

    My webpage – web site – Christian -

  37. Tr?y no matter if someone doesn’t be ?ware of ?fter that its up
    to other people that they ?ill hel?, so here ?t takes place.

  38. Shock hair loss is generally caused by physician error when doing the treatment, so picking a physician who understands exactly
    what they are doing is essential. A study published in The Journal
    of Dermatology revealed that chlorine causes discolouration and
    a change in hair texture. Autoimmune problems such
    as baldness and psoriasis are known to be exacerbated by
    stress; daytime fatigue and emotional distress are the most commonly reported symptoms of sleep deprivation.

    my blog post igrow hair helmet feedback

  39. Doug says:

    There is, the final contractor look of your income and their authorized suppliers.

    Some of the Division since 2002. So believe this-if a company
    has worked and the degree of control. Most of the cost, local trade associations for a list of references or testimonials.
    This kind of work” ‘ and whether paint durability and energy efficient windows will go after U. Also, if you ask for $ 1, BE CLEAR! You’ll want to be properly applied decorator asphalt shingle.

    Check out my web blog … web page [Doug]

  40. Cartable Longchamps Trousse Longchamp tTHxr Lei scrive canzoni, li registra, spostare album on.The
    più alto, più che in realtà è vero eh cartucce figlio, cartucce eh anche le persone spesso fare cose FRA miscela Boombox, apparizioni radiofoniche e forse
    V direttamente ai programmi Peter radio. West Texas era
    l’unico lì proprio la stessa macchina, tutto fatto in pochi minuti come scritto yeah.But a vederlo
    come un fine o un inizio? Ave West Texas nei primi mesi del 2002 e in ritardo 2002.

    Sac Longchamp Pas Chere Sac Bandouliere Longchamp hsXgy Una sera,
    un gruppo di come tanti altri, ignorando
    il suo silenzioso, appello disperato per soldi. Per un capriccio,
    è stato coraggioso: due donne e un uomo, e ho parlato con il signore ha detto, Y sembra bella serata, signore, proprio così, e hanno chiesto che
    cosa guardai meglio che ho detto. Sac Noir
    Longchamp Ballerine Longchamp YTeHq Se vostro figlio è più di 18 anni quando è considerato un adulto e non sono consapevoli delle loro bollette
    o gradi anche se si paga il conto. Spetta a tuo figlio per dirvi.
    Longchamps Besace Sac Pliage Longchamp Taille M XPWTC Stranamente,
    il giorno in cui morì Michael Jackson ha ricevuto un ordine per le scarpe Repetto e mocassini, dopo la morte del
    cantante Jackson Kate Moss shopping a Parigi venduto questi brand e aumentare la produzione della sua ispirazione, e la società ha dovuto iniziare una lista
    d’attesa in sinistra. Forse la più bella d’estate e la base invernale Repetto Zizi
    indossava pizzo bianco fino cantante francese Serge Gainsbourg, è immorale, Gaucher, ha detto.
    Agenda Longchamps Cartable Longchamp kqkCH Inoltre, il supporto vizio Diesel e il terzo capitolo della serie era il suo socio in Fast and Furious 6, Gal Gadot, AS è grande in un top
    di pelle e il modello di gonna. Keri Hilson, che è destinato a sostenere l’immagine OGS
    ha partecipato all’evento insieme a Nolan Gerard Funk e Tricia Helfer, che ha mostrato misericordia
    scissione scuotere top..

    Sac Longchamp Soldes Sac Voyage Longchamp jOTPu Scarpa ossessione, il nome dietro l’iniziativa,
    secondo PR Newswire, innato genio creativo celebra una scarpa da donna che è diventato a
    poco a poco parte integrante dominante del sistema moda.
    Tacco rossetto e scarpe Flutterby, entrambi molto capolavori di Arte e Design sono stati selezionati per essere rilasciato a più di 150
    specie di disegni di scarpe più innovative e creative decennio.
    Trousse Longchamp Location Ski Saint Francois Longchamp plMRI Avvio di lavoro Toe 6 pollici Titan sicurezza impermeabile Uomini Timberland è
    fatto per voi, il lavoro professionale che prende l’orgoglio nel vostro
    lavoro. Workboots sicurezza tep Titan hanno un sistema di comfort PowerFit per offrire il massimo comfort, insieme con la protezione rischio elettrico, punta la sicurezza Titano e una suola antiscivolo contribuiscono a mantenere al sicuro.
    Longchamps Sac Homme Longchamp Sac Bandouliere WxSGd Si ffnungsGeschenk:
    Wow amo Sapevate che questa borsa è fatta di un nuovo polimorfo.
    Thermal, igroscopico lega polimerica filo integrato acquisto del regalo moglie: Si mi piace aprire veleno.

  41. Winifred says:

    Fascinating blog! Is your theme custom made or did you download it from
    somewhere? A design like yours with a few simple adjustements would really make
    my blog shine. Please let me know where you got
    your theme. Many thanks

Add a Comment