Differences

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

--- v5:database:microsoft_sql_server [2020/01/13 12:38] – Add tier1 tag dregad
+++ v5:database:microsoft_sql_server [2025/06/01 13:21] (current) – Remove square brackets in tags dregad
@@ 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 tier1]}}
+{{tag>SQL_Server unix active freetds tier1}}
 --------------------------------------
 ===== mssql (Windows) =====
@@ Line 145: / 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 160: / 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}}