Here are the results of more tests. When I remote login to the server
(2003) and open Enterprise Manager and open any SMTP mail task I cannot
ping anything or execute the smpt mail task successfully. Even when I
enter an external smpt virtual server address that I know works, the
ping fails, as does the mail portion of the job.
However if I execute a telnet to any of these same SMTP servers from
the same machine, it is successful. It seems to isolate the problem to
how the DTS SMPT Mail Task job is pinging / connecting to the outside
or local smpt machines. I'm thinking maybe its using an outbound port
that something else is using?
Any insight is appreciated.
Thanks,
Dustin
[quoted text, click to view] Dustin wrote:
> I am using SMTP Mail Task on a windows 2003 server and have the SMTP
> Virtual Server portion of IIS running with anonymous access enabled. I
> have a DTS package which consists of a single SMTPMail task that sends
> an email to myself via the server I just mentioned.
>
> When I run this task from an external client (my own machine - windows
> xp - non local) it succeeds, and also when I use the "ping" command at
> the "server" tab in the properties of this task, it pings successfully.
>
> However, when I login to the 2003 server on which the sql server, iis,
> and SMTP virtual reside, open the task, and attempt to run it it fails.
> The ping is also unsuccessful. I have tried using "localhost",
> 127.0.0.1, and any other number of possibilities to no avail.
>
> Lastly I can telnet to my own smtp mail server via port 25 from both my
> external client machine (xp) and the locally on the 2003 server.
>
> I also use Windows auth on both machines using (so same user login and
> pass, and admin rights on both machines).
>
> Thanks in advance,
>
> Dustin
Dustin,
Unfortunetly I don't have an answer for your question. But I will say
that from everyone I've talked to I hear that the smtp mail task is
unreliable. I tend to use an extended stored procedure for automated
emails in my packages: xp_smtp_sendmail
It's very easy to use and I've never had a problem. Just something to
consider.
Jay
[quoted text, click to view] Dustin wrote:
> Here are the results of more tests. When I remote login to the server
> (2003) and open Enterprise Manager and open any SMTP mail task I cannot
> ping anything or execute the smpt mail task successfully. Even when I
> enter an external smpt virtual server address that I know works, the
> ping fails, as does the mail portion of the job.
>
> However if I execute a telnet to any of these same SMTP servers from
> the same machine, it is successful. It seems to isolate the problem to
> how the DTS SMPT Mail Task job is pinging / connecting to the outside
> or local smpt machines. I'm thinking maybe its using an outbound port
> that something else is using?
>
> Any insight is appreciated.
>
> Thanks,
>
> Dustin
>
>
> Dustin wrote:
> > I am using SMTP Mail Task on a windows 2003 server and have the SMTP
> > Virtual Server portion of IIS running with anonymous access enabled. I
> > have a DTS package which consists of a single SMTPMail task that sends
> > an email to myself via the server I just mentioned.
> >
> > When I run this task from an external client (my own machine - windows
> > xp - non local) it succeeds, and also when I use the "ping" command at
> > the "server" tab in the properties of this task, it pings successfully.
> >
> > However, when I login to the 2003 server on which the sql server, iis,
> > and SMTP virtual reside, open the task, and attempt to run it it fails.
> > The ping is also unsuccessful. I have tried using "localhost",
> > 127.0.0.1, and any other number of possibilities to no avail.
> >
> > Lastly I can telnet to my own smtp mail server via port 25 from both my
> > external client machine (xp) and the locally on the 2003 server.
> >
> > I also use Windows auth on both machines using (so same user login and
> > pass, and admin rights on both machines).
> >
> > Thanks in advance,
> >
> > Dustin
Don't see what you're looking for? Try a search.
