Afficher un message
Vieux 31/03/2008, 14h55   #2
John Bell
Aucun Avatar
 
Messages: n/a
Hébergeur:
Par défaut RE: SQL Mail problems on SQL 2000, can anyone .

Hi

I would change everything to xp_xmtp!

That said, I don't think you are not likely to get anything written or
returned as an error, if this is an authentication process waiting for input,
unless that process times out (which I suspect it doesn't).

Have you tried relaying though a SMTP relay?

John

"ianwr" wrote:

> Hi,
>
> I wonder if anyone can with the following. We have a production
> sql 2000 server with SQL mail setup.
>
> We have outlook 2000 coporate/workgroup edition installed and sql SP4.
> Outlook is pointed to a SMTP server as the company use lotus notes as
> their email and The problem that we have is that every so often the
> mail stops working and hangs.
>
> I understand from other message sthat this is down to the smtp client
> requesting authentication but because its running in a service we
> never see the dialog box and as such a reboot is required.
>
> We know the configuration is correct as emails do get sent at times.
> Apart from changing everything to SMTP client dlls is there any way to
> track down exactly what is happening with the SQL mail when it hangs?
> Nothing appears in any of the error or event logs so its annoying that
> i can't go back to the business with a more concrete explanation of
> whats happing.
>
> Any ideas?
>
> Ian.
>

  Réponse avec citation
 
Page generated in 0,06186 seconds with 9 queries