Database Mail

We have a user set up for our .net framework (webuser) with access to a database we created for our website. "webuser" needs to be able to send out emails using Databse Mail (SQL Server 2005) via a stored proc by excuting msdb.dbo.sp_send_dbmail. This stopred proc works fine when I am logged in as administrator but won't work for "webuser" and I can't seem to grant DatabaseMailUserRole to our that user either. What do I need to do?

I have bee trying to find a "how to" on setting this up but have been unsuccessful.

What do you mean by you can't grant? What errors or problems did you have? Did you add the user to msdb and then add the user to the role?

-Sue

|||Hi,
1.) Goto "Databasemail" under Management,
2.) Click on "Manage Profile Security"
3.) Goto "Private profiles" and select the 'webuser' from the dropdown menu and give access to the profile which webuser should use

or else

you can go to the 'public profile', There you can select a profile which can be used as public users and make this as default profile. And call this profile in webapplication to send mail.