Database Mailing

  • 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

  • Please don't cross post. It just wastes peoples time and fragments replies.

    No replies to this thread please. Direct replies to: http://qa.sqlservercentral.com/Forums/Topic731203-146-1.aspx

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • I Don't Understand what exactly u said

  • Cross posting is posting the same question in two or more forums. Please don't do it. It's not necessary, many people read all the forums. Also it just leads to people posting answers to a question that's already been answered elsewhere.

    No more replies to this thread please.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • But i have not recieved the answer from anywhere , so i posted

  • pkuchaliya (6/9/2009)


    But i have not recieved the answer from anywhere , so i posted

    You posted the question in two different forums 1 minute apart. There's no way someone will reply within 1 minute.

    Please in future post your questions in one forum, not in several.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • GilaMonster (6/9/2009)


    pkuchaliya (6/9/2009)


    But i have not recieved the answer from anywhere , so i posted

    You posted the question in two different forums 1 minute apart. There's no way someone will reply within 1 minute.

    Please in future post your questions in one forum, not in several.

    k

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply