Hello friends,

When an email receives in document library,I have to create FBA user for the email sender!!

But I am getting error on MembershipUser user = Membership.CreateUser(username, defaultpassword, senderEmail, defaultQuestion, defaultAnswer, true, out createStatus)  : Unable to connect to SQL Server database.

After troubleshooting code(below) I  found  Membership.CreateUser is taking connection string from machine.config(below,also see in attached image)

_sqlConnectionString "data source=.\\SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|aspnetdb.mdf;User Instance=true"(kindly see attached image)

How to force code to take  connection string from Webapplication web.config or is there any custom code to set connection string ?

 public override void EmailReceived(SPList list, SPEmailMessage emailMessage, String receiverData)
        {
            base.EmailReceived(list, emailMessage, receiverData);

            SPSecurity.RunWithElevatedPrivileges(delegate
            {
                try
                {
                    username = emailMessage.Sender.Trim();
                    query = emailMessage.PlainTextBody.Trim();
                    senderEmail = emailMessage.Sender;

                    MembershipCreateStatus createStatus;

                    username = username.Substring(0, username.LastIndexOf("@"));

                    MembershipUser user = Membership.CreateUser(username, defaultpassword, senderEmail, defaultQuestion, defaultAnswer, true, out createStatus);
                    switch (createStatus)
                    {

                        case MembershipCreateStatus.Success:
                            AddUserToGroup(securityGroup, user.Email, username);
                            AddQuery(user.Email, user.UserName, query);
                            SendEmail(username, senderEmail);
                            break;
                        case MembershipCreateStatus.DuplicateUserName:
                            AddUserToGroup(securityGroup, user.Email, username);
                            AddQuery(user.Email, user.UserName, query);
                            SendEmail(username, senderEmail);
                            break;
                        case MembershipCreateStatus.DuplicateEmail:
                            AddUserToGroup(securityGroup, user.Email, username);
                            AddQuery(user.Email, user.UserName, query);
                            SendEmail(username, senderEmail);
                            break;
                        // break;
                        ////This Case Occured whenver we send invalid mail format
                        //case MembershipCreateStatus.InvalidEmail:
                        //    lblResult.ForeColor = Color.Red;
                        //    lblResult.Text = "The email address you provided is invalid.";
                        //    return "InvalidEmail";
                        //// break;
                        //default:
                        //    lblResult.ForeColor = Color.Red;
                        //    lblResult.Text = "There was an unknown error; the user account was NOT created.";
                        //    return "default";
                        // break;
                    }

                }
                catch (MembershipCreateUserException ex)
                {
                    Trace.TraceInformation("MailProcessor exception: {0}", ex.Message);
                }

            });
        }