title: SmarterAsp.Net Connection String
body: <p>I have a program I wrote in ASP.Net MVC.  When I run the file inside Visual Studio it runs great.  I uploaded the file on SmarterAsp.Net.  Now everything comes up except my database part of the file and I get an error 52 when I bring up the database part.  Here is the link to my site.  <a href="http://dwmurphy67-001-site2.smarterasp.net/" rel="nofollow">http://dwmurphy67-001-site2.smarterasp.net/</a>.  When you click on the tab that says patches that's where my database should come up.  This is what SmarterAsp.Net gave me for the connection strings:</p>
  
  <p>ASP.net</p>
  
  <p>"Data Source=SQL5011.Smarterasp.net;Initial Catalog=DB_9B2856_Product;User Id=DB_9B2856_Product_admin;Password=YOUR_DB_PASSWORD;" </p>
  
  <p>Classic ASP</p>
  
  <p>"Provider=SQLOLEDB;Data Source=SQL5011.Smarterasp.net;Initial Catalog=DB_9B2856_Product;User Id=DB_9B2856_Product_admin;Password=YOUR_DB_PASSWORD;" </p>
  
  <p>This is what I have in my web.config file:</p>
  
  <p></p>
  
  <pre><code> &lt;add name= "Product" connectionString="Data Source=SQL5011.Smarterasp.net;Initial Catalog=DB_9B2856_Product;User Id=DB_9B2856_Product_admin;Password:#######"/&gt;
  &lt;add name="ProductEntities" connectionString="metadata=res://*/Models.Product.csdl|res://*/Models.Product.ssdl|res://*/Models.Product.msl;provider=System.Data.SqlClient;provider connection string=&amp;quot;data source=(LocalDB)\v11.0;attachdbfilename=|DataDirectory|\Product.mdf;integrated security=True;MultipleActiveResultSets=True;App=EntityFramework&amp;quot;"
    providerName="System.Data.EntityClient" /&gt;
  &lt;add name="EmailmeContext" connectionString="Data Source=(localdb)\v11.0; Initial Catalog=EmailmeContext-20140604141117; Integrated Security=True; MultipleActiveResultSets=True; AttachDbFilename=|DataDirectory|EmailmeContext-20140604141117.mdf"
    providerName="System.Data.SqlClient" /&gt;
  </code></pre>
  
  <p></p>
  
  <p>Can anyone help me with this?</p>
  
  <p>I know somewhere my connection string is wrong where I'm hooking up to the database on SmarterAsp.Net.</p>