What should you do?

You are creating an application that will connect to the AgentPortal database by using a SQL login named AgentPortalUser. Stored procedures in the database will use sp_send_dbmail to send email messages.

You create a user account in the msdb database for the AgentPortalUser login. You use the Database Mail Configuration Wizard to create a Database Mail profile. Security has not been configured for the Database Mail profile.

You need to ensure that AgentPortalUser can send email messages.

What should you do?
A . In the Database Mail Configuration Wizard, create an email account for each recipient’s email address in the Database Mail profile.
B . Configure the AgentPortalUser user as a member of SQLAgentOperationRole in the msdb database.
C . In the Database Mail Configuration Wizard, configure the Database Mail profile as a private profile for the AgentPortalUser
D . Enable the Guest user in the msdb database.

View Answer

Answer: C

Explanation:

To send Database Mail, you must be a member of the DatabaseMailUserRole database role in the msdb database.