I know that this has been asked in the past, but is it now possible to use Wordpress with SQL Server? I've already got a SQL Server on my account, so don't really want to have to get a MySQL as well. It appears that since this question was last asked that new bits of technology have become available, such as these: Microsoft Drivers for PHP for SQL Server: http://www.microsoft.com/en-gb/download/details.aspx?id=20098 And here it explains how to install Wordpress on SQL Server: http://wordpress.visitmix.com/development/installing-wordpress-on-sql-server#prerequisites Does anyone have Wordpress running on DiscountAsp.net with SQLServer? Cheers, Steve
The php drivers for SQL are on the servers, but there's no easy way to get standard WordPress to use SQL. You have to download a special build and I don't know how well that's maintained or how often it's updated. Which is a bit of a concern, since WordPress does a lot of security updates. So you can do it, but it's certainly a lot easier to use MySQL and the default WordPress download. We run the Everleap blog on Windows/IIS, but we still use MySQL for the back end. The instructions you linked to seem to be for a SQL Express database, which isn't something we support (Microsoft doesn't recommend supporting it in a shared environment).
Thanks for getting back to me so quickly. Given your reply, it looks like there's nothing for it but to get a MySQL account in addition to the SQL Server one I have already. I suppose this at least keeps the blogging part separate from my main site, which might have some advantages. Thanks again, Steve
