No need to install all .net membership services when all you’re using is the SQLRoleProvider (which is usually the case for me at CSU, where I’m relying on the ActiveDirectoryMembershipProvider). So, here’s the basic command line syntax for installing the sql role provider:
First, switch to the appropriate directory:
aspnet_regsql -S <server> -U <user> -P <password> -A r -d <database>
Now, if you’re like me and want to paste the above into the command window, just use this key command: ALT+SPACE+E+P to paste. Use the ^ character to escape special chars.