XML Web Servivces AUTHENTICATION

Question

Hi guys. I created a XML Web Service called BugTraker and I have the usernames, passwords and roles stored into SQL server tables called tUsers and tRoles. How can I configure my web server to authenticate users, passwords and roles from SQL Server using the information stored in SQL server? If somebody has some examples I'll appreciate. Thanks Ali Hidalgo