Wednesday, September 18, 2019

SSIS - Start job with different account (credencials)

SSIS - Start job with different account (credentials)

1. Create new credentials (existing AD/local user)  at SQLServer->Security-Credentials


2. Create proxy SQLAgent->Proxies->SSIS Package execution (if you want to use it for ssis package)


3. At job step choose run as (created proxy)


No comments:

Post a Comment

Problem with database open ORA-19804, ORA-19809, ORA-03113

1. Try to login to database with SYS AS SYSDBA user. If the instance is idle, run the startup command. 2. If ORA-03113 occured, check the la...