🗄️ MSSQL Server Connection Test

❌ Connection Failed

Error Details:

SQLSRV Error Info:

Array
(
    [0] => Array
        (
            [0] => 08001
            [SQLSTATE] => 08001
            [1] => -2146893019
            [code] => -2146893019
            [2] => [Microsoft][ODBC Driver 18 for SQL Server]SSL Provider: The certificate chain was issued by an authority that is not trusted.

            [message] => [Microsoft][ODBC Driver 18 for SQL Server]SSL Provider: The certificate chain was issued by an authority that is not trusted.

        )

    [1] => Array
        (
            [0] => 08001
            [SQLSTATE] => 08001
            [1] => -2146893019
            [code] => -2146893019
            [2] => [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
            [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
        )

)

Troubleshooting Tips:

• Verify the server IP address and port number are correct
• Check if the SQL Server is running and accepting TCP/IP connections
• Ensure the username and password are correct
• Verify SQL Server authentication mode allows SQL Server logins
• Check firewall settings - port 21474 should be open
• Ensure the database "KsmErp" exists and user has access
• Try enabling TCP/IP protocol in SQL Server Configuration Manager