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.

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.
>

"ianwr" <ianwrigglesworth@yahoo.co.uk> wrote in message
news:e81da577-bbe8-451a-ad09-e14a42334838@e67g2000hsa.googlegroups.com...
> 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.
>

A couple of things you can try.

One, install the IIS SMTP Server on each SQL Server itself and lock down
that SMTP Server to only forward to the corporate SMTP server. I did this
at my old company years ago and it solved a LOT of the problems we had with
SQL 2000 mail (almost all of which are caused by the Outlook client hanging
at some point while trying to talk to the SMTP server.) Basically since
it's local, you won't get timeouts, network interruptions, etc.

Now, sometimes you can do a xp_stopmail, stop the SQL Server agent, wait a
few minutes and then rkill MAPISP32.DLL, open Outlook manually, clear out
ALL messages (IN, OUT, SENT, etc.).

Then restart SQL Server agent, run xp_sendmail manually and get mail working
again.

Not guaranteed to work, but often did.


> Any ideas?
>
> Ian.



--
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html

On Apr 1, 8:18am, "Greg D. Moore \(Strider\)"
<mooregr_deletet...@greenms.com> wrote:
> "ianwr" <ianwriggleswo...@yahoo.co.uk> wrote in message
>
> news:e81da577-bbe8-451a-ad09-e14a42334838@e67g2000hsa.googlegroups.com...
>
>
>
>
>
> > 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.
>
> A couple of things you can try.
>
> One, install the IIS SMTP Server on each SQL Server itself and lock down
> that SMTP Server to only forward to the corporate SMTP server. I did this
> at my old company years ago and it solved a LOT of the problems we had with
> SQL 2000 mail (almost all of which are caused by the Outlook client hanging
> at some point while trying to talk to the SMTP server.) Basically since
> it's local, you won't get timeouts, network interruptions, etc.
>
> Now, sometimes you can do a xp_stopmail, stop the SQL Server agent, wait a
> few minutes and then rkill MAPISP32.DLL, open Outlook manually, clear out
> ALL messages (IN, OUT, SENT, etc.).
>
> Then restart SQL Server agent, run xp_sendmail manually and get mail working
> again.
>
> Not guaranteed to work, but often did.
>
> > Any ideas?
>
> > Ian.
>
> --
> Greg Moore
> SQL Server DBA Consulting Remote and Onsite available!
> Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html- Hide quoted text -
>
> - Show quoted text -

Thanks for the suggestions. One thing i did find out is that the MAPI
profile didn't have a valid POP3 address just a dummy one. Looking at
the Microsoft support areas it says that you need a valid one.

Unfortunately, the organisation is Lotus notes and i asked them to set
one up on the existing smtp server. They did this ok, i tested outlook
without SQL server involved and i can send and receive message from
within outlook.

When i try a sendmail from SQL Server, the email leaves sql server and
goes straight into the Inbox of the mailbox. I can't understand why
the email sits in the inbox. No matter what i do after that ie. click
on send/receive in the outlook client the mail just still sits in the
inbox even though the "to" address is correct.

Any ideas?

Hi

You don't say what version of Outlook you are using, Outlook 2002 requires
Outlook to be running when connecting to non-exchange servers which messages
may remain in the inbox until the client is started. See
http://support.microsoft.com/default...b;en-us;263556

John


"ianwr" <ianwrigglesworth@yahoo.co.uk> wrote in message
news:9bb2d77d-941c-4e18-96f2-15d8f6ecda67@o1g2000pra.googlegroups.com...
On Apr 1, 8:18 am, "Greg D. Moore \(Strider\)"
<mooregr_deletet...@greenms.com> wrote:
> "ianwr" <ianwriggleswo...@yahoo.co.uk> wrote in message
>
> news:e81da577-bbe8-451a-ad09-e14a42334838@e67g2000hsa.googlegroups.com...
>
>
>
>
>
> > 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.
>
> A couple of things you can try.
>
> One, install the IIS SMTP Server on each SQL Server itself and lock down
> that SMTP Server to only forward to the corporate SMTP server. I did this
> at my old company years ago and it solved a LOT of the problems we had
> with
> SQL 2000 mail (almost all of which are caused by the Outlook client
> hanging
> at some point while trying to talk to the SMTP server.) Basically since
> it's local, you won't get timeouts, network interruptions, etc.
>
> Now, sometimes you can do a xp_stopmail, stop the SQL Server agent, wait a
> few minutes and then rkill MAPISP32.DLL, open Outlook manually, clear out
> ALL messages (IN, OUT, SENT, etc.).
>
> Then restart SQL Server agent, run xp_sendmail manually and get mail
> working
> again.
>
> Not guaranteed to work, but often did.
>
> > Any ideas?
>
> > Ian.
>
> --
> Greg Moore
> SQL Server DBA Consulting Remote and Onsite available!
> Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html- Hide
> quoted text -
>
> - Show quoted text -

Thanks for the suggestions. One thing i did find out is that the MAPI
profile didn't have a valid POP3 address just a dummy one. Looking at
the Microsoft support areas it says that you need a valid one.

Unfortunately, the organisation is Lotus notes and i asked them to set
one up on the existing smtp server. They did this ok, i tested outlook
without SQL server involved and i can send and receive message from
within outlook.

When i try a sendmail from SQL Server, the email leaves sql server and
goes straight into the Inbox of the mailbox. I can't understand why
the email sits in the inbox. No matter what i do after that ie. click
on send/receive in the outlook client the mail just still sits in the
inbox even though the "to" address is correct.

Any ideas?