Written by: Steve Gray
2/18/2010 10:06 AM 

Take the following steps to configure SQL mail on a SQL 2005 server:

Execute this script:

use master

go

sp_configure 'show advanced options',1

go

reconfigure with override

go

sp_configure 'Database Mail XPs',1

go

reconfigure 

go 

In MANAGEMENT  DATABASE MAIL, right click and select CONFIGURE DATABASE MAIL

Select SET UP DATABASE MAIL...

Create a profile.

Make the account a public profile. Important: in the 'Manage Profile Security' page, make your profile a 'default profile'

Click on SQL SERVER AGENT  OPERATORS and create an operator

Trackback Print

Tags:

Categories:

Location: Blogs DEVSHED Blogs SQL