Hinterndorfer Markus asked 1 year ago
Hello!
How can i add the Encrypt and TrustServerCertificate to the mssqlnative connection? We need this for the use with php 8.2.6.
Thanks!
Our Connection:
define(“PHPGRID_DBTYPE”,”mssqlnative”);
define(“PHPGRID_DBHOST”,”A1525v\SQLInstanz2″);
define(“PHPGRID_DBUSER”,”reports”);
define(“PHPGRID_DBPASS”,”XXXX”));
define(“PHPGRID_DBNAME”,”Garant_Produktion_ESA”);
Example from Microsoft:
$serverName = “serverName”;
$connectionInfo = array( “Database”=>”DbName”,
“UID”=>”UserName”,
“PWD”=>”Password”,
“Encrypt”=>true,
“TrustServerCertificate”=>true);
$conn = sqlsrv_connect( $serverName, $connectionInfo);
Abu Ghufran Staff answered 1 year ago
Hi,
Currently, it’s not configurable. You can solve the issue by editing lib/inc/jqgrid_dist.php and search ($this->con->charSet) and add next line:
$this->con->charSet = $this->charset;
$this->con->setConnectionParameter('Encrypt',1);
$this->con->setConnectionParameter('TrustServerCertificate',1);
