• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

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

 
Ranch Hand
Posts: 72
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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 ...
     
    author
    Posts: 5856
    7
    Android Eclipse IDE Ubuntu
    • Mark post as helpful
    • send pies
      Number of slices to send:
      Optional 'thank-you' note:
    • 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
      Number of slices to send:
      Optional 'thank-you' note:
    • 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
      Number of slices to send:
      Optional 'thank-you' note:
    • Quote
    • Report post to moderator
    Do you mean tools li' this?
     
    A. S. Georgie
    Ranch Hand
    Posts: 72
    • Mark post as helpful
    • send pies
      Number of slices to send:
      Optional 'thank-you' note:
    • 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
      Number of slices to send:
      Optional 'thank-you' note:
    • 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
      Number of slices to send:
      Optional 'thank-you' note:
    • 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
    Posts: 5856
    7
    Android Eclipse IDE Ubuntu
    • Mark post as helpful
    • send pies
      Number of slices to send:
      Optional 'thank-you' note:
    • 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
      Number of slices to send:
      Optional 'thank-you' note:
    • 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
      Number of slices to send:
      Optional 'thank-you' note:
    • Quote
    • Report post to moderator

    Peter Johnson wrote:
    http://faq.javaranch.com/java/PatienceIsAVirtue



    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 just had the craziest dream. This tiny ad was in it.
    a bit of art, as a gift, the permaculture playing cards
    https://gardener-gift.com
    reply
      Bookmark Topic Watch Topic
    • New Topic