microsoft/msphpsql

Not working sqlsrv_connect (php 8.1.7 -> 8.3.14))

bertman80 opened this issue · 3 comments

bertman80 commented

Hello,

I need to update PHP because we are currently running 8.1.7. I understood that 8.4 is not supported in combination with MS SQL, so I downloaded 8.3.14.
We are running:

  • Windows 2022 server with IIS
  • MS SQL 2022

We have 4 sites running, and I configured PHP per site so I can update more securely. I updated one site to point to the new PHP version, but I cannot establish a connection to the database.
I’m likely overlooking something, but I have no idea at the moment.

Comparison of php.ini files

Difference between php.ini (compared with the production example)

display_errors = on
display_startup_errors = on
error_reporting = E_ALL
error_log = syslog
extension_dir = "C:\php\8.3.14\ext"
cgi.force_redirect = 0
cgi.fix_pathinfo = 1
fastcgi.impersonate = 1
extension = php_sqlsrv_83_nts_x64.dll

Difference between php.ini (compared with the 8.1.7 version)

display_errors = on (disabled)
display_startup_errors = on (disabled)
error_log = syslog (php_errors.log)
extension_dir = "C:\php\8.3.14\ext" (extension_dir = "C:\php\8.1.7\ext")
extension = php_sqlsrv_83_nts_x64.dll (extension = php_sqlsrv_81_nts_x64.dll)

PHP Connection Code

I’m using the following code in PHP to connect:

$conn_array = array(
    "UID" => $username,
    "PWD" => $password,
    "Database" => $database,
    "CharacterSet" => "UTF-8"
);
$conn = sqlsrv_connect($servername, $conn_array);

I’m now getting a 500 error.

IIS Log
Here is the IIS log output:

2024-11-27 07:47:26 <server IP> GET / - 443 - <client IP> Mozilla/5.0+(Windows+NT+10.0;+Win64;+x64)+AppleWebKit/537.36+(KHTML,+like+Gecko)+Chrome/131.0.0.0+Safari/537.36 - 500 0 0 371
2024-11-27 07:47:26 <server IP> GET / - 443 - <client IP> Mozilla/5.0+(Windows+NT+10.0;+Win64;+x64)+AppleWebKit/537.36+(KHTML,+like+Gecko)+Chrome/131.0.0.0+Safari/537.36 - 500 0 0 119
2024-11-27 07:47:27 <server IP> GET / - 443 - <client IP> Mozilla/5.0+(Windows+NT+10.0;+Win64;+x64)+AppleWebKit/537.36+(KHTML,+like+Gecko)+Chrome/131.0.0.0+Safari/537.36 - 500 0 0 121
2024-11-27 07:47:32 <server IP> GET / - 443 - <client IP> Mozilla/5.0+(Windows+NT+10.0;+Win64;+x64)+AppleWebKit/537.36+(KHTML,+like+Gecko)+Chrome/131.0.0.0+Safari/537.36 - 500 0 0 80
CesitUPS commented

Try adding

"Encrypt" => false

in connection parameters

bertman80 commented

Probably a local browser issue. I will check again tomorrow and then I will let you know

bertman80 commented

It was indeed an issue with the machine or browser. My apologies.