Error when attaching report file to email subscriptions on reporting services sql 2012
This might be a permission issue but cant seem to find out where else i need to add permissions for this person. They have a report created by someone else on the system. i can add a subscription for it and have it emailed to me with attachment
and works perfectly. when this user adds the subscription and has the attachment added it gets an error "Failure sending mail: The report server has encountered a configuration error. Mail will not be resent.", if there is not attachment
and the link is sent no error appears.Michael Duhon
July 16th, 2012 5:01pm
Check if this helps: A call to the AuthzInitializeContextFromSid API function fails during the delivery of an e-mail subscription
in SQL Server Reporting Services
Free Windows Admin Tool Kit Click here and download it now
July 17th, 2012 1:13am
Perfect, just went into the reporting services configuration manager and changed the Report Server Service Account from Local Service to a Domain account and emails starting working with attachments! thanksMichael Duhon
July 17th, 2012 11:18am
Actually after a day after adding a windows account to the service startup account it sends the reports as attachments just fine but other user's can't log into the site anymore. This web link helped me fix the issue now attachments are working and
users can access the Reports web page.
http://msdn.microsoft.com/en-us/library/cc281253.aspxMichael Duhon
Free Windows Admin Tool Kit Click here and download it now
July 31st, 2012 5:22pm