Help Regarding databse mail

I would like to know the details for configuring database mail in my servers.

Could anyone please help me...?
LVL 14
Jagdish DevakuSr DB ArchitectAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Jerryuk007Connect With a Mentor Commented:
On MSSQL 7.0/2000, If using Outlook... Other Mail Client might differ slightly...

1.> Make sure your SQL Server Services (including SQL Agent) are started using a Domain Account.
2.> Make sure that Domain Account as a Mailbox.
3.> Install MS Outlook (for example) on your Database Server.
4.> Send an Email from your MSSQL Server using Outlook (else Exchange Server does not always validate the Mailbox correctly).
5.> Restart the SQL Services.

Then to send Email using T-SQL, look at the syntax of xp_sendmail in Book On Line.

Hope this help.

Jerry
0
 
RobbPConnect With a Mentor Commented:
Hi - MSDN always comes with multiple scenarios and nice to knows
http://msdn2.microsoft.com/en-us/library/ms189620.aspx
0
All Courses

From novice to tech pro — start learning today.