Update a Database Mail Account (SSMS)

Here, I demonstrate how to update a Database Mail account in SQL Server using the SQL Server Management Studio (SSMS) graphical user interface.

If you want to see how to do it using T-SQL, see Update a Database Mail Account (T-SQL).

Let’s Begin

From the Object Explorer, open the Management node and right click Database Mail:

Screenshot of the Configure Database Mail option

From the context menu, click Configure Database Mail.

You may get an interim “Welcome” screen before you get to the next one. If so, click Next > to continue to the following screen.

This opens the Select Configuration Task screen:

Screenshot of the Select Configuration Task screen

On this screen, select Manage Database Mail accounts and profiles, then click Next >.

This moves us on to the next screen:

Screenshot of the Manage Profiles and Accounts screen

Select View, change, or delete an existing account and click Next >.

This opens the Manage Existing Account screen:

Screenshot of the Manage Existing Account screen with the dropdown menu highlighted

Use the dropdown menu at the top to select the account that you’d like to update.

Once you have selected the account, the details for that account will be populated into the various fields of the dialog box:

Screenshot of the Manage Existing Account screen

You can now review these details and make changes as necessary.

If you need to change multiple accounts, you can select each one from the dropdown and make changes as required. This saves you from having to launch the wizard for every account that needs to be changed.

Once you’ve made the changes you need to make, click Next >.

This brings us to a screen that allows us to review the changes before they are actually implemented:

Screenshot of the confirmation screen

If you’re updating multiple accounts, you’ll see each one listed here.

If anything looks wrong, go back and make adjustments as required, before returning to this screen.

Click Finish to implement the changes.

This implements the changes, and once all changes are done, the following screen is displayed:

Screenshot of the final screen

The account has now been updated.

Click Close to finish.