Post reply

Database mail not working.

  • September 24, 2019 at 11:52 pm

    #3683148

    SQL 2014 Clustered  2 Nodes

    VMware ESXI 6.5

    All drives are on NAS using iSCSI

    Lost the drives and I had to reinstall all my SQL instances  got them back online now

    Some final detail to work out.

    Setup Database Mail

    Tried Send test email and all emails are in the queue   status NOT SENT

    Looked at the logs and I see no errors

    Any ideas?

     

     

     

     

     

  • September 25, 2019 at 1:48 am

    #3683158

    You don't give us much to go on except to say it's broke.

    With that in mind, check the profile(s) and make sure one of them is setup as a default.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
    "Change is inevitable... change for the better is not".
    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)
    Intro to Tally Tables and Functions

  • September 25, 2019 at 5:05 am

    #3683182

    Please check with your mail admin/network team whether the IP / Host configured in the Profile is white listed? If yes then double check the credentials (if any) which is being configured in the Profile.

    SQL Server Carpenter - Consultant & Trainer
    Author of Learn T-SQL from Scratch

  • September 25, 2019 at 11:20 am

    #3683247

    Thank you

    I figured it out

    It was the Server name was incorrect.  The MSTDC setup on the Cluster was wrong after correcting that email starting working.

    Thanks again for all the responses.

     

    Tom

     

     

  • September 25, 2019 at 8:56 pm

    #3683441

    trgrassijr wrote:

    Thank you

    I figured it out

    It was the Server name was incorrect.  The MSTDC setup on the Cluster was wrong after correcting that email starting working.

    Thanks again for all the responses.

    Tom

     

    Glad you found out what it was and thank you for sharing what the fix was.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
    "Change is inevitable... change for the better is not".
    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)
    Intro to Tally Tables and Functions

Viewing 5 posts - 1 through 4 (of 4 total)

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