• 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
  • Liutauras Vilda
  • Paul Clapham
Sheriffs:
  • paul wheaton
  • Tim Cooke
  • Henry Wong
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Piet Souris
Bartenders:
  • Mike London

Problem in connecting to database

 
Ranch Hand
Posts: 162
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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...


 
Bartender
Posts: 10336
Hibernate Eclipse IDE Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Please help me with some solution....
 
Paul Sturrock
Bartender
Posts: 10336
Hibernate Eclipse IDE Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Any help please....
 
Bartender
Posts: 2661
19
Netbeans IDE C++ Linux
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Yes, i tried... but still the same problem exists...
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
reply
    Bookmark Topic Watch Topic
  • New Topic