Add Gmail as Database Mail Account.sql

-- Add gmail account as Profile

EXEC sys.sp_configure N'show advanced options',1
go
reconfigure
go

EXEC sys.sp_configure N'Database Mail XPs', N'1' 
GO 
RECONFIGURE 
GO 
EXECUTE msdb.dbo.sysmail_add_profile_sp  
   @profile_name=N'Gmail Notification Account',  
   @description=N'Email Notifications from SQL Server using Gmail Account' 
GO 
EXECUTE msdb.dbo.sysmail_add_principalprofile_sp  
   @principal_name=N'guest',  
   @profile_name=N'Gmail Notification Account',  
   @is_default=1 
GO 

EXECUTE msdb.dbo.sysmail_add_account_sp    
   @account_name='Gmail Notifications', 
   @email_address='bulentgucuk@gmail.com', 
   @display_name='SQL Server Gmail Notifications',  
   @replyto_address='bulentgucuk@gmail.com',  
   @description='Email Address for sending Notifications using Gmail',  
   @mailserver_name='smtp.gmail.com', 
   @mailserver_type='SMTP', 
   @port=587, 
   @username='bulentgucuk@gmail.com', 
   @password = 'Kehribar',   ----- CHANGE THE PASSWORD!!!!!!!!!!!!!
   @use_default_credentials=0, 
   @enable_ssl=1 
   
 EXECUTE msdb.dbo.sysmail_add_profileaccount_sp  
   @profile_name=N'Gmail Notification Account',  
   @account_name=N'Gmail Notifications',
   @sequence_number = 1 ; 
GO