File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
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 Java 8 in Action this week in the Java 8 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

 
Consider Paul's rocket mass heater.
 
subject: MS SQL Server 2005 Authentication
 
Similar Threads
App Performance : MS SQL 2005 vs MS SQL 2008
No Current Row in the ResultSet when Migrating from SQL 2000 to 2005
Faint, failure to connect ms sqlserver with jtds
[IBM][SQLServer JDBC Driver]This driver is locked for use
Connecting to MS-SQL Server 2005 using IPv6 address