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.
IN SSIS How to change SQL Authentication to Windows Authentication
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
3 answers
Sort by: Most helpful
-
-
ZoeHui-MSFT 33,051 Reputation points
2022-05-25T02:45:54.94+00:00 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.
-
Krishna Shah 0 Reputation points
2024-02-14T07:09:31.4833333+00:00 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