I have an ASP.Net MVC site using Entity Framework which is running fine on my local PC. But when I upload it on Azure Web App and run, I get following error:
Unsecured Passwords Format Detected. The Membership Provider that contains the unsecure passwords format is: MySQLMembershipProvider. The obsoleted password format is: Clear.
Problem is I am not using MySQL database at all. The database I am using in this MVC application is SQL Server 2014.
Following is the connection string on my local PC:
<add name="MyEntities" connectionString="metadata=res://*/DAL.MyDB.csdl|res://*/DAL.MyDB.ssdl|res://*/DAL.MyDB.msl;
provider=System.Data.SqlClient;provider connection string="data source=.;initial catalog=MyDB;
integrated security=True;multipleactiveresultsets=True;application name=EntityFramework""
providerName="System.Data.EntityClient" />
And following is the connection string on Azure:
<add name="MyEntities" connectionString="metadata=res://*/DAL.MyDB.csdl|res://*/DAL.MyDB.ssdl|res://*/DAL.MyDB.msl;
provider=System.Data.SqlClient;provider connection string="data source=mydb.database.windows.net;
User ID=mydb_admin;Password=M3@#0l1Mk%uDc;initial catalog=MyDB;integrated security=True;
multipleactiveresultsets=True;application name=EntityFramework"" providerName="System.Data.EntityClient" />
As you can see the difference is only between SOURCE, USER and PASSWORD in both strings. One thing you should note is that there is no SQL Server 2014 on Azure as I am using Azure DB or SQL DB (what ever it is called). Could it be due to this?
How can I fix this issue?