Post reply

cannot connect to sqlserver.

  • May 2, 2018 at 10:08 am

    #337433

    JDBC URL:
    jdbc:sqlserver://localhost;databaseName=genogramAnalytics;trustServerCertificate=true;
    I get this error when I try to log in from my java application which already can connect to mysql and derby, but when I try logging into mssql I get this error. How do I make sure my host is accepting TCP/IP connections?
    The TCP/IP connection to the host localhost, port 1433 has
    failed. Error: "Connection refused: connect. Verify the
    connection properties. Make sure that an instance of SQL Server
    is running on the host and accepting TCP/IP connections at the
    port. Make sure that TCP connections to the port are not blocked
    by a firewall.". Please ensure that the TCP/IP protocol is
    enabled on your SQL Server instance

  • May 2, 2018 at 10:15 am

    #1988950

    Try setting Windows Firewall

  • May 2, 2018 at 10:52 am

    #1988962

    loie.a.west - Wednesday, May 2, 2018 10:08 AM

    JDBC URL:
    jdbc:sqlserver://localhost;databaseName=genogramAnalytics;trustServerCertificate=true;
    I get this error when I try to log in from my java application which already can connect to mysql and derby, but when I try logging into mssql I get this error. How do I make sure my host is accepting TCP/IP connections?
    The TCP/IP connection to the host localhost, port 1433 has
    failed. Error: "Connection refused: connect. Verify the
    connection properties. Make sure that an instance of SQL Server
    is running on the host and accepting TCP/IP connections at the
    port. Make sure that TCP connections to the port are not blocked
    by a firewall.". Please ensure that the TCP/IP protocol is
    enabled on your SQL Server instance

    Here is the list of some troubleshooting steps for connectivity to SQL Server with JDBC - it's essentially the same no matter whose driver you use:
    Troubleshooting Connectivity

    Sue

  • May 10, 2018 at 7:11 am

    #1990027

    Have you definitely enabled TCP/IP on the instance? It's disabled by default on 2014 (?) onwards. The setting can be enabled via SQL Server Configuration Manager.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply