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