SQL Tutorials

How To configure Database Mail in SQl server 2008 R2 Web

How To configureĀ  Database Mail in SQl server 2008 R2 Web

Description:

Here is the article for Database Mail configure using SQL server Agent in SQl server 2008 R2 web edition in SQL server management studio.

Steps:

Before start the need to check the below settings ,

– first Check the Database Mail enable or not.

– Create Database Mail account to use in SQL serve Agent.

– Now Need to create a database for SQL Agent for using in Databasemail Userrole in msdb.
How To configure  Database Mail in SQl server 2008 R2 Web
– Need to set default profile for msdb.

Steps for configure SQL Server Agent Database Mail,

– Login to the SQL server using the windows Authentication.

– Right click on SQL Server Agent and go to the properties.

– Click on Alert System and select Enable mail Profile.

– Now in Mail system select Database Mail.Then In Mail Profile list select the default profile for Database Mail.

– Then restart the SQL Server Agent.

Tags:SQl,SQl server,Database MAil,SQL Server Agent,Aganet mail service,Mail service system in SQL.