Results 1 to 4 of 4

Thread: Database mail setup using gmail smtp

  1. #1
    Join Date
    May 2009
    Posts
    41

    Database mail setup using gmail smtp

    hello,

    I am trying to setup database mail and I want to use gmail outgoing server. I used below instructioin bubt these don't seem to work.
    ---------------------------------------------
    email id: youremailid#gmail.com ( should have gmail.com)
    Display Name: SQL Server
    Reply email: can leave blank
    Server name: smtp.gmail.com ( this is really important)
    port no: 587 ( on many website this is given as 465 which is wrong, use 587 )
    Check : This server requires a secure connection
    Check Basic Authentication
    username: youremailid@gmail.com ( should have gmail.com)
    password: ( top secret , dont display ) …
    confirm password: confirm your password

    click next and also you need to make it default public profile.

    After you do this, you also have to change SQL Server Agent properties, in Properties click alerts system and then select database mail.
    MOST IMRORTANT when you make changes, to SQL SERVER AGENT properties, restart only SQL SERVER AGENT.

    right click SQL Server Agent and click restart, and then test your database mail.

    to test, right click database mail and click send test mail… VERY IMPORTANT ( Select right profile/account from drop down list), put any email id and click send test email. click ok.
    -------------------------------------------------------

    Anyone has other idea or suggestion??
    Last edited by yogesphu; 07-27-2011 at 02:18 PM.

  2. #2
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    Are you trying to configure it in a corporate environment?. Have you checked if your firewall policy allows to use google smtp on port 587?

  3. #3
    Join Date
    May 2009
    Posts
    41
    We got it figured out yesteday. and yes connectivity to their smtp was the problem. We were not even getting ping response from smtp.gmail.com. That is sorted out now and it is working fine. Thanks for your response though.

  4. #4
    Join Date
    Aug 2011
    Posts
    1

    this was a firewall issue, correct ?

    So I can understand, the solution that was found did include opening F/W port for smtp to gmail ? If some other action was needed, be interesting to know.
    Thanks. Rick

Posting Permissions

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