hello everyone,
so i have created a SSIS package that i want it to run on another server, so example below:
Server A is running the SSIS package, and the destination is Server B, that i want it to run under a certain account, like either the network service or system service, which has the appropriate permissions needed on certain databases, i tried to create a proxy server using Network Service account, however i get the following error message:
Unable to start execution of step 1 (reason: Error authenticating proxy NT AUTHORITY\NETWORK SERVICE, system error: The user name or password is incorrect.). The step failed.
I have the SSIS package set to "Windows Authentication" for the connection manager, but still coming up with that same error message, is there a trick to it or maybe something i am doing wrong?
thanks in advance
October 13, 2020 at 3:55 pm
Are server A and server B in the same domain?
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
October 13, 2020 at 3:55 pm
Hey Phil 🙂
Yes they are in the same Domain
Rather than continuing down the path you're on, I suggest getting SSIS running as a domain service account user. Then you can assign the required privs to the service account and all of your security problems should evaporate.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
October 13, 2020 at 6:02 pm
ahh cool let me try that out, big thank you sir 😉
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply