June 25, 2012 at 5:42 pm
Hi I am pulling one table data from prod to dev with ssis package. I ran it succesfully in BIDS.while trying to keep it in JOB i am getting error.
PROD box: is running on service account DOMAIN/ADMIN
DEV box : is running on service account LOCAL SYSTEM
I can see a line in error report as
Description: "Login failed for user 'DOMAIN\SERVERNAME$'.
Please suggest me.
Thanks!
June 25, 2012 at 5:50 pm
Which server are you trying to run SSIS package? I wouldn't be surprised if the problem is the account on which your Dev box is running (Local Service Account) as that does not have access to network resources.
June 25, 2012 at 6:17 pm
I am running this package from Dev box.
If the issue is with service account.wht will be the solution
Thanks!
June 25, 2012 at 6:26 pm
Please realize that I am just shooting in the dark here since I can't see from here what you see there. If it is the service account, you should look at using a domain account instead.
I could be wrong here though, so hopefully someone else may have another idea or two as well.
June 25, 2012 at 11:24 pm
Chances are high Lynn is right.
Either change the SQL Server Agent account on the DEV box to a domain account, or use a proxy.
Creating SQL Server Agent Proxies
I would go for the proxy.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply