PHWinfo - Afficher un message - SQL Mail problems on SQL 2000, can anyone help.

07/04/2008, 09h00

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?

07/04/2008, 09h00	#4
ianwr Messages: n/a Hébergeur:	Re: SQL Mail problems on SQL 2000, can anyone . 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?