May 12, 2008 at 1:13 am
Hi All
I'm new in SSIS Development. I have manage to design and deploy my Package to production SQL(MSDB) Security rely on server storage.
The problem start when I start scheduling in SQL JOB I'm getting the following error.
Executed as user: UCC-SQL\SYSTEM. ...ion 9.00.3042.00 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 8:57:01 AM Error: 2008-05-12 08:57:02.08 Code: 0xC0202009 Source: Test_deployment_Table Connection manager "BLAKE-DBN12.Staging" 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 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 'BLAKE\UCC-SQL$'.". End Error Error: 2008-05-12 08:57:02.08 Code: 0xC020801C Source: Data Flow Task Test_Deployment [97] ... The package execution fa... The step failed.
What can I do to avoid this.
May 12, 2008 at 10:25 am
Hi,
Do you have sufficient permission to use sql server agent ?
May 13, 2008 at 12:14 am
Yes I do have sufficient permission.
I'm thinking maybe its could be that SQL Server is running under Local System. I'ven't try changing its to use different account.
May 13, 2008 at 7:04 am
Hey try to create a login in sql and run the package under it.Also create a proxy account if you are running it as a job
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply