Database connection failed

BASE-user
2010-03-03
2013-06-03
  • BASE cannot logon to SQL. The environment is a brand new installation of BASE and Snort, Windows and SQL. The username and password does work over ODBC and SQL Server Management Studio. The create_base_tbls_mssql.sql script has been executed against Snort.

    Any ideas on how to troubleshoot this?

    J Wolfgang Goerlich

    Symptoms:

    From setup2.php:

    Database connection failed!
    Please try again!

    From the main page after manually creating base_conf.php:

    Error (p)connecting to DB : Snort@Db20.yourdomain.com
    Check the DB connection variables in base_conf.php _

    Environment:

    BASE 1.4.4
    Adodb 5.10 (for PHP5)
    PHP 5.2 (5.2.13)
    Snort 2.6.0
    SQL Server 2008 (64-bit)
    Windows Server 2008 R2 (64-bit)
    _

     
  • Resolved. AdoDb was not working properly. The mssql_* functions (php_mssql.dll) in 5.1.6 have been replaced with sqlsrv_* functions (php_sqlsrv_53_ts_vc9.dll) in PHP 5.3.13 and 5.3.2. I downgraded to PHP 5.1.6 and added php_mssql.dll to the php.ini as an extension. The AdoDb and BASE connectivity now work properly.