SQL Server DBA Tutorial 21 - How to configure Database Mail in SQL Server

*****************************************************************************************
* How to configure Database Mail in SQL Server *
*****************************************************************************************

We will be using two ways in SQL Server
1. Using SQL Server management studio graphic user interface GUI Version
2. Using T-SQL script

Information Needed:
2 - Email address (Valid mail Account)
3 - Mail Account Credentials (Valid Mail Account and Password)

/**T-SQL script**/
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 [Chiragstutorial]
@profile_name = 'Chiragstutorial',
@description = 'EmailNotification';
--CREATE Account [ChiragsTutorial]
@account_name = 'ChiragsTutorial',
@display_name = 'ChiragsTutorial',
@description = 'Email Notification',
@mailserver_type = 'SMTP',
@port = '587',
@password = 'GiveYourGmailCorrectPassword',
@use_default_credentials = 0 ,
@enable_ssl = 0 ;
-- Associate Account [ChiragsTutorial] to Profile [Chiragstutorial]
@profile_name = 'Chiragstutorial',
@account_name = 'ChiragsTutorial',
@sequence_number = 1 ;

Note : Flow the Process shown in video.

😉Subscribe and like for more videos:
💛Don't forget to, 💘Follow, 💝Like, 💖Share 💙&, Comment

Tutorial Link :

Thanks & Regards,
Chitt Ranjan Mahto "Chirag"
_________________________________________________________________________________________
Note: All scripts used in this demo will be available in our website.
Link will be available in description.

#DBATutorial
#DBATutorialLearning
#DBAEducation
#DBATutorialFree
#DatabaseTutorial
#SQLServerDatabaseTutorial
#SQLServerDBATutorial
#MicrosoftSQLServerDatabaseTutorial
#ChiragsDBATutorial
#ChiragsDatabaseTutorial
#ChiragsSQLServerDatabaseTutorial
#ChiragsSQLServerDBATutorial
#ChiragsMicrosoftSQLServerDatabaseTutorial
#CreateDatabaseinSQLServer
#CreateDatabasewithT-SQL
#chiragstutorial
#databasetutorial
#sqlserver
#sqlservertutorial
#sqlservermanagementstudio
#sql_server
#sqlservertutorial
#chiragstutorial
#databasetutorial
#sqlqueries
#sqldba
#database
#databasemanagement