Results 1 to 10 of 10
  1. #1
    Join Date
    Jul 2004
    Posts
    268

    Unanswered: Mailsend program

    Hi All,

    I have installed SQL Server 2005 and created a job. I made the job failed to test the mailsend program. The notification step that uses the mailsend succeeded but I did not get an email. I am using mailsend program on SQL Server 2000 and it works fine. I am really stomped and don't know what to do to fix it?

    Thanks.

  2. #2
    Join Date
    Nov 2004
    Location
    on the wrong server
    Posts
    8,835
    Provided Answers: 6
    what are you using to send mail? xp_sendmail? xp_smtpmail? CDOSYS? CDONTS?

    I feel stomped everyday.
    “If one brings so much courage to this world the world has to kill them or break them, so of course it kills them. The world breaks every one and afterward many are strong at the broken places. But those that will not break it kills. It kills the very good and the very gentle and the very brave impartially. If you are none of these you can be sure it will kill you too but there will be no special hurry.” Earnest Hemingway, A Farewell To Arms.

  3. #3
    Join Date
    Jul 2004
    Posts
    268
    I am using xp_sendmail.

  4. #4
    Join Date
    Nov 2004
    Location
    on the wrong server
    Posts
    8,835
    Provided Answers: 6
    have you....

    installed outlook on your DB server?

    is the agent using a network account mapped to an exhange mail profile?

    have you tested sending mail directly from the mail client?

    have you started a sql mail client session with xp_startmail?
    “If one brings so much courage to this world the world has to kill them or break them, so of course it kills them. The world breaks every one and afterward many are strong at the broken places. But those that will not break it kills. It kills the very good and the very gentle and the very brave impartially. If you are none of these you can be sure it will kill you too but there will be no special hurry.” Earnest Hemingway, A Farewell To Arms.

  5. #5
    Join Date
    Jul 2004
    Posts
    268
    Yes, Outlook Express

    How can I check it? Our network guys set up the server

    Yes and it was successfull

    I have read in BOL that this feature will be removed in a future version of Microsoft SQL Server.

  6. #6
    Join Date
    Jan 2004
    Location
    In a large office with bad lighting
    Posts
    1,040
    Have you opened the "Surface Area Configuration" tool and looked under feature configuration to enable SQL Mail?

    BTW ... Database Mail is the preferred method with 2005.

    -- This is all just a Figment of my Imagination --

  7. #7
    Join Date
    Jul 2004
    Posts
    268
    I'll try Database Mail option

  8. #8
    Join Date
    Dec 2002
    Posts
    1,245
    Database Mail is MUCH better. It takes a bit of configuration, but it's really nice.

    hmscott
    Have you hugged your backup today?

  9. #9
    Join Date
    Nov 2005
    Posts
    122
    On SQL Server 2005 use sp_senddbmail. It sends mail using SMTP and uses service broker for queuing mails to be sent. No need for Outlook on the server anymore, and the mail sending process is 100% asyncronous.

  10. #10
    Join Date
    Oct 2006
    Posts
    115
    what if I were to use SQL 2005 Express? how do I send the mail out?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •