Greens8301
asked on
SSIS package login failure SQL Server 2005
When I schedule a job, when it runs it calls a .dtsx package. i fails with the following error:
Connection manager "<name>" Description: SSIS Error Code DTS_E_OLEDBERROR.
Hresult: 0x80040E4D Description: "Login failed for user '<user>'.".
Can anyone help me how to approach resolving this error
Is your sql agent running under the local system account?
ASKER
It is not running under local system account
it is running under a domain (AD) account which has server roles set to only "public"
it is running under a domain (AD) account which has server roles set to only "public"
Are you personally able to log into the sql server instance w/ that domain acct?
ASKER
That account is a member of local administrators group
the sql instance doesn't have a local admin group, unless you have added it.
ASKER
This account is a domain account <domain>\<user>
This user is in the adminstration group of the server which hosts the SQL Server database
This user is in the adminstration group of the server which hosts the SQL Server database
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
This is purely SQL Server. There are jobs running on this server which runs successfully
I am beginning to think, if anything to do with the SSIS packet itself, connection manager or something along the line
On the "data source" section of "properties" => "steps" => "edit" will there be anything causing password issue or something along that line
Thanks
I am beginning to think, if anything to do with the SSIS packet itself, connection manager or something along the line
On the "data source" section of "properties" => "steps" => "edit" will there be anything causing password issue or something along that line
Thanks
ASKER
Here is additional message which made me think it is something to do with CONNECTION MANAGER
End Error Error: 2009-01-05 11:00:03.10 Code: 0xC020801C
Source: DFT BecameLate OLE_SRC BecameLate [1]
Description: SSIS Error Code DTS_E_CANNOTACQUIRECONNECT IONFROMCON NECTIONMAN AGER.
The AcquireConnection method call to the connection manager "CSSReports" failed with error code 0xC0202009.
There may be error messages posted before this with more information on why the AcquireConnection method call failed.
End Error Error: 2009-0... The package execution fa... The step failed.
End Error Error: 2009-01-05 11:00:03.10 Code: 0xC020801C
Source: DFT BecameLate OLE_SRC BecameLate [1]
Description: SSIS Error Code DTS_E_CANNOTACQUIRECONNECT
The AcquireConnection method call to the connection manager "CSSReports" failed with error code 0xC0202009.
There may be error messages posted before this with more information on why the AcquireConnection method call failed.
End Error Error: 2009-0... The package execution fa... The step failed.