Make a quick vote 🗳 ️How do you refer to SuiteCRM extensions: add-ons or plug-ins? Click here to have your say 👈

Will SuiteCRM8 ever officially support WIMP with MS SQL?

Hello all,

We run multiple SuiteCRM 7 instances on WIMP stacks with MS SQL. We seem to be in the vast minority with this approach, but we’re well versed in these technologies and SuiteCRM has run well in our experience despite needing to employ the use of a few extra tricks not covered by the installation docs.

We’ve been waiting with enthusiasm for v8 but didn’t notice until recently that support for most of this stack appears to have been quietly dropped in the migration to v8. I can’t find anything about it in the roadmap or release docs, and information in forums is scarce and usually just a hint at best.

I understand some people have tried running it with WAMP but results are unclear. I understand that due to the use of Platforms - Doctrine Database Abstraction Layer (DBAL) in theory MS SQL should work but that’s also unclear so far… We haven’t tried it ourselves yet.

My questions are:

  • Will SuiteCRM 8 support Windows, IIS, and MS SQL officially at any point?
  • If it will, is there any guess at an ETA?

I’d like to know if we are bidding a sad farewell to our erstwhile faithful friend, or if the fun will continue! :slight_smile:

Cheers,
Rob

Hi again,

Just wondering if anyone from the dev team or close to it has an answer to this question? I was guessing it is a simple “yes” or “no” to answer whether or not SuiteCRM 8 will support Windows, IIS, MS SQL officially at some point. I understand there might not be a set timeline for it, but we’d like to know what the product plan is.

Cheers,
Rob

Also wondering this, we had setup a test environment using a WIMP stack with MS SQL server 2016.

we are doing this in an effort towards a likely migration from saleforce enterprise for $50k+ / yr to SuiteCRM with on-going paid support time.

it had worked well so far and had been VERY alike to our current salesforce usage (no workflows really).

if it now only works on a linux based stack then that would be a harder sell since we are primarily a microsoft run house, we have over 50 servers and maybe 5 are linux based.

Hi guys. Since there was no official answer, let me just throw in my 2 cents…

Maybe SalesAgility doesn’t have many resources to come up with many “officially supported” guarantees, and it’s definitely not a Windows company. At all.

Still, MSSQL has always been supported, and the move to Doctrine only makes this better. So I would say that yes, it’s reasonable to run SuiteCRM on top of Windows platforms, you just need a bit of extra care testing since your set up won’t be as thoroughly tested by a large community as the (much more used) Linux ones.

That said, I am a rare case of a person who loves and extensively uses both Linux and Windows. And I would still advise running SuiteCRM on Ubuntu, in my experience all these years I think it’s simply the best option, and saves a lot of hassle.

Even if you run it inside a VM in a free Windows Hyper-V Server like I do :wink:

I’m also quite comfortable with unix/linux/as400 but the somewhat unwritten company policy has been to avoid linux whenever possible due to not wanting “science projects” (bs answer i know but whatever).
out of the 50+ servers between the on-prem hosts and our AWS cloud that i manage, i’ve only been allowed to use linux based designs when it was either the only option or the only option left.

as far as SQL that isn’t a concern, more a concern is that the 8.x archives do not really run or drop into a established IIS stack (already running a test instance of 7.12) and just run or even allow configuration (can’t even get the site to respond at the endpoint and nothing is really apparent as far as what it needs)
already confirmed that both the 7.12 instance and the 8.x instance folders and permissions in windows/IIS are identical.

Honestly, even if salesagility isn’t a “windows company”, it shouldn’t be that much of an ask to generate a basic install guide to install the system on a windows/sql stack for a product that is (or should be) largely hosting agnostic provided the infrastructure is there (DB system, PHP, webserver, etc.)