February 8, 2011 at 2:37 pm
Here is my setup:
We have two sql servers 2008 installed on two different window servers. First server is name instance in clustered environment e.g. DevBox\DevData and other one is default instance e.g. JobServer. Both servers are in CompNet domain. Domain user CompNet\mak is sysadmin on bot the servers.
I created one package in BIDS and stored as File System on the JobServer. Which grabs the data from DevData server calculates some steps and export into text files on JobServer. It runs fine when I run it from BIDS. Now I am trying to setup as job and schedule it to run from management studio but it fails. I have created credential and proxy to use credential and run the job as proxy. Following is the error desc.
Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft OLE DB Provider for SQL Server" Hresult: 0x80004005 Description: "[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.". Source: DTSTask_DTSDataPumpTask_1 OLE DB Source [1] Description: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "AppData" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed. Code: 0xC0047017 Source: DTSTask_DTSDataPumpTask_1 SSIS.Pipeline Description: component "OLE DB Source" (1) failed validation and returned error code 0xC020801C. Code: 0xC004700C Source: DTSTask_DTSDataPumpTask_1 SSIS.Pipeline Description: One or more component failed validation. Code: 0xC0024107 Source: DTSTask_DTSDataPumpTask_1 Description: There were errors during task validation. End Error DTExec: The package execution returned DTSER_FAILURE (1). The package execution failed. The step failed.,00:00:48,0,0,,,,0
Am I missing anything here?
I would appreciate the help.
Thanks.
February 10, 2011 at 12:11 am
Let's start with the basics:
can you somehow verify that the used credential has actually access to the other server?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply