Configuration of Gmail Smtp in Database mail in Sql Server 2008

Configuration of Gmail Smtp in Database mail in Sql Server 2008

Step 1:
           Connect to Sql server 2008.Expand Management in Object Explorer and right click on Database Mail and click Configure Database Mail 

Step 2:
select first option and click next.
       

Step 3:

Give any ProfileName for ex: "AlerNotify" and Click Add and then click New Account.



Step 4:



EmailAddress: vagalla.suresh@gmail.com
Display name: VAGALLA
Reply e-mail:vagalla.suresh@gmail.com
Server name: smpt.gmail.com
Port number:  587

Basic authentication

Username: vagalla.suresh@gmail.com
password: my gmail password
confirm password: my gmail password

Step 5:
Make that as default profile. and click Next and then Next and click Finish.


Step 6;
 close

Step 7:
  we can test  by right click on Database mail  and click send mail.