Win a copy of 97 Things Every Java Programmer Should Know this week in the Java in General forum!
  • 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 all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Paul Clapham
  • Jeanne Boyarsky
  • Junilu Lacar
  • Henry Wong
Sheriffs:
  • Ron McLeod
  • Devaka Cooray
  • Tim Cooke
Saloon Keepers:
  • Tim Moores
  • Stephan van Hulst
  • Frits Walraven
  • Tim Holloway
  • Carey Brown
Bartenders:
  • Piet Souris
  • salvin francis
  • fred rosenberger

MS SQL Server 2005 Authentication

 
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
 
Bartender
Posts: 10336
Hibernate Eclipse IDE 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

 
The only cure for that is hours of television radiation. And this tiny ad:
Devious Experiments for a Truly Passive Greenhouse!
https://www.kickstarter.com/projects/paulwheaton/greenhouse-1
    Bookmark Topic Watch Topic
  • New Topic