title: Execute SSIS package from Java calling Catalog procedures
body: <p>so what Im trying to do is call a stored procedure <code>usp_Something</code> that contains something like this</p>
  
  <pre><code>EXEC [SSISDB].[catalog].[create_execution]
      @folder_name = @f_name,
      @project_name = @pro_name,
      @package_name = @pack_name,
      @execution_id = @exec_id output
  
  EXEC [SSISDB].[catalog].[set_execution_parameter_value] @exec_id,  @object_type=50, @parameter_name=N'SYNCHRONIZED', @parameter_value=1
  
  EXEC [SSISDB].[catalog].[start_execution] @exec_id
  --SET @output_execution_id = @exec_id
  </code></pre>
  
  <p>In Java im doing a connection with JDBC Driver using a SQL Server authentication trying to call <code>usp_Something</code> procedure. But I get an error</p>
  
  <blockquote>
    <p>The operation cannot be started by an account that uses SQL Server
    Authentication. Start the operation with an account that uses Windows
    Authentication.</p>
  </blockquote>
  
  <p>Now, I know you need to use Windows authentication to run packages, but is there any workaround? I've been told not to use Windows authentication so I need a way for this to work using SQL Server authentication</p>