Connecting to mssql from windows 10 apache/php/cakephp3

Need Help
5

  1. cakephp DataSource Config (app.php)

    ‘Datasources’ => [
    ‘default’ => [
    ‘className’ => ‘Cake\Database\Connection’,
    ‘driver’ => ‘Cake\Database\Driver\SqlServer’,
    ‘persistent’ => false,
    ‘host’ => ‘hostname’,
    /**
    * CakePHP will use the default DB port based on the driver selected
    * MySQL on MAMP uses port 8889, MAMP users will want to uncomment
    * the following line and set the port accordingly
    */
    //‘port’ => ‘non_standard_port_number’,
    ‘username’ => ‘user’,
    ‘password’ => ‘pw’,
    ‘database’ => ‘db’,
    ‘encoding’ => PDO::SQLSRV_ENCODING_UTF8,
    ‘timezone’ => ‘UTC’,
    ‘flags’ => [],
    ‘cacheMetadata’ => true,
    ‘log’ => false,