Differences

This shows you the differences between two versions of the page.

--- v5:database:microsoft_sql_server [2019/12/29 20:21] – [SQL Server 2003] mnewnham
+++ v5:database:microsoft_sql_server [2022/11/15 02:13] (current) – [Common Connection Problems] mnewnham
@@ Line 26: / Line 26: @@
 [[v5:database:pdo#pdo_sqlsrv|PDO driver for SQL Server]]\\
 [[v5:database:odbc#odbc_mssql|ODBC driver for SQL Server]]\\
+== See Also ==
+[[v5:reference:connection:setconnectionparameter#sqlserver|setConnectionParameter()]]
 </WRAP>
@@ Line 72: / Line 74: @@
 $db->connect('SERVER\SQLEXPRESS',NULL,NULL,'NORTHWND');
 </code>
+===== Common Connection Problems =====
+Recent versions of SQL Server fail to connect with an error ''Message: [Microsoft][ODBC Driver 18 for SQL Server]SSL Provider: The certificate chain was issued by an authority that is not trusted.''
+This problem can be resolved by adding
+<code php>
+$db->setConnectionParameter('TrustServerCertificate',1);
+</code>
+before issuing the ''$db->connect()'' statement
 ------------------------------
 ===== How to create a connection under Linux =====
@@ Line 114: / Line 129: @@
 This driver provides access to Microsoft SQL Server databases from unix systems via Freetds
-{{tag>[SQL_Server unix active freetds]}}
+{{tag>[SQL_Server unix active freetds tier1]}}
 --------------------------------------
 ===== mssql (Windows) =====