Tag Archives: microsoft SQL Server

DB Mail configuration on SQL Server

Enable the Database mail configuration

1. Enable the db mail configuration on SQL Server

sp_configure 'Database Mail XPs',1
reconfigure

2. Enable service broker in the MSDB database.

ALTER DATABASE [MSDB] SET  ENABLE_BROKER WITH NO_WAIT;

3. Open the SQL Server Management Studio and right click on database mail

4. Configure the mail with SMTP and mail id

5. Go to SSMS (SQL Server Management Studio) and test the mail by right click on database mail.