Manage Profiles and Accounts (Database Mail)

Manage an existing Database Mail profile. A Database Mail profile is a collection of Database Mail accounts. Profiles improve reliability in cases where an e-mail server becomes unreachable, by providing alternative Database Mail accounts. At least one Database Mail account is required.  We can create new account ,new profile and we can view, change and delete existing account and profile. To do this follow the below steps.

• Connect to the SQL Server Management Studio.
• In the Object Explorer, Go to Management Node,  expand Management Node, and Point to Database Mail option  and Right-Click on it as shown in the figure below:

• Once Configure Database Mail option is clicked, Database Mail Configuration Wizard  appears.  This wizard helps to set up the database mail in SQL Server Instance as shown below.

 

when Next button is clicked as shown above then it will show Set up option as shown in the figure below.  In this we can find 4 options 

1. In this first option, new profile and account can be created, SMTP account will be added, security in the mail profile can be set up and system parameters can be configured.  To configure this follow the below link
2. In the second option Manage Database Mail Accounts and  Profiles. Here we can create,view and delete the accounts and profiles.
3. In third option Manage Profile Security.
4. View or Change System parameters.

For the first step you can find here Configure Database Mail – Send Email From SQL Database Now we will know about second option i.e Manage Database Mail Accounts and  Profiles configuration follow the below steps. check the radio button Mange Database Mail Accounts and Profiles option form the Database Mail Configuration Wizard window as shown below and then click on next button.

 

When click on next button then it will show Manage profiles and accounts window as shown below.  Here you can find 4 options, 

1. Create a new account (you can find how to configure a new account link )
2. View,Change or Delete an existing account
3. Create a new profile (you can find how to configure a new Profile link )
4. View,Change or Delete an existing profile.  

Here i will describe about 2 and 4th options.

View,Change or Delete an existing account
To View,Change or Delete an existing account check the radio button and click on next button as shown below. 

When click on next button it will show Mange existing account window. Here you can change/edit or you can delete the accounts.  If more than one account has been created then select the account form the account name drop down list and the select delete button to delete of change the email address and passwords and then click on next button as shown in the below screen.

When your deleting any account which is associated with any one of the profile then it throw an error as shown below screen shot. 

If more than one account then follow the steps as shown in the below screen shot and then click on next button.

 When click on delete button and then account will be deleted form the list and click on next button it will show deleted accounts list as shown in the below screen shot.

Click on finish button then it will show successful message and deleted list or updated list as shown in the below screen shot.

View,Change or Delete an existing Profile
To View,Change or Delete an existing profile check the radio button and click on next button as shown below.

 It will show database mail configuration window as shown below.  We can delete profile.  If more than one profile then select the deleted one and then click on delete button as shown bellow. here either we can add new SMTP mail account or remove the existing account. 

When you click on add button it will show a window to add a mail account to the profile as shown below window.

When you click on new account then it will show a window to create a new database mail account as shown below screen shot.  To configure follow the same steps as shown in the previous article.

after configuring or modifying profile click on next button then it will show complete wizard window as shown below.

Click on finish button then it will show status of the configuration as shown below.