Showing posts with label AD. Show all posts
Showing posts with label AD. Show all posts

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)


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...