1.x dev

[Kenneth202212]

Pull Request

Summary of Changes

MS Changed their most recent SQLServer component for PHP to fail on SQL's default self-signed certificate unless you say TrustServerCertificate true. Unfortunately there is no current means to pass that value through the Joomla framework

Testing Instructions

`

    $option = array();
    $option['driver']   = 'sqlsrv';
    $option['host']     = '(host)';
    $option['user']     = '(user)'; 
    $option['password'] = '(pass) ';
    $option['database'] = '(db-name)';
    $option['trust_certificate'] = true;

    $db = (new Joomla\Database\DatabaseFactory)->getDriver('sqlsrv', $option);

    $db->setQuery('SELECT COUNT(*) FROM MyTable');
    echo 'Results: ' . (int) $db->loadResult();`

Documentation Changes Required

SqlsrvDriver.zip

[Hackwar]

Since there is no change anymore to integrate, I'm closing this one.