Outlook needs to be open for SMTP.

sql2k sp3a
Ive been testing using the Pop3/ SMTP option as an alternative to Exchange
for SQL Alerts. I can get everything running with no problems. I set up an
operator and can test it 10 times in a row with success... while Outlook is
opened. But if I close Outlook, I will be able to test with success no more
than 2 times. (Though it does say sent successfull.) I will hit the test
button and the email will never arrive.
I will then log onto the box and attempt to open Outlook and it won't allow
me too. It complains about the Outlook.pst file being in use. The only way
to free this file up is to restart the SQL Agent. Only then does my test
email possibly arrive.
Has anyone else experienced this? Fix?
TIA, ChrisR
Maybe one of the articles linked here:
http://www.aspfaq.com/2403
(Or you might consider switching to XP_SMTP_SendMail.)
This is my signature. It is a general reminder.
Please post DDL, sample data and desired results.
See http://www.aspfaq.com/5006 for info.
"ChrisR" <noemail@.bla.com> wrote in message
news:OZ7ldn3PFHA.2348@.tk2msftngp13.phx.gbl...
> sql2k sp3a
> Ive been testing using the Pop3/ SMTP option as an alternative to Exchange
> for SQL Alerts. I can get everything running with no problems. I set up an
> operator and can test it 10 times in a row with success... while Outlook
> is opened. But if I close Outlook, I will be able to test with success no
> more than 2 times. (Though it does say sent successfull.) I will hit the
> test button and the email will never arrive.
> I will then log onto the box and attempt to open Outlook and it won't
> allow me too. It complains about the Outlook.pst file being in use. The
> only way to free this file up is to restart the SQL Agent. Only then does
> my test email possibly arrive.
> Has anyone else experienced this? Fix?
> TIA, ChrisR
>
>
|||ChrisR
your not alone, i had the same issue. NEVER found an answer ((HUGS))
"ChrisR" wrote:

> sql2k sp3a
> Ive been testing using the Pop3/ SMTP option as an alternative to Exchange
> for SQL Alerts. I can get everything running with no problems. I set up an
> operator and can test it 10 times in a row with success... while Outlook is
> opened. But if I close Outlook, I will be able to test with success no more
> than 2 times. (Though it does say sent successfull.) I will hit the test
> button and the email will never arrive.
> I will then log onto the box and attempt to open Outlook and it won't allow
> me too. It complains about the Outlook.pst file being in use. The only way
> to free this file up is to restart the SQL Agent. Only then does my test
> email possibly arrive.
> Has anyone else experienced this? Fix?
> TIA, ChrisR
>
>