|
Home > Archive > microsoft.public.sqlserver.server > August 2002 > sql mail problem
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
| Devin McMahon 2002-08-09, 8:23 am |
| Have you set the profile under both SQLServerAgent and
SQLMail. These two services use MAPI differently, so you
must apply the profile to both. You can send yourself
mail with xp_sendmail (which uses SQLMail), but if you
define a notification of a job completing, that is
SQLServerAgent mail. Check the settings under properties
for SQLServerAgent
>-----Original Message-----
>Running Win2k Server & SQL2000 sp2. I have set up SQL
mail successfully in
>that when I test it, I receive the email correctly.
However, I never get
>notified of my backups and other things that I have set
to email me. My
>profile is configured correctly etc. Any suggestions??
>
>--
>Schklerg
>
>
>.
>
| |
| The Schklerg 2002-08-09, 12:23 pm |
| Both are configured and test fine.
--
Schklerg
"Devin McMahon" <dmcmaho1@twcny.rr.com> wrote in message
news:041d01c23fad$b8cd0050$39e
f2ecf@TKMSFTNGXA08...
> Have you set the profile under both SQLServerAgent and
> SQLMail. These two services use MAPI differently, so you
> must apply the profile to both. You can send yourself
> mail with xp_sendmail (which uses SQLMail), but if you
> define a notification of a job completing, that is
> SQLServerAgent mail. Check the settings under properties
> for SQLServerAgent
> >-----Original Message-----
> >Running Win2k Server & SQL2000 sp2. I have set up SQL
> mail successfully in
> >that when I test it, I receive the email correctly.
> However, I never get
> >notified of my backups and other things that I have set
> to email me. My
> >profile is configured correctly etc. Any suggestions??
> >
> >--
> >Schklerg
> >
> >
> >.
> >
| |
|
| What version of Outlook are you running?
If Ofiice 2K post SR-1 or OfficeXP there are issues with the Outlook
Security. Due to the I-Love-You Virus and Mellisa MS doesn't allow
applications to send email through outlook and this includes SQL Server. If
you start SQL with the -c switch (it will interact with the desktop) and
test SQLMail you will see the Outlook Security Warning that another
application is trying to send email...
If possible try to install Outlook 2K pre SR-1 or Outlook98.
-Dan
"The Schklerg" <jasonbnospam@integratedbook.com> wrote in message
news:aj0uhs$17nbvh$1@ID-43593.news.dfncis.de...
> Both are configured and test fine.
>
> --
> Schklerg
>
> "Devin McMahon" <dmcmaho1@twcny.rr.com> wrote in message
> news:041d01c23fad$b8cd0050$39e
f2ecf@TKMSFTNGXA08...
> > Have you set the profile under both SQLServerAgent and
> > SQLMail. These two services use MAPI differently, so you
> > must apply the profile to both. You can send yourself
> > mail with xp_sendmail (which uses SQLMail), but if you
> > define a notification of a job completing, that is
> > SQLServerAgent mail. Check the settings under properties
> > for SQLServerAgent
> > >-----Original Message-----
> > >Running Win2k Server & SQL2000 sp2. I have set up SQL
> > mail successfully in
> > >that when I test it, I receive the email correctly.
> > However, I never get
> > >notified of my backups and other things that I have set
> > to email me. My
> > >profile is configured correctly etc. Any suggestions??
> > >
> > >--
> > >Schklerg
> > >
> > >
> > >.
> > >
>
>
| |
| The Schklerg 2002-08-14, 6:23 am |
| Xref: tkmsftngp01 microsoft.public.sqlserver.server:227591
Thanks. That must be it.
--
Schklerg
"dan" <dalman@ajilon.com> wrote in message
news:e7y7VItQCHA.2032@tkmsftngp11...
> What version of Outlook are you running?
>
> If Ofiice 2K post SR-1 or OfficeXP there are issues with the Outlook
> Security. Due to the I-Love-You Virus and Mellisa MS doesn't allow
> applications to send email through outlook and this includes SQL Server.
If
> you start SQL with the -c switch (it will interact with the desktop) and
> test SQLMail you will see the Outlook Security Warning that another
> application is trying to send email...
>
> If possible try to install Outlook 2K pre SR-1 or Outlook98.
>
> -Dan
>
>
> "The Schklerg" <jasonbnospam@integratedbook.com> wrote in message
> news:aj0uhs$17nbvh$1@ID-43593.news.dfncis.de...
> > Both are configured and test fine.
> >
> > --
> > Schklerg
> >
> > "Devin McMahon" <dmcmaho1@twcny.rr.com> wrote in message
> > news:041d01c23fad$b8cd0050$39e
f2ecf@TKMSFTNGXA08...
> > > Have you set the profile under both SQLServerAgent and
> > > SQLMail. These two services use MAPI differently, so you
> > > must apply the profile to both. You can send yourself
> > > mail with xp_sendmail (which uses SQLMail), but if you
> > > define a notification of a job completing, that is
> > > SQLServerAgent mail. Check the settings under properties
> > > for SQLServerAgent
> > > >-----Original Message-----
> > > >Running Win2k Server & SQL2000 sp2. I have set up SQL
> > > mail successfully in
> > > >that when I test it, I receive the email correctly.
> > > However, I never get
> > > >notified of my backups and other things that I have set
> > > to email me. My
> > > >profile is configured correctly etc. Any suggestions??
> > > >
> > > >--
> > > >Schklerg
> > > >
> > > >
> > > >.
> > > >
> >
> >
>
>
|
|
|
|
|