May 7, 2010 at 9:29 am
I have deployed three packages into SQL Server Integration services. one package calls two others. Everything runs successfully in integration services, but when I create a job to call the parent package I get the following errors:
An OLE DB error has occurred. Error code: 0x80040E4D. An OLE DB record is available. Source: "Microsoft SQL Server Native Client 10.0" Hresult: 0x80040E4D Description: "Login failed for user 'gmeeadmin'.".
I have configuration files with the login information. One thing is I don't have remote access to the server so can't find where the files are to make sure the connection strings are right.
Any advice? Thanks.
Karen
May 7, 2010 at 11:06 am
I would venture to say that the packages contain passwords and that the user executing them is not the user who developed them.
CEWII
May 7, 2010 at 12:15 pm
Actually,
I am the user who developed the packages and I also am the user who is executing them. Like I said, they execute from Integration Services but not from the SQL Server job. Thanks.
Karen
May 7, 2010 at 2:59 pm
When you execute them from SQL Agent and you look at the job history, for the step detail what does the line in the step detail say following this:
Executed as user:
If it isn't your account then you aren't truly running it..
CEWII
May 10, 2010 at 6:29 am
Yes, I am executing the package as myself. I am sysadmin because it is a development environment, so that is why I am perplexed.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply