Win a copy of The Way of the Web Tester: A Beginner's Guide to Automating Tests this week in the Testing forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Trouble Connecting to MSSQL Server 2005 (Struts+Hibernate): TCP/IP Error

Eric Sidarta
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Dear all,

I just had a problem connecting to MS-SQL Server 2005.
My application is based on Struts and connecting to database using Hibernate 2.1.6. My conection use SQLJDBC 1.1.1501
It is run under WINDOWS 2000 Advanced Server SP4

However, the application very good was working previously (never had problem like this)...then several days ago this thing happened.

TCP/IP connection failed to host:localhost"

It has something that said "connection time out"

My Sql Server TCP/IP enabled and port 1433

There is another problem here.
Because I cant connect 1433.I tried this command.

telnet localhost 1433 .It is failed.

I used netstat -an

it says that the port 1433 is in LISTENING mode.
My application works OK by the way, it just CANT CONNECT with the Database.

I tried using the exact same installed application on another computer, connecting to the database, but it was working fine(!)

So where exactly the problem occur? the database or the application?

Anyone has any solution? Thanks in advance
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic