Re: SQLAgent mail notifications not working

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Mark Menke (MarkMenke_at_discussions.microsoft.com)
Date: 12/13/04 

Date: Mon, 13 Dec 2004 11:35:02 -0800

I installed it when I was trying to get the mail notifications working. I've
uninstalled it now.

Should I look at using something other than mapi to make the notifications
work?

"Steve Foster [SBS MVP]" wrote:

> Mark Menke wrote:
>
> > I'm trying to get the SQL Agent notifications working under SBS2k3
> > Premium for the Sharepoint instance. Here's what I've done so far -
> >
> > 1. Created a domain user SQL_svc. Changed sql and sqlagent to
> > startup using these accounts -
> > 2. Logged into the server as SQL_svc and ran outlook 2003 configured
> > for exchange. Verified that I can send and receive email.
>
> Eek. You don't have Outlook installed on the SBS itself, do you? This
> is an unsupported (and strongly discouraged) configuration. You should
> get Outlook *off* the server ASAP.
>
> > 3. Ran Enterprise Manager and setup the sqlagent mail profile - hit
> > test and I get "Successfully started (and stopped) a mail session
> > with this profile.
>
> Did you restart the SQL services at this point?
>
> --
> Steve Foster [SBS MVP]
> ---------------------------------------
> MVPs do not work for Microsoft. Please reply only to the newsgroups.
>