Win a copy of Think Java: How to Think Like a Computer Scientist this week in the Java in General forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

MS SQL Server 2005 Authentication

 
Imre Tokai
Ranch Hand
Posts: 130
  • Mark post as helpful
  • send pies
  • 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
 
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 connections over TCP/IP? Out the box SQL Server 2005 is not.
 
Imre Tokai
Ranch Hand
Posts: 130
  • Mark post as helpful
  • send pies
  • 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

 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic