Thanks to Scott for creating a nice blog. I'm sharing the same:
After getting stuck and lots of hair pulling to setup the membership provider, I figured out that the problem arising during logins and role setup on live server was because of "Application Name" entry in web.config file.
Here it is to help you folks out of the trouble...