How to Configure DBMail in SQL Server - MS SQL Server DBA Tutorial

In this video you will learn how to configure DBMail in SQL Server using SQL Server Management studio as well as using T-SQL. It also explains how to configure Google smtp server as dbmail account in SQL Server using SQL Server management studio as well as T-SQL Script. It illustrates the smtp server configuration both for Exchange as well as google, what is the port google smtp server uses as well as port number of Microsoft Exchange Server. Step by step dbmail profile configuration as well as account setup. It also shows how to delete dbmail profile and account in sql server.

Script to Configure Database Mail in SQL Server by using Google Account

USE MASTER
 GO
 sp_configure 'show advanced options',1
GO

 RECONFIGURE WITH override
GO
 

sp_configure 'Database Mail XPs',1 
--go
--sp_configure 'SQL Mail XPs',0
 

GO 
RECONFIGURE 
GO


    
--CREATE Profile [Techbrothers]
    
EXECUTE msdb.dbo.sysmail_add_profile_sp
      
@profile_name = 'Techbrothers',
      
@description  = 'EmailNotification';
    
--CREATE Account [TechBrothers]
    
EXECUTE msdb.dbo.sysmail_add_account_sp
    
@account_name            = 'TechBrothers',
    
@email_address           = 'Techbrotherssqlage@gmail.com',
    
@display_name            = 'TechBrothers',
    
@replyto_address         = 'Techbrotherssqlage@gmail.com',
    
@description             = 'Email Notification',
    
@mailserver_name         = 'smtp.gmail.com',
    
@mailserver_type         = 'SMTP',
    
@port                    = '587',
    
@username                = 'Techbrotherssqlage',
    
@password                = 'GiveCorrectPassword', 
    
@use_default_credentials =  0 ,
    
@enable_ssl              =  1 ;
    
-- Associate Account [TechBrothers] to Profile [Techbrothers]
    
EXECUTE msdb.dbo.sysmail_add_profileaccount_sp
      
@profile_name = 'Techbrothers',
      
@account_name = 'TechBrothers',
      
@sequence_number = 1 ;
 
How to Configure DBMail in SQL Server

1 comment:

  1. I admire this article for the well-researched content and excellent wording. I got so involved in this material that I couldn’t stop reading. I am impressed with your work and skill. Thank you so much. If anyone looking for the Reliable SMTP Server provider, Mails2inbox is the best choice.

    ReplyDelete