Win a copy of Re-engineering Legacy Software this week in the Refactoring forum
or Docker in Action in the Cloud/Virtualization forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Problem in connecting to database

 
Neeba Rebbaca
Ranch Hand
Posts: 162
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
i tried to connect database (sql server 2000) through servlet.But its giving me "[Microsoft][sqlserver jdbc driver] error establishing socket"

I have given correct Port number(1433) and server name...

Please help me solving this issue...


Even its not launching within the server...


 
Paul Sturrock
Bartender
Posts: 10336
Eclipse IDE Hibernate Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Is your server configured to accept TCP/IP traffic? Is your server configured to allow SQL Server authentication? Is there any sort of firewall between your application and the server? Is the server running?
 
Neeba Rebbaca
Ranch Hand
Posts: 162
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
My server is not in n/w.yes i allow sql authentication.

What you mean by firewall between application and server???
 
Neeba Rebbaca
Ranch Hand
Posts: 162
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Please help me with some solution....
 
Paul Sturrock
Bartender
Posts: 10336
Eclipse IDE Hibernate Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

My server is not in n/w

I don't understand what "n/w" means.


yes i allow sql authentication.

OK, so is your server configured to accept TCP/IP traffic?


What you mean by firewall between application and server???

Just that - are these any firewalls between whatever machine your application runs on and whatever machine your SQL Server instance lives on.

Also, is your SQL Server 2000 instance patched to the latest version? Very (very!) early versions of SQL Server 2000 had issues with TCP/IP DLLs missbehaving.

 
Neeba Rebbaca
Ranch Hand
Posts: 162
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
1. I have checked, both Server network utility and client network untility for TCP/IP port(its 1433).
2. I have turned off the wirefall.
3. Allowed exception for Port 1433(giving Name as "1433" , Port number as "1433" )
4. Now my server is not in Network , so i tried to launch the application from inside the server itself.


How to check whether it accepTCP/IP traffic?
 
Neeba Rebbaca
Ranch Hand
Posts: 162
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Any help please....
 
Jan Cumps
Bartender
Posts: 2584
11
C++ Linux Netbeans IDE
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Neeba Rebbaca wrote:1...
4. Now my server is not in Network , so i tried to launch the application from inside the server itself.
In that case, try to replace 'testserver' by '127.0.0.1'.
 
Neeba Rebbaca
Ranch Hand
Posts: 162
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Yes, i tried... but still the same problem exists...
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic