|
|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
| ||||||||||||||||||||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Display Modes |
|
#1
|
|||
|
|||
|
Does anyone know what could be my problem here?
Let me explain…. I have two servers, one in a DMZ and the other on our local network. I have a DTS package running every night form the server on the DMZ. I can verify this by looking in the jobs. Here is the kicker. I can run the DTS package from Enterprise Manager (EM) and the package works just fine. But, every night the “job” fails (job error below). The job is running under the SA account so it has the permissions but fails. I am thinking that it could be something with the firewall between the DMZ and the local network. Some port that is being blocked or something. Does anyone know if “jobs” are using a special port or something? The reason why I am going down this path is that using EM and sitting on the local network I must be acting as some kind of “middle” man and that is why the DTS package is working when I fire it off. But, when the server in the DMZ is doing all the work there is no middle man helping it out. I.e. I can see the server in the DMZ and it can see the server on the local network through me. I know, sounds dumb. But, that is all I can think the problem could be some port being blocked on the firewall. Any help would be so wonderful. ******************* Start Of Job Error ******************* DTSRun: Loading... Error: -2147008507 (80074005); Provider Error: 0 (0) Error string: Unspecified error Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts.hlp Help context: 713 Error: -2147467259 (80004005); Provider Error: 1326 (52E) Error string: Client unable to establish connection Error source: Microsoft OLE DB Provider for SQL Server Help file: Help context: 0 Error: -2147467259 (80004005); Provider Error: 1326 (52E) Error string: [DBNMPNTW]ConnectionOpen (CreateFile()). Error source: Microsoft OLE DB Provider for SQL Server Help file: Help context: 0. Process Exit Code 1. The step failed. ***************** End Of Job Error ***************** Thanks, Dane- |
|
#2
|
||||
|
||||
|
The first thing you should do is follow your hunch and check the firewall logs! check for port 1433.
|
![]() |
| Viewing: Dev Articles Community Forums > Databases > Microsoft SQL Server > DTS - Job error |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|