February 23, 2009 at 11:22 pm
Hi,
While executing SSIS package manually it works fine. When I schedule a job to run the same SSIS i am getting the below error.
An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80040E4D Description: "Communication link failure".
An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80040E4D Description: "TCP Provider: An existing connection was forcibly closed by the remote host.
An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80040E4D Description: "Login failed for user 'XXX'.
Can any help me on this issue? I am facing this error in producion server. Please help ASAP
Thanks,
Anitha
February 24, 2009 at 2:54 am
I take it you have used SQL Server Agent to scheule the SSIS package?
If so, please confirm the following:
When you imported the Package under Intergration Services what did you select as the Protection Level?
February 24, 2009 at 3:12 am
Thanks for your reply.
The property set for protection level is "EncryptSensitiveWithUserKey"
February 24, 2009 at 3:24 am
Not sure if this is going to help but can you change it to:
'Rely on server storage and roles for access control'
P.s. Not sure if you can change it, you may have to delete and re-import the package.
February 25, 2009 at 7:41 am
Have you tried the above change? Did it help you?
I am having exactly the same problem. The SSIS package is running fine from BIDS but, when scheduled it to run from Sql server agent , it is arising permissions exception.
Please update it if you found any solution.
TIA
February 25, 2009 at 8:29 am
I had the same issue but the following sorted it.
Check out http://support.microsoft.com/kb/918760
SQL DBA
Every day is a school day, and don't trust anyone who tells you any different.
http://sqlblogness.blogspot.co.uk
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply