Solved

SQL Server database mail with ASP.net

Posted on 2009-05-14
6
359 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
NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

 
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

Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
date diff with Fiscal Calendar 4 57
hbo knew my windows software 4 62
Create a datatable in vb.net dynamically 1 23
Access Schema 6 26
Problem Hi all,    While many today have fast Internet connection, there are many still who do not, or are connecting through devices with a slower connect, so light web pages and fast load times are still popular.    If your ASP.NET page …
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…

830 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