jQuery in Action, 2nd edition*
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 Android Security Essentials Live Lessons this week in the Android 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
 
Similar Threads
No access to SQL Express 2005/2008 database
pre or post filter j_security_check
Tomcat 7 : JSESSIONID not being sent to client
JBoss 4.0 and MSSQL Server 2000
Problem with Connectivity