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.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 Database mailing Problem

Author  Topic 

pkuchaliya
Starting Member

49 Posts

Posted - 2009-06-09 : 03:19:01
Hi to all,

To use database mailing i Follow the steps
1.Enable database mail in surface area configuration
2.configure smtp
3.Add database mailing option in the current login.
4.configure datbase mail.
5. enable mail profile in sql server agent properties.
6. restart the sql server agent

when i send the test mail it generate the error
-----
Message
The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 16 (2009-06-09T12:36:59). Exception Message: Cannot send mails to mail server. (Failure sending mail.).
)
-------
when i execute the "sp_helprolemember" then it does not show the current login in the list.

Please tell how i can use database mail.

Plz help

pankaj
   

- Advertisement -