Linux and Microsoft SQL. Possible configuration for SugarCRM?

A few months ago I responded to a question (MS-SQL Linux Connector) on the SugarCRM community. The question is the following:

Ok. Built a Ubuntu server using the version per the OS supported guide. Followed by installing all of the requirements including the versions for PHP, Apache, MySQL, etc..  I am now in business with one thing; I need this to use a SQL Server (and not MySQL).  Any guides available on setting Sugar,PHP, Apache, etc. to work with a SQL Server?

The first response from the Community Manager has been:

At this time, our plan is to support MSSQL in Sugar 7 starting with version 7.5. This is subject to change, but is the current estimate. In 6.5.x, MSSQL is only supported on an IIS Server as the MS Driver is required. Using Linux and MSSQL is not currently supported.

Apparently it seems that it is not possible to install SugarCRM (especially version 7 of SugarCRM) on the software stack, Linux and Microsoft SQL Server. Although officially SugarCRM does not support this configuration, you can install SugarCRM on Linux that uses Microsoft SQL Server as the database, just simply install the driver FreeTDS on Linux and MSSQL PHP module.

For the purpose I have created a Virtual Appliance able to accommodate the installation of SugarCRM + Linux + MSSQL Module to connect to Microsoft SQL Server. This Virtual Appliance based on Ubuntu 14 to install SugarCRM with support for Microsoft SQL Server. The software stack is the following:

  • OS: Ubuntu Server 14.04 Kernel 3.13.0.24 x86_64
  • PHP: 5.3.28 +MSSQL Module (by phpbrew)
  • TDS: FreeTDS Driver + Utilities (tsql)
  • Web Server: Apache 2.4 (rewrite module enabled)

There are also two apache Virtual Host:

  • crm-ce.shirus-labs.local => SugarCRM CE 6.5.17 (document root /var/www/html/sugarcrm-ce)
  • crm-ee.shirus-labs.local => SugarCRM 7.2 (document root /var/www/html/sugarcrm-ee)

I have successfully installed the CE version of SugarCRM with Microsoft SQL Express 2008 as the database.

I exported the machine in OVF 2.0 format and available on DropBox.

Of course, remember that this type of configuration is not supported by SugarCRM 7.2.

Well done. At this URL https://www.dropbox.com/s/7483t4jmv5v... you can download the VM. Username and password for this VM are: amusarra/amusarra

If the content offered in this article have been helpful to you, you give me back the favor by sharing this article on social networking channels, so as to make it useful for others what I have written.

Antonio Musarra

I began my journey into the world of computing from an Olivetti M24 PC (http://it.wikipedia.org/wiki/Olivetti_M24) bought by my father for his work. Day after day, quickly taking control until … Now doing business consulting for projects in the enterprise application development using web-oriented technologies such as J2EE, Web Services, ESB, TIBCO, PHP.

You may also like...