SQL Trusted Authentication

[Ram Bu]

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