I am building an application using ASP.NET MVC and everything works fine on my local setup (localhost). I'm using GoDaddy for hosting and when I try to register as a user for my application, I get this error:
Unable to complete operation. The supplied SqlConnection does not specify an initial catalog or AttachDBFileName.
So I checked my web.config and it does actually provide those two arguments/parameters in the connection string:
<add name="DefaultConnection"
connectionString="Data Source=ip-of-database;
AttachDbFilename=|DataDirectory|\project-20151104031949.mdf;
Initial Catalog=project-20151104031949;User Id=user; Password=password"
providerName="System.Data.SqlClient"/>
I am using the Entity Framework (code first).
I looked at this Stackoverflow question as well as the documentation for ASP.NET deployment but either of them didn't really help.
Any suggestions?