Код: Выделить всё
$serverName = "x.x.x.x";
$connectionInfo = array("Database" => "database", "UID" => "user", "PWD" => "password","TrustServerCertificate"=>"yes");
$conn = sqlsrv_connect($serverName, $connectionInfo);
Если вот так
Код: Выделить всё
'db'=>[
'class' => 'yii\db\Connection',
'dsn'=>"sqlsrv:server=х.х.х.х;database=database",
'username' => 'username',
'password' => 'password',
'charset' => 'utf8',
],
Код: Выделить всё
Database Exception – yii\db\Exception
SQLSTATE[08001]: [Microsoft][ODBC Driver 18 for SQL Server]SSL Provider: [error:0A000086:SSL routines::certificate verify failed:self-signed certificate]
Error Info: Array
(
[0] => 08001
[1] => -1
[2] => [Microsoft][ODBC Driver 18 for SQL Server]SSL Provider: [error:0A000086:SSL routines::certificate verify failed:self-signed certificate]
[3] => 08001
[4] => -1
[5] => [Microsoft][ODBC Driver 18 for SQL Server]Client unable to establish connection
)
↵
Caused by: PDOException
SQLSTATE[08001]: [Microsoft][ODBC Driver 18 for SQL Server]SSL Provider: [error:0A000086:SSL routines::certificate verify failed:self-signed certificate]
in /var/www/bis/vendor/yiisoft/yii2/db/Connection.php at line 722