• 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
  • Tim Cooke
  • paul wheaton
  • Jeanne Boyarsky
  • Ron McLeod
Sheriffs:
  • Paul Clapham
  • Liutauras Vilda
  • Devaka Cooray
Saloon Keepers:
  • Tim Holloway
  • Roland Mueller
Bartenders:

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
     
    Eliminate 95% of the weeds in your lawn by mowing 3 inches or higher. Then plant tiny ads:
    Smokeless wood heat with a rocket mass heater
    https://woodheat.net
    reply
      Bookmark Topic Watch Topic
    • New Topic