sqlsrv ใช้งานไม่ได้ครับ ไม่สามารถเชื่อมต่อ mssqlได้ครับ แก้ไขยังไงดี

Quote:

This error occurs when the SSL certificate used by the SQL Server is not trusted by the client. To resolve this issue, you can do the following:

1. Import the root certificate from the SQL Server into the trusted root certificate store on the client machine.

2. Disable SSL certificate validation in the PDO connection string by adding "Encrypt=yes;TrustServerCertificate=yes" to the connection string.

Example:

$dsn = "sqlsrv:Server=$serverName;Database=$dbName;Encrypt=yes;TrustServerCertificate=yes";
$pdo = new PDO($dsn, $userName, $password);

Note: Disabling SSL certificate validation can compromise the security of the connection. It is recommended to import the root certificate instead.

3. Use a self-signed certificate instead of a trusted one. To do this, you will need to create your own self-signed certificate and configure SQL Server to use it.

4. Connect to the SQL Server using an IP address instead of a hostname in the connection string. This will bypass the certificate validation check, but it is less secure as the IP address may change.

Example:

$dsn = "sqlsrv:Server=192.168.0.1,1433;Database=$dbName";
$pdo = new PDO($dsn, $userName, $password);

5. Connect to the SQL Server using a non-SSL connection by removing the "Encrypt=yes" from the connection string.

Example:

$dsn = "sqlsrv:Server=$serverName;Database=$dbName";
$pdo = new PDO($dsn, $userName, $password);

Note: Using a non-SSL connection is not recommended as it can compromise the security of the data transmitted between the client and the server.

6. Update the ODBC driver to the latest version. The latest version of the ODBC Driver may have a fix for the SSL certificate validation issue. You can download the latest version of the ODBC Driver from Microsoft's website.

7. Use a different database driver that supports the SQL Server. For example, you can use the "FreeTDS" driver instead of the "sqlsrv" driver. FreeTDS is a set of libraries that allow connecting to SQL Server and Sybase databases from Linux and Unix platforms.

8. If you are using a cloud-based database, try connecting over an encrypted connection. Most cloud providers offer secure, encrypted connections that can be used instead of SSL.