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

  1. Torsten says:

    Sucking those things up can improve your allergies and make your home a cleaner place.
    German roaches are smaller and come into your house in other ways.
    Roaches can obtain a meal virtually anywhere and most households
    give you a very good variety of drinking water sources.

  2. Latoya says:

    They refugee in thhe small spaces, cracks and fissures found in any wall, roofing
    or kitchen cabinets. Roaches love to be in tight confined spaces, so even if the clutter is from paper, boxes, books, or anything else, ther is
    something for the roaches to feed on and live nicely.
    Save any left over paste in an air tight container and refrigerate.

  3. These all are part of SAP enterprise suite, SAP enterprise by design is in software as
    service model for providing hosted ERP solution to
    its purchasers.

  4. Moderately the enticing feminine Leprechaun outfit normally centres
    round a green mini-dress with some type of shamrock theme.

  5. The German cockroach is the molst comjmon type and is found all over the US.
    ” Ex means out of, and “terminus”in Latin meanns boundary or end. When cockroaches reach a serious infestation it is always best to contact a local Peest Control complany to help deal with and to kill off the cockroaches.

  6. German cockroaches can survive only 12 days with food but no water.
    More than any other prst – including ants, mosquitoes, or even spiders – cockroaches are heavily regarded as the lowest of low among home-invading pests.

    If you have cockroaches in the empties, you have to be careful.

  7. Corn meal in dog-food is just a targeted way to obtain protein that may be substituted for protein that is costlier animal.

  8. This dust works at a level that makes human size once again an advantage: the dust is mildly acrid or annoying to a human, but to a small insect it is toxic.
    So simply laying out some borax laced roach bait in those areas should do the trick.
    t set up nests in these areas, which will only lead to infestation.

  9. A go to to Turkey would be a great alternative to buy among the best handicrafts on the planet, at extraordinarily affordable prices.

  10. If you are allergic to pollen or dust, then you should find
    the personal air ionizer which actively works against these agents.

  11. I really loke looking through a post that will make people think.
    Also, thank you for permitting me to comment!

  12. Right here is the right website forr anybody who wishes to understand this topic.
    You realize sso much its alost hard tto argue with you (not that I perxonally will need
    to…HaHa). You definitely put a brad nnew spin on a topic that has been discussed for decades.

    Great stuff, ust wonderful!

  13. This kind of internet site is wonderful for people or those company who do not have any net formula abilities.

  14. I was very pleased to find this web site. I need to to thank you foor ones tiime for
    this fantastic read!! I definitely appreciated every litte bit of it and i also
    have you book-marked to see new stuff in your blog.

  15. Lachlan says:

    How about this vehicle but find lien it here again, flip up the perfect
    fit. The piees can be a tall glass of ice
    is onn thhe rise and on. As well as aerodynamic
    fairing. There are available in the cost effective.

    Feel freee to surf to my web-site … ici (Lachlan)

  16. Every time you may search to stay with a program for that time that it
    takes, you may expect to see positive aspects by your power.

  17. Once you get your quote from the timeshare firm then you too
    can contemplate promoting it to them or on the Web.

  18. Water is the most important factor in cockroach survival.
    Cockroaches can thrive and multiply from eating the glue
    from these types of furniture. Theey also depart tiny roach
    droppings and small roaches urine on best of the waste they don’t seem to care that they will be
    eating it later outside.

  19. The common man or woman can make delightful, homemade bread quite simply with
    a bread maker. Bread can be used to bind some of the most effective modern carp
    and catfish stimulators and attractors and liquids known today which is why I find it exceptionally effective.

    Make your appliances work for you, and not the
    other way around.

  20. Since its inception, a prepaid legel service plan has gained a whole lot of essential acclaim because of the number of benefits offered by these
    services.

  21. Oolong tea’s oxidation ranges from 10% to 70%,
    somewhere between ggreen tea and black tea.
    Oolong teas aree produced from tea leaves that have been allowed to oxidize for a limited
    time, only until they attain thhe desired color, but not complete oxidation. There have been studies on green tea which shopw that LDL is prevented from oxidizing and therefore doesn’t turn into the dreaded plaque.

    Feel free tto visit my webpage … gwenhinsonunwey.Wordpress.com

  22. Auto immune illnesses will be prevented if lectins are averted and
    if the particular person sticks to healthy meals with the paleo
    weight loss plan.

  23. I also learned that he lived with his elderly mother in a great thatched roof house that I had passed by less than a kilometer back.
    The Warren-Newport Public Library up in Gurnee will
    be closed on Monday. ” Or so I kept on trying to tell myself, but I still felt depressed.

  24. If some one wants expert view concerning blogging then i advise
    him/her to visit this website, Keep up the pleasant
    work.

  25. ask says:

    May I just say what a relief to discover somebody who really knows what
    they are discussing over the internet. You actually know how to bring
    an issue to light and make it important. A lot more people
    need to look at this and understand this side of your story.

    I was surprised you are not more popular because you definitely
    possess the gift.

  26. Thanks to notes of passion fruit and citrus and a high
    alpha acid level, this versatile hop is great as a
    late addition in the brewing process. Some people will even look for whacky items that will
    pep up the gathering. So the next time someone looks down their nose at you for the
    stories that you tell about the night before and the beer
    that you drank.

  27. youtube.com says:

    As the styles are plenty in number every man can try out different style of wear.
    You must surely take a look at answers throughout the option on-line two.

    Yes even Miss perfect size 10 who feels too pale, or conscious
    of those wobbly bits.

  28. scotch rocks says:

    There is definately a lot to know about this subject.

    I really like all of the points you have made.

  29. The steel entire body of the auto is always worth one thing, even if it is getting scrapped.
    One can very easily find various junk removal companies.
    You can call your Attorney General’s office to find
    out the state of limitations in your own state.

  30. It’s a region of a unique appearance; it appears like a bird with wings that are stretched, the language is Croatian.

  31. After making an attempt a career in specialist baseball, Michael returned
    to the NBA and right away became the dominating presence that he had been just before he retired.
    These problems are universal and as a solution to it
    many companies have started manufacturing dog shoes. Dorsiflexion (Pointing your foot upwards towards the shin).

  32. Living Room says:

    I am sure this article has touched alll the internet visitors,
    its really really fastidious article on building up new
    webb site.

  33. Right here is the perfect blog for anyone who would like to find out
    about this topic. You understand a whole lot its almost tough to
    argue with you (not that I personally will need to…HaHa).
    You definitely put a new spin on a topic which has been discussed for a long time.
    Excellent stuff, just wonderful!

  34. Michal says:

    Simply wish to say your article is as amazing.
    The clarity in your post is juyst great and i could assume you are an expert on this subject.

    Fine with your permission let me to grab your feed to keep updated with forthcoming post.
    Thanks a million and please carry onn tthe rewardiing
    work.

    Check out myy blog post filmy erotyczne (Michal)

  35. At this time I am going to do my breakfast, afterward having my breakfast coming over again to read more news.

  36. A latest study found that the technicians could possibly certainl not as fun and easy to
    slide from left to be said that they might simply want a video of that out.

    Accessories for your iPhone 6 Plus displays more than 90% of thhe phone are sturdy and as a partner whho is constantly buzzing, beeping, and mobile operating systems tto be a delay or cancellation. Craft mobile is
    the mobile phone Windows iphone 6 cover has added starts to its own.

    Feel free to surf tto my website :: tough iPhone 6 cases

  37. En partant de cette hypothèse, l’éventualité de voir son habitation saccagée ou
    son car dégradée ou brulée serait décuplé.

  38. Greate article. Keep posting such kind of info
    on your site. Im really impressed by it.
    Hi there, You’ve done an excellent job. I will definitely digg it and personally
    recommend to my friends. I’msure they will be benefited from this
    weeb site.

  39. Kathrin says:

    Some studies say yes,other folks no. Some believe coconut oil since itt is a saturated vegetable fat raises LDL cholesterol.

    Also visit mmy homepage: coconut oil recipes food neteork (Kathrin)

  40. Janine says:

    For your lengthiest time, I have involved in rigorous work outs continually pushing me personally to the restricts to get my ideal weight.
    That’s things i do today to remain healthy. But my pounds
    issue was nonetheless a problem mainly because each time I’m accomplished working out, In addition, i consume a lot to make
    up the electricity I dropped. Doesn’t make sense.
    I essential one thing to support me stop eating a great deal
    of nevertheless i also don’t like the idea of ravenous me.

    And PhenElite weight loss pills just have the job.
    It suppressed my hunger for foods with out this feeling of starving personally.
    I started with all the tablet 3 months in the past using 2 supplements a half-hour prior to lunch time.
    I usually have really good lunch daily meals. But what designed
    the main difference was after my exercise routine, I not
    any longer binged for food items. I will final the night time with 2 crackers and a window of whole milk.
    No more evening hefty dishes. And after 21 times with the schedule, I shed 17 pounds so i decreased from the 32 pant measurement to 29.
    I’ve never ever experienced slimmer such as this prior to, this all in 3 months, couldn’t require additional!

  41. Thad says:

    The particular beep sound an individual seen is not a significant issue nonetheless
    it could potentially cause your PS3 never to work
    properly. “And since apparently users won’t even need a hardware mod-chip to experiment with pirated games, I do not feel that Sony will even detect which users to lock out from PSN. Some_text_are_here if Final Fantasy XIV Online with time limits of PS3-holdings – unknown.

  42. Hi to all, for the reason that I am in fact eager of reading this website’s post
    to be updated on a regular basis. It includes fastidious stuff.

  43. Attractive component t? content. I simply stumbled ?pon your weeb site ?nd
    in accession capital t? claim th?t I acquire act?ally loved account youjr blog posts.
    ?nyway ?’ll be subscribing t? your feeds and even I success ??u get entry to
    persistently ?uickly.

    Review m? web blog Estella Bartlett

  44. I think you have produced several truly fascinating points. Not too many others would really think about this the way you just did. I am very impressed that there is so much about this subject that has been revealed and you made it so nicely, with so considerably class. Brilliant one, man! Very special things right here.

  45. Fysioterapi says:

    I am actually pleased to glance at this website posts which contains plenty of valuable information, thanks for providing such statistics.

  46. Bryan says:

    Así, el jugador lo que recibe son las ventajas generados por esa apuesta gratis que utilice en el caso de que acierte.

Add a Comment