aspose file tools*
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 Spring in Action this week in the Spring 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
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: SQL Trusted Authentication