title: Api error System.ArgumentException: Format of the initialization string does not conform to specification starting at index 258
body: <p><a href="https://i.stack.imgur.com/TyleN.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/TyleN.png" alt="program.cs ConnectionString" /></a>
  <a href="https://i.stack.imgur.com/rWLUI.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/rWLUI.png" alt="Error screenshot" /></a></p>
  <p>I'm currently trying to work through connecting to a cloud-based database with an Api I've found a lot of similar questions but all the fixes I have found on stack haven't worked for my solution any help would be appreciated
  [Error that the Api is showing - program.cs ConnectionString ]</p>
  <p>ConnectionString in <code>appsettings</code>:</p>
  <pre><code>
      &quot;ConnectionStrings&quot;: {
          &quot;MyContext&quot;: 
      &quot;Server=tcp:removed.database.windows.net,1433;Initial Catalog=kawamaraedb;Persist Security Info=False;User  ID=Removed;Password='Removed';MultipleActiveResultSets=False;Encrypt=True;TrustServerCertificate=False;Connection Timeout=30;&quot;
    },
  </code></pre>
  <p>ID and Password are correct</p>
  <p>My fix</p>
  <p>I figured it out i had to manually type in the connection string from azure and take out alot of the added code string</p>
  <p>FROM THIS:</p>
  <p>Server=tcp:sql.database.windows.net,1433;Initial Catalog=YOUR DB;Persist Security Info=False;User ID={USER};Password={your_password};MultipleActiveResultSets=False;Encrypt=True;TrustServerCertificate=False;Connection Timeout=30;</p>
  <p>TO THIS</p>
  <p>&quot;Data Source=tcp:sql.database.windows.net,1433;Initial Catalog=YOUR DB;User Id={USER};Password={YOUR PASSWORD}&quot;</p>