aspose file tools*
The moose likes JDBC and the fly likes netstat, telnet: TCP/IP connection to localhost 1433 failed Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "netstat, telnet: TCP/IP connection to localhost 1433 failed" Watch "netstat, telnet: TCP/IP connection to localhost 1433 failed" New topic
Author

netstat, telnet: TCP/IP connection to localhost 1433 failed

A. S. Georgie
Ranch Hand

Joined: Dec 25, 2009
Posts: 72
Hello everyone,

i'm having not stillness with my JDBC connectivity through, and this time i'm using 'sqljdbc.jar' and
a bit different log like:

☺ ERROR: org.jboss.util.NestedSQLException: Could not create connection; - nested throwable: (com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host localhost,
port 1433 has failed
. ☻


and due to the prior topic, got understand why is this, so checked ports at all with netstat
and found out 'bout 1433 and nothing and it was out of door, so and in the nick of all just decided
to open this port by telnet o localhost 1433 is ...Could not open connection ...

i found some article about how to configure my SQL Server 2000, well, there were some nice ones:
  • http://support.microsoft.com/kb/814130
  • http://support.microsoft.com/kb/283811
  • http://support.microsoft.com/kb/314067
  • and more other sites...


  • i checked my Administrative tools > Services | SQLSERCWEAGENT to start too, that aside
    subsidiary LOG in Microsoft SQL Server\MSSQL\ says server Using 'SSNETLIB.DLL' version '8.0.194'
    to configure otherwise don't ask me not aware, cause when see through Start > All Program > Microsoft SQL Server
    i can't find something about configuration, really I'd ha' sufferin if hadn hit coderanch.com somebody help me please, i'm on the qui vive in any case,
    my pure appreciation ...
    Peter Johnson
    author
    Bartender

    Joined: May 14, 2008
    Posts: 5843
        
        7

    I assume that you have already checked that SQL Server is running. Try using TCP View from sysinternals to determine which port(s) SQL Server has open.


    JBoss In Action
    A. S. Georgie
    Ranch Hand

    Joined: Dec 25, 2009
    Posts: 72
    Peter Johnson wrote:
    I assume that you have already checked that SQL Server is running. Try using TCP View from sysinternals to determine which port(s) SQL Server has open.


    how to check systerminals?
    A. S. Georgie
    Ranch Hand

    Joined: Dec 25, 2009
    Posts: 72
    Do you mean tools li' this?
    A. S. Georgie
    Ranch Hand

    Joined: Dec 25, 2009
    Posts: 72
    Dear Mr. Johnson,

    Thank you about your very precise reply, suppose you are busy then i'll try one TCPView to determine one port,
    goodbye and take care ...
    A. S. Georgie
    Ranch Hand

    Joined: Dec 25, 2009
    Posts: 72
    Peter Johnson wrote:I assume that you have already checked that SQL Server is running. Try using TCP View from sysinternals to determine which port(s) SQL Server has open.


    it was very, very thank you, got it but it woudn't work too, i need your answer dearie ...


    [Thumbnail for TCPView.JPG]

    A. S. Georgie
    Ranch Hand

    Joined: Dec 25, 2009
    Posts: 72
    so, could anybody blow my cobwebs away, i now know it's not just this port number wont work how can i get this straight what it's this then anyway ....
    Peter Johnson
    author
    Bartender

    Joined: May 14, 2008
    Posts: 5843
        
        7

    suppose you are busy

    http://faq.javaranch.com/java/PatienceIsAVirtue

    I looked at the TCPView output you posted. Did you look at it? Tell me, which port is SQL Server using? Now compare that to the port you specified.
    A. S. Georgie
    Ranch Hand

    Joined: Dec 25, 2009
    Posts: 72
    Peter Johnson wrote:
    suppose you are busy

    http://faq.javaranch.com/java/PatienceIsAVirtue

    I looked at the TCPView output you posted. Did you look at it? Tell me, which port is SQL Server using? Now compare that to the port you specified.



    sqlserver using this port 2727 then i changed this in -ds.xml file to this, then 'm having chilling problem ...
    so i guess this port correct but chilling???
    A. S. Georgie
    Ranch Hand

    Joined: Dec 25, 2009
    Posts: 72


    Oh sorry about that, i really didn't mean, you leaned me this valuable great rule, and mine mistake, so hope you forgive my naive action ...


    i will edit next time here, thank you for reviewing
     
    I agree. Here's the link: http://aspose.com/file-tools
     
    subject: netstat, telnet: TCP/IP connection to localhost 1433 failed