Can i configure gmail smtp with SQL server?

Question

I want use gmail smtp for sending outside mail how can i do that

---

Itrit

Answer 1

Hello,

Yes, you can. Please read the following post:

http://blogs.msdn.com/b/suhde/archive/2009/07/12/how-to-configure-sql-server-database-mail-to-send-email-using-your-windows-live-mail-account-or-your-gmail-account.aspx

Hope this helps.

Regards,

Alberto Morillo
SQLCoffee.com

Answer 2

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