Post reply

Issues in Database mail

  • May 29, 2009 at 3:21 am

    #200990

    Hi,

    I have one issue in database mail which I posted before but did not get proper answer.

    I have configured database mail in SQL server 2005. When sending the test mail, I am getting the error as below as per the log file

    "The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 2 (2009-05-27T09:22:39). Exception Message: Cannot send mails to mail server. (Command not implemented. The server response was: Error: command not implemented)"

    When running the script,

    EXEC msdb.dbo.sp_send_dbmail

    @profile_name = 'AdventureWorks Administrator',

    @recipients = 'danw@Adventure-Works.com',

    @body = 'The stored procedure finished successfully.',

    @subject = 'Automated Success Message'

    It is showing as Mail queued. But not getting delivered.

    Is it due to some problem in connecting to SMTP sever?

    Can it be an access issue?

    Ryan
    //All our dreams can come true, if we have the courage to pursue them//

  • May 29, 2009 at 3:59 am

    #1001956

    Do you have the profile/account created .above all do you have outlook on your machine ..

    If not it will not work .

    You need to be able to access your exchange server form your machine ..

    Abhay Chaudhary
    Sr.DBA (MCITP/MCTS :SQL Server 2005/2008 ,OCP 9i)

  • May 29, 2009 at 4:14 am

    #1001957

    I think its because of SMTP server.

    Do you having outlook.

    Check these too:

    1.Have u given the correct IP and port for SMTP.

    2.In database mail profile (ie. AdventureWorks Administrator) did u add the correct account (probably sumantr@Adventure-Works.com ) to be used for sending the mail try also add alternative account too.

    3.In sql server agent -> properties->alert system->

    -check enable mail profile (ie. AdventureWorks Administrator)

    -Mail system as Database Mail

    -Mail profile as profile that you have mentioned in the script.

    4.Use these to verify your mails

    Use msdb

    select * from sysmail_mailitems

    select * from sysmail_log

    select * from sysmail_sentitems

    5.Also try sending a test mail to danw@Adventure-Works.com .

    Tanx 😀

  • May 29, 2009 at 5:52 am

    #1001977

    Hi,

    Thanks for the reply.

    I have checked the above steps as you mentioned.

    I am able to send message through SMTP commands but not through SQL mail. So I think no problems in SMTP settings.

    Can you plaese let me know what else needs to be checked?

    Ryan
    //All our dreams can come true, if we have the courage to pursue them//

  • May 29, 2009 at 8:09 am

    #1002070

    Have you made sure the port (25?) is open and available? You could run a telnet session to check...

  • May 29, 2009 at 8:16 am

    #1002074

    In SMTP allow anonymous access/relay.

    Alex S

  • May 29, 2009 at 9:05 am

    #1002105

    Just to clarify, you do NOT need Outlook installed on your SQL Server to use Database Mail.

    What is the SMTP server you are using?

    Jack Corbett
    Consultant - Straight Path Solutions
    Check out these links on how to get faster and more accurate answers:
    Forum Etiquette: How to post data/code on a forum to get the best help
    Need an Answer? Actually, No ... You Need a Question

  • May 29, 2009 at 9:09 am

    #1002110

    Hi,

    I ran telnet session from that server and I am able to deliver the message through command prompt. I think the error I am getting which is "command not implemented" is due to the wrong command in SMTP and the error no is 502. Is there settings required between SQL server and SMTP server?

    Ryan
    //All our dreams can come true, if we have the courage to pursue them//

  • May 29, 2009 at 9:25 am

    #1002128

    Yes. As the poster above mentioned, you must create a profile in SQL Server (that has SMTP server name, port, authentication etc).

  • May 29, 2009 at 9:27 am

    #1002131

    This is a good read for setup:

    http://www.mssqltips.com/tip.asp?tip=1438

    Easy to follow...

  • June 1, 2009 at 2:24 am

    #1002600

    Hi,

    I have created SMTP priflle with valid data but still I am facing the same problem. Is there any software or settings in IIS or some other things are required?

    Ryan
    //All our dreams can come true, if we have the courage to pursue them//

  • June 2, 2009 at 6:24 am

    #1003356

    If you have an anti-virus installed, check the settings to make sure it's not blocking the application. You may need to add exceptions.

    databasemail90.exe

    DTExec.exe (SSIS)

    dtexecui.exe

    You should be able to see this "blocking", or "denied" in the various AV logs.

    If you haven't "restart" the SQLServerAgent, after you add the profile to the SQLServerAgent--Alert System.

  • June 2, 2009 at 6:58 am

    #1003384

    Are you able to send mail from any programing language application (eg, from ASP, or C#) with your setting which you used here?

    "Don't limit your challenges, challenge your limits"

  • June 2, 2009 at 4:24 pm

    #1003689

    I am able to send the message from that server through telnet command by SMTP server.

    With the same smtp server I am able to send mail from another server. I am facing the problem in two server which I tried to configure mirroring but failed. Is there any dependency between database mail and mirroring?

    Ryan
    //All our dreams can come true, if we have the courage to pursue them//

  • June 2, 2009 at 9:56 pm

    #1003751

    One of following solution can resolve your problem.

    1. Add port 25 to firewall port exceptions.

    2. Verify mail account authentication specially SSL.

    3. Check antivirus program or disable it, restart SQL Services.

    4. Try.

Viewing 15 posts - 1 through 15 (of 20 total)

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