If there is an Asp.net application running all you need is a configuration and the .NET run time will take care of roles and permissions for you. Check below for details.

http://www.sqlservercentral.com/Forums/Topic779867-364-1.aspx