my dog learned polymorphism*
The moose likes JDBC and the fly likes MS SQL Server 2005 Authentication Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of OCA/OCP Java SE 7 Programmer I & II Study Guide this week in the OCPJP forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "MS SQL Server 2005 Authentication" Watch "MS SQL Server 2005 Authentication" New topic
Author

MS SQL Server 2005 Authentication

Imre Tokai
Ranch Hand

Joined: Jun 04, 2008
Posts: 130
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

Joined: Apr 14, 2004
Posts: 10336

Is your server configured to accept connections over TCP/IP? Out the box SQL Server 2005 is not.


JavaRanch FAQ HowToAskQuestionsOnJavaRanch
Imre Tokai
Ranch Hand

Joined: Jun 04, 2008
Posts: 130
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

 
It is sorta covered in the JavaRanch Style Guide.
 
subject: MS SQL Server 2005 Authentication