title: How to allow sql athentication to run ssis packages in asp.net mvc
body: <p>I have created an SSIS project with multiple packages, they work well in my development machine and also when deployed to the server of the organization i work for (running them with SQL management studio and a given user within the active directory of the company).</p>
  
  <p>I also have created an asp.net web application to run the packages, which runs without issues the packages with the following ConnectionStrings:</p>
  
  <pre><code>&lt;add name="DBQueries" connectionString="Data Source=Server;Initial Catalog=SSISDB;Integrated Security=SSPI;" providerName="System.Data.SqlClient" /&gt;
  </code></pre>
  
  <p>But as soon as i set SQL Server authentication and change the ConnectionStrings to the next one it just doesn't work:</p>
  
  <pre><code>&lt;add name="DBQueries" connectionString="Data Source=Server;Initial Catalog=SSISDB;user=user;password=password;" providerName="System.Data.SqlClient" /&gt;
  </code></pre>
  
  <p>The company won't let the application to have the ConnectionString with Integrated Security. Its there a workaround or anything i can do in the configuration of the SQL user or the SSIS packages?</p>
  
  <p><strong>EDIT:</strong> Debugging i found this:</p>
  
  <pre><code>The operation cannot be started by an account that uses SQL Server Authentication. Start the operation with an account that uses Integrated Authentication.
  </code></pre>