I found it and working fine
In middle tier,
System.Web.Security.MembershipUser newUser = System.Web.Security.Membership.CreateUser(email, strpassword, email)
In Web.config
<connectionStrings>
<add name="MySqlConnection" connectionString="Data Source=xxxx-PC\SQLEXPRESS,1978;Initial Catalog=xxxx;Password=xxxxx;User ID=sa;MultipleActiveResultSets=True;" />
</connectionStrings>
<system.web>
<machineKey validationKey="4064C4EE1751795629390787C3222886C6111911" decryptionKey="2065E0EECFECA8EE8CB888BF8C5E2E7F7C52C816FF916227" decryption="3DES" validation="SHA1" />
<membership defaultProvider="SqlProvider" userIsOnlineTimeWindow="15">
<providers>
<clear />
<add
name="SqlProvider"
type="System.Web.Security.SqlMembershipProvider"
connectionStringName="MySqlConnection"
applicationName="DotNetNuke"
enablePasswordRetrieval="true"
enablePasswordReset="false"
requiresQuestionAndAnswer="false"
requiresUniqueEmail="true"
minRequiredPasswordLength="7"
minRequiredNonalphanumericCharacters="0"
passwordFormat="Encrypted" />
</providers>
</membership>
And in SP,
INSERT INTO xxxxx_users (Username, FirstName, LastName, IsSuperUser, Email,DisplayName, UpdatePassword) VALUES(@Username, @FName, @LName , 0, @Email, @AName , 0)
SELECT @dnnuserid = userid FROM dnnverve_Users WHERE username = @Username
INSERT INTO xxxxx_UserPortals (userId, PortalId, CreatedDate) VALUES(@dnnuserid, @PortalId, GETDATE())
INSERT INTO xxxxx_UserRoles (userId, roleId) SELECT @dnnuserid, roleId FROM dnnverve_RolesWHERE RoleName = 'Registered Users'
Set @RetUserid = @dnnuserid
Return @RetUserid