Getting error while deploying SSIS packages through powershell

Question

When we tried deployment of SSIS packages to sql server with sql login credentials instead of windows authentication through powershell, I am getting below error

"The operation cannot be started by an account that uses SQL Server Authentication. Start the operation with an account that uses Windows Authentication."

do we need to use windows authentication only to deploy or it will work through SQL server authentication also?

Answer 1

Hi @LVS Raghu Vamsi,

You cannot deploy to the SSIS catalog using a SQL login. You must login to the SQL Server using Windows Authentication.

See:
https://learn.microsoft.com/en-us/sql/integration-services/ssis-quickstart-deploy-ssms?view=sql-server-ver16#authentication-methods-for-deployment

Regards，

Zoe Hui

---

If the answer is helpful, please click "Accept Answer" and upvote it.