Issue with Database Mail

  • Is this a firewall issue?

  • lets do some basic diagnostics;

    does this return STARTED or something different?

    EXECUTE msdb.dbo.sysmail_help_status_sp --STARTED?

    try stopping and starting the mail service:

    EXECUTE msdb.dbo.sysmail_stop_sp;

    GO

    EXECUTE msdb.dbo.sysmail_start_sp;

    and finally, yes, you probably need to bouhce the SLQ Agent.

    this is not the exact issue you mention, but Kimberly tripp has a similar issue requiring the stop and start of the Agent.

    http://www.sqlskills.com/BLOGS/KIMBERLY/post/SQL-Server-2008-fails-to-send-database-mail-Sparse-columns-with-filtered-indexes-Upcoming-Events-and-as-usual-catching-up-(ie-cookies)!.aspx

    Lowell


    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • HOw long does it take to stop the Mail Service? It has been over 10 min's , the query is still executing. Will keep updated when the service stops.

    Lowell (9/8/2011)


    lets do some basic diagnostics;

    does this return STARTED or something different?

    EXECUTE msdb.dbo.sysmail_help_status_sp --STARTED?

    try stopping and starting the mail service:

    EXECUTE msdb.dbo.sysmail_stop_sp;

    GO

    EXECUTE msdb.dbo.sysmail_start_sp;

    and finally, yes, you probably need to bouhce the SLQ Agent.

    this is not the exact issue you mention, but Kimberly tripp has a similar issue requiring the stop and start of the Agent.

    http://www.sqlskills.com/BLOGS/KIMBERLY/post/SQL-Server-2008-fails-to-send-database-mail-Sparse-columns-with-filtered-indexes-Upcoming-Events-and-as-usual-catching-up-(ie-cookies)!.aspx

  • Tried stopping the mail service using EXECUTE msdb.dbo.sysmail_stop_sp;, Even after 1 hr the Query is executing. Unable to stop the service.

    (: Hakuna Matata 🙂 (9/8/2011)


    HOw long does it take to stop the Mail Service? It has been over 10 min's , the query is still executing. Will keep updated when the service stops.

    Lowell (9/8/2011)


    lets do some basic diagnostics;

    does this return STARTED or something different?

    EXECUTE msdb.dbo.sysmail_help_status_sp --STARTED?

    try stopping and starting the mail service:

    EXECUTE msdb.dbo.sysmail_stop_sp;

    GO

    EXECUTE msdb.dbo.sysmail_start_sp;

    and finally, yes, you probably need to bouhce the SLQ Agent.

    this is not the exact issue you mention, but Kimberly tripp has a similar issue requiring the stop and start of the Agent.

    http://www.sqlskills.com/BLOGS/KIMBERLY/post/SQL-Server-2008-fails-to-send-database-mail-Sparse-columns-with-filtered-indexes-Upcoming-Events-and-as-usual-catching-up-(ie-cookies)!.aspx

  • Even after 3.5 hours , I was unable to stop the mail service. What could be the issue. Can restarting the SQL server solve this issue.

    (: Hakuna Matata 🙂 (9/9/2011)


    Tried stopping the mail service using EXECUTE msdb.dbo.sysmail_stop_sp;, Even after 1 hr the Query is executing. Unable to stop the service.

    (: Hakuna Matata 🙂 (9/8/2011)


    HOw long does it take to stop the Mail Service? It has been over 10 min's , the query is still executing. Will keep updated when the service stops.

    Lowell (9/8/2011)


    lets do some basic diagnostics;

    does this return STARTED or something different?

    EXECUTE msdb.dbo.sysmail_help_status_sp --STARTED?

    try stopping and starting the mail service:

    EXECUTE msdb.dbo.sysmail_stop_sp;

    GO

    EXECUTE msdb.dbo.sysmail_start_sp;

    and finally, yes, you probably need to bouhce the SLQ Agent.

    this is not the exact issue you mention, but Kimberly tripp has a similar issue requiring the stop and start of the Agent.

    http://www.sqlskills.com/BLOGS/KIMBERLY/post/SQL-Server-2008-fails-to-send-database-mail-Sparse-columns-with-filtered-indexes-Upcoming-Events-and-as-usual-catching-up-(ie-cookies)!.aspx

  • Try these things

    Right click on Sql server Agent > Properties > Now click on Enable mail profile

    Click on ok.

  • The mail profile has already been enabled. I

    mandeep.joon (9/12/2011)


    Try these things

    Right click on Sql server Agent > Properties > Now click on Enable mail profile

    Click on ok.

  • I restarted the Database Mail service, deleted the existing profiles & accounts and created a new profile & account. Yet I am unable to send Test Mails. In the database Mail log I can only find the entries of restarting the Mail Service, no logs generated for the test mails sent. Somebody help me please as the Mail service is down from 1st September.

    (: Hakuna Matata 🙂 (9/12/2011)


    The mail profile has already been enabled. I

    mandeep.joon (9/12/2011)


    Try these things

    Right click on Sql server Agent > Properties > Now click on Enable mail profile

    Click on ok.

  • Can restarting the SQL Server resolve my issue, Since this is a Production Server used 24/7, I am reluctant to restart the SQL Server. My other concern is what if I am unable to restart the SQL Server. I am unable to restart the Server, how can I troubleshoot this issue?

  • Check with your IT / Tech Services department to make sure there's been no recent changes to the Exchange Server (assuming your company uses that), there's this nifty little setting in Exchange that "Allow Server to relay mail" (not sure on the exact wording here), and it's server specific (for any server with SMTP installed).

    Of course you could google or BOL the relaying issue as well (there's tons of articles on that out there - ex: http://technet.microsoft.com/en-us/library/dd277329.aspx)

    Without that set, you'll experience issues that you're describing. You can send thousands of emails (without any errors) but none are ever received.

    Also, were any recent windows updates installed on the server?

    ______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience

  • Just check with your system administrators to see if they have recently made any changes to the SMTP server or any Antivirus software is blocking the mails or ports etc..

    Thank You,

    Best Regards,

    SQLBuddy

  • The IT Team confirms that we don't use Exchange Server. I tried using my Gmail Id with the following settings:

    Server Name: smtp.gmail.com

    port no: 587

    Check : This server requires a secure connection

    Check Basic Authentication with my gmail id & password.

    Default public profile

    Still the same problem

    MyDoggieJessie (9/13/2011)


    Check with your IT / Tech Services department to make sure there's been no recent changes to the Exchange Server (assuming your company uses that), there's this nifty little setting in Exchange that "Allow Server to relay mail" (not sure on the exact wording here), and it's server specific (for any server with SMTP installed).

    Of course you could google or BOL the relaying issue as well (there's tons of articles on that out there - ex: http://technet.microsoft.com/en-us/library/dd277329.aspx)

    Without that set, you'll experience issues that you're describing. You can send thousands of emails (without any errors) but none are ever received.

    Also, were any recent windows updates installed on the server?

  • The same Gmail settings worked fine on my other production server.

    (: Hakuna Matata 🙂 (9/14/2011)


    The IT Team confirms that we don't use Exchange Server. I tried using my Gmail Id with the following settings:

    Server Name: smtp.gmail.com

    port no: 587

    Check : This server requires a secure connection

    Check Basic Authentication with my gmail id & password.

    Default public profile

    Still the same problem

    MyDoggieJessie (9/13/2011)


    Check with your IT / Tech Services department to make sure there's been no recent changes to the Exchange Server (assuming your company uses that), there's this nifty little setting in Exchange that "Allow Server to relay mail" (not sure on the exact wording here), and it's server specific (for any server with SMTP installed).

    Of course you could google or BOL the relaying issue as well (there's tons of articles on that out there - ex: http://technet.microsoft.com/en-us/library/dd277329.aspx)

    Without that set, you'll experience issues that you're describing. You can send thousands of emails (without any errors) but none are ever received.

    Also, were any recent windows updates installed on the server?

  • Something might be blocking the mail relay from this server. Check if the ports are being blocked by any antivirus software , file filters etc...

    Thank You,

    Best Regards,

    SQLBuddy

  • The issue has been resolved finally. I had to restart the SQL Server. Once restarted The server started sending all the mails that were in queue. Still have no clue as to what was the issue.

Viewing 15 posts - 16 through 29 (of 29 total)

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