Installing WordPress on Windows Server 2012 R2 and MS SQL 2012 R2 Express


Has anybody successfully installed WordPress on Windows Server 2012 and MS SQL 2012 R2 Express? I've tried using a collection of tutorials that I've gathered from forums and YouTube. I was able to set it up and ran the installation. WordPress installed the tables in MS SQL but that was pretty much it. I couldn't log into the admin console, it seemed like it only installed partially. I'm curious if anyone has done it successfully. If so, how were you able to do it. It seemed like there's a permission issue but I used an 'sa' account during the WordPress install configuration.

Thank you!
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Zephyr ICTCloud ArchitectCommented:
In very straightforward words, usually people install Wamp on the server, copy the Wordpress files in the correct folder (usually under www) configure the wp-config.php file with the correct settings for the database and such.

You can create a separate db of course, like you did.

Now, disclaimer, I'm not one to install Wordpress on Windows servers, but just wanted to give you the way I know a lot of people that do, do it.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
David Johnson, CD, MVPOwnerCommented:
I've not had success using SQL Server (any version)  and use MYSQL instead and once you have php configured it works ok.
petaganayrAuthor Commented:
The easiest way to install WordPress on Windows Server 2012R2, I found out, is by using the Microsoft Web Platform Installer (WPI) but it installs it over MySQL. The whole process is automated, I like it. I am just curious if anyone has installed it on Server 2012 R2 and SQL Express 2012 R2 successfully. A few post on the Internet claim that it can be done. It's been a headache so far.

Anyway, I'll keep this post open for a while in case someone has done this successfully. Thank you all!
petaganayrAuthor Commented:
Thank you for the comments. I'm sorry that it took forever for me to do this.

Installing WordPress on Windows Server 2012 R2 and MS SQL 2012 R2 Express is very difficult to do, and I couldn't get it to work properly 100%. I'd like to share this information.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today

From novice to tech pro — start learning today.