Database Mail configuration

Database Mail Configuration

1.Create the profile

2.Add the Accouts known as Email Setting inlcudes outgoing server , Authentication etc.

Below smtp.live.com is the smtp servername  or ID such as Server IP address.

Port number : 587

Email Address : xxx@hotmail.com ; any messages sent through this server via this email ID.

Reply Email : When recepients try to reply the same above mailID.

For Hotmail : we need to use Basic authentication , it will operate under your Account.

Username for the exsiting Live account and the password .

Database Mail Troubleshooting

To view the sent items: select * from msdb.dbo.sysmail_sentitems

To view the unsent items: select * from msdb.dbo.sysmail_unsentitems

To view the failed mails: select * from msdb.dbo.sysmail_faileditems