.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Post New Web Links

SSRS 2005 - Failure sending mail in e-mail subscription

Posted By:      Posted Date: October 19, 2010    Points: 0   Category :Sql Server
 

Hi,

I added a new TimedSubscription to a report.  However when the report ran, it hit an error.  The Status text was as follows.

Failure sending mail: The permissions granted to user 'domain\user1' are insufficient for performing this operation.

(assuming domain\user1 was my account)

I have the Content Manager role to the report and its folder.  I could run the report interactively with no issues.  This particular report does not require any parameters.

The odd thing was this only happened when I selected "Include Report".  If I selected only "Include Link" it would be fine.

To troubleshoot, I changed my role to System Administrator in Report Manager and re-tried.  The same result was observed.  However after I added my user account, domain\user1, to the local Administrators group, the problem went away!

What rights (in SSRS, local server, folder, etc) does a user need to have in order for the e-mail subscription with file inclusion to work?

The systems involved are as follows.

Windows Server 2003 (SP2)
Microsoft SQL Server Standard Edition, 9.00.4053.00

Thanks.

 

Best regards,

Jude.




View Complete Post


More Related Resource Links

Failure sending mail error in asp.net

  
Hi I have used gmail for sending mail localy which worked fine but when i uploaded the same file on server the "Failure sending mail." error occured.here is the code i have written:            Dim message As New MailMessage            message.From = New MailAddress("xxx@gmail.com")            message.To.Add(New MailAddress("xxx@yahoo.com"))            message.Subject = test mail""            message.Body = "Hi you have got a test mail from me!            Dim client As New SmtpClient            client.Credentials = New System.Net.NetworkCredential("xxx@gmail.com", "xxxxxxx")            client.Port = 587            client.Host = "smtp.gmail.com"            client.EnableSsl = True            client.Send(message)Pl

SSIS Send Mail Task - Failure Sending Mail

  
Dear all, I have switched off the firewall settings on my system and as suggested im entering the minimal information and data to send the mail. but still the Mail Task is failing.. plz suggest.

SSIS Send Mail Task - Failure Sending Mail

  
Hi Everyone, Hopefully someone out there will have an idea as this is driving me nuts. I've setup a task to email on success/failure and keep receiving the following message when executed: Progress: The SendMail task is initiated. - 0 percent complete[Send Mail Task] Error: An error occurred with the following error message: "Failure sending mail.". Progress: The SendMail task is completed. - 100 percent completeTask Send Mail Task failed When I configure Outlook Express on the same machine with the same settings it works. On the SMTP Connection Manager I have left the default name, tested with both an IP address and Server Name, and no authentication or SSL. On the Send Mail Task, it uses the above connection. The To: , From: , Subject  fields are populated. Message SourceType is DirectInput, MessageSource is Test, Priority is Normal and no attachments or expressions etc. Nothing useful is logged in the Event Viewer even with full logging turned on. Any suggestions appreciated, Thanks.

'System.Net.Mail.SmtpException: Failure sending mail.

  
'System.Net.Mail.SmtpException: Failure sending mail. ---> System.IO.IOException: Unable to read data from the transport connection: net_io_connectionclosed.   at System.Net.Mail.SmtpReplyReaderFactory.ProcessRead(Byte[] buffer, Int32 offset, Int32 read, Boolean readLine)   at System.Net.Mail.SmtpReplyReaderFactory.ReadLines(SmtpReplyReader caller, Boolean oneLine)   at System.Net.Mail.SmtpReplyReaderFactory.ReadLine(SmtpReplyReader caller)   at System.Net.Mail.SmtpReplyReader.ReadLine()   at System.Net.Mail.CheckCommand.Send(SmtpConnection conn, String& response)   at System.Net.Mail.MailCommand.Send(SmtpConnection conn, Byte[] command, String from)   at System.Net.Mail.SmtpTransport.SendMail(MailAddress sender, MailAddressCollection recipients, String deliveryNotify, SmtpFailedRecipientException& exception)   at System.Net.Mail.SmtpClient.Send(MailMessage message)   --- End of inner exception stack trace ---   at System.Net.Mail.SmtpClient.Send(MailMessage message)   at crmpark.bemail.sendemail(String toemail, String frmemail, String bcc, String cc, String strattach, String Subject, String bmessage) in    getting the above error when sending mail from asp.net 2.0

