Mail Profile disabled in SQL Server Agent Properties

[brianhensley@yahoo.com]

It's a Windows 2000 Server box with SQL 2000 on it. MSSQLSERVER &
SQLSERVERAGENT services are logged in as valid domain user. I set up a
mail profile for that user, and can send email via Outlook 2003.
However, when I go to the SQL Agent Properties in Enterprise Manager,
Mail Profile is disabled.

I've restarted the services & even tried rebooting the server. This
works on my other servers, but they're Windows 2003. Not sure if
that's the problem though.

Anybody have any clues?

[Simon Hayes]

Re: Mail Profile disabled in SQL Server Agent Properties


<brianhensley@y ahoo.com> wrote in message
news:1114783987 .666029.195920@ z14g2000cwz.goo glegroups.com.. .[color=blue]
> It's a Windows 2000 Server box with SQL 2000 on it. MSSQLSERVER &
> SQLSERVERAGENT services are logged in as valid domain user. I set up a
> mail profile for that user, and can send email via Outlook 2003.
> However, when I go to the SQL Agent Properties in Enterprise Manager,
> Mail Profile is disabled.
>
> I've restarted the services & even tried rebooting the server. This
> works on my other servers, but they're Windows 2003. Not sure if
> that's the problem though.
>
> Anybody have any clues?
>[/color]

See Q10 and Q19 (and also the article mentioned in the Summary section):

http://support.microsoft.com/default.aspx?scid=kb;en-us;315886

Simon