We are looking for a contemporary looking theme (like Avada or Envato) that is compatible with MSSQL.
Could you please give me some recommendations?
This is not really a theme question. WordPress itself isn’t really compatible with MSSQL (without a LOT of tinkering).
Hi, correct me if I’m wrong, but MSSQL is a database engine, not a CMS or blogging software designed so to serve html content to the website visitors?
As such there needs to be something playing together with MSSQL to make it work? If you will program it yourself any site template will do, but programmers are required. If you want to use WordPress there is no stable solution. If you want to try other CMS there are potential solutions for drupal, joomla and concrete5, maybe others in eCommerce category – but double check before buing anything!
Joomla supports MSSQL, you should look for a Joomla template and start from there
This may be of use:http://wordpress.visitmix.com/development/installing-wordpress-on-sql-server
Thanks, kops. I believe this is the guide our IT used to set up the Windows server 2012. Initially WP seemed to be working fine, until we installed the Avada premium theme. Right away there were some issues and scripts not working properly. So I contacted the developers of the theme and provided them with the pho error log. Their reply was:
“I didn’t realize that you are running a port of Wordpress using MS SQL Server. Unfortunately, that is not a supported release from Wordpress, which requires MySQL database version 5.0 . The project that provides the Wordpress for SQL Server version (and a plugin for the same) has had reports of SQL errors related to the LIKE statement, which is what is happening here.
The theme was written with SQL that conforms to syntax excepted by MySQL DB. Each database, unfortunately, does have it’s own unique supporting syntax and features that are not compatible with other database servers. I would recommend that you check with your IT person and see if they can setup an instance of MySQL for your web account. With the SQL Server version you are currently on you may well experience unpredictable results.
I’ll pass this a along to the developers of the theme, but I am not even certain they have access to SQL server DB since the theme is written with MySQL in mine. I hope this helps.”
I was advised to post here and ask for a MSSQL compatible theme.
Now, I am a bit of stuck – I was told yesterday that we can’t install MySQL. We need to be on a Windows server 2012 with MSSQL. The initial plan was to use WordPress and build a site (consolidating several existing WP blogs with all/most posts and features). But upon testing and seeing the theme problems, I am not sure if there might be other issues with plugins (which are also written with MySQL in mind) in future.
If we decide to go the other route – using Drupal for example, it opens a different can of worms, considering the consolidation of the existing blogs.
On top of that, I have a set deadline of several weeks, which is fast approaching.:-)
In that case you’re either going to have to fight to install MySql on the Windows box or fight to put the sites on a Linux server – there’s going to be too many issues moving forwards if you’re using WP.
Just use a mySQL – Mssql sux anyway
The issue here is that you need to use technologies that go together. If you must use WordPress, then you must use Linux and MySQL. If you must use Windows server and MSSQL, then you cannot use WordPress. It’s as simple as that.
I have quite a bit of experience running WordPress on Windows Server, and although it IS possible to get it working, it’s just not a clean solution at all. It’s very messy. It’s a customized hack at best, which means you’re always playing “whack-a-mole” with any changes/updates, etc.
Hope that helps!
Thanks, Scott! Yes, I understand that, and I am trying to find a solution… The problem is that the company works only with Windows servers, but they want a WordPress site (as people know how to use it, and there are several blogs that need to be consolidated).
Do you have any experience with MySQL under Windows? Could there be any problems too?