WordPress and SQL Server

By default WordPress uses the MySQL database. MySQL can reside on the same server as MSSQL. Also, the SQL syntax used by WordPress is specific to MySQL. You have to go through each SQL statement in WordPress core and change it to the MSSQL. Even then you will not be assured at the behaviour will be the same.

How I can install the wordpress with SQL Server Database 2012.

Short answer: You can’t. SQL Server Database 2012 is not compatible with WordPress and cannot be used. See the requirement pages

https://www.ads-software.com/about/requirements/

Longer answer: It might be technically possible but it would not be supported. You would be guaranteed to have crippling debilitating pain and suffering as a result. ??

For installing on Windows give this a read as a start.

https://codex.www.ads-software.com/Installing_WordPress#WAMP

I think, you can find some articles how this was achieved. I have found this one. Please, let us know your feedback on this. Thank you.

https://blog.building-blocks.com/technical-tips/installing-wordpress-on-windows-using-sql-server-2008-r2-part-1

https://blog.building-blocks.com/technical-tips/installing-wordpress-on-windows-using-sql-server-2008-r2-part-2

Also you might follow and do some fixes yourselves with the plugin you need for this? https://www.ads-software.com/support/plugin/wordpress-database-abstraction

I’ve been asked this question before and the reason was they wanted WordPress on a Windows Server or something along those lines.

If you’re stuck on a Windows environment try using XAMPP / Virtualbox w/ a flavour of linux (ubuntu or something similar).

Using WordPress with in a LAMP environment is a lot easier than anything Windows has to offer by default

I have just managed to install wordpress on SQL Server with instructions above… still need to test it properly