PHP in Debian, DB in MSSQL - Install problem

**anoka** · 2012-01-21, 11:15 AM

Hi!

I would like to install SugarCRM community edition to Debian linux. But the database must be MSSSQL.
I can connect from linux to SQL via tsql and php too.
But the installation "freeze", when "Verifying DB Credentials.".

I can connect with this:

PHP Code:


<html>

<body>

<?php

$con = mssql_connect ("sc-sql03.local.softc.hu\crmsql", "sugarsqladmin", "<pass>");

mssql_select_db ("sugarcrm", $con);

$sql= "SELECT * FROM sysobjects";

$rs= mssql_query ($sql, $con);

echo "The field number one is: ";

echo mssql_result ($rs, 0, 0);

mssql_close ($con);

?>

</body>

</html>

Result:
The field number one is: sysrscols

CRM install.log latest lines:

Code:

2012-01-21 12:55:17...Begin DB Check Process *************
2012-01-21 12:55:17...testing with mssql:freetds
2012-01-21 12:55:17...Basic form info is valid, continuing Process.
2012-01-21 12:55:17...Testing user account...
2012-01-21 12:55:17...Connection made using  host: sc-sql03.local.softc.hu, usr: sugarsqladmin
2012-01-21 12:55:17...Testing priviliged account...
2012-01-21 12:55:17...Connection made using  host: sc-sql03.local.softc.hu, usr: sugarsqladmin

After nothing else, nothing happen.