If you run SQL profiler what do you observe? -----Original Message----- From: Matthieu DELAHAIS [mailto:[EMAIL PROTECTED] Sent: Thursday, March 13, 2003 12:58 AM To: [EMAIL PROTECTED] Subject: Realm with MS SQL Server
Hi all, I'm trying to use Realm with MS SQL Server. So I follow the Realm-HowTo. I configure my server.xml file in adding the following lines at the end of the file : <Realm className="org.apache.catalina.realm.JDBCRealm" debug="99" driverName="com.microsoft.jdbc.sqlserver.SQLServerDriver" connectionURL="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=Jetspe edUnis;SelectMethod=cursor" connectionName="basename" connectionPassword="password" userTable="users" userNameCol="user_name" userCredCol="user_pass" userRoleTable="user_roles" roleNameCol="role_name"/> I created the tables into SQL Server and I inserted some users and roles. But, when I try to connect whit this users on tomcat (http://localhost/examples/jsp/security/protected/login.jsp), i have the message : Invalid username and/or password, please try again. Did I forget something? Any help will be welcome! Thanks in advance Matthieu ___________________________________________________________ Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en fran�ais ! Yahoo! Mail : http://fr.mail.yahoo.com --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
