installation problem --> SQL Server

[jrichnow]

Hi all,

I'm trying to install SugarCRM (4.5.0) on Windows XP. I installed PHP5 and Apache 2.2. Both work fine together. I already had MySQL 5.0. I can use MySQL from a PHP page and get result sets etc back.

Now in Step 2 of the SugarCRM installation (System Check Acceptance) I get for "SQL Server Database" always "Not available". What does the installation check for in terms of this SQL Server Database? I simply cannot not install SugarCRM without this support.

Any help is greatly appreciated.

Cheers

Jens

[Dajee]

I am having this same problem too, Step 2 only displays "SQL Server Database Not Available" also the MB Strings indicator is showing this all the time, "MB Strings Module Not found: SugarCRM will not be able to process multi-byte characters. This will impact receiving emails in character sets other than UTF-8". My PHP and Apache as well as MySql is installed perfectly fine, there seems to be a configuration, problem. Can anyone help please with some speed, it would be greatly appreciated. Help Help !!!!!

[Sasi]

Did you configure php.ini per instructions for sql server..
e.g. enable
extension=php_msql.dll

[Sasi]

Did you configure php.ini per instructions for sql server..
e.g. enable
extension=php_mssql.dll

[jrichnow]

Hi Sasi,

yes, I configured (hopefully) everything as per instructions, i.e.,

extension_dir = "C:\php\ext"
extension=php_mbstring.dll
extension=php_mysql.dll
extension=php_mysqli.dll

I double-checked that the extension poath is correct and all referenced libraries are present.

Also, I configured all settings in the [MySQL] and [MySQLi] sections.

Cheers

Jens

[ruchida]

Hi Sasi,

yes, I configured (hopefully) everything as per instructions, i.e.,

extension_dir = "C:\php\ext"
extension=php_mbstring.dll
extension=php_mysql.dll
extension=php_mysqli.dll

I double-checked that the extension poath is correct and all referenced libraries are present.

Also, I configured all settings in the [MySQL] and [MySQLi] sections.

Cheers

Jens

Are you going to use MySQL, not MS SQL Server? Some people thought you're going to use MS SQL by looking at your first post.

Anyway, is your PHP directory set in the path variable? Or is libmysql.dll copied to your Windows system directory?

[jrichnow]

Hi,

yes, I want to use MySQL. Sorry for the misunderstanding. I set and entry to PHP into the windows PATH (e.g., c:\php) which should cover the binary and the libmysql.dll as well. I did not copy libmysql.dll to the Windows system directory.

Cheers

Jens

[ruchida]

Are you using the correct package?
http://www.sugarforge.org/frs/downlo...ite-4.5.0d.zip

Be careful that there is another package that only supports MS SQL Server.
http://www.sugarforge.org/frs/downlo...tch-4.5.0d.zip

[jrichnow]

Are you using the correct package?
http://www.sugarforge.org/frs/downlo...ite-4.5.0d.zip

Be careful that there is another package that only supports MS SQL Server.
http://www.sugarforge.org/frs/downlo...tch-4.5.0d.zip

Thanks you very much for this pointer. It solved the problem! From the download page (http://www.sugarcrm.com/crm/download/sugar-suite.html) it is not apparent that the download SugarSuite-for-Microsoft implicitely implies the usage of SQL Server! I feel a brief description or a note is required here to make the user aware about the database used for each download. Anyway, downloading the 'general' package everything worked fine, without any problems.

Thanks again!

Jens

[gmullen]

Hopefully someone has come across this problem and I just haven't found the solution yet. I am trying to install Sugar 4.5.0d on a Windows 2003 Server running IIS 6.0. I have PHP set up and configured (edited the php.ini file etc) and have also setup MSSQL (SQL shows up and running). When I lauch the SugarCRM install, I get to the pre-install check and this is what I get:

Component Status
PHP Version Unsupported PHP Version Installed: ( ver 4.4.4 )
SQL Server Database Not Available
MB Strings Module Not found: SugarCRM will not be able to process multi-byte characters. This will impact receiving emails in character sets other than UTF-8.
XML Parsing OK
PHP Safe Mode Turned Off OK
PHP Allow Call Time Pass Reference Turned On OK
PHP Memory Limit >= 32M OK (Unlimited)
Writable SugarCRM Configuration File (config.php) OK
Writable Custom Directory OK
Writable Modules Sub-Directories and Files OK
Writable Data Sub-Directories OK
Writable Cache Sub-Directories OK
Writable Session Save Path () Not A Valid Directory
Optional Components Status
IMAP Module Not found: InboundEmail and Campaigns (Email) require the IMAP libraries. Neither will be functional.
cURL Module Not found: Sugar Scheduler will run with limited functionality.
PHP-JSON Module (v 1.1.1) Not found: The PHP-JSON PHP module reaps enormous performance benefits.
ZLIB Compression Module OK
Note: Your php configuration file (php.ini) is located at:
C:\WINDOWS\php.ini

I don't know why my SQL server is unavailable, did I miss a set somewhere? Also, I have noticed that the Sugar installer says my ph.ini is located at C:\WINDOWS\php.ini. That is not where the files actually is, the files is in c:\php\php.ini. Why does sugar think it is there? I have checked the "Windows" to see if there was a php.ini file there and there is not. I'm pretty new to SQL and PHP , but I'm fairly confident I have everything setup correctly. Any help or ideas would be great.....