Hello:
Two questions.
First, generally speaking, how do you configure SQL 2000 to e-mail end
users? I have a SQL script that shows, in an accounting database, inventory
items that have not been purchased from a vendor within the last year. I
want to e-mail that list of items to end users on a monthly basis. That
list of items amounts to a report.
Secondly, my script has a specific date. It, basically, says < 06/01/06. I
don't want the IT staff to have to come in and update the date parameter. Is
there a way to place syntax in the script to pull the date from the operating
system?
Thanks!
childofthe1980s> First, generally speaking, how do you configure SQL 2000 to e-mail end
> users?
I suggest you use xp_smtp from www.sqldev.net. The built-in email support in 2000 is based on MAPI
and is a hassle to get working.
> Secondly, my script has a specific date. It, basically, says < 06/01/06. I
> don't want the IT staff to have to come in and update the date parameter. Is
> there a way to place syntax in the script to pull the date from the operating
> system?
Most probably (can't say for sure without knowing anything about your code). Check out the GETDATE()
function.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"childofthe1980s" <childofthe1980s@.discussions.microsoft.com> wrote in message
news:273474B7-38E8-435F-835A-123502316C07@.microsoft.com...
> Hello:
> Two questions.
> First, generally speaking, how do you configure SQL 2000 to e-mail end
> users? I have a SQL script that shows, in an accounting database, inventory
> items that have not been purchased from a vendor within the last year. I
> want to e-mail that list of items to end users on a monthly basis. That
> list of items amounts to a report.
> Secondly, my script has a specific date. It, basically, says < 06/01/06. I
> don't want the IT staff to have to come in and update the date parameter. Is
> there a way to place syntax in the script to pull the date from the operating
> system?
> Thanks!
> childofthe1980s|||Please don't post independently in separate newsgroups. You can add
multiple newsgroups to the header and then all the answers appear as one.
See my reply in the other newsgroup.
Andrew J. Kelly SQL MVP
"childofthe1980s" <childofthe1980s@.discussions.microsoft.com> wrote in
message news:273474B7-38E8-435F-835A-123502316C07@.microsoft.com...
> Hello:
> Two questions.
> First, generally speaking, how do you configure SQL 2000 to e-mail end
> users? I have a SQL script that shows, in an accounting database,
> inventory
> items that have not been purchased from a vendor within the last year. I
> want to e-mail that list of items to end users on a monthly basis. That
> list of items amounts to a report.
> Secondly, my script has a specific date. It, basically, says < 06/01/06.
> I
> don't want the IT staff to have to come in and update the date parameter.
> Is
> there a way to place syntax in the script to pull the date from the
> operating
> system?
> Thanks!
> childofthe1980s
Showing posts with label configure. Show all posts
Showing posts with label configure. Show all posts
Monday, March 26, 2012
e-mailing users in SQL 2000
Hello:
Two questions.
First, generally speaking, how do you configure SQL 2000 to e-mail end
users? I have a SQL script that shows, in an accounting database, inventory
items that have not been purchased from a vendor within the last year. I
want to e-mail that list of items to end users on a monthly basis. That
list of items amounts to a report.
Secondly, my script has a specific date. It, basically, says < 06/01/06. I
don't want the IT staff to have to come in and update the date parameter. Is
there a way to place syntax in the script to pull the date from the operating
system?
Thanks!
childofthe1980s
> First, generally speaking, how do you configure SQL 2000 to e-mail end
> users?
I suggest you use xp_smtp from www.sqldev.net. The built-in email support in 2000 is based on MAPI
and is a hassle to get working.
> Secondly, my script has a specific date. It, basically, says < 06/01/06. I
> don't want the IT staff to have to come in and update the date parameter. Is
> there a way to place syntax in the script to pull the date from the operating
> system?
Most probably (can't say for sure without knowing anything about your code). Check out the GETDATE()
function.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"childofthe1980s" <childofthe1980s@.discussions.microsoft.com> wrote in message
news:273474B7-38E8-435F-835A-123502316C07@.microsoft.com...
> Hello:
> Two questions.
> First, generally speaking, how do you configure SQL 2000 to e-mail end
> users? I have a SQL script that shows, in an accounting database, inventory
> items that have not been purchased from a vendor within the last year. I
> want to e-mail that list of items to end users on a monthly basis. That
> list of items amounts to a report.
> Secondly, my script has a specific date. It, basically, says < 06/01/06. I
> don't want the IT staff to have to come in and update the date parameter. Is
> there a way to place syntax in the script to pull the date from the operating
> system?
> Thanks!
> childofthe1980s
|||Please don't post independently in separate newsgroups. You can add
multiple newsgroups to the header and then all the answers appear as one.
See my reply in the other newsgroup.
Andrew J. Kelly SQL MVP
"childofthe1980s" <childofthe1980s@.discussions.microsoft.com> wrote in
message news:273474B7-38E8-435F-835A-123502316C07@.microsoft.com...
> Hello:
> Two questions.
> First, generally speaking, how do you configure SQL 2000 to e-mail end
> users? I have a SQL script that shows, in an accounting database,
> inventory
> items that have not been purchased from a vendor within the last year. I
> want to e-mail that list of items to end users on a monthly basis. That
> list of items amounts to a report.
> Secondly, my script has a specific date. It, basically, says < 06/01/06.
> I
> don't want the IT staff to have to come in and update the date parameter.
> Is
> there a way to place syntax in the script to pull the date from the
> operating
> system?
> Thanks!
> childofthe1980s
Two questions.
First, generally speaking, how do you configure SQL 2000 to e-mail end
users? I have a SQL script that shows, in an accounting database, inventory
items that have not been purchased from a vendor within the last year. I
want to e-mail that list of items to end users on a monthly basis. That
list of items amounts to a report.
Secondly, my script has a specific date. It, basically, says < 06/01/06. I
don't want the IT staff to have to come in and update the date parameter. Is
there a way to place syntax in the script to pull the date from the operating
system?
Thanks!
childofthe1980s
> First, generally speaking, how do you configure SQL 2000 to e-mail end
> users?
I suggest you use xp_smtp from www.sqldev.net. The built-in email support in 2000 is based on MAPI
and is a hassle to get working.
> Secondly, my script has a specific date. It, basically, says < 06/01/06. I
> don't want the IT staff to have to come in and update the date parameter. Is
> there a way to place syntax in the script to pull the date from the operating
> system?
Most probably (can't say for sure without knowing anything about your code). Check out the GETDATE()
function.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"childofthe1980s" <childofthe1980s@.discussions.microsoft.com> wrote in message
news:273474B7-38E8-435F-835A-123502316C07@.microsoft.com...
> Hello:
> Two questions.
> First, generally speaking, how do you configure SQL 2000 to e-mail end
> users? I have a SQL script that shows, in an accounting database, inventory
> items that have not been purchased from a vendor within the last year. I
> want to e-mail that list of items to end users on a monthly basis. That
> list of items amounts to a report.
> Secondly, my script has a specific date. It, basically, says < 06/01/06. I
> don't want the IT staff to have to come in and update the date parameter. Is
> there a way to place syntax in the script to pull the date from the operating
> system?
> Thanks!
> childofthe1980s
|||Please don't post independently in separate newsgroups. You can add
multiple newsgroups to the header and then all the answers appear as one.
See my reply in the other newsgroup.
Andrew J. Kelly SQL MVP
"childofthe1980s" <childofthe1980s@.discussions.microsoft.com> wrote in
message news:273474B7-38E8-435F-835A-123502316C07@.microsoft.com...
> Hello:
> Two questions.
> First, generally speaking, how do you configure SQL 2000 to e-mail end
> users? I have a SQL script that shows, in an accounting database,
> inventory
> items that have not been purchased from a vendor within the last year. I
> want to e-mail that list of items to end users on a monthly basis. That
> list of items amounts to a report.
> Secondly, my script has a specific date. It, basically, says < 06/01/06.
> I
> don't want the IT staff to have to come in and update the date parameter.
> Is
> there a way to place syntax in the script to pull the date from the
> operating
> system?
> Thanks!
> childofthe1980s
e-mailing users in SQL 2000
Hello:
Two questions.
First, generally speaking, how do you configure SQL 2000 to e-mail end
users? I have a SQL script that shows, in an accounting database, inventory
items that have not been purchased from a vendor within the last year. I
want to e-mail that list of items to end users on a monthly basis. That
list of items amounts to a report.
Secondly, my script has a specific date. It, basically, says < 06/01/06. I
don't want the IT staff to have to come in and update the date parameter. I
s
there a way to place syntax in the script to pull the date from the operatin
g
system?
Thanks!
childofthe1980s> First, generally speaking, how do you configure SQL 2000 to e-mail end
> users?
I suggest you use xp_smtp from www.sqldev.net. The built-in email support in
2000 is based on MAPI
and is a hassle to get working.
> Secondly, my script has a specific date. It, basically, says < 06/01/06.
I
> don't want the IT staff to have to come in and update the date parameter.
Is
> there a way to place syntax in the script to pull the date from the operat
ing
> system?
Most probably (can't say for sure without knowing anything about your code).
Check out the GETDATE()
function.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"childofthe1980s" <childofthe1980s@.discussions.microsoft.com> wrote in messa
ge
news:273474B7-38E8-435F-835A-123502316C07@.microsoft.com...
> Hello:
> Two questions.
> First, generally speaking, how do you configure SQL 2000 to e-mail end
> users? I have a SQL script that shows, in an accounting database, invento
ry
> items that have not been purchased from a vendor within the last year. I
> want to e-mail that list of items to end users on a monthly basis. That
> list of items amounts to a report.
> Secondly, my script has a specific date. It, basically, says < 06/01/06.
I
> don't want the IT staff to have to come in and update the date parameter.
Is
> there a way to place syntax in the script to pull the date from the operat
ing
> system?
> Thanks!
> childofthe1980s|||Please don't post independently in separate newsgroups. You can add
multiple newsgroups to the header and then all the answers appear as one.
See my reply in the other newsgroup.
Andrew J. Kelly SQL MVP
"childofthe1980s" <childofthe1980s@.discussions.microsoft.com> wrote in
message news:273474B7-38E8-435F-835A-123502316C07@.microsoft.com...
> Hello:
> Two questions.
> First, generally speaking, how do you configure SQL 2000 to e-mail end
> users? I have a SQL script that shows, in an accounting database,
> inventory
> items that have not been purchased from a vendor within the last year. I
> want to e-mail that list of items to end users on a monthly basis. That
> list of items amounts to a report.
> Secondly, my script has a specific date. It, basically, says < 06/01/06.
> I
> don't want the IT staff to have to come in and update the date parameter.
> Is
> there a way to place syntax in the script to pull the date from the
> operating
> system?
> Thanks!
> childofthe1980s
Two questions.
First, generally speaking, how do you configure SQL 2000 to e-mail end
users? I have a SQL script that shows, in an accounting database, inventory
items that have not been purchased from a vendor within the last year. I
want to e-mail that list of items to end users on a monthly basis. That
list of items amounts to a report.
Secondly, my script has a specific date. It, basically, says < 06/01/06. I
don't want the IT staff to have to come in and update the date parameter. I
s
there a way to place syntax in the script to pull the date from the operatin
g
system?
Thanks!
childofthe1980s> First, generally speaking, how do you configure SQL 2000 to e-mail end
> users?
I suggest you use xp_smtp from www.sqldev.net. The built-in email support in
2000 is based on MAPI
and is a hassle to get working.
> Secondly, my script has a specific date. It, basically, says < 06/01/06.
I
> don't want the IT staff to have to come in and update the date parameter.
Is
> there a way to place syntax in the script to pull the date from the operat
ing
> system?
Most probably (can't say for sure without knowing anything about your code).
Check out the GETDATE()
function.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"childofthe1980s" <childofthe1980s@.discussions.microsoft.com> wrote in messa
ge
news:273474B7-38E8-435F-835A-123502316C07@.microsoft.com...
> Hello:
> Two questions.
> First, generally speaking, how do you configure SQL 2000 to e-mail end
> users? I have a SQL script that shows, in an accounting database, invento
ry
> items that have not been purchased from a vendor within the last year. I
> want to e-mail that list of items to end users on a monthly basis. That
> list of items amounts to a report.
> Secondly, my script has a specific date. It, basically, says < 06/01/06.
I
> don't want the IT staff to have to come in and update the date parameter.
Is
> there a way to place syntax in the script to pull the date from the operat
ing
> system?
> Thanks!
> childofthe1980s|||Please don't post independently in separate newsgroups. You can add
multiple newsgroups to the header and then all the answers appear as one.
See my reply in the other newsgroup.
Andrew J. Kelly SQL MVP
"childofthe1980s" <childofthe1980s@.discussions.microsoft.com> wrote in
message news:273474B7-38E8-435F-835A-123502316C07@.microsoft.com...
> Hello:
> Two questions.
> First, generally speaking, how do you configure SQL 2000 to e-mail end
> users? I have a SQL script that shows, in an accounting database,
> inventory
> items that have not been purchased from a vendor within the last year. I
> want to e-mail that list of items to end users on a monthly basis. That
> list of items amounts to a report.
> Secondly, my script has a specific date. It, basically, says < 06/01/06.
> I
> don't want the IT staff to have to come in and update the date parameter.
> Is
> there a way to place syntax in the script to pull the date from the
> operating
> system?
> Thanks!
> childofthe1980s
Thursday, March 22, 2012
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
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
Wednesday, March 21, 2012
Email report to Operator
While configure Email reporting to Operator under Database Maintenance
Plan got below mention error...
Error 22022: SQLServerAgent Error: The SQLServerAgent mail session is
not running; check the mail profile and/or the SQLServerAgent service
startup account in the SQLServerAgent properties dialog.
How to overcome this issue?
Please guide!!!!
ThanksDo please check if here is something that can help you:
http://classicasp.aspfaq.com/email/...ning.com/blogs/
<darshaksshah@.gmail.com> wrote in message
news:1169890433.901537.64880@.k78g2000cwa.googlegroups.com...
> While configure Email reporting to Operator under Database Maintenance
> Plan got below mention error...
> Error 22022: SQLServerAgent Error: The SQLServerAgent mail session is
> not running; check the mail profile and/or the SQLServerAgent service
> startup account in the SQLServerAgent properties dialog.
> How to overcome this issue?
> Please guide!!!!
> Thanks
>|||Many Reasons: Out of them
Check to see if your SQL Agent is Running:
Also Check if the DBMail is Started or Setup Properly.
Check SQL Agent is Running under a domain Service Account and if it
has required Priviliges (near to sa) - if the Jobs invlove sending out
Notifications.
I recommend reading BOL more on this.
Maninder
MCDBA
On Jan 27, 4:33 am, darshakss...@.gmail.com wrote:
> While configure Email reporting to Operator under Database Maintenance
> Plan got below mention error...
> Error 22022: SQLServerAgent Error: The SQLServerAgent mail session is
> not running; check the mail profile and/or the SQLServerAgent service
> startup account in the SQLServerAgent properties dialog.
> How to overcome this issue?
> Please guide!!!!
> Thanks
Plan got below mention error...
Error 22022: SQLServerAgent Error: The SQLServerAgent mail session is
not running; check the mail profile and/or the SQLServerAgent service
startup account in the SQLServerAgent properties dialog.
How to overcome this issue?
Please guide!!!!
ThanksDo please check if here is something that can help you:
http://classicasp.aspfaq.com/email/...ning.com/blogs/
<darshaksshah@.gmail.com> wrote in message
news:1169890433.901537.64880@.k78g2000cwa.googlegroups.com...
> While configure Email reporting to Operator under Database Maintenance
> Plan got below mention error...
> Error 22022: SQLServerAgent Error: The SQLServerAgent mail session is
> not running; check the mail profile and/or the SQLServerAgent service
> startup account in the SQLServerAgent properties dialog.
> How to overcome this issue?
> Please guide!!!!
> Thanks
>|||Many Reasons: Out of them
Check to see if your SQL Agent is Running:
Also Check if the DBMail is Started or Setup Properly.
Check SQL Agent is Running under a domain Service Account and if it
has required Priviliges (near to sa) - if the Jobs invlove sending out
Notifications.
I recommend reading BOL more on this.
Maninder
MCDBA
On Jan 27, 4:33 am, darshakss...@.gmail.com wrote:
> While configure Email reporting to Operator under Database Maintenance
> Plan got below mention error...
> Error 22022: SQLServerAgent Error: The SQLServerAgent mail session is
> not running; check the mail profile and/or the SQLServerAgent service
> startup account in the SQLServerAgent properties dialog.
> How to overcome this issue?
> Please guide!!!!
> Thanks
Email report to Operator
While configure Email reporting to Operator under Database Maintenance
Plan got below mention error...
Error 22022: SQLServerAgent Error: The SQLServerAgent mail session is
not running; check the mail profile and/or the SQLServerAgent service
startup account in the SQLServerAgent properties dialog.
How to overcome this issue?
Please guide!!!!
Thanks
Many Reasons: Out of them
Check to see if your SQL Agent is Running:
Also Check if the DBMail is Started or Setup Properly.
Check SQL Agent is Running under a domain Service Account and if it
has required Priviliges (near to sa) - if the Jobs invlove sending out
Notifications.
I recommend reading BOL more on this.
Maninder
MCDBA
On Jan 27, 4:33 am, darshakss...@.gmail.com wrote:
> While configure Email reporting to Operator under Database Maintenance
> Plan got below mention error...
> Error 22022: SQLServerAgent Error: The SQLServerAgent mail session is
> not running; check the mail profile and/or the SQLServerAgent service
> startup account in the SQLServerAgent properties dialog.
> How to overcome this issue?
> Please guide!!!!
> Thanks
Plan got below mention error...
Error 22022: SQLServerAgent Error: The SQLServerAgent mail session is
not running; check the mail profile and/or the SQLServerAgent service
startup account in the SQLServerAgent properties dialog.
How to overcome this issue?
Please guide!!!!
Thanks
Many Reasons: Out of them
Check to see if your SQL Agent is Running:
Also Check if the DBMail is Started or Setup Properly.
Check SQL Agent is Running under a domain Service Account and if it
has required Priviliges (near to sa) - if the Jobs invlove sending out
Notifications.
I recommend reading BOL more on this.
Maninder
MCDBA
On Jan 27, 4:33 am, darshakss...@.gmail.com wrote:
> While configure Email reporting to Operator under Database Maintenance
> Plan got below mention error...
> Error 22022: SQLServerAgent Error: The SQLServerAgent mail session is
> not running; check the mail profile and/or the SQLServerAgent service
> startup account in the SQLServerAgent properties dialog.
> How to overcome this issue?
> Please guide!!!!
> Thanks
Email report to Operator
While configure Email reporting to Operator under Database Maintenance
Plan got below mention error...
Error 22022: SQLServerAgent Error: The SQLServerAgent mail session is
not running; check the mail profile and/or the SQLServerAgent service
startup account in the SQLServerAgent properties dialog.
How to overcome this issue?
Please guide!!!!
ThanksDo please check if here is something that can help you:
http://classicasp.aspfaq.com/email/how-do-i-send-e-mail-from-sql-server.html.
--
Dejan Sarka
http://www.solidqualitylearning.com/blogs/
<darshaksshah@.gmail.com> wrote in message
news:1169890433.901537.64880@.k78g2000cwa.googlegroups.com...
> While configure Email reporting to Operator under Database Maintenance
> Plan got below mention error...
> Error 22022: SQLServerAgent Error: The SQLServerAgent mail session is
> not running; check the mail profile and/or the SQLServerAgent service
> startup account in the SQLServerAgent properties dialog.
> How to overcome this issue?
> Please guide!!!!
> Thanks
>|||Many Reasons: Out of them
Check to see if your SQL Agent is Running:
Also Check if the DBMail is Started or Setup Properly.
Check SQL Agent is Running under a domain Service Account and if it
has required Priviliges (near to sa) - if the Jobs invlove sending out
Notifications.
I recommend reading BOL more on this.
Maninder
MCDBA
On Jan 27, 4:33 am, darshakss...@.gmail.com wrote:
> While configure Email reporting to Operator under Database Maintenance
> Plan got below mention error...
> Error 22022: SQLServerAgent Error: The SQLServerAgent mail session is
> not running; check the mail profile and/or the SQLServerAgent service
> startup account in the SQLServerAgent properties dialog.
> How to overcome this issue?
> Please guide!!!!
> Thanks
Plan got below mention error...
Error 22022: SQLServerAgent Error: The SQLServerAgent mail session is
not running; check the mail profile and/or the SQLServerAgent service
startup account in the SQLServerAgent properties dialog.
How to overcome this issue?
Please guide!!!!
ThanksDo please check if here is something that can help you:
http://classicasp.aspfaq.com/email/how-do-i-send-e-mail-from-sql-server.html.
--
Dejan Sarka
http://www.solidqualitylearning.com/blogs/
<darshaksshah@.gmail.com> wrote in message
news:1169890433.901537.64880@.k78g2000cwa.googlegroups.com...
> While configure Email reporting to Operator under Database Maintenance
> Plan got below mention error...
> Error 22022: SQLServerAgent Error: The SQLServerAgent mail session is
> not running; check the mail profile and/or the SQLServerAgent service
> startup account in the SQLServerAgent properties dialog.
> How to overcome this issue?
> Please guide!!!!
> Thanks
>|||Many Reasons: Out of them
Check to see if your SQL Agent is Running:
Also Check if the DBMail is Started or Setup Properly.
Check SQL Agent is Running under a domain Service Account and if it
has required Priviliges (near to sa) - if the Jobs invlove sending out
Notifications.
I recommend reading BOL more on this.
Maninder
MCDBA
On Jan 27, 4:33 am, darshakss...@.gmail.com wrote:
> While configure Email reporting to Operator under Database Maintenance
> Plan got below mention error...
> Error 22022: SQLServerAgent Error: The SQLServerAgent mail session is
> not running; check the mail profile and/or the SQLServerAgent service
> startup account in the SQLServerAgent properties dialog.
> How to overcome this issue?
> Please guide!!!!
> Thanks
Sunday, March 11, 2012
email configuration - mail profile
Hi,
I want to configure my SQL Server 2000 to send me email using operator if there is any prob in the server.
I installed office 2000 , configure microsoft outlook, I am able to send - receive emails from the account I created. my mail server is up and running fine.
How can I configure my SQL Server 2000 to send me emails.
I am not able to see any profile in support services - SQL Mail .
In control panel if I double-clicked on mail, I can only see Account - SQLMAIL which I created for my email, type (mail (default)), connection - local area network.
Appreciate your help.
Thanks.There's another recent thread with a similar (I believe) issue. You need to ensure that when you are setting up your Outlook client that you are logged in as the SQL Agent service account. So, if you SQL Agent service is set up to run under MyDomain\MySQLAgent, you need to login as MyDomain\MySQLAgent and configure Outlook. Then open EM and configure SQL Mail.
Check out SQL BOL.
Regards,
Hugh Scott
Originally posted by ramshree
Hi,
I want to configure my SQL Server 2000 to send me email using operator if there is any prob in the server.
I installed office 2000 , configure microsoft outlook, I am able to send - receive emails from the account I created. my mail server is up and running fine.
How can I configure my SQL Server 2000 to send me emails.
I am not able to see any profile in support services - SQL Mail .
In control panel if I double-clicked on mail, I can only see Account - SQLMAIL which I created for my email, type (mail (default)), connection - local area network.
Appreciate your help.
Thanks.|||I'm facing a similar problem.
How to check SQL Agent service is set up to run under wat account ?|||Right click SQL Server Agent in EM.. Click Properties ...check Service startup account.|||I Right click SQL Server Agent in EM.. Click Properties ...then can c General tab, Advanced tab and so on, i can't find ...check Service startup account.
I'm very new to SQL, i dun understand wat hmscott said "if you SQL Agent service is set up to run under MyDomain\MySQLAgent, you need to login as MyDomain\MySQLAgent and configure Outlook. "
The login is reffering to wat s/w ?|||Lets start from the beginning - Describe your problem/issues with setting up sqlmail ?
I want to configure my SQL Server 2000 to send me email using operator if there is any prob in the server.
I installed office 2000 , configure microsoft outlook, I am able to send - receive emails from the account I created. my mail server is up and running fine.
How can I configure my SQL Server 2000 to send me emails.
I am not able to see any profile in support services - SQL Mail .
In control panel if I double-clicked on mail, I can only see Account - SQLMAIL which I created for my email, type (mail (default)), connection - local area network.
Appreciate your help.
Thanks.There's another recent thread with a similar (I believe) issue. You need to ensure that when you are setting up your Outlook client that you are logged in as the SQL Agent service account. So, if you SQL Agent service is set up to run under MyDomain\MySQLAgent, you need to login as MyDomain\MySQLAgent and configure Outlook. Then open EM and configure SQL Mail.
Check out SQL BOL.
Regards,
Hugh Scott
Originally posted by ramshree
Hi,
I want to configure my SQL Server 2000 to send me email using operator if there is any prob in the server.
I installed office 2000 , configure microsoft outlook, I am able to send - receive emails from the account I created. my mail server is up and running fine.
How can I configure my SQL Server 2000 to send me emails.
I am not able to see any profile in support services - SQL Mail .
In control panel if I double-clicked on mail, I can only see Account - SQLMAIL which I created for my email, type (mail (default)), connection - local area network.
Appreciate your help.
Thanks.|||I'm facing a similar problem.
How to check SQL Agent service is set up to run under wat account ?|||Right click SQL Server Agent in EM.. Click Properties ...check Service startup account.|||I Right click SQL Server Agent in EM.. Click Properties ...then can c General tab, Advanced tab and so on, i can't find ...check Service startup account.
I'm very new to SQL, i dun understand wat hmscott said "if you SQL Agent service is set up to run under MyDomain\MySQLAgent, you need to login as MyDomain\MySQLAgent and configure Outlook. "
The login is reffering to wat s/w ?|||Lets start from the beginning - Describe your problem/issues with setting up sqlmail ?
Subscribe to:
Posts (Atom)