Error while sending email using ASP.NET 2.0 -'System.Net.Mail.SmtpException: Failure sending mail

  

'System.Net.Mail.SmtpException: Failure sending mail. ---> System.IO.IOException: Unable to read data from the transport connection: net_io_connectionclosed.   at System.Net.Mail.SmtpReplyReaderFactory.ProcessRead(Byte[] buffer, Int32 offset, Int32 read, Boolean readLine)   at System.Net.Mail.SmtpReplyReaderFactory.ReadLines(SmtpReplyReader caller, Boolean oneLine)   at System.Net.Mail.SmtpReplyReaderFactory.ReadLine(SmtpReplyReader caller)   at System.Net.Mail.SmtpReplyReader.ReadLine()   at System.Net.Mail.CheckCommand.Send(SmtpConnection conn, String& response)   at System.Net.Mail.MailCommand.Send(SmtpConnection conn, Byte[] command, String from)   at System.Net.Mail.SmtpTransport.SendMail(MailAddress sender, MailAddressCollection recipients, String deliveryNotify, SmtpFailedRecipientException& exception)   at System.Net.Mail.SmtpClient.Send(MailMessage message)   --- End of inner exception stack trace ---   at System.Net.Mail.SmtpClient.Send(MailMessage message) 

 i tried many things but still awaiting solution


svk

 

sometimes  i get this error

 'System.Net.Mail.SmtpException: Failure sending mail. ---> System.Net.WebException: The remote name could not be resolved: 'smtp.mail.y

Failure sending mail: Exception 0xc0000005 was generated at address 0x000007FEE3D4122B Mail will not

  

I'm running SSRS 2008R2.  I'm getting the above error a a couple of email subscriptions.  Some email subscriptions work, a few I'm getting this error message.  I've seen the posts about resetting IIS, SSRS and Agent Service.  I've done this, and it does seem to temporary fix the issue, but then it comes back. 

The one post where it says the "From" field containing more than 255 characters.  This is not my situation.

I need to find a more permanent fix for this issue.  Does anybody have any further insight.  Some postings seem to be related to older versions of SSRS.  I'm on the latest.

http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/5819e507-e398-4960-b5d4-c455d1140bbb

http://social.msdn.microsoft.com/Forums/en/sqlreportingservices/thread/28fea020-f2ef-4f6d-8c39-13dc00af87a1

Any help or suggestions would be appreciated.


Is Conditional Subscription possible in SSRS 2005?

  

Hi Guys,

Is there a way to set up a subscription that will send e-mails based on the contents of a report? For example, I want to schedule a daily subscription that will only send an e-mail if the report contains data, otherwise it will do nothing for that day. i.e If the report has more than one row, it should send the mail otherwise it should not send the mail.....

Is it possible in SSRS 2005 or is there any other way to do it???

 


how to embed image in mail body while sending mail in c#.net uisng Exchange2007_SP1.

  

 Hi,

I am uisng ExchangeVersion.Exchange2007_SP1 EWS to send mail through my c#.net application. I want to embed image in mail body so tht user can see body message along with image in its inbox mail .currently I am uisng image tag to show image but in the email body its just showing image url instead of image.
Thanks,
sachin


Multivalued parameter & Data driven subscription for SSRS 2005

  
I need to create data driven subscription for our reports. Most our reports have multi valued parameters (7-12 parameters with at least 4-5 with multiple values)and need to be send to a users between the range of 25-200. So standard subscription is really not a choice.I have gone through most of the threads before. Question 1:Does any one have a solution for the SSRS 2005 regarding passing mutiple values for a parameter for the Data subscription table. If yes, could you please share the information. Question 2:I found some solutions using the SOAP API. Can any one explain that in detail- how we can do it ?Reference:http://social.msdn.microsoft.com/forums/en-US/sqlreportingservices/thread/8ab615b4-1373-4258-bf49-c2843cfea8e9/http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=516735&SiteID=1 Question 3:Here is the other solution I found in one of the postsApparently passing in values like {A, B, C} only works when you configure the parameter values not to come from a dataset so that SSRS doesnt check for ValidValues.Reference: http://social.msdn.microsoft.com/forums/en-US/sqlreportingservices/thread/b2c50aea-2032-4025-a155-306c00fcb856/Any commends about this solution?Thanks

