3 posts
  • Has been part of the Envato Community for over 1 year
  • Has collected 10+ items on Envato Market
nd_marketing says

Hi guys,

We are looking for a contemporary looking theme (like Avada or Envato) that is compatible with MSSQL.

Could you please give me some recommendations?

Thans!

32 posts
  • Has collected 1+ items on Envato Market
  • Located in United States
  • Sells items exclusively on Envato Market
  • Has been part of the Envato Community for over 3 years
dyspersion says

This is not really a theme question. WordPress itself isn’t really compatible with MSSQL (without a LOT of tinkering).

23 posts
  • Has been part of the Envato Community for over 1 year
ZxxxZ says

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!

1959 posts Don't Worry, Be Happy
  • Sells items exclusively on Envato Market
  • Elite Author: Sold more than $75,000 on Envato Market
  • Made it to the Authors' Hall of Fame
  • Has referred 200+ members
+8 more
FinalDestiny says

Joomla supports MSSQL, you should look for a Joomla template and start from there :)

365 posts
  • Has been part of the Envato Community for over 5 years
  • Has collected 500+ items on Envato Market
  • Located in United Kingdom
kops says
3 posts
  • Has been part of the Envato Community for over 1 year
  • Has collected 10+ items on Envato Market
nd_marketing says

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.:-)

365 posts
  • Has been part of the Envato Community for over 5 years
  • Has collected 500+ items on Envato Market
  • Located in United Kingdom
kops says

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.

647 posts
  • Has been part of the Envato Community for over 3 years
  • Has sold $10,000+ on Envato Market
  • Has collected 10+ items on Envato Market
  • Sells items exclusively on Envato Market
+1 more
ChapterThemes says

Just use a mySQL – Mssql sux anyway :)

32 posts
  • Has collected 1+ items on Envato Market
  • Located in United States
  • Sells items exclusively on Envato Market
  • Has been part of the Envato Community for over 3 years
dyspersion says

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!

Scott

3 posts
  • Has been part of the Envato Community for over 1 year
  • Has collected 10+ items on Envato Market
nd_marketing says

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?

Thanks!

Helpful Information

  • Please read our community guidelines. Self promotion and discussion of piracy is not allowed.
  • Open a support ticket if you would like specific help with your account, deposits or purchases.
  • Item Support by authors is optional and may vary. Please see the Support tab on each item page.

Most of all, enjoy your time here. Thank you for being a valued Envato community member.

Post Reply

Format your entry with some basic HTML. Read the Full Details, or here is a refresher:

<strong></strong> to make things bold
<em></em> to emphasize
<ul><li> or <ol><li> to make lists
<h3> or <h4> to make headings
<pre></pre> for code blocks
<code></code> for a few words of code
<a></a> for links
<img> to paste in an image (it'll need to be hosted somewhere else though)
<blockquote></blockquote> to quote somebody

:grin: :shocked: :cry: Complete List of Smiley Codes

by
by
by
by
by
by