We installed SuiteCRM 7.7.8 on a CentOS 7 box. The box has PHP 7.0.13 and “ODBC Driver 13 for SQL Server”.
I know that I am able to connect to the database by using this script:
<?php
$serverName = "XXXX";
$connectionOptions = array(
"Database" => "SuiteCRM",
"Uid" => "CRM_USER",
"PWD" => "XXXXX"
);
//Establishes the connection
$conn = sqlsrv_connect($serverName, $connectionOptions);
if($conn)
echo "Connected!"
?>I get a result of connected and on the SQL Server I can see the packets coming through.
When I try to set up SuiteCRM, I can not get past the screen for setting up the database. For the database i select “SQL Server (Microsoft SQL Server Driver for PHP)”.
in “SuiteCRM Database User” I select “Provide Existing User”. I use the user from the connection string above and know that user works.
Still I keep getting the error “The provided database host, username, and/or password is invalid, and a connection to the database could not be established. Please enter a valid host, username and password”. The really odd part is, I am not even getting packets on the SQL Server so i know the request is not even getting there.
My thoughts are that it is possibly using a wrong driver and not the MSSQL server I installed. I am not sure how to check this though and have not had any luck on Google or on this board finding anything.
Thank you in advanced for any assistance.