Login failed for user 'sa'. WebSecurity.InitializeDatabaseConnection

318 Views Asked by At
public class MvcApplication : System.Web.HttpApplication
{
    protected void Application_Start()
    {

        AreaRegistration.RegisterAllAreas();
        FilterConfig.RegisterGlobalFilters(GlobalFilters.Filters);
        RouteConfig.RegisterRoutes(RouteTable.Routes);
        BundleConfig.RegisterBundles(BundleTable.Bundles);
        if (!WebMatrix.WebData.WebSecurity.Initialized)
        {
            WebSecurity.InitializeDatabaseConnection("DefaultConnection", "UserProfile", "UserId", "UserName", autoCreateTables: true);
        }
        WebSecurity.CreateUserAndAccount("Admin", "Admin");
        Roles.CreateRole("Administrator");
        Roles.AddUserToRole("Admin", "Administrator");

    }

}





<add name="DefaultConnection" connectionString="Data Source=DEV001;Initial Catalog=SimpleMembership;Persist Security Info=True;User ID=sa;Password=***********" providerName="System.Data.SqlClient" />

I couldnt see what is wrong. I can connect to database with SQL management studio or in vs2013 server explorer. I copied connection string from properties in server explorer defaultConnection. But already ı cant login for same password and user when ı run application . I get error

Login failed for user 'sa'.

source error.

 if (!WebMatrix.WebData.WebSecurity.Initialized)
    {
        WebSecurity.InitializeDatabaseConnection("DefaultConnection", "UserProfile", "UserId", "UserName", autoCreateTables: true);
    }

Thanks for help

0

There are 0 best solutions below