Solved

SQL Server database mail with ASP.net

Posted on 2009-05-14
6
358 Views
Last Modified: 2012-05-07
I am having a problem using SQL Server 2005 database mail from ASP.net (w/ VB.net).

I can run the stored procedure that sends the mail in SQL Server and it works perfect.

However, when I run the same stored procedure in ASP.net the email is not sent.

I obviously am missing something somewhere, any help????
0
Comment
Question by:yonbret
  • 3
  • 3
6 Comments
 
LVL 6

Expert Comment

by:bull_rider
ID: 24388030
Its actually the user who is running it from asp.net. His permissions are not set accordingly.
0
 

Author Comment

by:yonbret
ID: 24388047
I was guessing that.

Does it run using the Network Service account, like most ASP.net processes?

What permissions need to be set?
0
 

Author Comment

by:yonbret
ID: 24389262
I have discovered one other thing that is helpful to know.

If I run the stored proc using Windows Authentiacation, the email is sent without a problem.

If I run the stored proc using SQL Authentication, the email is not sent.
0
Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

 
LVL 6

Expert Comment

by:bull_rider
ID: 24391749
Could you please mark this question answered then if it did resolve your actual issue?
0
 

Author Comment

by:yonbret
ID: 24396280
The question is not answered.

I need to know why SQL Authentication is not working, but Windows Authentication is working?

What account is used by SQL Authentication? What permissions need to be set for this account on the SMTP server?
0
 
LVL 6

Accepted Solution

by:
bull_rider earned 500 total points
ID: 24397582
Please follow the below link:

http://www.sqlserverspecialists.co.uk/blog/_archives/2007/10/18/3299690.html

Let me know if you still face this issue.
0

Featured Post

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Just a quick little trick I learned recently.  Now that I'm using jQuery with abandon in my asp.net applications, I have grown tired of the following syntax:      (CODE) I suppose it just offends my sense of decency to put inline VBScript on a…
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
Internet Business Fax to Email Made Easy - With  eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, f…

912 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now