Home / server / Questions / 69568
Accepted
MrEdmundo
Asked: 2009-09-30 02:44:27 +0800 CST

SQL Server 2005 Alerts no Email Option

  • 772

I've got Database Mail set up successfully, I can send test emails, however when I go to set up an alert to be sent by email to an operator I don't have a checkbox to check to say email should be sent.

I've checked the following:

  • SQL Agent Alert System has Email set up

  • I've restart SQL Agent

  • I have a default mail profile

  • The profile is a public profile

  • Operators are set up (that's where I can't see the email checkbox)

  • SQL Server & Agent are running under the same account the SQLMail is set up for

I'm using SQL Server 2005 SP3, if anybody has any thoughts it would be much appreciated.

sql-server-2005

1 Answers

  1. Best Answer

    From SSMS, click on the plus next to Management. From there, right-click on Database Mail, and Configure Database Mail....click Next on the Welcome Screen. Select Manage profile security and click Next. Are there any profiles listed here? Are any of them set to use the default profile? If not, set it to yes and try again.

    A good resource for stepping through and setting database email up can be found here.

    Edited to add

    Based on your comments below you should patch SSMS in addition to SQL Server.

    • 1