title: Connection string in appsettings.json for remote database
body: <p>I have hosting account in <code>plesk</code> panel. I can create and remove a database in hosting panel.</p>
  <p>Now I want to create a database from my local computer using add-migration in code first approach. but the following error occurs:</p>
  <blockquote>
  <p>&quot;login failed for the user [myUserId]&quot;</p>
  </blockquote>
  <p>The connection string in <code>appsettings.json</code> is:</p>
  <pre><code>&quot;CourseConnection&quot;: &quot;Data Source = host-ip,1433; Initial Catalog=mydb;User ID=myuserid;Password=mypassword&quot;     
  </code></pre>
  <p>There are two options to create databases on hosting panel:</p>
  <pre><code>localhost:3306(default for mysql)
  localhost(default for MS sql v13.0...)
  </code></pre>
  <p>I think that provider name is not mentioned in <code>connectionstring</code> but <code>appsettings.json</code> works fine on my local machine without provider name: <code>System.Data.SqlClient.</code></p>