Win a copy of Mesos in Action this week in the Cloud/Virtualizaton forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

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

 
A. S. Georgie
Ranch Hand
Posts: 72
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
    Posts: 5852
    7
    Android Eclipse IDE Ubuntu
    • Mark post as helpful
    • send pies
    • Quote
    • Report post to moderator
    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.

     
    A. S. Georgie
    Ranch Hand
    Posts: 72
    • Mark post as helpful
    • send pies
    • Quote
    • Report post to moderator
    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
    Posts: 72
    • Mark post as helpful
    • send pies
    • Quote
    • Report post to moderator
    Do you mean tools li' this?
     
    A. S. Georgie
    Ranch Hand
    Posts: 72
    • Mark post as helpful
    • send pies
    • Quote
    • Report post to moderator
    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
    Posts: 72
    • Mark post as helpful
    • send pies
    • Quote
    • Report post to moderator
    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 ...
    TCPView.JPG
    [Thumbnail for TCPView.JPG]
     
    A. S. Georgie
    Ranch Hand
    Posts: 72
    • Mark post as helpful
    • send pies
    • Quote
    • Report post to moderator
    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
    Posts: 5852
    7
    Android Eclipse IDE Ubuntu
    • Mark post as helpful
    • send pies
    • Quote
    • Report post to moderator
    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
    Posts: 72
    • Mark post as helpful
    • send pies
    • Quote
    • Report post to moderator
    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
    Posts: 72
    • Mark post as helpful
    • send pies
    • Quote
    • Report post to moderator


    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
     
    • Post Reply
    • Bookmark Topic Watch Topic
    • New Topic