SQL Server DBA Tutorial 132-How to configure DBMail in SQL Server

Поділитися
Вставка
  • Опубліковано 25 жов 2024

КОМЕНТАРІ • 23

  • @LaRothe
    @LaRothe 8 років тому +2

    I'm with error:The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 3 (2016-08-03T11:47:38). Exception Message: Could not connect to mail server. (A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond 64.233.190.109:587).
    )
    How do I solve this?

  • @dhruvpatel1466
    @dhruvpatel1466 4 роки тому

    I have followed all of your instructions and still, I am not able to get a test email. I am also trying to use the send email task on SSIS, but I am getting an error. The error is this: Error: 0xC002F304 at Send Mail Task, Send Mail Task: An error occurred with the following error message: "Failure sending mail. System.Net.WebException: Unable to connect to the remote server System.Net.Sockets.SocketException: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond 74.125.195.109:25".
    Task failed: Send Mail Task

    • @TechBrothersIT
      @TechBrothersIT  4 роки тому

      First please check if google SMTP is still available to use? Second you are not using the right port (25 is for exchange) I have shown port that was available for google SMTP when I published the video. Based on your error those are two issues needs to be resolved in order for you to use google SMTP.

  • @prawinumar9211
    @prawinumar9211 9 років тому +1

    Hi Aamir,
    Thanks for posting the video i have followed all the steps what you u have advised in video but got error as below
    The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 2 (2015-09-30T22:49:47). Exception Message: Cannot send mails to mail server. (The SMTP server requires a secure connection or the client was not authenticated. The server response was: 5.7.0 Must issue a STARTTLS command first. xu5sm1791459pab.12 - gsmtp).
    )
    Can u please suggest

    • @gates1978
      @gates1978 8 років тому +1

      +prawin umar Hi tech Brothers, same issue over here. Please help

    • @lakshayarora3935
      @lakshayarora3935 5 років тому

      Same issue with me also

  • @prathipraveen
    @prathipraveen 6 років тому

    i cannot find DATABASE MAIL IN SqlServerLog...what can i do

  • @bcakansagarafy4051
    @bcakansagarafy4051 3 роки тому

    helloo, i dont have an option of database mail in ssms... how to add??

    • @TechBrothersIT
      @TechBrothersIT  3 роки тому

      Check your permissions, try sysadmin permissions to see if you get that option.

  • @luffyy8194
    @luffyy8194 3 роки тому

    Thanks

  • @rahulgautam511
    @rahulgautam511 3 роки тому +1

    Hello,
    Not getting email.

    • @luffyy8194
      @luffyy8194 3 роки тому

      ua-cam.com/video/eJU8ZdzfMWo/v-deo.html

    • @luffyy8194
      @luffyy8194 3 роки тому

      You need to enable IMAP in Gmail settings and then turn on 'less secure app access' in Google account.

  • @banalasiva5743
    @banalasiva5743 3 роки тому

    The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 1003 (2021-03-09T11:12:38). Exception Message: Could not connect to mail server.(smtp server requires a secure connection or the client was not authenticated the server response was 5.7.0 must issue a STARTTLS command first mu6sm1135567pjb.35 -gsmtp)

    • @TechBrothersIT
      @TechBrothersIT  3 роки тому

      This means you don’t have permission on the smtp server, if you do, please select secure connection option. Usually if you are trying to use google or other available smtp, they have their specific requirements.

    • @banalasiva5743
      @banalasiva5743 3 роки тому

      @@TechBrothersIT can u guide how to resolve

  • @manoharchowdarycherukuri7088
    @manoharchowdarycherukuri7088 3 роки тому

    im getting the error it will not send a mail to gmail.

    • @TechBrothersIT
      @TechBrothersIT  3 роки тому

      Please check gmail smtp requirements, I believe they have tightened the security.

    • @luffyy8194
      @luffyy8194 3 роки тому

      ua-cam.com/video/eJU8ZdzfMWo/v-deo.html

  • @banalasiva5743
    @banalasiva5743 3 роки тому

    i am getting this error

  • @noorhirjee2274
    @noorhirjee2274 9 років тому

    PL EXPLAIN HOW TO INSTALL SMTP SERVER. THANKS.

    • @TechBrothersIT
      @TechBrothersIT  9 років тому +1

      +Noor Hirjee Thanks for contacting us. Will have this topic in list and try to get to it.

    • @noorhirjee2274
      @noorhirjee2274 8 років тому +1

      I am still waiting for SMTP SERVER TOPICS.THANKS