title: SqlException: Login failed for user (user is not the set user in the connection string)
body: <p>I have built a website using asp.net core 2.1 which works fine on my local machine. However, when I upload the published files to the hosting (1&amp;1 shared windows hosting if it matters at all) I get the following error message</p>
  
  <pre><code>SqlException: Login failed for user 'WINHOST\WINSHUK104BS$'.
  </code></pre>
  
  <p>I have a connection string in my appsettings.json which looks like:</p>
  
  <pre><code>    {
    "Data": {
      "GWebBlog": {
        "ConnectionString": "Server=db778661550.hosting-data.io;Database=db778661550;User id=db778661550;Password=[password-omitted];Trusted_Connection=True;"
      }
    }
  }
  </code></pre>
  
  <p>Any idea as to what on earth is going on? Any help would be very much appreciated. Thank you for your time and expertise, I look forward to your response</p>
  
  <p>******* EDIT ******</p>
  
  <p>I updated the connection string as suggested. However, I have the same error message but the right user. </p>
  
  <pre><code>SqlException: Login failed for user 'db778661550'.
  System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, SqlCredential credential, object providerInfo, string newPassword, SecureString newSecurePassword, bool redirectedUserInstance, SqlConnectionString userConnectionOptions, SessionData reconnectSessionData, bool applyTransientFaultHandling)
  </code></pre>