Okay, I'll give you the step by step process
Configuring DBMail setup:
Go to Object Explorer -> Management -> Right Click on database mail and Select 'Configure Database Mail' as follows
next -> Select 'setup database mail by performing the following ' as follows -> next
-> enter profile name = 'SQL Profile' and description as follows
-> click on add button -> enter the following details. Always use your own email id. Generally we have to use here company email id. we've to raise ticket to mail server admin team to get the following details.
*separate email id for SQL Server
* SMTP server name
* port nmber
* ssl feature should be enable or disable.
-> In Basic authentication option enter same email id along with valid password of the email id.
-> ok -> Next -> Under manage profile security option make the profile as public by selecting checkbox and default as follows.
-> Next -> Accept the default setting for System Parameters as follows.
Finish.
Close.
this is the process of configuring the dbmail i were followed.
