Windows Authentication and Custom SQL Profile/Role membership
===

How would it be best to use windows authentication with custom sql profile and role membership?  We currently grab windows.identity.name (domain/username) and look up information i sql server to retrieve profile and role information.  I would like to make things more efficient by utilizing membership providers.  

How would I go about doing this?  We currently develop within corporate environment using mvc and webforms.