🗄️ MSSQL Server Connection Test

📋 Environment Check

Extension: pdo
✓ Loaded
Extension: pdo_sqlsrv
✗ Not Loaded
Extension: sqlsrv
✓ Loaded
PHP Version
7.4.11
Operating System
Windows NT EC2AMAZ-14NSJLJ 10.0 build 17763 (Windows Server 2016) AMD64

🔧 Connection Configuration

Server Address
123.63.129.110
Port
21474
Username
tabuser2023
Database
KsmErp

🔌 Connection Test #2: SQLSRV (Native)

Attempting connection using SQLSRV native driver...

❌ SQLSRV Connection: FAILED

Error: Connection failed - see errors below

SQLSRV Error Details:

SQLSTATE: 08001
Code: -2146893019
Message: [Microsoft][ODBC Driver 18 for SQL Server]SSL Provider: The certificate chain was issued by an authority that is not trusted.


SQLSTATE: 08001
Code: -2146893019
Message: [Microsoft][ODBC Driver 18 for SQL Server]Client unable to establish connection. For solutions related to encryption errors, see https://go.microsoft.com/fwlink/?linkid=2226722

📊 Overall Connection Summary

ExtensionAvailableStatusDetails
PDO_SQLSRV❌ NoN/AExtension not loaded
SQLSRV✅ Yes❌ FAILEDConnection failed - see errors below...
PDO_ODBC❌ NoN/AExtension not loaded

❌ All Connection Methods Failed

None of the available extensions could connect to the MSSQL server.

🔧 Troubleshooting Steps

  1. Verify Server Accessibility:
    • Check if SQL Server is running
    • Verify the IP address: 123.63.129.110
    • Verify the port: 21474 (default is 1433)
    • Test network connectivity: telnet 123.63.129.110 21474
  2. Check SQL Server Configuration:
    • Ensure TCP/IP protocol is enabled in SQL Server Configuration Manager
    • Verify SQL Server is listening on port 21474
    • Check SQL Server authentication mode (should allow SQL Server authentication, not just Windows)
    • Restart SQL Server service after configuration changes
  3. Verify Credentials:
    • Username: tabuser2023
    • Ensure the password is correct
    • Verify the user has permission to access database: KsmErp
    • Check if the user account is not locked or expired
  4. Firewall Settings:
    • Check Windows Firewall on the SQL Server machine
    • Ensure port 21474 is open for inbound connections
    • Check any network firewalls between the PHP server and SQL Server
  5. SQL Server Browser Service:
    • If using named instances, ensure SQL Server Browser service is running
    • Or use explicit port numbers in connection strings

🌐 Network Diagnostics

DNS Resolution
✓ IP address format valid: 123.63.129.110
Port Validation
✓ Valid port number: 21474
TCP Socket Test
✓ Port is open and accepting connections
Test completed in: 180.97 ms
Timestamp: 2026-10-15 16:16:18 UTC