Database connection failed

  • J Wolfgang Goerlich

    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


    From setup2.php:

    Database connection failed!
    Please try again!

    From the main page after manually creating base_conf.php:

    Error (p)connecting to DB :
    Check the DB connection variables in base_conf.php _


    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)

  • J Wolfgang Goerlich

    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.


Log in to post a comment.

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:

JavaScript is required for this form.

No, thanks