This week's book giveaways are in the Java EE and JavaScript forums.
We're giving away four copies each of The Java EE 7 Tutorial Volume 1 or Volume 2(winners choice) and jQuery UI in Action and have the authors on-line!
See this thread and this one for details.
The moose likes Tomcat and the fly likes SQL Trusted Authentication Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of The Java EE 7 Tutorial Volume 1 or Volume 2 this week in the Java EE forum
or jQuery UI in Action in the JavaScript forum!
JavaRanch » Java Forums » Products » Tomcat
Bookmark "SQL Trusted Authentication" Watch "SQL Trusted Authentication" New topic
Author

SQL Trusted Authentication

Ram Bu
Greenhorn

Joined: Jul 15, 2005
Posts: 13
Hi,

Is it possible to setup Tomcat's REALM to use trusted authentication in order to access SQL Server database. Currently, you have to pass userid and password in order to talk to the database server.

<Realm className="org.apache.catalina.realm.JDBCRealm" debug="99" driverName="com.microsoft.jdbc.sqlserver.SQLServerDriver" connectionURL="jdbc:microsoft:sqlserver://databaseServer;DatabaseName=databaseName;SelectMethod=Cursor" connectionName="userId" connectionPassword="password" userTable="users" userNameCol="username" userCredCol="password" userRoleTable="user_role" roleNameCol="role_name" />

If it is possible (using trusted authentication), can some guru show me how to do this?

Thank you,
R
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: SQL Trusted Authentication