title: Change .mdf local database and transfer to SQL Server 2014 with user sa .. later on I want to upload my project to hosting or iis host
body: <p>I have faced issues after finish my ASP.NET MVC &amp; Entity Framework project.</p>
  <p>I have changed the connection string and point to my SQL Server with user <code>sa</code> to generate the database.</p>
  <p>I get this error:</p>
  <blockquote>
  <p>System.Data.SqlClient.SqlException: 'Cannot find the object &quot;dbo.Comments&quot; because it does not exist or you do not have permissions.'</p>
  </blockquote>
  <p>When I return to the local connection string, everything is working fine again.</p>
  <p>Local connection string</p>
  <pre><code>&lt;connectionStrings&gt;
      &lt;add name=&quot;DefaultConnection&quot; 
           connectionString=&quot;Data Source=(LocalDb)\MSSQLLocalDB;
                             AttachDbFilename=|DataDirectory|\aspnet-ElectronicHarajPro-20200323090456.mdf;
                             Initial Catalog=aspnet-ElectronicHarajPro-20200323090456;
                             Integrated Security=True&quot; 
           providerName=&quot;System.Data.SqlClient&quot; /&gt;
  &lt;/connectionStrings&gt;
    
  </code></pre>
  <p>SQL Server connection string:</p>
  <pre><code>&lt;connectionStrings&gt;
      &lt;add name=&quot;DefaultConnection&quot; 
           connectionString=&quot;Data Source=(LocalDb)\MSSQLLocalDB;
                             Server=MININT-3V9GJ88;
                             Database=ElectronicHarajPro;
                             User Id=sa;Password=123456;
                             Integrated Security=false&quot; 
           providerName=&quot;System.Data.SqlClient&quot; /&gt;
  &lt;/connectionStrings&gt;
  </code></pre>