aspose file tools*
The moose likes JDBC and the fly likes Windows Authentication or SQL authentication for Spring JDBC connection Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Windows Authentication or SQL authentication for Spring JDBC connection" Watch "Windows Authentication or SQL authentication for Spring JDBC connection" New topic
Author

Windows Authentication or SQL authentication for Spring JDBC connection

Abhishekshri Shrivastava
Ranch Hand

Joined: Jan 13, 2011
Posts: 31
Hi,

I am creating a JDBC connection to MY SQL server Database. DBA has made it windows authenticated.
It's a web application and need to be deployed on a remote server.
I know windows authentication is good because of AD account creation / deletion stuff. We delete the AD account and SQL server account gets deleted.

But I am worried about JDBC connection. It's to be deployed on remote server.
In case of windows authentication either from jdbc or jtds I get error and solutions(on many blogs) say to add a dll in my lib path.

Please suggest me Pros and Cons of both. Which authentication is suggested when a remote db connection is expected(apps is to be deployed on another server)?

Thanks,
Abhishek Shrivastava
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Windows Authentication or SQL authentication for Spring JDBC connection