SSIS 2005 - Send Mail Task - signature appended to email is garbled - unicode problem?

  
Hi, I'm pretty new to SSIS so go easy on me. I have a Send Mail Task to notify if a file cannot be imported - the mailbody is created on the previous step by a VB.NET script task to include the name of the file and the path it's been archived to. The problem I'm having is that while the body of the email I've created is displaying fine, our company's Exchange server appends a signature to all emails, and this is coming up as undisplayable characters, presumably due to some kind of unicode encoding problem. I've tried casting the email body in an expression to DT_STR (doesn't work as DT_STR "cannot be converted to a supported type" which seems a bit odd but never mind), DT_WSTR (garbled signature), DT_TEXT/DT_NTEXT (strange error on this one - "Attempted to read or write protected memory") none of those ideas worked, and I'm a bit stumped now. Can anyone help? I'm using SSIS 2005 with SP3

Sending an e-mail with the content of a GridView in asp.net 2.0. problem

  
Hi experts,  I am Sending an e-mail with the content of a GridView in asp.net 2.0. Everything is working fine , but my problem is that  it is also sending "DELETE" LINKLabel to the email. Is there anyway so that only Content of Gridview will go to email and "Delete" Link will not go. Is it possible ??? Thanks in Advance

problem with sending mail by smtpclient

  
 hi , I have an aspx  page that sending a mail by smtp client , but it`s not work properly ! and pass an exeption : failur sending mail here is my code :   protected void BTN_Submit_Order_Click(object sender, EventArgs e) { MailMessage MailMsg = new MailMessage("Sales@anahidcorp.com", "test0@anahidcorp.com"); MailMsg.Subject = "?????"; MailMsg.Body = "????"; MailMsg.IsBodyHtml = false; MailMsg.BodyEncoding = System.Text.Encoding.Unicode; MailMsg.SubjectEncoding = System.Text.Encoding.Unicode; MailMsg.CC.Add("test1@anahidcorp.com"); MailMsg.CC.Add("test2@anahidcorp.com"); NetworkCredential cred = new NetworkCredential("Sales@anahidcorp.com", "mypass"); SmtpClient smtp = new SmtpClient("myserver"); smtp.UseDefaultCredentials = false; smtp.EnableSsl = true; smtp.Credentials = cred; try { smtp.Send(MailMsg); } catch ( SmtpException ex) { Response.Redirect("errpage.aspx?err=" +

SQL 2005 - SSRS - timeout on Subscription Creation

  
SSRS failing when we are trying to create the subscription with a "timeout" failure.  The report runs when run normally, and we have created subscriptions of this report on other computers.  We have adjusted the timeout value to a very long time.  The error message returned is:   The operation has timed out (System.Web.Services)   ------------------------------ Program Location:      at System.Web.Services.Protocols.WebClientProtocol.GetWebResponse(WebRequest request)    at System.Web.Services.Protocols.HttpWebClientProtocol.GetWebResponse(WebRequest request)    at Microsoft.SqlServer.Management.UI.RSClient.RSClientConnection.GetWebResponse(WebRequest request)    at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)    at Microsoft.SqlServer.ReportingServices2005.ReportingService2005.GetReportParameters(String Report, String HistoryID, Boolean ForRendering, ParameterValue[] Values, DataSourceCredentials[] Credentials)    at Microsoft.SqlServer.ReportingServices2005.RSConnection.GetReportParameters(String Report, String HistoryID, Boolean ForRendering, ParameterValue[] Values, DataSourceCredentials[] Credentials)    at Microsoft.SqlServer.Management.UI.RSClient.RSClientConnection.GetReportParameters(String report, String

Dynamics Ax report mail subscription error

  
I created a Dynamics Ax report. In this report some axapta static functions are called. When I run the report in browser it shows data normal. I created for this report email subscription(Setted the execution account).In the email is attached the report in pdf format, but for textboxes where it has to show data with results from axapta functions it shows "#Error". Running the report from link attached in mail shows data normal(Without"#Error"). What can be the solution for this problem?   The error from Event viewer: "The complete data cache has been flushed to request from session 13".      

how send mail with out help of sp_send_dbmail in sql server 2005

  
Hi all, I want to sent mail using sp_send_dbmail but the hosing have problem as it require admin permission on master db so  they told me not use this SP is there any other method so that i can send the mail using SQL Server 2005  Thanks and Regards Er.Pradipta Nayak
Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend