Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
nguyenl
Posting Yak Master
128 Posts |
 Posted - 2009-01-15 : 18:53:35
|
| Hi,Please help. I have 2 servers. I have an SSIS package that extracts data from server A and moves it to Server B. This SSIS package is a "file System". When I run it manually through Business Intelligence it works fine. Whn I use a Job agent to run this SSIS it breaks. I have set protection level to not save sensitive data.The error I get is:Date,Source,Severity,Step ID,Server,Job Name,Step Name,Notifications,Message,Duration,Sql Severity,Sql Message ID,Operator Emailed,Operator Net sent,Operator Paged,Retries Attempted01/15/2009 15:22:08,Build INFO_PROP,Error,0,HIGHLANDERVM,Build INFO_PROP,(Job outcome),,The job failed. The Job was invoked by User THURSTON\Nguyenl. The last step to run was step 1 (BUILD INFO_PROP).,00:00:03,0,0,,,,001/15/2009 15:22:08,Build INFO_PROP,Error,1,HIGHLANDERVM,Build INFO_PROP,BUILD INFO_PROP,,Executed as user: HIGHLANDERVM\SYSTEM. ....00.3042.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 3:22:09 PM Error: 2009-01-15 15:22:10.69 Code: 0xC0202009 Source: Info_PropBuild Connection manager "HIGHRISEVM.INFO_PROP" 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: "Login failed for user 'THURSTON\HIGHLANDERVM$'.". End Error Error: 2009-01-15 15:22:10.69 Code: 0xC020801C Source: ADDRESS Move to HighlanderVM OLE DB Source [20] Description: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "HIGHRISEVM.INFO_PROP" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call... The package execution fa... The step failed. |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-01-15 : 20:24:03
|
| Is SQL agent running in domain account? Does the account has privileges for DTSX file? |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-01-15 : 22:55:56
|
| does a vaild login exist for 'THURSTON\HIGHLANDERVM$' account? |
|
|
|
nguyenl
Posting Yak Master
128 Posts |
Posted - 2009-01-16 : 11:12:43
|
| Thanks for the replies.Yes, I created a specific local account to run this Job Agent. It is valid. If I create a login called Admin to run this job, do I have to also create this same local account on the other server?Yes the server is in the domain. You have to grant the SQL agent privilege to the DTSX file manually? |
|
|
|
nguyenl
Posting Yak Master
128 Posts |
Posted - 2009-01-16 : 14:45:17
|
| I believe the problem here is that the Job agent can't target the second server. I disabled all object relating to the second server and it works fine. How do I configure this? Please help. Under Job agent properties, the "Target Multiple Servers" is greyed out.Thanks |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-01-16 : 15:17:03
|
| As I said , You SQL Server agent account should be running in domain account(not local account) also it should have permission for it. |
|
|
|
|
|
|
|
|
SSIS ERROR