Sugar Open Source Installation Guide Version 4.5.1

Installation Prerequisites and Guidelines

Ensure that the following requirements are met before you install Sugar Suite 4.5.1.

•	If you are using MySQL, install version 4.1.2 or higher to use with Sugar Suite 4.5.1.

•	If you are using SQL server, install and set it up to work with Sugar Suite. For more information, navigate to www.sugarcrm.com/wiki/Sugar Developer Wiki/Configuration and Installation/Installing SugarCRM with SQL Server.

•

In order for Sugar Suite to connect to SQL Server, all Web servers that will run Sugar Suite need to receive an update to one of the Microsoft DLLs. Download ntwdblib.dll version 2000.80.194.0 and place it in the system directory of all Web servers running Sugar Suite and connecting to Microsoft SQL Server. After you complete this task, it is recommended that you search each Web server for all copies of ntwdblib.dll and rename them to something else, such as ntwdblib2.dll to ensure that the correct DLL is loaded.

•	Install PHP and make the following changes:

•	To enable the MS SQL extensions, open up php.ini and uncomment the following string:

“extension=php_mssql.dll”

•	To enable UTF8 character support, search for the following string:

mssql.charset = "ISO-8859-1"

and change it to

mssql.charset = "UTF-8"

SugarCRM requires that date strings be retrieved in YYYY-MM-DD hh:mm:ss format. To enable this in SQL Server uncomment the following option and make sure it is set to Off as follows:

mssql.datetimeconvert = Off

•	When you install Sugar Suite 4.5.1, do the following:

•	In Step 4 of the installation process, check the Host Name entry. If you accepted the default values, then the name will be similar to “server name” + “\SQLExpress”. So assuming your computer name is “foo”, the database hostname is “foo\SQLExpress”.

•	Enter the server name in the first text field (“foo” from the example above) and the instance name in the second tab (“SQLExpress” in the example above).

The rest of the installation process proceeds as usual.