Can't Install SugarCRM 4.5.0b - mssql_query(): Unable to connect to server

**exthor** · 2006-09-19, 03:35 PM

Hi, I have a Windows server running plesk and mysql. I also have MS sqlexpress 2005 installed on the computer.

PHP Version 4.3.11
SugarSuite-for-Microsoft-4.5.0b.zip
MySQL 4.1.12-nt running

I downloaded the files, and installed them in the directory, then access the files through the browser.
I am able to go through the process, but step 7 keeps on coming back with the following errors:

Step 7: Perform Setup
Creating Sugar configuration file (config.php)

Creating Sugar application tables, audit tables, and relationship metadata...

Creating the database sugarcrm on localhost...
Warning: mssql_query(): Unable to connect to server: (null) in C:\Inetpub\vhosts\knsci.com\httpdocs\crm\install\i nstall_utils.php on line 534

Warning: mssql_query(): A link to the server could not be established in C:\Inetpub\vhosts\knsci.com\httpdocs\crm\install\i nstall_utils.php on line 534

Warning: mssql_close(): supplied argument is not a valid MS SQL-Link resource in C:\Inetpub\vhosts\knsci.com\httpdocs\crm\install\i nstall_utils.php on line 535
done
Creating the Database username and password...
Warning: mssql_connect(): Unable to connect to server: localhost\sqlexpress in C:\Inetpub\vhosts\knsci.com\httpdocs\crm\install\i nstall_utils.php on line 437
done

Warning: mssql_connect(): Unable to connect to server: localhost\sqlexpress in C:\Inetpub\vhosts\knsci.com\httpdocs\crm\include\d atabase\MssqlManager.php on line 121

Warning: mssql_close(): supplied argument is not a valid MS SQL-Link resource in C:\Inetpub\vhosts\knsci.com\httpdocs\crm\include\d atabase\MssqlManager.php on line 89
Could not connect to server localhost as sugarcrm.

I already tryied replacing the ntwdblib.dll in the WINNT folder, but it didn't work.

Can you please help me figure out what is going on.

Thanks

**kpit** · 2006-09-19, 03:50 PM

Do you have the php module for msql configured?

**exthor** · 2006-09-19, 08:19 PM

I'm not sure what is the PHP module for msql?
Is it the phpMyAdmin 2.6.0-pl3
I have that module.
is there something else I should install?
Also, when I go through the install process, the step 3 ask me for the database info, host name/host instance, I use the default of localhost/sqlexpress
Should I be using something else?

**kpit** · 2006-09-19, 09:10 PM

Find you php.ini file. Edit the file. Look for the following:

Code:

;extension=php_mssql.dll

Remove the leading ";" and then save the file.

Code:

extension=php_mssql.dll

Restart your Webserver. this adds the MS SQL for php.

**exthor** · 2006-09-19, 11:57 PM

Yeah that was done.
It's got to be something else

**ruchida** · 2006-09-20, 12:48 AM

Try replacing the ntwdblib.dll shipped with PHP (or MSSQL) with the one bundled with Sugar 4.5.0 SCL.

**exthor** · 2006-09-20, 04:36 AM

Hey Guys,
Thanks for the help. I got it resolve.
I tryed everything I found in the forum, but nothing worked. Even getting the new file, and the changes to the php.ini.
The problem was that I was using;
SugarSuite-for-Microsoft-4.5.0b.zip
--> this version is based on the MS SQL server. I was trying to use the mysql db
so, I downloaded the regular sugarsuite and tested, and it worked fine.

I think sugar CRM should mention somewhere that tha SugarSuite-for-Microsoft-4.5.0b.zip is MS because it's meant to use the MS SQL DB.

I hope this post will help people like me.

Thanks anyway