ssis scheduled job Login failed for user 'Domain\Name$'

Question

question

jhowe asked Aug 28, '12

ssis scheduled job Login failed for user 'Domain\Name$'

Hi all, i'm trying to execute a scheduled job that runs an SSIS package but am getting nowhere. The account that SSIS is running under has a server login on the servers it is trying to access. What am i missing??? Date 28/08/2012 13:19:27 Log Job History () Step ID 1 Server SERVER Job Name Step Name Duration 00:00:02 Sql Severity 0 Sql Message ID 0 Operator Emailed Operator Net sent Operator Paged Retries Attempted 0

 Message Executed as user: \SYSTEM. Microsoft (R) SQL Server Execute Package Utility Version 10.50.1600.1 for 64-bit Copyright (C) Microsoft Corporation 2010. All rights reserved. Started: 13:19:27 Error: 2012-08-28 13:19:29.70 Code: 0xC0202009 Source: DataWarehouseLoad Connection manager "" Description: SSIS Error Code DTS_E_OLEDBERROR. 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 'DOMAIN\NAME$'.". End Error Error: 2012-08-28 13:19:29.70 Code: 0xC020801C Source: Add extra data Get Unfulfilled reasonsx [1] Description: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "" 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: 2012-08-28 13:19:29.70 Code: 0xC0047017 Source: Add extra data SSIS.Pipeline Description: component "Get Unfulfilled reasonsx" (1) failed validation and returned error code 0xC020801C. End Error Error: 2012-08-28 13:19:29.70 Code: 0xC004700C Source: Add extra data SSIS.Pipeline Description: One or more component failed validation. End Error Error: 2012-08-28 13:19:29.70 Code: 0xC0024107 Source: Add extra data Description: There were errors during task validation. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 13:19:27 Finished: 13:19:29 Elapsed: 2.031 seconds. The package execution failed. The step failed.

sql-server-2008 ssis sql-server-2008-r2

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 1 · 2012-08-28T13:07:45Z

yogirk answered Aug 28, '12

When you schedule the SSIS Package as a SQL Agent job, it runs under the context of the service account that runs SQL Server Agent service. You might want to check if the service account has enough permissions. You can use SQL Agent proxies to run the package under a different security context.

1

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Usman Butt commented · Aug 28, 2012 at 01:29 PM

+1. This is mostly the case.

0 ·

Answer 2 · 2012-08-28T18:31:07Z

SirSQL answered Aug 28, '12

Based on your error message it appears as though the SQL Server Agent service is running under the NETWORK SERVICE account. This means that it will connect to the remote computer under the context of the machine account in the domain. You can either grant access to the machine account on the remote server or do as yogirk suggests and create a SQL Agent proxy to run the package (which will help lock down security)

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 3 · 2014-11-05T04:58:38Z

manadkarni answered Nov 5, '14

I am facing a similar problem. I have a Proxy created as well, however the scheduled job fails and the log says 'Environment Variable:null. Login to account 'domain\acc_name failed'. I also tried resetting the password for the account. Still doesn't work. Is the issue regarding permissions for the service account?

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

question