IN SSIS How to change SQL Authentication to Windows Authentication

Question

HI
I was trying to deploy the packages in to server it is erroring out with the below error .

TITLE: SQL Server Integration Services

---

The operation cannot be started by an account that uses SQL Server Authentication. Start the operation with an account that uses Integrated Authentication. (Microsoft SQL Server, Error: 27123)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&ProdVer=15.00.4223&EvtSrc=MSSQLServer&EvtID=27123&LinkId=20476

---

BUTTONS:

OK

---

can any one help me regarding this issue which i am Facing

Thanks in advance ,
Dinesh

Answer 1

Hi @Dinesh Shetty ,

If you're deploying to a SQL Server with the Deployment Wizard, you have to use Windows authentication; you can't use SQL Server authentication.

If you're deploying to an Azure SQL Database server, you have to use SQL Server authentication or Azure Active Directory authentication; you can't use Windows authentication.

You may change the authentication directly.

Regards，

Zoe

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

You can just change the authentication type of window authentication then connect to database.

as you can see in the image authentication to windows authentication the issue will be fixed you don't need to go through deployment process

Answer 3

The error is clear. 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