Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
pradeep_iete
Yak Posting Veteran
84 Posts |
 Posted - 2009-01-08 : 06:25:58
|
| When i execute the procedure ::: EXEC msdb.dbo.sp_send_dbmail @profile_name = 'APT Pradeep', @recipients ='pradeep_iete@hotmail.com' , @body ='dfadasdgsdfghss' , @subject = 'SEND TO HO STATUS ALERT MAIL'; I get the error :MessageThe mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 2 (2009-01-08T15:58:54). Exception Message: Could not connect to mail server. (No connection could be made because the target machine actively refused it).)Kindly Guide what went wrong ? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
pradeep_iete
Yak Posting Veteran
84 Posts |
Posted - 2009-01-08 : 07:08:40
|
| Guide me as well towards Configuring the Database mail top point an SMTP server as this the first time i am using Database Mail |
 |
|
|
sakets_2000
Master Smack Fu Yak Hacker
1472 Posts |
Posted - 2009-01-08 : 07:47:27
|
| Your SMTP server is probably not working.This link describes how to configure it http://msdn.microsoft.com/en-us/library/ms175951.aspx |
|
|
|
|
|
|
Database Mail