Profiles are either public or private. A private profile is accessible only to specific users or roles. A public profile allows any user or role with access to the mail host database (msdb) to send e-mail using that profile.
A profile may be a default profile. In this case, users or roles can send e-mail using the profile without explicitly specifying the profile. If the user or role sending the e-mail message has a default private profile, Database Mail uses that profile. If the user or role has no default private profile, sp_send_dbmail uses the default public profile for the msdb database. If there is no default private profile for the user or role and no default public profile for the database, sp_send_dbmail returns an error. Only one profile can be marked as the default profile. To configure follow the bellow steps.
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.
click on Next button shown above then it will show set of Set up options as shown in the figure below.
click on next button from the above screen then it will show Mange Profile Security window. From the Manage Profile Security screen, select the target profile, then click in the Default Profile tab to activate the drop-down. Select Yes fromt the drop-down then click on next button as shown below screen.
Click on next button then it will show complete wizard window as shown below screen. From the Complete the Wizard screen, click on
Click on finish button then it will show status window as shown below.
A profile may be a default profile. In this case, users or roles can send e-mail using the profile without explicitly specifying the profile. If the user or role sending the e-mail message has a default private profile, Database Mail uses that profile. If the user or role has no default private profile, sp_send_dbmail uses the default public profile for the msdb database. If there is no default private profile for the user or role and no default public profile for the database, sp_send_dbmail returns an error. Only one profile can be marked as the default profile. To configure follow the bellow 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:
No comments:
Post a Comment