Share via

Package source SSIS Catalog with Windows Authentication only

UrBel 220 Reputation points
2023-07-12T03:57:28.78+00:00

hi all,

anyone know that SSIS Catalog source on SQL Agent Job setting give us option Log on as Windows Authentication only..

great appreciation for all answermsdn_ms_forum

regards,

Urbel

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,342 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,629 questions
0 comments
Accepted answer
  1. ZoeHui-MSFT 39,671 Reputation points
    2023-07-12T09:50:10.74+00:00

    Hi @RASWADI,

    If you want to run the packages stored in SSIS catalog.

    The operation can only be started by an account that uses Windows Authentication.

    In addition, if you want to deploy packages to SSIS catalog, you could only use Windows Authentication.

    Check: https://learn.microsoft.com/en-us/answers/questions/1325014/getting-error-while-deploying-ssis-packages-throug

    Regards，

    Zoe Hui

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

    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.