none
Error JDBC connection to MS SQL server 2005

    Question

  • Dear All,

    Using JDBC trying to connect MS SQL server 2005. Getting the following error:


    org.apache.commons.dbcp.DbcpException: java.sql.SQLException: Network error IOException: Connection refused: connect
    java.sql.SQLException: Network error IOException: Connection refused: connect
    java.net.ConnectException: Connection refused: connect
    org.apache.commons.dbcp.DbcpException: java.sql.SQLException: Network error IOException: Connection refused: connect
    java.sql.SQLException: Network error IOException: Connection refused: connect
    java.net.ConnectException: Connection refused: connect




    Here is the TCP/IP setting in our SQL server 2005:
    I disable the Windows 2003 R2 firewall, but that didn’t help.
    In SQL server 2005 for Remote connections:
    Enabled “Local and Remote connections: Using both TCP/IP and Named Pipes
    In TCP/IP Prosperities:

    IP Addresses:
    IP1: Active: Yes
    Enabled: Yes
    IP address: the server IP address Example 192.168.0.1
    TCP Dynamic port: 0
    TCP Port: 1433
    ///
    IP2: Active: Yes
    Enabled: Yes
    IP address: the server IP address Example 192.168.0.1
    TCP Dynamic port: 0
    TCP Port: 1433
    ////
    IP3: Active: Yes
    Enabled: Yes
    IP address: the server IP address Example 192.168.0.1
    TCP Dynamic port: 0
    TCP Port:
    ///
    IP4: Active: Yes
    TCP Dynamic ports: 1053
    TCP Port:


    For Protocols:
    Under general:
    Enable: Yes
    Keep Alive: 30000
    Listen ALL: Yes
    No Delay: No

    I think that should be enough info to start with.

    Please advice.


    Thanks for any help.


    Abrahim

    Friday, October 12, 2007 4:20 PM