I am developing many tools using .NET EXE and SSIS packages.
My question is,
I want to run all the scheduler (EXE and SSIS Packages) using service account.
I have two accounts.
One is "Admin" Account.
Two is "Service" Account.
Admin Account password will change every 40 days.
Service Account password won't change (Static and Strong Password).
So, I am planning to use service account for the scheduling the task.
For this, i am logging in server using Admin Account and then configure the scheduling the task using service account.
I am facing the problem below.
- Whenever the admin account password getting expired, my task scheduler will stop or getting error due admin password expired.
- If i use both are Service Account (Logging the server and scheduling the task, then it will work fine) - But, this is not advisable. Because, Service account password is Static and it may hack/share the credentials to anyone.
- I want the solution like below.
I am always should logging using Admin account, and configure the task scheduler should use Service Account.
Is it possible to do the above...?
Or what is the alternative solution to run the task using service account.