It should be setup automatically.. once someone makes a payment for a membership the eStore plugin will create the membership account and send an email which will contain a unique link to complete the registration (choose username and password). Did you hook up the payment button created in eStore for a particular membership level that is explained in this post?