Differences

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

--- v5:database:microsoft_sql_server [2022/07/13 02:59] – [mssqlnative] mnewnham
+++ v5:database:microsoft_sql_server [2025/06/01 13:21] (current) – Remove square brackets in tags dregad
@@ Line 74: / 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 116: / Line 129: @@
 This driver provides access to Microsoft SQL Server databases from unix systems via Freetds
-{{tag>[SQL_Server unix active freetds tier1]}}
+{{tag>SQL_Server unix active freetds tier1}}
 --------------------------------------
 ===== mssql (Windows) =====
@@ Line 147: / Line 160: @@
 This driver provides undocumented portability extensions to the Unix mssql driver
-{{tag>[SQL_Server unix windows active portable]}}
+{{tag>SQL_Server unix windows active portable}}
 ===== mssql_n =====
@@ Line 162: / Line 175: @@
 This driver appears to provide Unicode enhancements to the mssql driver. You can set character sets using the [[v5:reference:connection:setconnectionparameter|setConnectionParameter()]] command
-{{tag>["Microsoft SQL Server" unicode freetds windows]}}
+{{tag>"Microsoft SQL Server" unicode freetds windows}}