Mengaktifkan koneksi database SQL Server di PHP 8.3.16 menggunakan Laragon #68

1. Cek versi PHP

Buka terminal:

php -v

Contoh hasil:

PHP 8.3.16

2. Cek TS atau NTS

php -i | findstr Thread

Jika hasil:

Thread Safety => enabled

berarti:

TS (Thread Safe)

Jika:

Thread Safety => disabled

berarti:

NTS (Non Thread Safe)

3. Install ODBC Driver SQL Server

WAJIB install.

Download:

https://learn.microsoft.com/en-us/sql/connect/odbc/download-odbc-driver-for-sql-server?utm_source=chatgpt.com

Install versi:

x64

4. Download SQLSRV Driver PHP

Download:

https://github.com/microsoft/msphpsql/releases?utm_source=chatgpt.com

5. Pilih DLL sesuai PHP

Jika PHP TS:

Gunakan:

php_sqlsrv_83_ts_x64.dll
php_pdo_sqlsrv_83_ts_x64.dll

Jika PHP NTS:

Gunakan:

php_sqlsrv_83_nts_x64.dll
php_pdo_sqlsrv_83_nts_x64.dll

6. Copy DLL ke folder ext

Contoh lokasi:

C:\laragon\bin\php\php-8.3.16-Win32-vs16-x64\ext

7. Edit php.ini

Lokasi:

C:\laragon\bin\php\php-8.3.16-Win32-vs16-x64\php.ini

Tambahkan:

TS
extension=php_sqlsrv_83_ts_x64.dll
extension=php_pdo_sqlsrv_83_ts_x64.dll

NTS
extension=php_sqlsrv_83_nts_x64.dll
extension=php_pdo_sqlsrv_83_nts_x64.dll

8. Restart Laragon

Menu:

Laragon → PHP → Reload

atau restart Laragon.

9. Verifikasi extension aktif

php -m

Harus muncul:

sqlsrv
pdo_sqlsrv

10. Test koneksi SQL Server

Contoh file test_koneksi.php:

<?php

$serverName = "10.100.1.25";

$connectionOptions = array(
    "Database" => "master",
    "Uid" => "sa",
    "PWD" => "password",

    // bypass SSL internal/self-signed
    "TrustServerCertificate" => true,
    "Encrypt" => false
);

$conn = sqlsrv_connect($serverName, $connectionOptions);

if ($conn) {
    echo "Koneksi berhasil!";
} else {
    print_r(sqlsrv_errors());
}

11. Jalankan file

Jalankan pada terminal vs code

php .\test_koneksi.php

Jika berhasil:

Koneksi berhasil!