• 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

MS SQL Server 2005 Authentication

 
Ranch Hand
Posts: 130
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hello!


I have a Java/Tomcat/Struts application that connects to MS SQL server.

With version 2000 it is working as expected via jtds-1.2.jar driver, downloaded from Sourceforge.

The trouble appears when I'm using ver 2005. I'm using the same jtds-1.2.jar driver.
I set SQL Server Authentication on the server, but when I access to the application via browser I get:



Any experience, suggestion, hint with this kind of MS SQL Server 2005 Authentication?


Regards
 
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 connections over TCP/IP? Out the box SQL Server 2005 is not.
 
Imre Tokai
Ranch Hand
Posts: 130
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
In SQL Server Configuration Manager i found:
Protocols for SQLEXPRESS

Settings are:
Shared Memory Enabled
Named Pipes Disabled
TCP/IP Enabled
VIA Disabled

Seems that server is configured to accept connections over TCP/IP.


Any more hints?

Regards

 
reply
    Bookmark Topic Watch Topic
  • New Topic