By Ikto on

I am trying to run Drupal 9.5.2 with xampp using sqlsrv, the specs are:

  • php version is the 8.1.12 (ts)
  • drupal version is 9.5.2
  • sqlsrv version 5.10.0 8.1(ts)
  • pdo_sqlsrv 5.10.0 8.1(ts)
  • sqlsrv module 4.3.1.
  • SSMS 18(Local instance SQLEXPRESS)
  • ODBC Driver 17

I am new to the Drupal world and have been following the documentation to implement sql server support:

  • I downloaded Drupal and sqlsrv module via Composer making sure all dependencies were fulfilled.
  • Downloaded from PECL sqlsrv version 5.10.0 8.1ts and pdo_sqlsrv 5.10.0 8.1ts and configured them in PHP.ini as:
extension=php_sqlsrv.dll
extension=php_pdo_sqlsrv.dll
  • I created a local instance of sql server:
  • Created a database
  • made sure the server was configured for remote connection
  • Created an administrative login and enabled SQL Server Authentication
  • Checked that TCP/IP was enabled for the connection
  • Checked the firewall
  • Checked that the SQL Server Browser/SQL Server (SQLEXPRESS) services were running

At the time of installation via browser (install.php) arrived at the database selection I get the option "SQLServer" and fill in the connection information as follows:

Database Name:testDB

Username:User

Password:PasswordOfTheUser

Advanced Options:
	Host: COMPUTER\SQLEXPRESS
	Port: 1433
	Schema: dbo
	☐ Cache Schema Definitions
	Driver Path: Empty
	Table Prefix: Empty

And every time I get the error:

SQLSTATE[08001]: [Microsoft][ODBC Driver 17 for SQL Server]TCP Provider: Unable to establish connection. Persistent rejection of the target computer.

the exact same connection configuration works trying to connect via php/python scripts.

Am I missing any steps from the documentation? 
Do you have any suggestions that can help me get out of this situation?

Thank you very much in advance for your advice!

⋅ Categories: Drupal 9.x