Question

You have to configure a SQL Server instance to ensure that a user named U1 can send mail by using Database Mail. Solution: You add the DatabaseMailUserRole to U1 in the tempdb database. Does this solution meet the goal?

a) True
b) False

Answer 1

The proposed solution is incorrect because Database Mail permissions must be configured in the msdb database, not the tempdb database.

The solution of adding the user U1 to the DatabaseMailUserRole in the tempdb database does not meet the goal of configuring a SQL Server instance to ensure that the user U1 can send mail by using Database Mail. The correct approach is to add the user U1 to the DatabaseMailUserRole in the msdb database, not tempdb. The msdb database is where SQL Server stores schedules, alerts, and Database Mail configuration data, so permissions related to Database Mail should be configured there.

Therefore, the proposed solution is incorrect; instead, you should focus on the msdb database for Database Mail configuration and permissions.