Email Subscriptions Issue

Hi,
I've been having an issue getting email subscriptions going. I've followed
the link on Configure a Report Server for E-mail Delivery on msdn2 and it
looks like it creates the report, I'm just getting an odd CAS issue I don't
know how to resolve.
Here is the info from my log
ReportingServicesService!schedule!4!3/21/2006-08:30:01:: Creating Time based
subscription notification for subscription:
c2ab0c2a-b6f1-4778-bd8a-f095d11a04b8
ReportingServicesService!library!4!3/21/2006-08:30:01:: Schedule
b91a6628-784f-4c47-853d-8a589c2a6879 execution completed at 3/21/2006
8:30:01 AM.
ReportingServicesService!dbpolling!4!3/21/2006-08:30:01:: EventPolling
finished processing item 67befaa3-5171-4991-b84e-61c064c1a5ed
ReportingServicesService!dbpolling!c!3/21/2006-08:30:01::
NotificationPolling processing 1 more items. 1 Total items in internal
queue.
ReportingServicesService!dbpolling!d!3/21/2006-08:30:01::
NotificationPolling processing item 3b191c1b-5df5-42ee-9ed1-6437e7c68d90
ReportingServicesService!notification!d!03/21/2006-08:30:01:: e ERROR: Error
occured processing notification. Request for the permission of type
'System.Web.AspNetHostingPermission, System, Version=2.0.0.0,
Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.
ReportingServicesService!notification!d!03/21/2006-08:30:01:: Notification
3b191c1b-5df5-42ee-9ed1-6437e7c68d90 completed. Success: True, Status:
Request for the permission of type 'System.Web.AspNetHostingPermission,
System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'
failed., DeliveryExtension: Report Server Email, Report: SalesOrderSummary,
Attempt 0
ReportingServicesService!dbpolling!d!03/21/2006-08:30:01::
NotificationPolling finished processing item
3b191c1b-5df5-42ee-9ed1-6437e7c68d90
I've searched for the AspNetHostingPermission regards to this, but can't
seem to find it. I set an unattended execution account but no good there.
do I have to give whatever account the ReportingServiceServices is running
as AspNetHostingPermission access? And to what?
Thanks,
ChrisHi Chris,
Welcome to the MSDN newsgroup.
From your description, I understand you're encounering some problem in the
SQL 2005 reporting service when use the email delivery service to send
email notification, correct?
Based on the log entry you provided, the reporting service application is
concerning about the ASPNETHostPermission, this is quite strange and I
seldom see error on this object,(mostly it'll report error regarding on a
certain account or an API call...).
I think we can first try confirming this issue to be a .NET cas specific
one. You can use the "caspol.exe" tool(shiped with .net framework to
configure .NET code access policy setting)
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/htm
l/cpconusingcodeaccesssecuritypolicytoolcaspolexe.asp
use the "caspol.exe -s off" to temporarly disable the CAS checking. Test
the SSRS email delivery again under the CAS disabing mode to see whether it
still suffer the issue. If not, we can confirm the problem to be a .net CAS
configration or code evidence specifc issue.
Also, you can try creating another SSRS report and configure it to use
EMAIL delivery to see whethre this is a common problem on that server
machine.
In addition, here are some reference introducing the .NET CAS used in SQL
2005 reporting service:
#Understanding Code Access Security in Reporting Services
http://msdn2.microsoft.com/en-us/library/ms155108.aspx
Please feel free to post here if you've any other finding.
Regards,
Steven Cheng
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi Steven,
Thanks for the response. So I ran caspol -s off which temporarily disabled
CAS checking. Ran the subscription and no dice. I tried running it as a
file share, same error as before with the ASPNetHostingPermission.
When you talk about creating a report for email delivery, what exactly do
you mean. I'm afraid I'm not sure what to do here.
Thanks!
Chris
"Steven Cheng[MSFT]" <stcheng@.online.microsoft.com> wrote in message
news:I9pOSMYTGHA.7884@.TK2MSFTNGXA03.phx.gbl...
> Hi Chris,
> Welcome to the MSDN newsgroup.
> From your description, I understand you're encounering some problem in the
> SQL 2005 reporting service when use the email delivery service to send
> email notification, correct?
> Based on the log entry you provided, the reporting service application is
> concerning about the ASPNETHostPermission, this is quite strange and I
> seldom see error on this object,(mostly it'll report error regarding on a
> certain account or an API call...).
> I think we can first try confirming this issue to be a .NET cas specific
> one. You can use the "caspol.exe" tool(shiped with .net framework to
> configure .NET code access policy setting)
>
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/htm
> l/cpconusingcodeaccesssecuritypolicytoolcaspolexe.asp
>
> use the "caspol.exe -s off" to temporarly disable the CAS checking. Test
> the SSRS email delivery again under the CAS disabing mode to see whether
> it
> still suffer the issue. If not, we can confirm the problem to be a .net
> CAS
> configration or code evidence specifc issue.
> Also, you can try creating another SSRS report and configure it to use
> EMAIL delivery to see whethre this is a common problem on that server
> machine.
> In addition, here are some reference introducing the .NET CAS used in SQL
> 2005 reporting service:
> #Understanding Code Access Security in Reporting Services
> http://msdn2.microsoft.com/en-us/library/ms155108.aspx
> Please feel free to post here if you've any other finding.
> Regards,
> Steven Cheng
> Microsoft Online Community Support
>
> ==================================================> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ==================================================>
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>|||Thanks for your response Chris,
So turn off CAS still suffer the problem, it is likely not a typical CAS
configuration issue. The "creating a report for email delivery" I mentioned
means create another report or a new email notification task to see whether
it also suffers the problem.
BTW, does this problem occur the first time on that server and have you
ever successfully used the email notification on that server before?
Regards,
Steven Cheng
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may
learn and benefit from your issue.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi Steven,
I tried creating a new report with new email delvery options. Same result.
No, I have never used email delivery on this before, so I've never had a
successful run of it.
What else can I check?
Thanks!
Chris
"Steven Cheng[MSFT]" <stcheng@.online.microsoft.com> wrote in message
news:eIzGbZnTGHA.864@.TK2MSFTNGXA03.phx.gbl...
> Thanks for your response Chris,
> So turn off CAS still suffer the problem, it is likely not a typical CAS
> configuration issue. The "creating a report for email delivery" I
> mentioned
> means create another report or a new email notification task to see
> whether
> it also suffers the problem.
> BTW, does this problem occur the first time on that server and have you
> ever successfully used the email notification on that server before?
> Regards,
> Steven Cheng
> Microsoft Online Community Support
>
> ==================================================> When responding to posts, please "Reply to Group" via your newsreader so
> that others may
> learn and benefit from your issue.
> ==================================================>
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>|||To add to this I'm using Forms Auth. However, running in debug mode and
letting the server execute doesn't ever hit any breakpoints...
"Steven Cheng[MSFT]" <stcheng@.online.microsoft.com> wrote in message
news:eIzGbZnTGHA.864@.TK2MSFTNGXA03.phx.gbl...
> Thanks for your response Chris,
> So turn off CAS still suffer the problem, it is likely not a typical CAS
> configuration issue. The "creating a report for email delivery" I
> mentioned
> means create another report or a new email notification task to see
> whether
> it also suffers the problem.
> BTW, does this problem occur the first time on that server and have you
> ever successfully used the email notification on that server before?
> Regards,
> Steven Cheng
> Microsoft Online Community Support
>
> ==================================================> When responding to posts, please "Reply to Group" via your newsreader so
> that others may
> learn and benefit from your issue.
> ==================================================>
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>|||Thanks for your followup Chris,
Since the email delivery never run on the server, I'm thinking whether
there is something incorrectly about the RS installation. Is it possible
that you try unstalling and reinstalling the RS service?
Regards,
Steven Cheng
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi Steven,
Thank you for the continued assistance. I've decided to escalate this to an
MSDN support incident since it seems to be much more than meets the eye.
To answer your question though, it's happening on 3 different servers with
RS on it. Each one same issue.
Thank you so much for your continued support though!
-Chris
"Steven Cheng[MSFT]" <stcheng@.online.microsoft.com> wrote in message
news:Z6ib5%23lUGHA.4716@.TK2MSFTNGXA01.phx.gbl...
> Thanks for your followup Chris,
> Since the email delivery never run on the server, I'm thinking whether
> there is something incorrectly about the RS installation. Is it possible
> that you try unstalling and reinstalling the RS service?
> Regards,
> Steven Cheng
> Microsoft Online Community Support
>
> ==================================================> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ==================================================>
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>|||Thanks for your response Chris,
Hope you'll soon get this resolved. And welcome to post the result and
share with us when you got it resolved.
Regards,
Steven Cheng
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.sql