Hi All,

I am not able to do Realm Authentication using sql server 2005.

I am attaching the code which i have written in server.xml

<Realm className="org.apache.catalina.realm.JDBCRealm"
driverName="com.microsoft.jdbc.sqlserver.SQLServerDriver"
connectionURL="jdbc:microsoft:sqlserver://ebizetl;DatabaseName=ilex_final;SelectMethod=Cursor"
connectionName="sa" connectionPassword="Mind1234"
userTable="lo_user" userNameCol="lo_us_name" userCredCol="lo_us_pass"
userRoleTable="lo_us_authentication" roleNameCol="lo_ro_role_name" />

Please help me as soon as possible

Thanks

Atul