How to set up database mail in SQL Server 2005

One of the great improvements in SQL Server 2005 is that it no longer requires an Exchange Server in order to send email. One of the most basic uses of email in SQL Server is to notify someone if a job fails – a backup, for example.

Here is a link to a most excellent article that explains exactly how to set up database mail in SQL Server 2005.

Once you’ve set up database mail, you need to go to SQL Server Agent properties, and on the Alert System tab, enable the mail profile you have set up. Then make sure you restart SQL Server agent. If you don’t restart SQL Server Agent, your test emails will work, but your job notifications will not.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s