Community Server shared membership

Step to configure Community Server with an existing membership database.

Create Community Server Database manually

Step 1.) Add a new connection string in CS web.config that points to your sites membership database.

Step 2.)Update your providers
(Membership, Profile, and/or Role) to use the new connection string

Step 3.) Change the CS application name to your sites application name.
The applicationName property exists in Membership, Profile and Role Provider tags.
AND in the database cs_SiteSettings.ApplicationName.


Step 3.)Add CS stored procs to you mainsites database.
* cs_Membership_GetUsersByName
* cs_Membership_IsUserNameTaken
* cs_Membership_RenameUser
* cs_Membership_ChangePasswordAnswer
* cs_Membership_ValidatePasswordAnswer
* cs_Profile_GetPropertiesForUsers
* cs_Role_Get
* cs_Roles_CreateRole
* cs_Roles_UpdateRole
* cs_Roles_GetRoleIdsForUsers
* cs_Roles_Get

Step 4.)Copy CS roles to you mainsites aspnet_Roles table.
make sure to enable identity insert

Step 5.)Copy CS Users to you mainsites aspnet_Users table.
make sure to enable identity insert

Step 6.)Copy CS User to Roles mapping to you mainsites aspnet_UsersInRoles table.
make sure to enable identity insert