Thread Details
  • State Not Answered
  • Replies 5 replies
  • Subscribers 367 subscribers
  • Views 1952 views
  • Users 0 members are here
Forum Actions

Receiving Error When Installing SugarCRM v 13 (Sql Server)

Eric Augustus

I am receiving the following error 

Database Support was not found. Please make sure you have the necessary drivers for one of the following supported Database Types: MySQL, MS SQLServer, Oracle, or DB2. You might need to uncomment the extension in the php.ini file, or recompile with the right binary file, depending on your version of PHP. Please refer to your PHP Manual for more information on how to enable Database Support.

I have updated the php.ini file with the to point to the ext folder with  ext=php_sqlsrv_82_nts_x64.dll..  Can you advise if the sql server reference is correct and/or I am missing something.

  • 0

    Hi  ,

    It's been awhile since I've had to deal with configuring Sugar for SQL Server, but Microsoft has the following pages to provide guidance:

    https://learn.microsoft.com/en-us/sql/connect/php/system-requirements-for-the-php-sql-driver?view=sql-server-ver16&redirectedfrom=MSDN#driver-versions
    https://learn.microsoft.com/en-us/sql/connect/php/loading-the-php-sql-driver?view=sql-server-ver16

    A few things that I notice that differ from what you list versus the above article:

    • The directive pointing to the extension file should be 'extension=', not 'ext='
    • The driver you reference doesn't seem to be appropriate. It should either be 'php_sqlsrv_82_ts.dll' for 32-bit or 'php_sqlsrv_82_nts.dll' for 64-bit assuming you are running on a Windows web server. I don't see any mention of 'php_sqlsrv_82_nts_x64.dll' in their configuration options.

    I hope this helps!

    Chris

    Co-Founder | SugarCRM's 2024 Global Outfitters Partner of the Year

  • 0 in reply to Chris Raffle

    Thank you Chris for the reply, however I am getting the same error.  I will dig deeper to figure out what is wrong.

  • 0 in reply to Eric Augustus

    hello Eric

    On fresh install I have the same error on MYSQL connection on windows 2022 installing Apache and php 8.0.28

    Also the Elasticcearch 8.4.3 connection not working ( had to bypass ) even though can connect on the port with curl. 

    What a day wasted time.

  • 0 in reply to Andries Pretorius

    Maybe this helps:

    SugarCRM 12.0 fresh install --- php errors noted:


    Warning: ini_set(): Session ini settings cannot be changed when a session is active in C:\A\xampp\htdocs\sugarcrm\include\utils.php on line 4009

    Warning: ini_set(): Session ini settings cannot be changed when a session is active in C:\A\xampp\htdocs\sugarcrm\include\utils.php on line 4009

    Fatal error: Uncaught Error: Call to undefined function mysqli_report() in C:\A\xampp\htdocs\sugarcrm\include\database\MysqliManager.php:280 Stack trace: #0 C:\A\xampp\htdocs\sugarcrm\install\checkDBSettings.php(112): MysqliManager->connect(Array, false) #1 C:\A\xampp\htdocs\sugarcrm\install\install_utils.php(1333): checkDBSettings(true) #2 C:\A\xampp\htdocs\sugarcrm\install.php(501): validate_dbConfig() #3 {main} thrown in C:\A\xampp\htdocs\sugarcrm\include\database\MysqliManager.php on line 280

    Fatal error: Uncaught TypeError: SugarQuery::setDBManager(): Argument #1 ($db) must be of type DBManager, bool given, called in C:\A\xampp\htdocs\sugarcrm\include\SugarQuery\SugarQuery.php on line 160 and defined in C:\A\xampp\htdocs\sugarcrm\include\SugarQuery\SugarQuery.php:167 Stack trace: #0 C:\A\xampp\htdocs\sugarcrm\include\SugarQuery\SugarQuery.php(160): SugarQuery->setDBManager(false) #1 C:\A\xampp\htdocs\sugarcrm\modules\Administration\UpgradeHistory.php(266): SugarQuery->__construct() #2 C:\A\xampp\htdocs\sugarcrm\src\PackageManager\PackageManager.php(746): UpgradeHistory->getJustInstalled() #3 C:\A\xampp\htdocs\sugarcrm\include\utils.php(3267): Sugarcrm\Sugarcrm\PackageManager\PackageManager->handleApplicationFatalError(Object(ErrorException)) #4 [internal function]: sugar_cleanup() #5 {main} thrown in C:\A\xampp\htdocs\sugarcrm\include\SugarQuery\SugarQuery.php on line 167

  • 0 in reply to Andries Pretorius

    Hello Andries,

    I updated the drives in the php/ext folder for windows and added php_pdo_sqlsrv_7_nts.dll and php_sqlsrv_7_nts.dlland updated the php.ini file. I am past this window.  Also, I am having the same issue in sqlserver_connect() as you (Call to undefined function mysqli_report()).  I read the driver above does not support sqlserver_connect() deprecated, could be the same issue. good luck.