public void CreateNewSiteNewSQLOwner(string SiteUrl, string SiteTitle, string SiteDescription, string SiteTemplate, string OwnerFirstName, string OwnerLastName, string OwnerLogin, string OwnerPassword, string PwdQuestion, string PwdAnswer, string OwnerEmail, string AppName, string WebAppUrl, string ProviderName, uint nLCID) { SQLMembershipService SQLService = null; SharePointService SPService = null; try { SQLService = new SQLMembershipService(); SPService = new SharePointService(); string siteownerLogin = ProviderName + ":" + OwnerLogin; string siteownerName = OwnerFirstName + " " + OwnerLastName; string question = PwdQuestion; string answer = PwdAnswer; // create SQL user SQLService.CreateUser(AppName, OwnerLogin, OwnerPassword, OwnerEmail, question, answer, false); // create mapping for new site SQLService.CreateSiteMapping(AppName, SiteUrl); // set application name for sqlmembership provider. string oldAppName = SQLService.GetApplicationName(); SQLService.SetApplicationName(AppName); //create site with user as site owner SPService.hstCreateSite(WebAppUrl, SiteUrl, SiteTitle, SiteDescription, nLCID, SiteTemplate, siteownerLogin, siteownerName, OwnerEmail, null, null, null, true); // restore application name for sqlmembership provider. SQLService.SetApplicationName(oldAppName); } finally { if (SQLService != null) { SQLService.Dispose(); } if (SPService != null) { SPService.Dispose(); } } }