SQLSRV Not Showing in PHP INFO using PHP 8.2.1 and Sql Server 2019

PHP
#1

Hi,

I have download and install SQLSRV32.EXE and SQLSRV40.EXE

I have configured php.ini by adding extension

extension_dir = "ext"

[PHP_SQLSRV]
extension = php_sqlsrv_81_ts.dll
extension = php_sqlsrv_81_ts_x64.dll

My Windows server 2019 and IIS restart several times after new configured php.ini,

I use am using SQL Server 2019, and my PHP version is as follows:

PHP 8.2.1 (cli) (built: Jan 3 2023 23:36:33) (NTS Visual C++ 2019 x64), 
Copyright (c) The PHP Group Zend Engine v4.2.1, Copyright (c) Zend Technologies,

But SQLSRV Not Showing in PHP INFO

Is there something wrong ?

1 Like
#2

You,… might not be able to load both the regular and x64 versions of the same DLL at the same time; it may be causing conflicts. Try loading just the x64 one, as your info suggests you’re running an x64 build?

1 Like
#3

Thanks for suggestion.

I have tried using

extension_dir = "ext"

[PHP_SQLSRV]
extension = php_sqlsrv_81_ts_x64.dll

or

extension_dir = "ext"

[PHP_SQLSRV]
extension=php_sqlsrv.dll

Without success… :frowning:

Is it possible that on windows server 2019 the SQLSRV extension is not available?

https://www.php.net/manual/en/sqlsrv.requirements.php

1 Like
#4

Fairly sure that’s just out of date;