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 |
|
Dane_Jurkovic
Starting Member
2 Posts |
 Posted - 2003-02-05 : 10:07:34
|
| 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- |
|
|
Andraax
Aged Yak Warrior
790 Posts |
Posted - 2003-02-05 : 11:37:19
|
| Hi Dane!When you run a DTS package from the Enterprise Manager installed on your local computer, you run it locally, eg, your computer connects to the datasources in the package.If you try to run the package from the Enterprise Manager on the server, you should get the error.Reading the error message, it looks like it might be the firewall blocking TCP port 1433, from the DMZ to the internal network.The wise desicion here (according to me) would be to initiate the package from the internal server, in order to avoid any connections from the DMZ to the internal network. This is, of course, the best option for security reasons. |
 |
|
|
Argyle
Yak Posting Veteran
53 Posts |
Posted - 2003-02-05 : 12:39:53
|
| Looking at:Error string: [DBNMPNTW]ConnectionOpen (CreateFile()). it seems you are using the network library named pipes. Try changing the default network library on both servers to TCP/IP. (Run -> cliconfg.exe)And as mentioned check that port 1433 is open./Argyle |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-02-05 : 13:00:46
|
| You should not be using port 1433 in a DMZ environment. You will want to change the port that SQL Server listens on, then open that port up on the firewall. It is very bad to use port 1433.The whole purpose of a DMZ environment is security, so do not add a possible security hole by using 1433. |
|
|
|
|
|
|
|
|
Job Error. Need help ASAP.