none
Can i configure gmail smtp with SQL server?

Answers

    • Marked as answer by Itrit Sunday, February 17, 2013 7:29 AM
    Sunday, February 17, 2013 6:35 AM
    Moderator
  • Hi,

    Ofcourse you can do that, please check

    http://techblissonline.com/troubleshoot-gmail-smtp-server-connection/

    http://techblissonline.com/gmail-smtp/

    check using following command

    telnet <server_name> <port_number>

    that smtp server is working now, configure using following steps

    1. Right-Click on Database Mail and choose Configure Database Mail

          This starts the Database Mail Configuration Wizard. Click Next.

    2. In the Select Configuration Task screen, choose “Set up Database Mail by performing the following tasks:” and click “Next”.

    3. Enter a Profile Name. This can be any Arbitrary Name that will help you identify the Profile. You might also want to add a Description. Now, click on Add

    4. Prompted to create a New Database Mail Account. Enter any Account Name and Description. The other parameters are as follows

    Configuring Google Mail (Gmail):

    Email address: Your Gmail ID
    Display name: Your name
    Reply e-mail: Any reply-to email account
    Server name: smtp.gmail.com
    Port number: 587
    This server requires a secure connection (SSL): Checked ON
    In the next section, choose Basic Authentication and enter the following information:            
    User name: Your gmail ID            
    Password: Password for your gmail ID            
    Confirm password: Password for your gmail ID            

    5. New Profile screen, click Next. The next Manage Profile Security screen allows you to set the Public Profiles, the Private Profiles and the Default Profiles for each of the Public and Private Profiles.        

    Start sending emails now



    Please help and appreciate others by using these features: "Propose As Answer", "Vote As Helpful" and "Mark As Answer"

    Waqas

    MS(SPM), MS(E&F),M.Engg, MCP, MCT, MCTS, MCITP, MCSE, MCPD, MCSD, MCDBA , Author
    Twitter: @Waqas_m1
    Linked In: http://www.linkedin.com/in/waqasm1



    • Proposed as answer by Waqas M Sunday, February 17, 2013 6:49 AM
    • Edited by Waqas M Sunday, February 17, 2013 7:19 AM
    • Marked as answer by Itrit Sunday, February 17, 2013 7:29 AM
    Sunday, February 17, 2013 6:49 AM

All replies

    • Marked as answer by Itrit Sunday, February 17, 2013 7:29 AM
    Sunday, February 17, 2013 6:35 AM
    Moderator
  • Hi,

    Ofcourse you can do that, please check

    http://techblissonline.com/troubleshoot-gmail-smtp-server-connection/

    http://techblissonline.com/gmail-smtp/

    check using following command

    telnet <server_name> <port_number>

    that smtp server is working now, configure using following steps

    1. Right-Click on Database Mail and choose Configure Database Mail

          This starts the Database Mail Configuration Wizard. Click Next.

    2. In the Select Configuration Task screen, choose “Set up Database Mail by performing the following tasks:” and click “Next”.

    3. Enter a Profile Name. This can be any Arbitrary Name that will help you identify the Profile. You might also want to add a Description. Now, click on Add

    4. Prompted to create a New Database Mail Account. Enter any Account Name and Description. The other parameters are as follows

    Configuring Google Mail (Gmail):

    Email address: Your Gmail ID
    Display name: Your name
    Reply e-mail: Any reply-to email account
    Server name: smtp.gmail.com
    Port number: 587
    This server requires a secure connection (SSL): Checked ON
    In the next section, choose Basic Authentication and enter the following information:            
    User name: Your gmail ID            
    Password: Password for your gmail ID            
    Confirm password: Password for your gmail ID            

    5. New Profile screen, click Next. The next Manage Profile Security screen allows you to set the Public Profiles, the Private Profiles and the Default Profiles for each of the Public and Private Profiles.        

    Start sending emails now



    Please help and appreciate others by using these features: "Propose As Answer", "Vote As Helpful" and "Mark As Answer"

    Waqas

    MS(SPM), MS(E&F),M.Engg, MCP, MCT, MCTS, MCITP, MCSE, MCPD, MCSD, MCDBA , Author
    Twitter: @Waqas_m1
    Linked In: http://www.linkedin.com/in/waqasm1



    • Proposed as answer by Waqas M Sunday, February 17, 2013 6:49 AM
    • Edited by Waqas M Sunday, February 17, 2013 7:19 AM
    • Marked as answer by Itrit Sunday, February 17, 2013 7:29 AM
    Sunday, February 17, 2013 6:49 AM