February 5, 2003 at 7:27 am
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 for the server on the DMZ. I can verify this by looking in the job. 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-
February 5, 2003 at 7:36 am
Are you running the DTS from your own PC?
Remember DTS is client side software, hence it runs from the PC you run it on. If this is the case you may have access to the DMZ where the server doesn't
Steven
February 5, 2003 at 8:04 am
Nope the DTS is running from the server in the DMZ.
quote:
Are you running the DTS from your own PC?Remember DTS is client side software, hence it runs from the PC you run it on. If this is the case you may have access to the DMZ where the server doesn't
February 5, 2003 at 8:38 am
I think this is to do with the privileges for the account you started the SQL Server Agent service under.
Regards,
Andy Jones
.
February 5, 2003 at 10:43 am
Have you discussed it with your network/sys admin? What time are YOU running the query? Have you tested it at the same time as the job runs? If not, then you can't compare the two. You could be testing it and get successful results and then when the job runs the network might be down. I suggest taking the time and use EM to test the script/connectivity AT THE TIME THAT THE JOB IS SCHEDULED (caps used for emphasis). If it fails, then you know it's not the job, but the time that it is running. Then you have to find out what is happening at that time that isn't happening when you tested it earlier.
-SQLBill
February 6, 2003 at 4:25 am
Sounds like your server is trying to connect using Named Pipes. Use Client Network Utility on the server to create alias to other server and make sure network library is set to TCP/IP.
Far away is close at hand in the images of elsewhere.
Anon.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply