Sql Mail Ms 05

[JoeyD]

I am using the sql send mail stored procedure inside an asp.net 2.0 website. When I run it on my localhost it sends the mail fine. However, when I build it out to our main server on the UNC it won't send the mail. Is there any permissions or setting that I might need to change to allow that server to use the procedures.?

JoeyD

[Marin]

What error message (if any) did you get? Do you have a mail profile properly set on SQL server, if not xp_sendmail won't work.