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
Showing posts with label delivery. Show all posts
Showing posts with label delivery. Show all posts
Thursday, March 22, 2012
Wednesday, March 21, 2012
Email Subscripions Question
I would like to do a email subscription but the Email option doesn;'t show up
in the delivery methods.
What needs to be enabled to allow this option?
Cheers BrianIn the RSReportServer.config file make sure that the email delivery
extension is properly configured. You need to specify the SMTPServer and
the From element to get the extension to show up.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Brian Ward" <BrianWard@.discussions.microsoft.com> wrote in message
news:61C7BB6A-982E-4534-A395-ADCF1E4F7D14@.microsoft.com...
>I would like to do a email subscription but the Email option doesn;'t show
>up
> in the delivery methods.
> What needs to be enabled to allow this option?
> Cheers Brian|||Thanks, I'll check it out.
"Daniel Reib (MSFT)" wrote:
> In the RSReportServer.config file make sure that the email delivery
> extension is properly configured. You need to specify the SMTPServer and
> the From element to get the extension to show up.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Brian Ward" <BrianWard@.discussions.microsoft.com> wrote in message
> news:61C7BB6A-982E-4534-A395-ADCF1E4F7D14@.microsoft.com...
> >I would like to do a email subscription but the Email option doesn;'t show
> >up
> > in the delivery methods.
> >
> > What needs to be enabled to allow this option?
> >
> > Cheers Brian
>
>sql
in the delivery methods.
What needs to be enabled to allow this option?
Cheers BrianIn the RSReportServer.config file make sure that the email delivery
extension is properly configured. You need to specify the SMTPServer and
the From element to get the extension to show up.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Brian Ward" <BrianWard@.discussions.microsoft.com> wrote in message
news:61C7BB6A-982E-4534-A395-ADCF1E4F7D14@.microsoft.com...
>I would like to do a email subscription but the Email option doesn;'t show
>up
> in the delivery methods.
> What needs to be enabled to allow this option?
> Cheers Brian|||Thanks, I'll check it out.
"Daniel Reib (MSFT)" wrote:
> In the RSReportServer.config file make sure that the email delivery
> extension is properly configured. You need to specify the SMTPServer and
> the From element to get the extension to show up.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Brian Ward" <BrianWard@.discussions.microsoft.com> wrote in message
> news:61C7BB6A-982E-4534-A395-ADCF1E4F7D14@.microsoft.com...
> >I would like to do a email subscription but the Email option doesn;'t show
> >up
> > in the delivery methods.
> >
> > What needs to be enabled to allow this option?
> >
> > Cheers Brian
>
>sql
Email Sub delivery failure
I have been trying to get email delivery of reports working for the best part
of 2 days now... I have learnt a lot about connections, encrypted files,
rsconfig etc, but I still can not get the thing to work.
I have ended up with the orginial problem I had, "Failure sending mail: The
Report Server has encountered a configuration error; more details in the log
files"
I have applied SP1 and now changed the account that the service uses to one
that had domain admin rights.
I am still can not see what else is left... every account that I know about
within RS has admin rights...
The following is an excerpt from the log...
Any ideas would be greatfully accepted... I dont really want to reinstall
but if that is what it takes ...
--
Thanks
Chris
ReportingServicesService!dbpolling!c24!13/02/2005-11:53:03:: EventPolling
processing 1 more items. 1 Total items in internal queue.
ReportingServicesService!dbpolling!1c8!13/02/2005-11:53:03:: EventPolling
processing item d4b31a3b-7752-49ed-ae30-36035bbd89c5
ReportingServicesService!library!1c8!13/02/2005-11:53:04:: Schedule
897832a6-9489-478d-8e75-97b1b64a2b5d executed at 13/02/2005 11:53:04.
ReportingServicesService!schedule!1c8!13/02/2005-11:53:04:: Creating Time
based subscription notification for subscription:
ef711679-d57d-4aba-b06b-47aafc18e808
ReportingServicesService!library!1c8!13/02/2005-11:53:04:: Schedule
897832a6-9489-478d-8e75-97b1b64a2b5d execution completed at 13/02/2005
11:53:04.
ReportingServicesService!dbpolling!1c8!13/02/2005-11:53:04:: EventPolling
finished processing item d4b31a3b-7752-49ed-ae30-36035bbd89c5
ReportingServicesService!dbpolling!1c8!13/02/2005-11:53:04::
NotificationPolling processing item c6a2efa0-ecac-40b9-b2c9-18610a52d62c
ReportingServicesService!dbpolling!c24!13/02/2005-11:53:04::
NotificationPolling processing 1 more items. 1 Total items in internal queue.
ReportingServicesService!library!1c8!02/13/2005-11:53:06:: i INFO:
Initializing EnableIntegratedSecurity to 'True' as specified in Server
system properties.
ReportingServicesService!library!1c8!02/13/2005-11:53:11:: i INFO: Call to
RenderFirst( '/Report Project2/Study Progress Report' )
ReportingServicesService!library!1c8!02/13/2005-11:53:11:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
The Report Server has encountered a configuration error; more details in the
log files, AuthzInitializeContextFromSid: Win32 error: 1355;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
The Report Server has encountered a configuration error; more details in the
log files
ReportingServicesService!library!1c8!02/13/2005-11:53:11:: i INFO:
Initializing EnableExecutionLogging to 'True' as specified in Server system
properties.
ReportingServicesService!emailextension!1c8!02/13/2005-11:53:12:: Error
sending email. Microsoft.ReportingServices.Diagnostics.Utilities.RSException:
The Report Server has encountered a configuration error; more details in the
log files -->
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
The Report Server has encountered a configuration error; more details in the
log files
at
Microsoft.ReportingServices.Authorization.Native.GetAuthzContextForUser(IntPtr userSid)
at Microsoft.ReportingServices.Authorization.Native.IsAdmin(String
userName)
at
Microsoft.ReportingServices.Authorization.WindowsAuthorization.IsAdmin(String
userName, IntPtr userToken)
at
Microsoft.ReportingServices.Authorization.WindowsAuthorization.CheckAccess(String
userName, IntPtr userToken, Byte[] secDesc, ReportOperation requiredOperation)
at Microsoft.ReportingServices.Library.Security.CheckAccess(ItemType
catItemType, Byte[] secDesc, ReportOperation rptOper)
at
Microsoft.ReportingServices.Library.RSService._GetReportParameterDefinitionFromCatalog(CatalogItemContext
reportContext, String historyID, Boolean forRendering, Guid& reportID, Int32&
executionOption, String& savedParametersXml, ReportSnapshot&
compiledDefinition, ReportSnapshot& snapshotData, Guid& linkID, DateTime&
historyDate)
at
Microsoft.ReportingServices.Library.RSService._GetReportParameters(String
report, String historyID, Boolean forRendering, NameValueCollection values,
DatasourceCredentialsCollection credentials)
at
Microsoft.ReportingServices.Library.RSService.RenderAsLiveOrSnapshot(CatalogItemContext
reportContext, ClientRequest session, Warning[]& warnings,
ParameterInfoCollection& effectiveParameters)
at
Microsoft.ReportingServices.Library.RSService.RenderFirst(CatalogItemContext
reportContext, ClientRequest session, Warning[]& warnings,
ParameterInfoCollection& effectiveParameters, String[]& secondaryStreamNames)
at Microsoft.ReportingServices.Library.RenderFirstCancelableStep.Execute()
at
Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
-- End of inner exception stack trace --
at
Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
at
Microsoft.ReportingServices.Library.RenderFirstCancelableStep.RenderFirst(RSService
rs, CatalogItemContext reportContext, ClientRequest session, JobTypeEnum
type, Warning[]& warnings, ParameterInfoCollection& effectiveParameters,
String[]& secondaryStreamNames)
at Microsoft.ReportingServices.Library.ReportImpl.Render(String
renderFormat, String deviceInfo)
at
Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.ConstructMessageBody(IMessage message, Notification notification, SubscriptionData data)
at
Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.CreateMessage(Notification notification)
at
Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.Deliver(Notification notification)
ReportingServicesService!notification!1c8!02/13/2005-11:53:12:: Notification
c6a2efa0-ecac-40b9-b2c9-18610a52d62c completed. Success: False, Status:
Failure sending mail: The Report Server has encountered a configuration
error; more details in the log files, DeliveryExtension: Report Server Email,
Report: Study Progress Report, Attempt 0
ReportingServicesService!dbpolling!1c8!02/13/2005-11:53:12::
NotificationPolling finished processing item
c6a2efa0-ecac-40b9-b2c9-18610a52d62cChris,
I'm having the same issue. Your log file is getting the WinNT error 1355,
and
there is currently a hotfix available for it (834859) I haven't tried it yet,
but someone did at the following url and it worked for them.
http://groups-beta.google.com/group/microsoft.public.sqlserver.reportingsvcs/msg/123eea5b7fc5edaa?q=authz+group:microsoft.public.sqlserver.reportingsvcs&hl=en&lr=&ie=UTF-8&rnum=4
"Chris Morgan" wrote:
> I have been trying to get email delivery of reports working for the best part
> of 2 days now... I have learnt a lot about connections, encrypted files,
> rsconfig etc, but I still can not get the thing to work.
> I have ended up with the orginial problem I had, "Failure sending mail: The
> Report Server has encountered a configuration error; more details in the log
> files"
> I have applied SP1 and now changed the account that the service uses to one
> that had domain admin rights.
> I am still can not see what else is left... every account that I know about
> within RS has admin rights...
> The following is an excerpt from the log...
> Any ideas would be greatfully accepted... I dont really want to reinstall
> but if that is what it takes ...
> --
> Thanks
> Chris
>
> ReportingServicesService!dbpolling!c24!13/02/2005-11:53:03:: EventPolling
> processing 1 more items. 1 Total items in internal queue.
> ReportingServicesService!dbpolling!1c8!13/02/2005-11:53:03:: EventPolling
> processing item d4b31a3b-7752-49ed-ae30-36035bbd89c5
> ReportingServicesService!library!1c8!13/02/2005-11:53:04:: Schedule
> 897832a6-9489-478d-8e75-97b1b64a2b5d executed at 13/02/2005 11:53:04.
> ReportingServicesService!schedule!1c8!13/02/2005-11:53:04:: Creating Time
> based subscription notification for subscription:
> ef711679-d57d-4aba-b06b-47aafc18e808
> ReportingServicesService!library!1c8!13/02/2005-11:53:04:: Schedule
> 897832a6-9489-478d-8e75-97b1b64a2b5d execution completed at 13/02/2005
> 11:53:04.
> ReportingServicesService!dbpolling!1c8!13/02/2005-11:53:04:: EventPolling
> finished processing item d4b31a3b-7752-49ed-ae30-36035bbd89c5
> ReportingServicesService!dbpolling!1c8!13/02/2005-11:53:04::
> NotificationPolling processing item c6a2efa0-ecac-40b9-b2c9-18610a52d62c
> ReportingServicesService!dbpolling!c24!13/02/2005-11:53:04::
> NotificationPolling processing 1 more items. 1 Total items in internal queue.
> ReportingServicesService!library!1c8!02/13/2005-11:53:06:: i INFO:
> Initializing EnableIntegratedSecurity to 'True' as specified in Server
> system properties.
> ReportingServicesService!library!1c8!02/13/2005-11:53:11:: i INFO: Call to
> RenderFirst( '/Report Project2/Study Progress Report' )
> ReportingServicesService!library!1c8!02/13/2005-11:53:11:: e ERROR: Throwing
> Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
> The Report Server has encountered a configuration error; more details in the
> log files, AuthzInitializeContextFromSid: Win32 error: 1355;
> Info:
> Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
> The Report Server has encountered a configuration error; more details in the
> log files
> ReportingServicesService!library!1c8!02/13/2005-11:53:11:: i INFO:
> Initializing EnableExecutionLogging to 'True' as specified in Server system
> properties.
> ReportingServicesService!emailextension!1c8!02/13/2005-11:53:12:: Error
> sending email. Microsoft.ReportingServices.Diagnostics.Utilities.RSException:
> The Report Server has encountered a configuration error; more details in the
> log files -->
> Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
> The Report Server has encountered a configuration error; more details in the
> log files
> at
> Microsoft.ReportingServices.Authorization.Native.GetAuthzContextForUser(IntPtr userSid)
> at Microsoft.ReportingServices.Authorization.Native.IsAdmin(String
> userName)
> at
> Microsoft.ReportingServices.Authorization.WindowsAuthorization.IsAdmin(String
> userName, IntPtr userToken)
> at
> Microsoft.ReportingServices.Authorization.WindowsAuthorization.CheckAccess(String
> userName, IntPtr userToken, Byte[] secDesc, ReportOperation requiredOperation)
> at Microsoft.ReportingServices.Library.Security.CheckAccess(ItemType
> catItemType, Byte[] secDesc, ReportOperation rptOper)
> at
> Microsoft.ReportingServices.Library.RSService._GetReportParameterDefinitionFromCatalog(CatalogItemContext
> reportContext, String historyID, Boolean forRendering, Guid& reportID, Int32&
> executionOption, String& savedParametersXml, ReportSnapshot&
> compiledDefinition, ReportSnapshot& snapshotData, Guid& linkID, DateTime&
> historyDate)
> at
> Microsoft.ReportingServices.Library.RSService._GetReportParameters(String
> report, String historyID, Boolean forRendering, NameValueCollection values,
> DatasourceCredentialsCollection credentials)
> at
> Microsoft.ReportingServices.Library.RSService.RenderAsLiveOrSnapshot(CatalogItemContext
> reportContext, ClientRequest session, Warning[]& warnings,
> ParameterInfoCollection& effectiveParameters)
> at
> Microsoft.ReportingServices.Library.RSService.RenderFirst(CatalogItemContext
> reportContext, ClientRequest session, Warning[]& warnings,
> ParameterInfoCollection& effectiveParameters, String[]& secondaryStreamNames)
> at Microsoft.ReportingServices.Library.RenderFirstCancelableStep.Execute()
> at
> Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
> -- End of inner exception stack trace --
> at
> Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
> at
> Microsoft.ReportingServices.Library.RenderFirstCancelableStep.RenderFirst(RSService
> rs, CatalogItemContext reportContext, ClientRequest session, JobTypeEnum
> type, Warning[]& warnings, ParameterInfoCollection& effectiveParameters,
> String[]& secondaryStreamNames)
> at Microsoft.ReportingServices.Library.ReportImpl.Render(String
> renderFormat, String deviceInfo)
> at
> Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.ConstructMessageBody(IMessage message, Notification notification, SubscriptionData data)
> at
> Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.CreateMessage(Notification notification)
> at
> Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.Deliver(Notification notification)
> ReportingServicesService!notification!1c8!02/13/2005-11:53:12:: Notification
> c6a2efa0-ecac-40b9-b2c9-18610a52d62c completed. Success: False, Status:
> Failure sending mail: The Report Server has encountered a configuration
> error; more details in the log files, DeliveryExtension: Report Server Email,
> Report: Study Progress Report, Attempt 0
> ReportingServicesService!dbpolling!1c8!02/13/2005-11:53:12::
> NotificationPolling finished processing item
> c6a2efa0-ecac-40b9-b2c9-18610a52d62c
>|||David,
I did what I did not want to do in the end... reinstalled and used the
domain admin account from the outset, it guess what it works...
I wouldnt say that I fixed the problem, just hit it with a big enough
hammer...
What I can say is that our users are really amazed at what we can do now and
all the effort we have put into getting RS working was well worth it...
Thanks for the link...
Chris
"David Siebert" wrote:
> Chris,
> I'm having the same issue. Your log file is getting the WinNT error 1355,
> and
> there is currently a hotfix available for it (834859) I haven't tried it yet,
> but someone did at the following url and it worked for them.
>
> http://groups-beta.google.com/group/microsoft.public.sqlserver.reportingsvcs/msg/123eea5b7fc5edaa?q=authz+group:microsoft.public.sqlserver.reportingsvcs&hl=en&lr=&ie=UTF-8&rnum=4
>
> "Chris Morgan" wrote:
> > I have been trying to get email delivery of reports working for the best part
> > of 2 days now... I have learnt a lot about connections, encrypted files,
> > rsconfig etc, but I still can not get the thing to work.
> >
> > I have ended up with the orginial problem I had, "Failure sending mail: The
> > Report Server has encountered a configuration error; more details in the log
> > files"
> >
> > I have applied SP1 and now changed the account that the service uses to one
> > that had domain admin rights.
> >
> > I am still can not see what else is left... every account that I know about
> > within RS has admin rights...
> >
> > The following is an excerpt from the log...
> >
> > Any ideas would be greatfully accepted... I dont really want to reinstall
> > but if that is what it takes ...
> >
> > --
> > Thanks
> > Chris
> >
> >
> > ReportingServicesService!dbpolling!c24!13/02/2005-11:53:03:: EventPolling
> > processing 1 more items. 1 Total items in internal queue.
> > ReportingServicesService!dbpolling!1c8!13/02/2005-11:53:03:: EventPolling
> > processing item d4b31a3b-7752-49ed-ae30-36035bbd89c5
> > ReportingServicesService!library!1c8!13/02/2005-11:53:04:: Schedule
> > 897832a6-9489-478d-8e75-97b1b64a2b5d executed at 13/02/2005 11:53:04.
> > ReportingServicesService!schedule!1c8!13/02/2005-11:53:04:: Creating Time
> > based subscription notification for subscription:
> > ef711679-d57d-4aba-b06b-47aafc18e808
> > ReportingServicesService!library!1c8!13/02/2005-11:53:04:: Schedule
> > 897832a6-9489-478d-8e75-97b1b64a2b5d execution completed at 13/02/2005
> > 11:53:04.
> > ReportingServicesService!dbpolling!1c8!13/02/2005-11:53:04:: EventPolling
> > finished processing item d4b31a3b-7752-49ed-ae30-36035bbd89c5
> > ReportingServicesService!dbpolling!1c8!13/02/2005-11:53:04::
> > NotificationPolling processing item c6a2efa0-ecac-40b9-b2c9-18610a52d62c
> > ReportingServicesService!dbpolling!c24!13/02/2005-11:53:04::
> > NotificationPolling processing 1 more items. 1 Total items in internal queue.
> > ReportingServicesService!library!1c8!02/13/2005-11:53:06:: i INFO:
> > Initializing EnableIntegratedSecurity to 'True' as specified in Server
> > system properties.
> > ReportingServicesService!library!1c8!02/13/2005-11:53:11:: i INFO: Call to
> > RenderFirst( '/Report Project2/Study Progress Report' )
> > ReportingServicesService!library!1c8!02/13/2005-11:53:11:: e ERROR: Throwing
> > Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
> > The Report Server has encountered a configuration error; more details in the
> > log files, AuthzInitializeContextFromSid: Win32 error: 1355;
> > Info:
> > Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
> > The Report Server has encountered a configuration error; more details in the
> > log files
> > ReportingServicesService!library!1c8!02/13/2005-11:53:11:: i INFO:
> > Initializing EnableExecutionLogging to 'True' as specified in Server system
> > properties.
> > ReportingServicesService!emailextension!1c8!02/13/2005-11:53:12:: Error
> > sending email. Microsoft.ReportingServices.Diagnostics.Utilities.RSException:
> > The Report Server has encountered a configuration error; more details in the
> > log files -->
> > Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
> > The Report Server has encountered a configuration error; more details in the
> > log files
> > at
> > Microsoft.ReportingServices.Authorization.Native.GetAuthzContextForUser(IntPtr userSid)
> > at Microsoft.ReportingServices.Authorization.Native.IsAdmin(String
> > userName)
> > at
> > Microsoft.ReportingServices.Authorization.WindowsAuthorization.IsAdmin(String
> > userName, IntPtr userToken)
> > at
> > Microsoft.ReportingServices.Authorization.WindowsAuthorization.CheckAccess(String
> > userName, IntPtr userToken, Byte[] secDesc, ReportOperation requiredOperation)
> > at Microsoft.ReportingServices.Library.Security.CheckAccess(ItemType
> > catItemType, Byte[] secDesc, ReportOperation rptOper)
> > at
> > Microsoft.ReportingServices.Library.RSService._GetReportParameterDefinitionFromCatalog(CatalogItemContext
> > reportContext, String historyID, Boolean forRendering, Guid& reportID, Int32&
> > executionOption, String& savedParametersXml, ReportSnapshot&
> > compiledDefinition, ReportSnapshot& snapshotData, Guid& linkID, DateTime&
> > historyDate)
> > at
> > Microsoft.ReportingServices.Library.RSService._GetReportParameters(String
> > report, String historyID, Boolean forRendering, NameValueCollection values,
> > DatasourceCredentialsCollection credentials)
> > at
> > Microsoft.ReportingServices.Library.RSService.RenderAsLiveOrSnapshot(CatalogItemContext
> > reportContext, ClientRequest session, Warning[]& warnings,
> > ParameterInfoCollection& effectiveParameters)
> > at
> > Microsoft.ReportingServices.Library.RSService.RenderFirst(CatalogItemContext
> > reportContext, ClientRequest session, Warning[]& warnings,
> > ParameterInfoCollection& effectiveParameters, String[]& secondaryStreamNames)
> > at Microsoft.ReportingServices.Library.RenderFirstCancelableStep.Execute()
> > at
> > Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
> > -- End of inner exception stack trace --
> > at
> > Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
> > at
> > Microsoft.ReportingServices.Library.RenderFirstCancelableStep.RenderFirst(RSService
> > rs, CatalogItemContext reportContext, ClientRequest session, JobTypeEnum
> > type, Warning[]& warnings, ParameterInfoCollection& effectiveParameters,
> > String[]& secondaryStreamNames)
> > at Microsoft.ReportingServices.Library.ReportImpl.Render(String
> > renderFormat, String deviceInfo)
> > at
> > Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.ConstructMessageBody(IMessage message, Notification notification, SubscriptionData data)
> > at
> > Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.CreateMessage(Notification notification)
> > at
> > Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.Deliver(Notification notification)
> > ReportingServicesService!notification!1c8!02/13/2005-11:53:12:: Notification
> > c6a2efa0-ecac-40b9-b2c9-18610a52d62c completed. Success: False, Status:
> > Failure sending mail: The Report Server has encountered a configuration
> > error; more details in the log files, DeliveryExtension: Report Server Email,
> > Report: Study Progress Report, Attempt 0
> > ReportingServicesService!dbpolling!1c8!02/13/2005-11:53:12::
> > NotificationPolling finished processing item
> > c6a2efa0-ecac-40b9-b2c9-18610a52d62c
> >|||Just as a word of warning, my first attempt at a solution was to reinstall
RS. The mail worked for a little while, and then I began receiving the same
error again. So, just be on the lookout for failing email subscriptions.
While we haven't installed the hotfix, we've resorted to just sending a link
in the email. The error only occurs when you try to embed or attach a
report. Good luck.
"Chris Morgan" wrote:
> David,
> I did what I did not want to do in the end... reinstalled and used the
> domain admin account from the outset, it guess what it works...
> I wouldnt say that I fixed the problem, just hit it with a big enough
> hammer...
> What I can say is that our users are really amazed at what we can do now and
> all the effort we have put into getting RS working was well worth it...
> Thanks for the link...
> Chris
>
> "David Siebert" wrote:
> > Chris,
> >
> > I'm having the same issue. Your log file is getting the WinNT error 1355,
> > and
> > there is currently a hotfix available for it (834859) I haven't tried it yet,
> > but someone did at the following url and it worked for them.
> >
> >
> > http://groups-beta.google.com/group/microsoft.public.sqlserver.reportingsvcs/msg/123eea5b7fc5edaa?q=authz+group:microsoft.public.sqlserver.reportingsvcs&hl=en&lr=&ie=UTF-8&rnum=4
> >
> >
> > "Chris Morgan" wrote:
> >
> > > I have been trying to get email delivery of reports working for the best part
> > > of 2 days now... I have learnt a lot about connections, encrypted files,
> > > rsconfig etc, but I still can not get the thing to work.
> > >
> > > I have ended up with the orginial problem I had, "Failure sending mail: The
> > > Report Server has encountered a configuration error; more details in the log
> > > files"
> > >
> > > I have applied SP1 and now changed the account that the service uses to one
> > > that had domain admin rights.
> > >
> > > I am still can not see what else is left... every account that I know about
> > > within RS has admin rights...
> > >
> > > The following is an excerpt from the log...
> > >
> > > Any ideas would be greatfully accepted... I dont really want to reinstall
> > > but if that is what it takes ...
> > >
> > > --
> > > Thanks
> > > Chris
> > >
> > >
> > > ReportingServicesService!dbpolling!c24!13/02/2005-11:53:03:: EventPolling
> > > processing 1 more items. 1 Total items in internal queue.
> > > ReportingServicesService!dbpolling!1c8!13/02/2005-11:53:03:: EventPolling
> > > processing item d4b31a3b-7752-49ed-ae30-36035bbd89c5
> > > ReportingServicesService!library!1c8!13/02/2005-11:53:04:: Schedule
> > > 897832a6-9489-478d-8e75-97b1b64a2b5d executed at 13/02/2005 11:53:04.
> > > ReportingServicesService!schedule!1c8!13/02/2005-11:53:04:: Creating Time
> > > based subscription notification for subscription:
> > > ef711679-d57d-4aba-b06b-47aafc18e808
> > > ReportingServicesService!library!1c8!13/02/2005-11:53:04:: Schedule
> > > 897832a6-9489-478d-8e75-97b1b64a2b5d execution completed at 13/02/2005
> > > 11:53:04.
> > > ReportingServicesService!dbpolling!1c8!13/02/2005-11:53:04:: EventPolling
> > > finished processing item d4b31a3b-7752-49ed-ae30-36035bbd89c5
> > > ReportingServicesService!dbpolling!1c8!13/02/2005-11:53:04::
> > > NotificationPolling processing item c6a2efa0-ecac-40b9-b2c9-18610a52d62c
> > > ReportingServicesService!dbpolling!c24!13/02/2005-11:53:04::
> > > NotificationPolling processing 1 more items. 1 Total items in internal queue.
> > > ReportingServicesService!library!1c8!02/13/2005-11:53:06:: i INFO:
> > > Initializing EnableIntegratedSecurity to 'True' as specified in Server
> > > system properties.
> > > ReportingServicesService!library!1c8!02/13/2005-11:53:11:: i INFO: Call to
> > > RenderFirst( '/Report Project2/Study Progress Report' )
> > > ReportingServicesService!library!1c8!02/13/2005-11:53:11:: e ERROR: Throwing
> > > Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
> > > The Report Server has encountered a configuration error; more details in the
> > > log files, AuthzInitializeContextFromSid: Win32 error: 1355;
> > > Info:
> > > Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
> > > The Report Server has encountered a configuration error; more details in the
> > > log files
> > > ReportingServicesService!library!1c8!02/13/2005-11:53:11:: i INFO:
> > > Initializing EnableExecutionLogging to 'True' as specified in Server system
> > > properties.
> > > ReportingServicesService!emailextension!1c8!02/13/2005-11:53:12:: Error
> > > sending email. Microsoft.ReportingServices.Diagnostics.Utilities.RSException:
> > > The Report Server has encountered a configuration error; more details in the
> > > log files -->
> > > Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
> > > The Report Server has encountered a configuration error; more details in the
> > > log files
> > > at
> > > Microsoft.ReportingServices.Authorization.Native.GetAuthzContextForUser(IntPtr userSid)
> > > at Microsoft.ReportingServices.Authorization.Native.IsAdmin(String
> > > userName)
> > > at
> > > Microsoft.ReportingServices.Authorization.WindowsAuthorization.IsAdmin(String
> > > userName, IntPtr userToken)
> > > at
> > > Microsoft.ReportingServices.Authorization.WindowsAuthorization.CheckAccess(String
> > > userName, IntPtr userToken, Byte[] secDesc, ReportOperation requiredOperation)
> > > at Microsoft.ReportingServices.Library.Security.CheckAccess(ItemType
> > > catItemType, Byte[] secDesc, ReportOperation rptOper)
> > > at
> > > Microsoft.ReportingServices.Library.RSService._GetReportParameterDefinitionFromCatalog(CatalogItemContext
> > > reportContext, String historyID, Boolean forRendering, Guid& reportID, Int32&
> > > executionOption, String& savedParametersXml, ReportSnapshot&
> > > compiledDefinition, ReportSnapshot& snapshotData, Guid& linkID, DateTime&
> > > historyDate)
> > > at
> > > Microsoft.ReportingServices.Library.RSService._GetReportParameters(String
> > > report, String historyID, Boolean forRendering, NameValueCollection values,
> > > DatasourceCredentialsCollection credentials)
> > > at
> > > Microsoft.ReportingServices.Library.RSService.RenderAsLiveOrSnapshot(CatalogItemContext
> > > reportContext, ClientRequest session, Warning[]& warnings,
> > > ParameterInfoCollection& effectiveParameters)
> > > at
> > > Microsoft.ReportingServices.Library.RSService.RenderFirst(CatalogItemContext
> > > reportContext, ClientRequest session, Warning[]& warnings,
> > > ParameterInfoCollection& effectiveParameters, String[]& secondaryStreamNames)
> > > at Microsoft.ReportingServices.Library.RenderFirstCancelableStep.Execute()
> > > at
> > > Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
> > > -- End of inner exception stack trace --
> > > at
> > > Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
> > > at
> > > Microsoft.ReportingServices.Library.RenderFirstCancelableStep.RenderFirst(RSService
> > > rs, CatalogItemContext reportContext, ClientRequest session, JobTypeEnum
> > > type, Warning[]& warnings, ParameterInfoCollection& effectiveParameters,
> > > String[]& secondaryStreamNames)
> > > at Microsoft.ReportingServices.Library.ReportImpl.Render(String
> > > renderFormat, String deviceInfo)
> > > at
> > > Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.ConstructMessageBody(IMessage message, Notification notification, SubscriptionData data)
> > > at
> > > Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.CreateMessage(Notification notification)
> > > at
> > > Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.Deliver(Notification notification)
> > > ReportingServicesService!notification!1c8!02/13/2005-11:53:12:: Notification
> > > c6a2efa0-ecac-40b9-b2c9-18610a52d62c completed. Success: False, Status:
> > > Failure sending mail: The Report Server has encountered a configuration
> > > error; more details in the log files, DeliveryExtension: Report Server Email,
> > > Report: Study Progress Report, Attempt 0
> > > ReportingServicesService!dbpolling!1c8!02/13/2005-11:53:12::
> > > NotificationPolling finished processing item
> > > c6a2efa0-ecac-40b9-b2c9-18610a52d62c
> > >
of 2 days now... I have learnt a lot about connections, encrypted files,
rsconfig etc, but I still can not get the thing to work.
I have ended up with the orginial problem I had, "Failure sending mail: The
Report Server has encountered a configuration error; more details in the log
files"
I have applied SP1 and now changed the account that the service uses to one
that had domain admin rights.
I am still can not see what else is left... every account that I know about
within RS has admin rights...
The following is an excerpt from the log...
Any ideas would be greatfully accepted... I dont really want to reinstall
but if that is what it takes ...
--
Thanks
Chris
ReportingServicesService!dbpolling!c24!13/02/2005-11:53:03:: EventPolling
processing 1 more items. 1 Total items in internal queue.
ReportingServicesService!dbpolling!1c8!13/02/2005-11:53:03:: EventPolling
processing item d4b31a3b-7752-49ed-ae30-36035bbd89c5
ReportingServicesService!library!1c8!13/02/2005-11:53:04:: Schedule
897832a6-9489-478d-8e75-97b1b64a2b5d executed at 13/02/2005 11:53:04.
ReportingServicesService!schedule!1c8!13/02/2005-11:53:04:: Creating Time
based subscription notification for subscription:
ef711679-d57d-4aba-b06b-47aafc18e808
ReportingServicesService!library!1c8!13/02/2005-11:53:04:: Schedule
897832a6-9489-478d-8e75-97b1b64a2b5d execution completed at 13/02/2005
11:53:04.
ReportingServicesService!dbpolling!1c8!13/02/2005-11:53:04:: EventPolling
finished processing item d4b31a3b-7752-49ed-ae30-36035bbd89c5
ReportingServicesService!dbpolling!1c8!13/02/2005-11:53:04::
NotificationPolling processing item c6a2efa0-ecac-40b9-b2c9-18610a52d62c
ReportingServicesService!dbpolling!c24!13/02/2005-11:53:04::
NotificationPolling processing 1 more items. 1 Total items in internal queue.
ReportingServicesService!library!1c8!02/13/2005-11:53:06:: i INFO:
Initializing EnableIntegratedSecurity to 'True' as specified in Server
system properties.
ReportingServicesService!library!1c8!02/13/2005-11:53:11:: i INFO: Call to
RenderFirst( '/Report Project2/Study Progress Report' )
ReportingServicesService!library!1c8!02/13/2005-11:53:11:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
The Report Server has encountered a configuration error; more details in the
log files, AuthzInitializeContextFromSid: Win32 error: 1355;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
The Report Server has encountered a configuration error; more details in the
log files
ReportingServicesService!library!1c8!02/13/2005-11:53:11:: i INFO:
Initializing EnableExecutionLogging to 'True' as specified in Server system
properties.
ReportingServicesService!emailextension!1c8!02/13/2005-11:53:12:: Error
sending email. Microsoft.ReportingServices.Diagnostics.Utilities.RSException:
The Report Server has encountered a configuration error; more details in the
log files -->
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
The Report Server has encountered a configuration error; more details in the
log files
at
Microsoft.ReportingServices.Authorization.Native.GetAuthzContextForUser(IntPtr userSid)
at Microsoft.ReportingServices.Authorization.Native.IsAdmin(String
userName)
at
Microsoft.ReportingServices.Authorization.WindowsAuthorization.IsAdmin(String
userName, IntPtr userToken)
at
Microsoft.ReportingServices.Authorization.WindowsAuthorization.CheckAccess(String
userName, IntPtr userToken, Byte[] secDesc, ReportOperation requiredOperation)
at Microsoft.ReportingServices.Library.Security.CheckAccess(ItemType
catItemType, Byte[] secDesc, ReportOperation rptOper)
at
Microsoft.ReportingServices.Library.RSService._GetReportParameterDefinitionFromCatalog(CatalogItemContext
reportContext, String historyID, Boolean forRendering, Guid& reportID, Int32&
executionOption, String& savedParametersXml, ReportSnapshot&
compiledDefinition, ReportSnapshot& snapshotData, Guid& linkID, DateTime&
historyDate)
at
Microsoft.ReportingServices.Library.RSService._GetReportParameters(String
report, String historyID, Boolean forRendering, NameValueCollection values,
DatasourceCredentialsCollection credentials)
at
Microsoft.ReportingServices.Library.RSService.RenderAsLiveOrSnapshot(CatalogItemContext
reportContext, ClientRequest session, Warning[]& warnings,
ParameterInfoCollection& effectiveParameters)
at
Microsoft.ReportingServices.Library.RSService.RenderFirst(CatalogItemContext
reportContext, ClientRequest session, Warning[]& warnings,
ParameterInfoCollection& effectiveParameters, String[]& secondaryStreamNames)
at Microsoft.ReportingServices.Library.RenderFirstCancelableStep.Execute()
at
Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
-- End of inner exception stack trace --
at
Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
at
Microsoft.ReportingServices.Library.RenderFirstCancelableStep.RenderFirst(RSService
rs, CatalogItemContext reportContext, ClientRequest session, JobTypeEnum
type, Warning[]& warnings, ParameterInfoCollection& effectiveParameters,
String[]& secondaryStreamNames)
at Microsoft.ReportingServices.Library.ReportImpl.Render(String
renderFormat, String deviceInfo)
at
Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.ConstructMessageBody(IMessage message, Notification notification, SubscriptionData data)
at
Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.CreateMessage(Notification notification)
at
Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.Deliver(Notification notification)
ReportingServicesService!notification!1c8!02/13/2005-11:53:12:: Notification
c6a2efa0-ecac-40b9-b2c9-18610a52d62c completed. Success: False, Status:
Failure sending mail: The Report Server has encountered a configuration
error; more details in the log files, DeliveryExtension: Report Server Email,
Report: Study Progress Report, Attempt 0
ReportingServicesService!dbpolling!1c8!02/13/2005-11:53:12::
NotificationPolling finished processing item
c6a2efa0-ecac-40b9-b2c9-18610a52d62cChris,
I'm having the same issue. Your log file is getting the WinNT error 1355,
and
there is currently a hotfix available for it (834859) I haven't tried it yet,
but someone did at the following url and it worked for them.
http://groups-beta.google.com/group/microsoft.public.sqlserver.reportingsvcs/msg/123eea5b7fc5edaa?q=authz+group:microsoft.public.sqlserver.reportingsvcs&hl=en&lr=&ie=UTF-8&rnum=4
"Chris Morgan" wrote:
> I have been trying to get email delivery of reports working for the best part
> of 2 days now... I have learnt a lot about connections, encrypted files,
> rsconfig etc, but I still can not get the thing to work.
> I have ended up with the orginial problem I had, "Failure sending mail: The
> Report Server has encountered a configuration error; more details in the log
> files"
> I have applied SP1 and now changed the account that the service uses to one
> that had domain admin rights.
> I am still can not see what else is left... every account that I know about
> within RS has admin rights...
> The following is an excerpt from the log...
> Any ideas would be greatfully accepted... I dont really want to reinstall
> but if that is what it takes ...
> --
> Thanks
> Chris
>
> ReportingServicesService!dbpolling!c24!13/02/2005-11:53:03:: EventPolling
> processing 1 more items. 1 Total items in internal queue.
> ReportingServicesService!dbpolling!1c8!13/02/2005-11:53:03:: EventPolling
> processing item d4b31a3b-7752-49ed-ae30-36035bbd89c5
> ReportingServicesService!library!1c8!13/02/2005-11:53:04:: Schedule
> 897832a6-9489-478d-8e75-97b1b64a2b5d executed at 13/02/2005 11:53:04.
> ReportingServicesService!schedule!1c8!13/02/2005-11:53:04:: Creating Time
> based subscription notification for subscription:
> ef711679-d57d-4aba-b06b-47aafc18e808
> ReportingServicesService!library!1c8!13/02/2005-11:53:04:: Schedule
> 897832a6-9489-478d-8e75-97b1b64a2b5d execution completed at 13/02/2005
> 11:53:04.
> ReportingServicesService!dbpolling!1c8!13/02/2005-11:53:04:: EventPolling
> finished processing item d4b31a3b-7752-49ed-ae30-36035bbd89c5
> ReportingServicesService!dbpolling!1c8!13/02/2005-11:53:04::
> NotificationPolling processing item c6a2efa0-ecac-40b9-b2c9-18610a52d62c
> ReportingServicesService!dbpolling!c24!13/02/2005-11:53:04::
> NotificationPolling processing 1 more items. 1 Total items in internal queue.
> ReportingServicesService!library!1c8!02/13/2005-11:53:06:: i INFO:
> Initializing EnableIntegratedSecurity to 'True' as specified in Server
> system properties.
> ReportingServicesService!library!1c8!02/13/2005-11:53:11:: i INFO: Call to
> RenderFirst( '/Report Project2/Study Progress Report' )
> ReportingServicesService!library!1c8!02/13/2005-11:53:11:: e ERROR: Throwing
> Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
> The Report Server has encountered a configuration error; more details in the
> log files, AuthzInitializeContextFromSid: Win32 error: 1355;
> Info:
> Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
> The Report Server has encountered a configuration error; more details in the
> log files
> ReportingServicesService!library!1c8!02/13/2005-11:53:11:: i INFO:
> Initializing EnableExecutionLogging to 'True' as specified in Server system
> properties.
> ReportingServicesService!emailextension!1c8!02/13/2005-11:53:12:: Error
> sending email. Microsoft.ReportingServices.Diagnostics.Utilities.RSException:
> The Report Server has encountered a configuration error; more details in the
> log files -->
> Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
> The Report Server has encountered a configuration error; more details in the
> log files
> at
> Microsoft.ReportingServices.Authorization.Native.GetAuthzContextForUser(IntPtr userSid)
> at Microsoft.ReportingServices.Authorization.Native.IsAdmin(String
> userName)
> at
> Microsoft.ReportingServices.Authorization.WindowsAuthorization.IsAdmin(String
> userName, IntPtr userToken)
> at
> Microsoft.ReportingServices.Authorization.WindowsAuthorization.CheckAccess(String
> userName, IntPtr userToken, Byte[] secDesc, ReportOperation requiredOperation)
> at Microsoft.ReportingServices.Library.Security.CheckAccess(ItemType
> catItemType, Byte[] secDesc, ReportOperation rptOper)
> at
> Microsoft.ReportingServices.Library.RSService._GetReportParameterDefinitionFromCatalog(CatalogItemContext
> reportContext, String historyID, Boolean forRendering, Guid& reportID, Int32&
> executionOption, String& savedParametersXml, ReportSnapshot&
> compiledDefinition, ReportSnapshot& snapshotData, Guid& linkID, DateTime&
> historyDate)
> at
> Microsoft.ReportingServices.Library.RSService._GetReportParameters(String
> report, String historyID, Boolean forRendering, NameValueCollection values,
> DatasourceCredentialsCollection credentials)
> at
> Microsoft.ReportingServices.Library.RSService.RenderAsLiveOrSnapshot(CatalogItemContext
> reportContext, ClientRequest session, Warning[]& warnings,
> ParameterInfoCollection& effectiveParameters)
> at
> Microsoft.ReportingServices.Library.RSService.RenderFirst(CatalogItemContext
> reportContext, ClientRequest session, Warning[]& warnings,
> ParameterInfoCollection& effectiveParameters, String[]& secondaryStreamNames)
> at Microsoft.ReportingServices.Library.RenderFirstCancelableStep.Execute()
> at
> Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
> -- End of inner exception stack trace --
> at
> Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
> at
> Microsoft.ReportingServices.Library.RenderFirstCancelableStep.RenderFirst(RSService
> rs, CatalogItemContext reportContext, ClientRequest session, JobTypeEnum
> type, Warning[]& warnings, ParameterInfoCollection& effectiveParameters,
> String[]& secondaryStreamNames)
> at Microsoft.ReportingServices.Library.ReportImpl.Render(String
> renderFormat, String deviceInfo)
> at
> Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.ConstructMessageBody(IMessage message, Notification notification, SubscriptionData data)
> at
> Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.CreateMessage(Notification notification)
> at
> Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.Deliver(Notification notification)
> ReportingServicesService!notification!1c8!02/13/2005-11:53:12:: Notification
> c6a2efa0-ecac-40b9-b2c9-18610a52d62c completed. Success: False, Status:
> Failure sending mail: The Report Server has encountered a configuration
> error; more details in the log files, DeliveryExtension: Report Server Email,
> Report: Study Progress Report, Attempt 0
> ReportingServicesService!dbpolling!1c8!02/13/2005-11:53:12::
> NotificationPolling finished processing item
> c6a2efa0-ecac-40b9-b2c9-18610a52d62c
>|||David,
I did what I did not want to do in the end... reinstalled and used the
domain admin account from the outset, it guess what it works...
I wouldnt say that I fixed the problem, just hit it with a big enough
hammer...
What I can say is that our users are really amazed at what we can do now and
all the effort we have put into getting RS working was well worth it...
Thanks for the link...
Chris
"David Siebert" wrote:
> Chris,
> I'm having the same issue. Your log file is getting the WinNT error 1355,
> and
> there is currently a hotfix available for it (834859) I haven't tried it yet,
> but someone did at the following url and it worked for them.
>
> http://groups-beta.google.com/group/microsoft.public.sqlserver.reportingsvcs/msg/123eea5b7fc5edaa?q=authz+group:microsoft.public.sqlserver.reportingsvcs&hl=en&lr=&ie=UTF-8&rnum=4
>
> "Chris Morgan" wrote:
> > I have been trying to get email delivery of reports working for the best part
> > of 2 days now... I have learnt a lot about connections, encrypted files,
> > rsconfig etc, but I still can not get the thing to work.
> >
> > I have ended up with the orginial problem I had, "Failure sending mail: The
> > Report Server has encountered a configuration error; more details in the log
> > files"
> >
> > I have applied SP1 and now changed the account that the service uses to one
> > that had domain admin rights.
> >
> > I am still can not see what else is left... every account that I know about
> > within RS has admin rights...
> >
> > The following is an excerpt from the log...
> >
> > Any ideas would be greatfully accepted... I dont really want to reinstall
> > but if that is what it takes ...
> >
> > --
> > Thanks
> > Chris
> >
> >
> > ReportingServicesService!dbpolling!c24!13/02/2005-11:53:03:: EventPolling
> > processing 1 more items. 1 Total items in internal queue.
> > ReportingServicesService!dbpolling!1c8!13/02/2005-11:53:03:: EventPolling
> > processing item d4b31a3b-7752-49ed-ae30-36035bbd89c5
> > ReportingServicesService!library!1c8!13/02/2005-11:53:04:: Schedule
> > 897832a6-9489-478d-8e75-97b1b64a2b5d executed at 13/02/2005 11:53:04.
> > ReportingServicesService!schedule!1c8!13/02/2005-11:53:04:: Creating Time
> > based subscription notification for subscription:
> > ef711679-d57d-4aba-b06b-47aafc18e808
> > ReportingServicesService!library!1c8!13/02/2005-11:53:04:: Schedule
> > 897832a6-9489-478d-8e75-97b1b64a2b5d execution completed at 13/02/2005
> > 11:53:04.
> > ReportingServicesService!dbpolling!1c8!13/02/2005-11:53:04:: EventPolling
> > finished processing item d4b31a3b-7752-49ed-ae30-36035bbd89c5
> > ReportingServicesService!dbpolling!1c8!13/02/2005-11:53:04::
> > NotificationPolling processing item c6a2efa0-ecac-40b9-b2c9-18610a52d62c
> > ReportingServicesService!dbpolling!c24!13/02/2005-11:53:04::
> > NotificationPolling processing 1 more items. 1 Total items in internal queue.
> > ReportingServicesService!library!1c8!02/13/2005-11:53:06:: i INFO:
> > Initializing EnableIntegratedSecurity to 'True' as specified in Server
> > system properties.
> > ReportingServicesService!library!1c8!02/13/2005-11:53:11:: i INFO: Call to
> > RenderFirst( '/Report Project2/Study Progress Report' )
> > ReportingServicesService!library!1c8!02/13/2005-11:53:11:: e ERROR: Throwing
> > Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
> > The Report Server has encountered a configuration error; more details in the
> > log files, AuthzInitializeContextFromSid: Win32 error: 1355;
> > Info:
> > Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
> > The Report Server has encountered a configuration error; more details in the
> > log files
> > ReportingServicesService!library!1c8!02/13/2005-11:53:11:: i INFO:
> > Initializing EnableExecutionLogging to 'True' as specified in Server system
> > properties.
> > ReportingServicesService!emailextension!1c8!02/13/2005-11:53:12:: Error
> > sending email. Microsoft.ReportingServices.Diagnostics.Utilities.RSException:
> > The Report Server has encountered a configuration error; more details in the
> > log files -->
> > Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
> > The Report Server has encountered a configuration error; more details in the
> > log files
> > at
> > Microsoft.ReportingServices.Authorization.Native.GetAuthzContextForUser(IntPtr userSid)
> > at Microsoft.ReportingServices.Authorization.Native.IsAdmin(String
> > userName)
> > at
> > Microsoft.ReportingServices.Authorization.WindowsAuthorization.IsAdmin(String
> > userName, IntPtr userToken)
> > at
> > Microsoft.ReportingServices.Authorization.WindowsAuthorization.CheckAccess(String
> > userName, IntPtr userToken, Byte[] secDesc, ReportOperation requiredOperation)
> > at Microsoft.ReportingServices.Library.Security.CheckAccess(ItemType
> > catItemType, Byte[] secDesc, ReportOperation rptOper)
> > at
> > Microsoft.ReportingServices.Library.RSService._GetReportParameterDefinitionFromCatalog(CatalogItemContext
> > reportContext, String historyID, Boolean forRendering, Guid& reportID, Int32&
> > executionOption, String& savedParametersXml, ReportSnapshot&
> > compiledDefinition, ReportSnapshot& snapshotData, Guid& linkID, DateTime&
> > historyDate)
> > at
> > Microsoft.ReportingServices.Library.RSService._GetReportParameters(String
> > report, String historyID, Boolean forRendering, NameValueCollection values,
> > DatasourceCredentialsCollection credentials)
> > at
> > Microsoft.ReportingServices.Library.RSService.RenderAsLiveOrSnapshot(CatalogItemContext
> > reportContext, ClientRequest session, Warning[]& warnings,
> > ParameterInfoCollection& effectiveParameters)
> > at
> > Microsoft.ReportingServices.Library.RSService.RenderFirst(CatalogItemContext
> > reportContext, ClientRequest session, Warning[]& warnings,
> > ParameterInfoCollection& effectiveParameters, String[]& secondaryStreamNames)
> > at Microsoft.ReportingServices.Library.RenderFirstCancelableStep.Execute()
> > at
> > Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
> > -- End of inner exception stack trace --
> > at
> > Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
> > at
> > Microsoft.ReportingServices.Library.RenderFirstCancelableStep.RenderFirst(RSService
> > rs, CatalogItemContext reportContext, ClientRequest session, JobTypeEnum
> > type, Warning[]& warnings, ParameterInfoCollection& effectiveParameters,
> > String[]& secondaryStreamNames)
> > at Microsoft.ReportingServices.Library.ReportImpl.Render(String
> > renderFormat, String deviceInfo)
> > at
> > Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.ConstructMessageBody(IMessage message, Notification notification, SubscriptionData data)
> > at
> > Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.CreateMessage(Notification notification)
> > at
> > Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.Deliver(Notification notification)
> > ReportingServicesService!notification!1c8!02/13/2005-11:53:12:: Notification
> > c6a2efa0-ecac-40b9-b2c9-18610a52d62c completed. Success: False, Status:
> > Failure sending mail: The Report Server has encountered a configuration
> > error; more details in the log files, DeliveryExtension: Report Server Email,
> > Report: Study Progress Report, Attempt 0
> > ReportingServicesService!dbpolling!1c8!02/13/2005-11:53:12::
> > NotificationPolling finished processing item
> > c6a2efa0-ecac-40b9-b2c9-18610a52d62c
> >|||Just as a word of warning, my first attempt at a solution was to reinstall
RS. The mail worked for a little while, and then I began receiving the same
error again. So, just be on the lookout for failing email subscriptions.
While we haven't installed the hotfix, we've resorted to just sending a link
in the email. The error only occurs when you try to embed or attach a
report. Good luck.
"Chris Morgan" wrote:
> David,
> I did what I did not want to do in the end... reinstalled and used the
> domain admin account from the outset, it guess what it works...
> I wouldnt say that I fixed the problem, just hit it with a big enough
> hammer...
> What I can say is that our users are really amazed at what we can do now and
> all the effort we have put into getting RS working was well worth it...
> Thanks for the link...
> Chris
>
> "David Siebert" wrote:
> > Chris,
> >
> > I'm having the same issue. Your log file is getting the WinNT error 1355,
> > and
> > there is currently a hotfix available for it (834859) I haven't tried it yet,
> > but someone did at the following url and it worked for them.
> >
> >
> > http://groups-beta.google.com/group/microsoft.public.sqlserver.reportingsvcs/msg/123eea5b7fc5edaa?q=authz+group:microsoft.public.sqlserver.reportingsvcs&hl=en&lr=&ie=UTF-8&rnum=4
> >
> >
> > "Chris Morgan" wrote:
> >
> > > I have been trying to get email delivery of reports working for the best part
> > > of 2 days now... I have learnt a lot about connections, encrypted files,
> > > rsconfig etc, but I still can not get the thing to work.
> > >
> > > I have ended up with the orginial problem I had, "Failure sending mail: The
> > > Report Server has encountered a configuration error; more details in the log
> > > files"
> > >
> > > I have applied SP1 and now changed the account that the service uses to one
> > > that had domain admin rights.
> > >
> > > I am still can not see what else is left... every account that I know about
> > > within RS has admin rights...
> > >
> > > The following is an excerpt from the log...
> > >
> > > Any ideas would be greatfully accepted... I dont really want to reinstall
> > > but if that is what it takes ...
> > >
> > > --
> > > Thanks
> > > Chris
> > >
> > >
> > > ReportingServicesService!dbpolling!c24!13/02/2005-11:53:03:: EventPolling
> > > processing 1 more items. 1 Total items in internal queue.
> > > ReportingServicesService!dbpolling!1c8!13/02/2005-11:53:03:: EventPolling
> > > processing item d4b31a3b-7752-49ed-ae30-36035bbd89c5
> > > ReportingServicesService!library!1c8!13/02/2005-11:53:04:: Schedule
> > > 897832a6-9489-478d-8e75-97b1b64a2b5d executed at 13/02/2005 11:53:04.
> > > ReportingServicesService!schedule!1c8!13/02/2005-11:53:04:: Creating Time
> > > based subscription notification for subscription:
> > > ef711679-d57d-4aba-b06b-47aafc18e808
> > > ReportingServicesService!library!1c8!13/02/2005-11:53:04:: Schedule
> > > 897832a6-9489-478d-8e75-97b1b64a2b5d execution completed at 13/02/2005
> > > 11:53:04.
> > > ReportingServicesService!dbpolling!1c8!13/02/2005-11:53:04:: EventPolling
> > > finished processing item d4b31a3b-7752-49ed-ae30-36035bbd89c5
> > > ReportingServicesService!dbpolling!1c8!13/02/2005-11:53:04::
> > > NotificationPolling processing item c6a2efa0-ecac-40b9-b2c9-18610a52d62c
> > > ReportingServicesService!dbpolling!c24!13/02/2005-11:53:04::
> > > NotificationPolling processing 1 more items. 1 Total items in internal queue.
> > > ReportingServicesService!library!1c8!02/13/2005-11:53:06:: i INFO:
> > > Initializing EnableIntegratedSecurity to 'True' as specified in Server
> > > system properties.
> > > ReportingServicesService!library!1c8!02/13/2005-11:53:11:: i INFO: Call to
> > > RenderFirst( '/Report Project2/Study Progress Report' )
> > > ReportingServicesService!library!1c8!02/13/2005-11:53:11:: e ERROR: Throwing
> > > Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
> > > The Report Server has encountered a configuration error; more details in the
> > > log files, AuthzInitializeContextFromSid: Win32 error: 1355;
> > > Info:
> > > Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
> > > The Report Server has encountered a configuration error; more details in the
> > > log files
> > > ReportingServicesService!library!1c8!02/13/2005-11:53:11:: i INFO:
> > > Initializing EnableExecutionLogging to 'True' as specified in Server system
> > > properties.
> > > ReportingServicesService!emailextension!1c8!02/13/2005-11:53:12:: Error
> > > sending email. Microsoft.ReportingServices.Diagnostics.Utilities.RSException:
> > > The Report Server has encountered a configuration error; more details in the
> > > log files -->
> > > Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
> > > The Report Server has encountered a configuration error; more details in the
> > > log files
> > > at
> > > Microsoft.ReportingServices.Authorization.Native.GetAuthzContextForUser(IntPtr userSid)
> > > at Microsoft.ReportingServices.Authorization.Native.IsAdmin(String
> > > userName)
> > > at
> > > Microsoft.ReportingServices.Authorization.WindowsAuthorization.IsAdmin(String
> > > userName, IntPtr userToken)
> > > at
> > > Microsoft.ReportingServices.Authorization.WindowsAuthorization.CheckAccess(String
> > > userName, IntPtr userToken, Byte[] secDesc, ReportOperation requiredOperation)
> > > at Microsoft.ReportingServices.Library.Security.CheckAccess(ItemType
> > > catItemType, Byte[] secDesc, ReportOperation rptOper)
> > > at
> > > Microsoft.ReportingServices.Library.RSService._GetReportParameterDefinitionFromCatalog(CatalogItemContext
> > > reportContext, String historyID, Boolean forRendering, Guid& reportID, Int32&
> > > executionOption, String& savedParametersXml, ReportSnapshot&
> > > compiledDefinition, ReportSnapshot& snapshotData, Guid& linkID, DateTime&
> > > historyDate)
> > > at
> > > Microsoft.ReportingServices.Library.RSService._GetReportParameters(String
> > > report, String historyID, Boolean forRendering, NameValueCollection values,
> > > DatasourceCredentialsCollection credentials)
> > > at
> > > Microsoft.ReportingServices.Library.RSService.RenderAsLiveOrSnapshot(CatalogItemContext
> > > reportContext, ClientRequest session, Warning[]& warnings,
> > > ParameterInfoCollection& effectiveParameters)
> > > at
> > > Microsoft.ReportingServices.Library.RSService.RenderFirst(CatalogItemContext
> > > reportContext, ClientRequest session, Warning[]& warnings,
> > > ParameterInfoCollection& effectiveParameters, String[]& secondaryStreamNames)
> > > at Microsoft.ReportingServices.Library.RenderFirstCancelableStep.Execute()
> > > at
> > > Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
> > > -- End of inner exception stack trace --
> > > at
> > > Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
> > > at
> > > Microsoft.ReportingServices.Library.RenderFirstCancelableStep.RenderFirst(RSService
> > > rs, CatalogItemContext reportContext, ClientRequest session, JobTypeEnum
> > > type, Warning[]& warnings, ParameterInfoCollection& effectiveParameters,
> > > String[]& secondaryStreamNames)
> > > at Microsoft.ReportingServices.Library.ReportImpl.Render(String
> > > renderFormat, String deviceInfo)
> > > at
> > > Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.ConstructMessageBody(IMessage message, Notification notification, SubscriptionData data)
> > > at
> > > Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.CreateMessage(Notification notification)
> > > at
> > > Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.Deliver(Notification notification)
> > > ReportingServicesService!notification!1c8!02/13/2005-11:53:12:: Notification
> > > c6a2efa0-ecac-40b9-b2c9-18610a52d62c completed. Success: False, Status:
> > > Failure sending mail: The Report Server has encountered a configuration
> > > error; more details in the log files, DeliveryExtension: Report Server Email,
> > > Report: Study Progress Report, Attempt 0
> > > ReportingServicesService!dbpolling!1c8!02/13/2005-11:53:12::
> > > NotificationPolling finished processing item
> > > c6a2efa0-ecac-40b9-b2c9-18610a52d62c
> > >
Sunday, March 11, 2012
Email Error: The delivery extension for this subscription could not be loaded.
I am just getting started using scheduled emails and after setting up the
config file and setting up a schedule...I get the following error reported
on the RS (and no email):
"The delivery extension for this subscription could not be loaded."
when the subscription fires.
Can some one point me in the right direction on where to get more
information on this error. Does this mean that the EMAIL extension could
not be loaded or,
that the rendering format could not be loaded or,
what?
My first guess is that I did not set up the the email config section
correctly. What do you think and where on my system (logs) should I look to
get more details on this error. Win2003 server has a working SMTP relay
(tested with CDO VBS script).
thanks in advance.
dlrLook in the ReportServerService<date>.log file for more error information.
Also in the RSReportServer.config file make sure the SMTPServer element and
From element are filled in.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Dennis Redfield" <dennis.redfield@.acadia-ins.com> wrote in message
news:eFPk2xKgEHA.1196@.TK2MSFTNGP11.phx.gbl...
> I am just getting started using scheduled emails and after setting up the
> config file and setting up a schedule...I get the following error reported
> on the RS (and no email):
> "The delivery extension for this subscription could not be loaded."
> when the subscription fires.
> Can some one point me in the right direction on where to get more
> information on this error. Does this mean that the EMAIL extension could
> not be loaded or,
> that the rendering format could not be loaded or,
> what?
> My first guess is that I did not set up the the email config section
> correctly. What do you think and where on my system (logs) should I look
to
> get more details on this error. Win2003 server has a working SMTP relay
> (tested with CDO VBS script).
> thanks in advance.
> dlr
>|||ok Daniel. That problems seems to be a one time thing. Nothing in the log
file and repeated experiments today have basic email "working". Well
actually a problem HAS come up with the attachments but that is the subject
of another post.
thanks
dlr
"Daniel Reib [MSFT]" <danreib@.online.microsoft.com> wrote in message
news:udRV82KgEHA.592@.TK2MSFTNGP11.phx.gbl...
> Look in the ReportServerService<date>.log file for more error information.
> Also in the RSReportServer.config file make sure the SMTPServer element
and
> From element are filled in.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> "Dennis Redfield" <dennis.redfield@.acadia-ins.com> wrote in message
> news:eFPk2xKgEHA.1196@.TK2MSFTNGP11.phx.gbl...
> > I am just getting started using scheduled emails and after setting up
the
> > config file and setting up a schedule...I get the following error
reported
> > on the RS (and no email):
> > "The delivery extension for this subscription could not be loaded."
> > when the subscription fires.
> > Can some one point me in the right direction on where to get more
> > information on this error. Does this mean that the EMAIL extension
could
> > not be loaded or,
> > that the rendering format could not be loaded or,
> > what?
> >
> > My first guess is that I did not set up the the email config section
> > correctly. What do you think and where on my system (logs) should I
look
> to
> > get more details on this error. Win2003 server has a working SMTP relay
> > (tested with CDO VBS script).
> >
> > thanks in advance.
> >
> > dlr
> >
> >
>
config file and setting up a schedule...I get the following error reported
on the RS (and no email):
"The delivery extension for this subscription could not be loaded."
when the subscription fires.
Can some one point me in the right direction on where to get more
information on this error. Does this mean that the EMAIL extension could
not be loaded or,
that the rendering format could not be loaded or,
what?
My first guess is that I did not set up the the email config section
correctly. What do you think and where on my system (logs) should I look to
get more details on this error. Win2003 server has a working SMTP relay
(tested with CDO VBS script).
thanks in advance.
dlrLook in the ReportServerService<date>.log file for more error information.
Also in the RSReportServer.config file make sure the SMTPServer element and
From element are filled in.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Dennis Redfield" <dennis.redfield@.acadia-ins.com> wrote in message
news:eFPk2xKgEHA.1196@.TK2MSFTNGP11.phx.gbl...
> I am just getting started using scheduled emails and after setting up the
> config file and setting up a schedule...I get the following error reported
> on the RS (and no email):
> "The delivery extension for this subscription could not be loaded."
> when the subscription fires.
> Can some one point me in the right direction on where to get more
> information on this error. Does this mean that the EMAIL extension could
> not be loaded or,
> that the rendering format could not be loaded or,
> what?
> My first guess is that I did not set up the the email config section
> correctly. What do you think and where on my system (logs) should I look
to
> get more details on this error. Win2003 server has a working SMTP relay
> (tested with CDO VBS script).
> thanks in advance.
> dlr
>|||ok Daniel. That problems seems to be a one time thing. Nothing in the log
file and repeated experiments today have basic email "working". Well
actually a problem HAS come up with the attachments but that is the subject
of another post.
thanks
dlr
"Daniel Reib [MSFT]" <danreib@.online.microsoft.com> wrote in message
news:udRV82KgEHA.592@.TK2MSFTNGP11.phx.gbl...
> Look in the ReportServerService<date>.log file for more error information.
> Also in the RSReportServer.config file make sure the SMTPServer element
and
> From element are filled in.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> "Dennis Redfield" <dennis.redfield@.acadia-ins.com> wrote in message
> news:eFPk2xKgEHA.1196@.TK2MSFTNGP11.phx.gbl...
> > I am just getting started using scheduled emails and after setting up
the
> > config file and setting up a schedule...I get the following error
reported
> > on the RS (and no email):
> > "The delivery extension for this subscription could not be loaded."
> > when the subscription fires.
> > Can some one point me in the right direction on where to get more
> > information on this error. Does this mean that the EMAIL extension
could
> > not be loaded or,
> > that the rendering format could not be loaded or,
> > what?
> >
> > My first guess is that I did not set up the the email config section
> > correctly. What do you think and where on my system (logs) should I
look
> to
> > get more details on this error. Win2003 server has a working SMTP relay
> > (tested with CDO VBS script).
> >
> > thanks in advance.
> >
> > dlr
> >
> >
>
Email delivery, rendering format problem
Hi,
Im trying to set up so the report gets delivered to specified email addresses with the rendering format set to Web Archive.
The problem is, it wont deliver the background of the report. We really need the background to be yellow (company color) i have tried with both the backgroundcolor setting and backgroundimage setting with repeat =true, but it just delivers the email as transparent(white) background.
Anyone know how to solve this?
regards,
xenojust seem like it is impossible. For those with similiar problem in the future, here is the work-around that i used:
Put a rectangle on your form that stretches 100% with and height of the form and put all objects within it. Make sure it will be resizable to fit.
I dont like it at all, but hey...cant waste too much time on these things when the clock is ticking.
.xeno
e-mail delivery to Dsitribution Group in AD fails
Hi
I have some unusual problem with e-mail delivery of reports.
I need sheduling subscription to daily report for all workers of our
company. All these people are members of distribution group in AD named "All
workers".
I've made subscription and typed in "TO:" field valid e-mail address of the
distributoin group: allworkers@.mydomain.com.
The e-mail message with report was succesifully send from Report Server but
it did not received by workers. Auto-reply from Exchage Server is "You don't
have sufficient permissions for sending e-mail to this e-mail address".
I cannot solve this problem. Please, help.
Additional symptoms: a) Message with report is succesifully delivered when I
put in "TO:" field direct e-mail addresses of one or several workers. Problem
occurs only with distribution goup. b) In Exchange server there are no
restrictions for sending mails to this group. Everyone can send e-mail
messages to "All Workes" group (I checked this in AD). c) Report Server
service is running under domain user account. When I sending e-mail from this
account to "All workers group" by means of Outlook CLient, evetything is ok.
I cannot put all e-mail addresses into "TO:" field as we have 300 workers :-)
--
Best regards,
Alexander Baskakovi'm afraid you ask this on the wrong group ? suggest your problem in the
exchange group, maybe they know the answer there.
Kind regards, Koen
"Alexander Baskakov" wrote:
> Hi
> I have some unusual problem with e-mail delivery of reports.
> I need sheduling subscription to daily report for all workers of our
> company. All these people are members of distribution group in AD named "All
> workers".
> I've made subscription and typed in "TO:" field valid e-mail address of the
> distributoin group: allworkers@.mydomain.com.
> The e-mail message with report was succesifully send from Report Server but
> it did not received by workers. Auto-reply from Exchage Server is "You don't
> have sufficient permissions for sending e-mail to this e-mail address".
> I cannot solve this problem. Please, help.
> Additional symptoms: a) Message with report is succesifully delivered when I
> put in "TO:" field direct e-mail addresses of one or several workers. Problem
> occurs only with distribution goup. b) In Exchange server there are no
> restrictions for sending mails to this group. Everyone can send e-mail
> messages to "All Workes" group (I checked this in AD). c) Report Server
> service is running under domain user account. When I sending e-mail from this
> account to "All workers group" by means of Outlook CLient, evetything is ok.
> I cannot put all e-mail addresses into "TO:" field as we have 300 workers :-)
> --
> Best regards,
> Alexander Baskakov|||Hi,
Koen.
Thank You for answer.
But now the problem has (may be tempory) solved. I'm sending mails from RS
to the one of users and then i'm redirecting mails to distribution group.
--
Best regards,
Alexander Baskakov
"Koen" wrote:
> i'm afraid you ask this on the wrong group ? suggest your problem in the
> exchange group, maybe they know the answer there.
> Kind regards, Koen
> "Alexander Baskakov" wrote:
> > Hi
> > I have some unusual problem with e-mail delivery of reports.
> > I need sheduling subscription to daily report for all workers of our
> > company. All these people are members of distribution group in AD named "All
> > workers".
> > I've made subscription and typed in "TO:" field valid e-mail address of the
> > distributoin group: allworkers@.mydomain.com.
> > The e-mail message with report was succesifully send from Report Server but
> > it did not received by workers. Auto-reply from Exchage Server is "You don't
> > have sufficient permissions for sending e-mail to this e-mail address".
> > I cannot solve this problem. Please, help.
> > Additional symptoms: a) Message with report is succesifully delivered when I
> > put in "TO:" field direct e-mail addresses of one or several workers. Problem
> > occurs only with distribution goup. b) In Exchange server there are no
> > restrictions for sending mails to this group. Everyone can send e-mail
> > messages to "All Workes" group (I checked this in AD). c) Report Server
> > service is running under domain user account. When I sending e-mail from this
> > account to "All workers group" by means of Outlook CLient, evetything is ok.
> >
> > I cannot put all e-mail addresses into "TO:" field as we have 300 workers :-)
> >
> > --
> > Best regards,
> > Alexander Baskakov
I have some unusual problem with e-mail delivery of reports.
I need sheduling subscription to daily report for all workers of our
company. All these people are members of distribution group in AD named "All
workers".
I've made subscription and typed in "TO:" field valid e-mail address of the
distributoin group: allworkers@.mydomain.com.
The e-mail message with report was succesifully send from Report Server but
it did not received by workers. Auto-reply from Exchage Server is "You don't
have sufficient permissions for sending e-mail to this e-mail address".
I cannot solve this problem. Please, help.
Additional symptoms: a) Message with report is succesifully delivered when I
put in "TO:" field direct e-mail addresses of one or several workers. Problem
occurs only with distribution goup. b) In Exchange server there are no
restrictions for sending mails to this group. Everyone can send e-mail
messages to "All Workes" group (I checked this in AD). c) Report Server
service is running under domain user account. When I sending e-mail from this
account to "All workers group" by means of Outlook CLient, evetything is ok.
I cannot put all e-mail addresses into "TO:" field as we have 300 workers :-)
--
Best regards,
Alexander Baskakovi'm afraid you ask this on the wrong group ? suggest your problem in the
exchange group, maybe they know the answer there.
Kind regards, Koen
"Alexander Baskakov" wrote:
> Hi
> I have some unusual problem with e-mail delivery of reports.
> I need sheduling subscription to daily report for all workers of our
> company. All these people are members of distribution group in AD named "All
> workers".
> I've made subscription and typed in "TO:" field valid e-mail address of the
> distributoin group: allworkers@.mydomain.com.
> The e-mail message with report was succesifully send from Report Server but
> it did not received by workers. Auto-reply from Exchage Server is "You don't
> have sufficient permissions for sending e-mail to this e-mail address".
> I cannot solve this problem. Please, help.
> Additional symptoms: a) Message with report is succesifully delivered when I
> put in "TO:" field direct e-mail addresses of one or several workers. Problem
> occurs only with distribution goup. b) In Exchange server there are no
> restrictions for sending mails to this group. Everyone can send e-mail
> messages to "All Workes" group (I checked this in AD). c) Report Server
> service is running under domain user account. When I sending e-mail from this
> account to "All workers group" by means of Outlook CLient, evetything is ok.
> I cannot put all e-mail addresses into "TO:" field as we have 300 workers :-)
> --
> Best regards,
> Alexander Baskakov|||Hi,
Koen.
Thank You for answer.
But now the problem has (may be tempory) solved. I'm sending mails from RS
to the one of users and then i'm redirecting mails to distribution group.
--
Best regards,
Alexander Baskakov
"Koen" wrote:
> i'm afraid you ask this on the wrong group ? suggest your problem in the
> exchange group, maybe they know the answer there.
> Kind regards, Koen
> "Alexander Baskakov" wrote:
> > Hi
> > I have some unusual problem with e-mail delivery of reports.
> > I need sheduling subscription to daily report for all workers of our
> > company. All these people are members of distribution group in AD named "All
> > workers".
> > I've made subscription and typed in "TO:" field valid e-mail address of the
> > distributoin group: allworkers@.mydomain.com.
> > The e-mail message with report was succesifully send from Report Server but
> > it did not received by workers. Auto-reply from Exchage Server is "You don't
> > have sufficient permissions for sending e-mail to this e-mail address".
> > I cannot solve this problem. Please, help.
> > Additional symptoms: a) Message with report is succesifully delivered when I
> > put in "TO:" field direct e-mail addresses of one or several workers. Problem
> > occurs only with distribution goup. b) In Exchange server there are no
> > restrictions for sending mails to this group. Everyone can send e-mail
> > messages to "All Workes" group (I checked this in AD). c) Report Server
> > service is running under domain user account. When I sending e-mail from this
> > account to "All workers group" by means of Outlook CLient, evetything is ok.
> >
> > I cannot put all e-mail addresses into "TO:" field as we have 300 workers :-)
> >
> > --
> > Best regards,
> > Alexander Baskakov
e-mail Delivery report by trigger or user solicitation.
It's possivel delivery a report after trigger execution ou user solicitation?
Thanks in advance, Rui Figueiredo
Yes, you can externally trigger the execution and email delivery of a report (= report subscription) using the FireEvent SOAP API. Here's a link that explains the required steps:http://blogs.msdn.com/lukaszp/archive/2005/10/07/478391.aspx
Also check out the RS script utility that will make it easier fire the event:
http://msdn2.microsoft.com/en-us/library/ms162839.aspx
Email delivery not functioning
I am trying to set up automatic email delivery on our production reporting
server which runs on version 1.0 with no service pack. I modified the
RSReportServer.config to make sure the SMTP server specification is correct.
The SQL server job created says it runs successfully. But no email ever
sent out. What could be wrong? And where can I find the log file that
recording this activity? Is it a SQL log?
Same set up has worked on my development machine, which has sp1 installed.
But I want to avoid installing sp1 on production unless I am sure that's the
cause.
-- XuefengLook for the log file name ReportServerService<date>.log file. It should be
located under \Program file\Microsoft Sql Server\ReportingService\Logfiles
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Xuefeng Cao" <xcao@.massmed.org> wrote in message
news:OCgnvE8pEHA.3524@.TK2MSFTNGP15.phx.gbl...
> I am trying to set up automatic email delivery on our production reporting
> server which runs on version 1.0 with no service pack. I modified the
> RSReportServer.config to make sure the SMTP server specification is
correct.
> The SQL server job created says it runs successfully. But no email ever
> sent out. What could be wrong? And where can I find the log file that
> recording this activity? Is it a SQL log?
> Same set up has worked on my development machine, which has sp1 installed.
> But I want to avoid installing sp1 on production unless I am sure that's
the
> cause.
> -- Xuefeng
>
server which runs on version 1.0 with no service pack. I modified the
RSReportServer.config to make sure the SMTP server specification is correct.
The SQL server job created says it runs successfully. But no email ever
sent out. What could be wrong? And where can I find the log file that
recording this activity? Is it a SQL log?
Same set up has worked on my development machine, which has sp1 installed.
But I want to avoid installing sp1 on production unless I am sure that's the
cause.
-- XuefengLook for the log file name ReportServerService<date>.log file. It should be
located under \Program file\Microsoft Sql Server\ReportingService\Logfiles
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Xuefeng Cao" <xcao@.massmed.org> wrote in message
news:OCgnvE8pEHA.3524@.TK2MSFTNGP15.phx.gbl...
> I am trying to set up automatic email delivery on our production reporting
> server which runs on version 1.0 with no service pack. I modified the
> RSReportServer.config to make sure the SMTP server specification is
correct.
> The SQL server job created says it runs successfully. But no email ever
> sent out. What could be wrong? And where can I find the log file that
> recording this activity? Is it a SQL log?
> Same set up has worked on my development machine, which has sp1 installed.
> But I want to avoid installing sp1 on production unless I am sure that's
the
> cause.
> -- Xuefeng
>
Email delivery not functional
Hello all,
I have programmed some subscriptions, containing sending EMails to different
recipients. My Problem: The delivery of the mails is functional to
Email-adresses like ...@.web.de or sth., but NOT to emails like
...@.t-online.de .
It would be nice, if anyone could help me, it´s very important. Thank you in
advanceYou may need to check the SendEmailToUserAlias and DefaultHostName elements
in the
RSReportServer.config file.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsadmin/htm/arp_configserver_v1_4bzl.asp
Adrian M.
"susanne" <susanne@.discussions.microsoft.com> wrote in message
news:49CAE9E5-DDBF-4038-AEC0-261A7D4DD6C1@.microsoft.com...
> Hello all,
> I have programmed some subscriptions, containing sending EMails to
> different
> recipients. My Problem: The delivery of the mails is functional to
> Email-adresses like ...@.web.de or sth., but NOT to emails like
> ...@.t-online.de .
> It would be nice, if anyone could help me, it´s very important. Thank you
> in
> advance
I have programmed some subscriptions, containing sending EMails to different
recipients. My Problem: The delivery of the mails is functional to
Email-adresses like ...@.web.de or sth., but NOT to emails like
...@.t-online.de .
It would be nice, if anyone could help me, it´s very important. Thank you in
advanceYou may need to check the SendEmailToUserAlias and DefaultHostName elements
in the
RSReportServer.config file.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsadmin/htm/arp_configserver_v1_4bzl.asp
Adrian M.
"susanne" <susanne@.discussions.microsoft.com> wrote in message
news:49CAE9E5-DDBF-4038-AEC0-261A7D4DD6C1@.microsoft.com...
> Hello all,
> I have programmed some subscriptions, containing sending EMails to
> different
> recipients. My Problem: The delivery of the mails is functional to
> Email-adresses like ...@.web.de or sth., but NOT to emails like
> ...@.t-online.de .
> It would be nice, if anyone could help me, it´s very important. Thank you
> in
> advance
email delivery in ssrs developer edition
is subscription using E-mail delivery possible in SSRS developer edition? act in the option for "Delivered By" in "New Subscription", only "Windows file share" is coming....
Hi.
Developer Edition gives you the same feature set as Enterprise, just with a license that does not allow use in a production environment.
If the email delivery option is not showing within SSRS, then it normally indicates the email settings have not been configured i.e. you must setup an SMTP server.
To check/configure this you use the Reporting Services Configuration Manager; check the Email Settings config (second from the bottom on the left) - once those have been completed correctly and the Email Settings shows a green tick, you should find email delivery is available for subscriptions.
Hope this helps,
Gary.
|||I am using SSRS developer edition and can only send email within my work domain - nothing external.Also, if you CC or Bcc an external address the process fails.
I assume this is a restriction on the developer edition.
EMail Delivery in Reporting Services 2000
Does Reporting Services 2000 have a email Delivery system for report subscriptions ? if so is there any documentation to back this up.
All i am finding is 2005 information
Any help would be great , Thanks in advance
NEver mind i think i found it in the books online.
Thanks anyway
EMail Delivery Format Problems
I have installed RS with SP1. I can send e-mails with reports attached to
it, but when I open the attachment I only see garbage, no matter what kind
of format I select (excel, pdf, etc.).
Any ideas?. Should I change something into the configuration files?
Thanks,
DanielYou might be running into the encoding issue. You can either install this
hotfix:
http://support.microsoft.com/default.aspx?scid=kb;[LN];872774 (Ignore the
fact that it is about Lotus, the real issue is an encoding issue)
Or you can install SP2:
http://www.microsoft.com/downloads/details.aspx?FamilyId=502C0D89-1308-4662-8F58-CEC55EF1235B&displaylang=en
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Daniel M" <dmongeb@.hotmail.com> wrote in message
news:u$JutcWYFHA.3164@.TK2MSFTNGP09.phx.gbl...
>I have installed RS with SP1. I can send e-mails with reports attached to
>it, but when I open the attachment I only see garbage, no matter what kind
>of format I select (excel, pdf, etc.).
> Any ideas?. Should I change something into the configuration files?
> Thanks,
> Daniel
>
it, but when I open the attachment I only see garbage, no matter what kind
of format I select (excel, pdf, etc.).
Any ideas?. Should I change something into the configuration files?
Thanks,
DanielYou might be running into the encoding issue. You can either install this
hotfix:
http://support.microsoft.com/default.aspx?scid=kb;[LN];872774 (Ignore the
fact that it is about Lotus, the real issue is an encoding issue)
Or you can install SP2:
http://www.microsoft.com/downloads/details.aspx?FamilyId=502C0D89-1308-4662-8F58-CEC55EF1235B&displaylang=en
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Daniel M" <dmongeb@.hotmail.com> wrote in message
news:u$JutcWYFHA.3164@.TK2MSFTNGP09.phx.gbl...
>I have installed RS with SP1. I can send e-mails with reports attached to
>it, but when I open the attachment I only see garbage, no matter what kind
>of format I select (excel, pdf, etc.).
> Any ideas?. Should I change something into the configuration files?
> Thanks,
> Daniel
>
Email delivery failure
Has anyone had issues with emails being delivered? The job runs successfully,
but the email does not get delivered. It seems to be related to the Reporting
Services server and not the email server. The reason I believe this is that,
after I reboot the Reporting Services server, the emails are successful. I
haven't been able to determine what causes the blockage on that server.Correction: Has anyone had issues with emails "not" being delievered?
"Rand" wrote:
> Has anyone had issues with emails being delivered? The job runs successfully,
> but the email does not get delivered. It seems to be related to the Reporting
> Services server and not the email server. The reason I believe this is that,
> after I reboot the Reporting Services server, the emails are successful. I
> haven't been able to determine what causes the blockage on that server.|||I am having the same exact issue. Any luck? Can you provide input on how you
resolved your issue, if you did?
"Rand" wrote:
> Correction: Has anyone had issues with emails "not" being delievered?
> "Rand" wrote:
> > Has anyone had issues with emails being delivered? The job runs successfully,
> > but the email does not get delivered. It seems to be related to the Reporting
> > Services server and not the email server. The reason I believe this is that,
> > after I reboot the Reporting Services server, the emails are successful. I
> > haven't been able to determine what causes the blockage on that server.
but the email does not get delivered. It seems to be related to the Reporting
Services server and not the email server. The reason I believe this is that,
after I reboot the Reporting Services server, the emails are successful. I
haven't been able to determine what causes the blockage on that server.Correction: Has anyone had issues with emails "not" being delievered?
"Rand" wrote:
> Has anyone had issues with emails being delivered? The job runs successfully,
> but the email does not get delivered. It seems to be related to the Reporting
> Services server and not the email server. The reason I believe this is that,
> after I reboot the Reporting Services server, the emails are successful. I
> haven't been able to determine what causes the blockage on that server.|||I am having the same exact issue. Any luck? Can you provide input on how you
resolved your issue, if you did?
"Rand" wrote:
> Correction: Has anyone had issues with emails "not" being delievered?
> "Rand" wrote:
> > Has anyone had issues with emails being delivered? The job runs successfully,
> > but the email does not get delivered. It seems to be related to the Reporting
> > Services server and not the email server. The reason I believe this is that,
> > after I reboot the Reporting Services server, the emails are successful. I
> > haven't been able to determine what causes the blockage on that server.
E-mail delivery configuration
I have looked high and low - everywhere - but can't seem
to find the answer.
Books on-line talks about the SMTPAuthenticate field in
the RSReportServer.config file and indicates that the
fields sendusername and senduserpassword need to be set
if authentication to the smtp server is required (in my
case it is).
Everytime I set the config file with the options that
seem to be correct from Books on-line, the email delivery
either fails or the e-mail delivery option on the
subscription is not available - usually meaning problems
with reportServer reading the config file.
Has anyone set up SMTP authentication with report server.
Below are pertinent data related to this problem.
notes from Books on-line --
SMTPAuthenticate Specifies an integer value that
indicates the kind of authentication to use when sending
messages to an SMTP service over a TCP/IP connection.
0=no authentication.
1=basic authentication. Credentials are passed in clear
text using either sendusername and senduserpassword, or
postusername and postuserpassword fields.
2= NTML (NT LanMan) authentication. The security context
of the current process is used to authenticate the
service.
It appears the sendusername and senduserpassword are from
CDO objects but when you look in the CDO Docs on MSDN it
identifies sendusername and sendpassword fields.
I have tried to set the following in the config file...
<SendUserName>wc.smith@.sbcglobal.net</SendUserName>
<SendPassword>7776787</SendPassword> (bogus password here)
and although ReportServer does not seem to error on the
config file the e-mail option on the subscription is not
available. It only has the fileshare option.
I am logged into Report Manager as admin.
Here is the snippet from the config file...
<Extensions>
<Delivery>
<Extension Name="Report Server
FileShare"
Type="Microsoft.ReportingServices.FileShareDeliveryProvide
r.FileShareProvider,ReportingServicesFileShareDeliveryProv
ider">
<MaxRetries>3</MaxRetries>
<SecondsBeforeRetry>900</SecondsBeforeRetry>
<Configuration>
<FileShareConfiguration>
<ExcludedRenderFormats>
<RenderingExtension>HTMLOWC</RenderingExtension>
<RenderingExtension>NULL</RenderingExtension>
</ExcludedRenderFormats>
</FileShareConfiguration>
</Configuration>
</Extension>
<Extension Name="Report Server
Email"
Type="Microsoft.ReportingServices.EmailDeliveryProvider.Em
ailProvider,ReportingServicesEmailDeliveryProvider">
<MaxRetries>3</MaxRetries>
<SecondsBeforeRetry>900</SecondsBeforeRetry>
<Configuration>
<RSEmailDPConfiguration>
<SMTPServer>smtp.sbcglobal.yahoo.com</SMTPServer>
<SMTPServerPort>25</SMTPServerPort>
<SMTPAccountName>WarrenSmith-sbc</SMTPAccountName>
<SMTPConnectionTimeout></SMTPConnectionTimeout>
<SMTPServerPickupDirectory></SMTPServerPickupDirec
tory>
<SMTPUseSSL></SMTPUseSSL>
<SendUsing>2</SendUsing>
<SMTPAuthenticate>1</SMTPAuthenticate>
<From>wc.smith@.sbcglobal.net</From>
<EmbeddedRenderFormats>
<RenderingExtension>MHTML</RenderingExtension>
</EmbeddedRenderFormats>
<PrivilegedUserRenderFormats></PrivilegedUserRende
rFormats>
<ExcludedRenderFormats>
<RenderingExtension>HTMLOWC</RenderingExtension>
<RenderingExtension>NULL</RenderingExtension>
</ExcludedRenderFormats>
<SendEmailToUserAlias>True</SendEmailToUserAlias>
<DefaultHostName></DefaultHostName>
<PermittedHosts></PermittedHosts>
</RSEmailDPConfiguration>
</Configuration>
</Extension>
<Extension Name="NULL"
Type="Microsoft.ReportingServices.NullDeliveryProvider.Nul
lProvider,ReportingServicesNullDeliveryProvider"/>
Does anyone know where you set the SendUserName and
SendPassword fields?
Thanks,
WarrenAs an update to the problem. If I put a 1 in the
SMTPAuthenticate field the config file errors off. I can
leave it blank and then my smtp server complains that I
am not authenticating. I can put a 2 in the field and
then report services does not deliver the email because I
am not using winnt authentication.
I have also tried to put in the SendUserName and
SendPassword (spelled this way and all lowercase, as in
the DOCS) as attributes...
<SMTPAuthenticate SendUserName="wc.smith@.sbcglobal.net"
SendPassword="3333333"></SMTPAuthenticate>
That does not error the config file unless, again you put
a 1 for the value of the element. Again a blank for the
SMTPAuthenticate element causes report services to fail
with a non-authentication (503) from the smtp server...
Here is the error I get for the subscription...
Failure sending mail: The server rejected the sender
address. The server response was: 530 authentication
required - for help go to
http://help.yahoo.com/help/us/sbc/dsl/mail/pop/pop-
11.html
Here is the delivery extensions area of the
RSReportServer.config file...
<Extension Name="Report Server
Email"
Type="Microsoft.ReportingServices.EmailDeliveryProvider.Em
ailProvider,ReportingServicesEmailDeliveryProvider">
<MaxRetries>3</MaxRetries>
<SecondsBeforeRetry>900</SecondsBeforeRetry>
<Configuration>
<RSEmailDPConfiguration>
<SMTPServer>smtp.sbcglobal.yahoo.com</SMTPServer>
<SMTPServerPort>25</SMTPServerPort>
<SMTPAccountName>WarrenSmith</SMTPAccountName>
<SMTPConnectionTimeout></SMTPConnectionTimeout>
<SMTPServerPickupDirectory></SMTPServerPickupDirec
tory>
<SMTPUseSSL></SMTPUseSSL>
<SendUsing>2</SendUsing>
<SMTPAuthenticate></SMTPAuthenticate>
<From>wc.smith@.sbcglobal.net</From>
<EmbeddedRenderFormats>
<RenderingExtension>MHTML</RenderingExtension>
</EmbeddedRenderFormats>
<PrivilegedUserRenderFormats></PrivilegedUserRende
rFormats>
<ExcludedRenderFormats>
<RenderingExtension>HTMLOWC</RenderingExtension>
<RenderingExtension>NULL</RenderingExtension>
</ExcludedRenderFormats>
<SendEmailToUserAlias>True</SendEmailToUserAlias>
<DefaultHostName>sbcglobal.net</DefaultHostName>
<PermittedHosts></PermittedHosts>
</RSEmailDPConfiguration>
</Configuration>
</Extension>
>--Original Message--
>I have looked high and low - everywhere - but can't seem
>to find the answer.
>Books on-line talks about the SMTPAuthenticate field in
>the RSReportServer.config file and indicates that the
>fields sendusername and senduserpassword need to be set
>if authentication to the smtp server is required (in my
>case it is).
>Everytime I set the config file with the options that
>seem to be correct from Books on-line, the email
delivery
>either fails or the e-mail delivery option on the
>subscription is not available - usually meaning problems
>with reportServer reading the config file.
>Has anyone set up SMTP authentication with report server.
>Below are pertinent data related to this problem.
>notes from Books on-line --
>SMTPAuthenticate Specifies an integer value that
>indicates the kind of authentication to use when sending
>messages to an SMTP service over a TCP/IP connection.
>0=no authentication.
>1=basic authentication. Credentials are passed in clear
>text using either sendusername and senduserpassword, or
>postusername and postuserpassword fields.
>2= NTML (NT LanMan) authentication. The security context
>of the current process is used to authenticate the
>service.
>It appears the sendusername and senduserpassword are
from
>CDO objects but when you look in the CDO Docs on MSDN it
>identifies sendusername and sendpassword fields.
>I have tried to set the following in the config file...
><SendUserName>wc.smith@.sbcglobal.net</SendUserName>
><SendPassword>7776787</SendPassword> (bogus password
here)
>and although ReportServer does not seem to error on the
>config file the e-mail option on the subscription is not
>available. It only has the fileshare option.
>I am logged into Report Manager as admin.
>Here is the snippet from the config file...
> <Extensions>
> <Delivery>
> <Extension Name="Report Server
>FileShare"
>Type="Microsoft.ReportingServices.FileShareDeliveryProvid
e
>r.FileShareProvider,ReportingServicesFileShareDeliveryPro
v
>ider">
> <MaxRetries>3</MaxRetries>
> <SecondsBeforeRetry>900</SecondsBeforeRetry>
> <Configuration>
> <FileShareConfiguration>
> <ExcludedRenderFormats>
> <RenderingExtension>HTMLOWC</RenderingExtension>
> <RenderingExtension>NULL</RenderingExtension>
> </ExcludedRenderFormats>
> </FileShareConfiguration>
> </Configuration>
> </Extension>
> <Extension Name="Report Server
>Email"
>Type="Microsoft.ReportingServices.EmailDeliveryProvider.E
m
>ailProvider,ReportingServicesEmailDeliveryProvider">
> <MaxRetries>3</MaxRetries>
> <SecondsBeforeRetry>900</SecondsBeforeRetry>
> <Configuration>
> <RSEmailDPConfiguration>
> <SMTPServer>smtp.sbcglobal.yahoo.com</SMTPServer>
> <SMTPServerPort>25</SMTPServerPort>
> <SMTPAccountName>WarrenSmith-sbc</SMTPAccountName>
> <SMTPConnectionTimeout></SMTPConnectionTimeout>
> <SMTPServerPickupDirectory></SMTPServerPickupDirec
>tory>
> <SMTPUseSSL></SMTPUseSSL>
> <SendUsing>2</SendUsing>
> <SMTPAuthenticate>1</SMTPAuthenticate>
> <From>wc.smith@.sbcglobal.net</From>
> <EmbeddedRenderFormats>
> <RenderingExtension>MHTML</RenderingExtension>
> </EmbeddedRenderFormats>
> <PrivilegedUserRenderFormats></PrivilegedUserRende
>rFormats>
> <ExcludedRenderFormats>
> <RenderingExtension>HTMLOWC</RenderingExtension>
> <RenderingExtension>NULL</RenderingExtension>
> </ExcludedRenderFormats>
> <SendEmailToUserAlias>True</SendEmailToUserAlias>
> <DefaultHostName></DefaultHostName>
> <PermittedHosts></PermittedHosts>
> </RSEmailDPConfiguration>
> </Configuration>
> </Extension>
> <Extension Name="NULL"
>Type="Microsoft.ReportingServices.NullDeliveryProvider.Nu
l
>lProvider,ReportingServicesNullDeliveryProvider"/>
>
>Does anyone know where you set the SendUserName and
>SendPassword fields?
>Thanks,
>Warren
>
>.
>|||Unfortunately, SendUserName and SendPassword are not supported in the e-mail
delivery extension. The only value that works other than 0 is 2 (which uses
the service account credentials).
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
<anonymous@.discussions.microsoft.com> wrote in message
news:2fb0d01c46d34$380d4fe0$a301280a@.phx.gbl...
> As an update to the problem. If I put a 1 in the
> SMTPAuthenticate field the config file errors off. I can
> leave it blank and then my smtp server complains that I
> am not authenticating. I can put a 2 in the field and
> then report services does not deliver the email because I
> am not using winnt authentication.
> I have also tried to put in the SendUserName and
> SendPassword (spelled this way and all lowercase, as in
> the DOCS) as attributes...
> <SMTPAuthenticate SendUserName="wc.smith@.sbcglobal.net"
> SendPassword="3333333"></SMTPAuthenticate>
> That does not error the config file unless, again you put
> a 1 for the value of the element. Again a blank for the
> SMTPAuthenticate element causes report services to fail
> with a non-authentication (503) from the smtp server...
> Here is the error I get for the subscription...
> Failure sending mail: The server rejected the sender
> address. The server response was: 530 authentication
> required - for help go to
> http://help.yahoo.com/help/us/sbc/dsl/mail/pop/pop-
> 11.html
>
> Here is the delivery extensions area of the
> RSReportServer.config file...
> <Extension Name="Report Server
> Email"
> Type="Microsoft.ReportingServices.EmailDeliveryProvider.Em
> ailProvider,ReportingServicesEmailDeliveryProvider">
> <MaxRetries>3</MaxRetries>
> <SecondsBeforeRetry>900</SecondsBeforeRetry>
> <Configuration>
> <RSEmailDPConfiguration>
> <SMTPServer>smtp.sbcglobal.yahoo.com</SMTPServer>
> <SMTPServerPort>25</SMTPServerPort>
> <SMTPAccountName>WarrenSmith</SMTPAccountName>
> <SMTPConnectionTimeout></SMTPConnectionTimeout>
> <SMTPServerPickupDirectory></SMTPServerPickupDirec
> tory>
> <SMTPUseSSL></SMTPUseSSL>
> <SendUsing>2</SendUsing>
> <SMTPAuthenticate></SMTPAuthenticate>
> <From>wc.smith@.sbcglobal.net</From>
> <EmbeddedRenderFormats>
> <RenderingExtension>MHTML</RenderingExtension>
> </EmbeddedRenderFormats>
> <PrivilegedUserRenderFormats></PrivilegedUserRende
> rFormats>
> <ExcludedRenderFormats>
> <RenderingExtension>HTMLOWC</RenderingExtension>
> <RenderingExtension>NULL</RenderingExtension>
> </ExcludedRenderFormats>
> <SendEmailToUserAlias>True</SendEmailToUserAlias>
> <DefaultHostName>sbcglobal.net</DefaultHostName>
> <PermittedHosts></PermittedHosts>
> </RSEmailDPConfiguration>
> </Configuration>
> </Extension>
>
>>--Original Message--
>>I have looked high and low - everywhere - but can't seem
>>to find the answer.
>>Books on-line talks about the SMTPAuthenticate field in
>>the RSReportServer.config file and indicates that the
>>fields sendusername and senduserpassword need to be set
>>if authentication to the smtp server is required (in my
>>case it is).
>>Everytime I set the config file with the options that
>>seem to be correct from Books on-line, the email
> delivery
>>either fails or the e-mail delivery option on the
>>subscription is not available - usually meaning problems
>>with reportServer reading the config file.
>>Has anyone set up SMTP authentication with report server.
>>Below are pertinent data related to this problem.
>>notes from Books on-line --
>>SMTPAuthenticate Specifies an integer value that
>>indicates the kind of authentication to use when sending
>>messages to an SMTP service over a TCP/IP connection.
>>0=no authentication.
>>1=basic authentication. Credentials are passed in clear
>>text using either sendusername and senduserpassword, or
>>postusername and postuserpassword fields.
>>2= NTML (NT LanMan) authentication. The security context
>>of the current process is used to authenticate the
>>service.
>>It appears the sendusername and senduserpassword are
> from
>>CDO objects but when you look in the CDO Docs on MSDN it
>>identifies sendusername and sendpassword fields.
>>I have tried to set the following in the config file...
>><SendUserName>wc.smith@.sbcglobal.net</SendUserName>
>><SendPassword>7776787</SendPassword> (bogus password
> here)
>>and although ReportServer does not seem to error on the
>>config file the e-mail option on the subscription is not
>>available. It only has the fileshare option.
>>I am logged into Report Manager as admin.
>>Here is the snippet from the config file...
>> <Extensions>
>> <Delivery>
>> <Extension Name="Report Server
>>FileShare"
>>Type="Microsoft.ReportingServices.FileShareDeliveryProvid
> e
>>r.FileShareProvider,ReportingServicesFileShareDeliveryPro
> v
>>ider">
>> <MaxRetries>3</MaxRetries>
>> <SecondsBeforeRetry>900</SecondsBeforeRetry>
>> <Configuration>
>> <FileShareConfiguration>
>> <ExcludedRenderFormats>
>> <RenderingExtension>HTMLOWC</RenderingExtension>
>> <RenderingExtension>NULL</RenderingExtension>
>> </ExcludedRenderFormats>
>> </FileShareConfiguration>
>> </Configuration>
>> </Extension>
>> <Extension Name="Report Server
>>Email"
>>Type="Microsoft.ReportingServices.EmailDeliveryProvider.E
> m
>>ailProvider,ReportingServicesEmailDeliveryProvider">
>> <MaxRetries>3</MaxRetries>
>> <SecondsBeforeRetry>900</SecondsBeforeRetry>
>> <Configuration>
>> <RSEmailDPConfiguration>
>> <SMTPServer>smtp.sbcglobal.yahoo.com</SMTPServer>
>> <SMTPServerPort>25</SMTPServerPort>
>> <SMTPAccountName>WarrenSmith-sbc</SMTPAccountName>
>> <SMTPConnectionTimeout></SMTPConnectionTimeout>
>> <SMTPServerPickupDirectory></SMTPServerPickupDirec
>>tory>
>> <SMTPUseSSL></SMTPUseSSL>
>> <SendUsing>2</SendUsing>
>> <SMTPAuthenticate>1</SMTPAuthenticate>
>> <From>wc.smith@.sbcglobal.net</From>
>> <EmbeddedRenderFormats>
>> <RenderingExtension>MHTML</RenderingExtension>
>> </EmbeddedRenderFormats>
>> <PrivilegedUserRenderFormats></PrivilegedUserRende
>>rFormats>
>> <ExcludedRenderFormats>
>> <RenderingExtension>HTMLOWC</RenderingExtension>
>> <RenderingExtension>NULL</RenderingExtension>
>> </ExcludedRenderFormats>
>> <SendEmailToUserAlias>True</SendEmailToUserAlias>
>> <DefaultHostName></DefaultHostName>
>> <PermittedHosts></PermittedHosts>
>> </RSEmailDPConfiguration>
>> </Configuration>
>> </Extension>
>> <Extension Name="NULL"
>>Type="Microsoft.ReportingServices.NullDeliveryProvider.Nu
> l
>>lProvider,ReportingServicesNullDeliveryProvider"/>
>>
>>Does anyone know where you set the SendUserName and
>>SendPassword fields?
>>Thanks,
>>Warren
>>
>>.|||I have found that I had to exempt my RS machine's ip from SMTP Auth to get this to go.
"Brian Welcker [MSFT]" wrote:
> Unfortunately, SendUserName and SendPassword are not supported in the e-mail
> delivery extension. The only value that works other than 0 is 2 (which uses
> the service account credentials).
> --
> Brian Welcker
> Group Program Manager
> SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
> <anonymous@.discussions.microsoft.com> wrote in message
> news:2fb0d01c46d34$380d4fe0$a301280a@.phx.gbl...
> > As an update to the problem. If I put a 1 in the
> > SMTPAuthenticate field the config file errors off. I can
> > leave it blank and then my smtp server complains that I
> > am not authenticating. I can put a 2 in the field and
> > then report services does not deliver the email because I
> > am not using winnt authentication.
> >
> > I have also tried to put in the SendUserName and
> > SendPassword (spelled this way and all lowercase, as in
> > the DOCS) as attributes...
> > <SMTPAuthenticate SendUserName="wc.smith@.sbcglobal.net"
> > SendPassword="3333333"></SMTPAuthenticate>
> >
> > That does not error the config file unless, again you put
> > a 1 for the value of the element. Again a blank for the
> > SMTPAuthenticate element causes report services to fail
> > with a non-authentication (503) from the smtp server...
> >
> > Here is the error I get for the subscription...
> >
> > Failure sending mail: The server rejected the sender
> > address. The server response was: 530 authentication
> > required - for help go to
> > http://help.yahoo.com/help/us/sbc/dsl/mail/pop/pop-
> > 11.html
> >
> >
> > Here is the delivery extensions area of the
> > RSReportServer.config file...
> >
> > <Extension Name="Report Server
> > Email"
> > Type="Microsoft.ReportingServices.EmailDeliveryProvider.Em
> > ailProvider,ReportingServicesEmailDeliveryProvider">
> > <MaxRetries>3</MaxRetries>
> >
> > <SecondsBeforeRetry>900</SecondsBeforeRetry>
> > <Configuration>
> >
> > <RSEmailDPConfiguration>
> >
> > <SMTPServer>smtp.sbcglobal.yahoo.com</SMTPServer>
> >
> > <SMTPServerPort>25</SMTPServerPort>
> >
> > <SMTPAccountName>WarrenSmith</SMTPAccountName>
> >
> > <SMTPConnectionTimeout></SMTPConnectionTimeout>
> >
> > <SMTPServerPickupDirectory></SMTPServerPickupDirec
> > tory>
> >
> > <SMTPUseSSL></SMTPUseSSL>
> >
> > <SendUsing>2</SendUsing>
> >
> > <SMTPAuthenticate></SMTPAuthenticate>
> >
> > <From>wc.smith@.sbcglobal.net</From>
> >
> > <EmbeddedRenderFormats>
> >
> > <RenderingExtension>MHTML</RenderingExtension>
> >
> > </EmbeddedRenderFormats>
> >
> > <PrivilegedUserRenderFormats></PrivilegedUserRende
> > rFormats>
> >
> > <ExcludedRenderFormats>
> >
> > <RenderingExtension>HTMLOWC</RenderingExtension>
> >
> > <RenderingExtension>NULL</RenderingExtension>
> >
> > </ExcludedRenderFormats>
> >
> > <SendEmailToUserAlias>True</SendEmailToUserAlias>
> >
> > <DefaultHostName>sbcglobal.net</DefaultHostName>
> >
> > <PermittedHosts></PermittedHosts>
> >
> > </RSEmailDPConfiguration>
> > </Configuration>
> > </Extension>
> >
> >
> >
> >>--Original Message--
> >>I have looked high and low - everywhere - but can't seem
> >>to find the answer.
> >>
> >>Books on-line talks about the SMTPAuthenticate field in
> >>the RSReportServer.config file and indicates that the
> >>fields sendusername and senduserpassword need to be set
> >>if authentication to the smtp server is required (in my
> >>case it is).
> >>
> >>Everytime I set the config file with the options that
> >>seem to be correct from Books on-line, the email
> > delivery
> >>either fails or the e-mail delivery option on the
> >>subscription is not available - usually meaning problems
> >>with reportServer reading the config file.
> >>
> >>Has anyone set up SMTP authentication with report server.
> >>
> >>Below are pertinent data related to this problem.
> >>
> >>notes from Books on-line --
> >>SMTPAuthenticate Specifies an integer value that
> >>indicates the kind of authentication to use when sending
> >>messages to an SMTP service over a TCP/IP connection.
> >>0=no authentication.
> >>1=basic authentication. Credentials are passed in clear
> >>text using either sendusername and senduserpassword, or
> >>postusername and postuserpassword fields.
> >>
> >>2= NTML (NT LanMan) authentication. The security context
> >>of the current process is used to authenticate the
> >>service.
> >>
> >>It appears the sendusername and senduserpassword are
> > from
> >>CDO objects but when you look in the CDO Docs on MSDN it
> >>identifies sendusername and sendpassword fields.
> >>
> >>I have tried to set the following in the config file...
> >><SendUserName>wc.smith@.sbcglobal.net</SendUserName>
> >><SendPassword>7776787</SendPassword> (bogus password
> > here)
> >>and although ReportServer does not seem to error on the
> >>config file the e-mail option on the subscription is not
> >>available. It only has the fileshare option.
> >>
> >>I am logged into Report Manager as admin.
> >>
> >>Here is the snippet from the config file...
> >>
> >> <Extensions>
> >> <Delivery>
> >> <Extension Name="Report Server
> >>FileShare"
> >>Type="Microsoft.ReportingServices.FileShareDeliveryProvid
> > e
> >>r.FileShareProvider,ReportingServicesFileShareDeliveryPro
> > v
> >>ider">
> >> <MaxRetries>3</MaxRetries>
> >>
> >> <SecondsBeforeRetry>900</SecondsBeforeRetry>
> >> <Configuration>
> >>
> >> <FileShareConfiguration>
> >>
> >> <ExcludedRenderFormats>
> >>
> >> <RenderingExtension>HTMLOWC</RenderingExtension>
> >>
> >> <RenderingExtension>NULL</RenderingExtension>
> >>
> >> </ExcludedRenderFormats>
> >>
> >> </FileShareConfiguration>
> >> </Configuration>
> >> </Extension>
> >> <Extension Name="Report Server
> >>Email"
> >>Type="Microsoft.ReportingServices.EmailDeliveryProvider.E
> > m
> >>ailProvider,ReportingServicesEmailDeliveryProvider">
> >> <MaxRetries>3</MaxRetries>
> >>
> >> <SecondsBeforeRetry>900</SecondsBeforeRetry>
> >> <Configuration>
> >>
> >> <RSEmailDPConfiguration>
> >>
> >> <SMTPServer>smtp.sbcglobal.yahoo.com</SMTPServer>
> >>
> >> <SMTPServerPort>25</SMTPServerPort>
> >>
> >> <SMTPAccountName>WarrenSmith-sbc</SMTPAccountName>
> >>
> >> <SMTPConnectionTimeout></SMTPConnectionTimeout>
> >>
> >> <SMTPServerPickupDirectory></SMTPServerPickupDirec
> >>tory>
> >>
> >> <SMTPUseSSL></SMTPUseSSL>
> >>
> >> <SendUsing>2</SendUsing>
> >>
> >> <SMTPAuthenticate>1</SMTPAuthenticate>
> >>
> >> <From>wc.smith@.sbcglobal.net</From>
> >>
> >> <EmbeddedRenderFormats>
> >>
> >> <RenderingExtension>MHTML</RenderingExtension>
> >>
> >> </EmbeddedRenderFormats>
> >>
> >> <PrivilegedUserRenderFormats></PrivilegedUserRende
> >>rFormats>
> >>
> >> <ExcludedRenderFormats>
> >>
> >> <RenderingExtension>HTMLOWC</RenderingExtension>
> >>
> >> <RenderingExtension>NULL</RenderingExtension>
> >>
> >> </ExcludedRenderFormats>
> >>
> >> <SendEmailToUserAlias>True</SendEmailToUserAlias>
> >>
> >> <DefaultHostName></DefaultHostName>
> >>
> >> <PermittedHosts></PermittedHosts>
> >>
> >> </RSEmailDPConfiguration>
> >> </Configuration>
> >> </Extension>
> >> <Extension Name="NULL"
> >>Type="Microsoft.ReportingServices.NullDeliveryProvider.Nu
> > l
> >>lProvider,ReportingServicesNullDeliveryProvider"/>
> >>
> >>
> >>Does anyone know where you set the SendUserName and
> >>SendPassword fields?
> >>
> >>Thanks,
> >>
> >>Warren
> >>
> >>
> >>.
> >>
>
>
to find the answer.
Books on-line talks about the SMTPAuthenticate field in
the RSReportServer.config file and indicates that the
fields sendusername and senduserpassword need to be set
if authentication to the smtp server is required (in my
case it is).
Everytime I set the config file with the options that
seem to be correct from Books on-line, the email delivery
either fails or the e-mail delivery option on the
subscription is not available - usually meaning problems
with reportServer reading the config file.
Has anyone set up SMTP authentication with report server.
Below are pertinent data related to this problem.
notes from Books on-line --
SMTPAuthenticate Specifies an integer value that
indicates the kind of authentication to use when sending
messages to an SMTP service over a TCP/IP connection.
0=no authentication.
1=basic authentication. Credentials are passed in clear
text using either sendusername and senduserpassword, or
postusername and postuserpassword fields.
2= NTML (NT LanMan) authentication. The security context
of the current process is used to authenticate the
service.
It appears the sendusername and senduserpassword are from
CDO objects but when you look in the CDO Docs on MSDN it
identifies sendusername and sendpassword fields.
I have tried to set the following in the config file...
<SendUserName>wc.smith@.sbcglobal.net</SendUserName>
<SendPassword>7776787</SendPassword> (bogus password here)
and although ReportServer does not seem to error on the
config file the e-mail option on the subscription is not
available. It only has the fileshare option.
I am logged into Report Manager as admin.
Here is the snippet from the config file...
<Extensions>
<Delivery>
<Extension Name="Report Server
FileShare"
Type="Microsoft.ReportingServices.FileShareDeliveryProvide
r.FileShareProvider,ReportingServicesFileShareDeliveryProv
ider">
<MaxRetries>3</MaxRetries>
<SecondsBeforeRetry>900</SecondsBeforeRetry>
<Configuration>
<FileShareConfiguration>
<ExcludedRenderFormats>
<RenderingExtension>HTMLOWC</RenderingExtension>
<RenderingExtension>NULL</RenderingExtension>
</ExcludedRenderFormats>
</FileShareConfiguration>
</Configuration>
</Extension>
<Extension Name="Report Server
Email"
Type="Microsoft.ReportingServices.EmailDeliveryProvider.Em
ailProvider,ReportingServicesEmailDeliveryProvider">
<MaxRetries>3</MaxRetries>
<SecondsBeforeRetry>900</SecondsBeforeRetry>
<Configuration>
<RSEmailDPConfiguration>
<SMTPServer>smtp.sbcglobal.yahoo.com</SMTPServer>
<SMTPServerPort>25</SMTPServerPort>
<SMTPAccountName>WarrenSmith-sbc</SMTPAccountName>
<SMTPConnectionTimeout></SMTPConnectionTimeout>
<SMTPServerPickupDirectory></SMTPServerPickupDirec
tory>
<SMTPUseSSL></SMTPUseSSL>
<SendUsing>2</SendUsing>
<SMTPAuthenticate>1</SMTPAuthenticate>
<From>wc.smith@.sbcglobal.net</From>
<EmbeddedRenderFormats>
<RenderingExtension>MHTML</RenderingExtension>
</EmbeddedRenderFormats>
<PrivilegedUserRenderFormats></PrivilegedUserRende
rFormats>
<ExcludedRenderFormats>
<RenderingExtension>HTMLOWC</RenderingExtension>
<RenderingExtension>NULL</RenderingExtension>
</ExcludedRenderFormats>
<SendEmailToUserAlias>True</SendEmailToUserAlias>
<DefaultHostName></DefaultHostName>
<PermittedHosts></PermittedHosts>
</RSEmailDPConfiguration>
</Configuration>
</Extension>
<Extension Name="NULL"
Type="Microsoft.ReportingServices.NullDeliveryProvider.Nul
lProvider,ReportingServicesNullDeliveryProvider"/>
Does anyone know where you set the SendUserName and
SendPassword fields?
Thanks,
WarrenAs an update to the problem. If I put a 1 in the
SMTPAuthenticate field the config file errors off. I can
leave it blank and then my smtp server complains that I
am not authenticating. I can put a 2 in the field and
then report services does not deliver the email because I
am not using winnt authentication.
I have also tried to put in the SendUserName and
SendPassword (spelled this way and all lowercase, as in
the DOCS) as attributes...
<SMTPAuthenticate SendUserName="wc.smith@.sbcglobal.net"
SendPassword="3333333"></SMTPAuthenticate>
That does not error the config file unless, again you put
a 1 for the value of the element. Again a blank for the
SMTPAuthenticate element causes report services to fail
with a non-authentication (503) from the smtp server...
Here is the error I get for the subscription...
Failure sending mail: The server rejected the sender
address. The server response was: 530 authentication
required - for help go to
http://help.yahoo.com/help/us/sbc/dsl/mail/pop/pop-
11.html
Here is the delivery extensions area of the
RSReportServer.config file...
<Extension Name="Report Server
Email"
Type="Microsoft.ReportingServices.EmailDeliveryProvider.Em
ailProvider,ReportingServicesEmailDeliveryProvider">
<MaxRetries>3</MaxRetries>
<SecondsBeforeRetry>900</SecondsBeforeRetry>
<Configuration>
<RSEmailDPConfiguration>
<SMTPServer>smtp.sbcglobal.yahoo.com</SMTPServer>
<SMTPServerPort>25</SMTPServerPort>
<SMTPAccountName>WarrenSmith</SMTPAccountName>
<SMTPConnectionTimeout></SMTPConnectionTimeout>
<SMTPServerPickupDirectory></SMTPServerPickupDirec
tory>
<SMTPUseSSL></SMTPUseSSL>
<SendUsing>2</SendUsing>
<SMTPAuthenticate></SMTPAuthenticate>
<From>wc.smith@.sbcglobal.net</From>
<EmbeddedRenderFormats>
<RenderingExtension>MHTML</RenderingExtension>
</EmbeddedRenderFormats>
<PrivilegedUserRenderFormats></PrivilegedUserRende
rFormats>
<ExcludedRenderFormats>
<RenderingExtension>HTMLOWC</RenderingExtension>
<RenderingExtension>NULL</RenderingExtension>
</ExcludedRenderFormats>
<SendEmailToUserAlias>True</SendEmailToUserAlias>
<DefaultHostName>sbcglobal.net</DefaultHostName>
<PermittedHosts></PermittedHosts>
</RSEmailDPConfiguration>
</Configuration>
</Extension>
>--Original Message--
>I have looked high and low - everywhere - but can't seem
>to find the answer.
>Books on-line talks about the SMTPAuthenticate field in
>the RSReportServer.config file and indicates that the
>fields sendusername and senduserpassword need to be set
>if authentication to the smtp server is required (in my
>case it is).
>Everytime I set the config file with the options that
>seem to be correct from Books on-line, the email
delivery
>either fails or the e-mail delivery option on the
>subscription is not available - usually meaning problems
>with reportServer reading the config file.
>Has anyone set up SMTP authentication with report server.
>Below are pertinent data related to this problem.
>notes from Books on-line --
>SMTPAuthenticate Specifies an integer value that
>indicates the kind of authentication to use when sending
>messages to an SMTP service over a TCP/IP connection.
>0=no authentication.
>1=basic authentication. Credentials are passed in clear
>text using either sendusername and senduserpassword, or
>postusername and postuserpassword fields.
>2= NTML (NT LanMan) authentication. The security context
>of the current process is used to authenticate the
>service.
>It appears the sendusername and senduserpassword are
from
>CDO objects but when you look in the CDO Docs on MSDN it
>identifies sendusername and sendpassword fields.
>I have tried to set the following in the config file...
><SendUserName>wc.smith@.sbcglobal.net</SendUserName>
><SendPassword>7776787</SendPassword> (bogus password
here)
>and although ReportServer does not seem to error on the
>config file the e-mail option on the subscription is not
>available. It only has the fileshare option.
>I am logged into Report Manager as admin.
>Here is the snippet from the config file...
> <Extensions>
> <Delivery>
> <Extension Name="Report Server
>FileShare"
>Type="Microsoft.ReportingServices.FileShareDeliveryProvid
e
>r.FileShareProvider,ReportingServicesFileShareDeliveryPro
v
>ider">
> <MaxRetries>3</MaxRetries>
> <SecondsBeforeRetry>900</SecondsBeforeRetry>
> <Configuration>
> <FileShareConfiguration>
> <ExcludedRenderFormats>
> <RenderingExtension>HTMLOWC</RenderingExtension>
> <RenderingExtension>NULL</RenderingExtension>
> </ExcludedRenderFormats>
> </FileShareConfiguration>
> </Configuration>
> </Extension>
> <Extension Name="Report Server
>Email"
>Type="Microsoft.ReportingServices.EmailDeliveryProvider.E
m
>ailProvider,ReportingServicesEmailDeliveryProvider">
> <MaxRetries>3</MaxRetries>
> <SecondsBeforeRetry>900</SecondsBeforeRetry>
> <Configuration>
> <RSEmailDPConfiguration>
> <SMTPServer>smtp.sbcglobal.yahoo.com</SMTPServer>
> <SMTPServerPort>25</SMTPServerPort>
> <SMTPAccountName>WarrenSmith-sbc</SMTPAccountName>
> <SMTPConnectionTimeout></SMTPConnectionTimeout>
> <SMTPServerPickupDirectory></SMTPServerPickupDirec
>tory>
> <SMTPUseSSL></SMTPUseSSL>
> <SendUsing>2</SendUsing>
> <SMTPAuthenticate>1</SMTPAuthenticate>
> <From>wc.smith@.sbcglobal.net</From>
> <EmbeddedRenderFormats>
> <RenderingExtension>MHTML</RenderingExtension>
> </EmbeddedRenderFormats>
> <PrivilegedUserRenderFormats></PrivilegedUserRende
>rFormats>
> <ExcludedRenderFormats>
> <RenderingExtension>HTMLOWC</RenderingExtension>
> <RenderingExtension>NULL</RenderingExtension>
> </ExcludedRenderFormats>
> <SendEmailToUserAlias>True</SendEmailToUserAlias>
> <DefaultHostName></DefaultHostName>
> <PermittedHosts></PermittedHosts>
> </RSEmailDPConfiguration>
> </Configuration>
> </Extension>
> <Extension Name="NULL"
>Type="Microsoft.ReportingServices.NullDeliveryProvider.Nu
l
>lProvider,ReportingServicesNullDeliveryProvider"/>
>
>Does anyone know where you set the SendUserName and
>SendPassword fields?
>Thanks,
>Warren
>
>.
>|||Unfortunately, SendUserName and SendPassword are not supported in the e-mail
delivery extension. The only value that works other than 0 is 2 (which uses
the service account credentials).
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
<anonymous@.discussions.microsoft.com> wrote in message
news:2fb0d01c46d34$380d4fe0$a301280a@.phx.gbl...
> As an update to the problem. If I put a 1 in the
> SMTPAuthenticate field the config file errors off. I can
> leave it blank and then my smtp server complains that I
> am not authenticating. I can put a 2 in the field and
> then report services does not deliver the email because I
> am not using winnt authentication.
> I have also tried to put in the SendUserName and
> SendPassword (spelled this way and all lowercase, as in
> the DOCS) as attributes...
> <SMTPAuthenticate SendUserName="wc.smith@.sbcglobal.net"
> SendPassword="3333333"></SMTPAuthenticate>
> That does not error the config file unless, again you put
> a 1 for the value of the element. Again a blank for the
> SMTPAuthenticate element causes report services to fail
> with a non-authentication (503) from the smtp server...
> Here is the error I get for the subscription...
> Failure sending mail: The server rejected the sender
> address. The server response was: 530 authentication
> required - for help go to
> http://help.yahoo.com/help/us/sbc/dsl/mail/pop/pop-
> 11.html
>
> Here is the delivery extensions area of the
> RSReportServer.config file...
> <Extension Name="Report Server
> Email"
> Type="Microsoft.ReportingServices.EmailDeliveryProvider.Em
> ailProvider,ReportingServicesEmailDeliveryProvider">
> <MaxRetries>3</MaxRetries>
> <SecondsBeforeRetry>900</SecondsBeforeRetry>
> <Configuration>
> <RSEmailDPConfiguration>
> <SMTPServer>smtp.sbcglobal.yahoo.com</SMTPServer>
> <SMTPServerPort>25</SMTPServerPort>
> <SMTPAccountName>WarrenSmith</SMTPAccountName>
> <SMTPConnectionTimeout></SMTPConnectionTimeout>
> <SMTPServerPickupDirectory></SMTPServerPickupDirec
> tory>
> <SMTPUseSSL></SMTPUseSSL>
> <SendUsing>2</SendUsing>
> <SMTPAuthenticate></SMTPAuthenticate>
> <From>wc.smith@.sbcglobal.net</From>
> <EmbeddedRenderFormats>
> <RenderingExtension>MHTML</RenderingExtension>
> </EmbeddedRenderFormats>
> <PrivilegedUserRenderFormats></PrivilegedUserRende
> rFormats>
> <ExcludedRenderFormats>
> <RenderingExtension>HTMLOWC</RenderingExtension>
> <RenderingExtension>NULL</RenderingExtension>
> </ExcludedRenderFormats>
> <SendEmailToUserAlias>True</SendEmailToUserAlias>
> <DefaultHostName>sbcglobal.net</DefaultHostName>
> <PermittedHosts></PermittedHosts>
> </RSEmailDPConfiguration>
> </Configuration>
> </Extension>
>
>>--Original Message--
>>I have looked high and low - everywhere - but can't seem
>>to find the answer.
>>Books on-line talks about the SMTPAuthenticate field in
>>the RSReportServer.config file and indicates that the
>>fields sendusername and senduserpassword need to be set
>>if authentication to the smtp server is required (in my
>>case it is).
>>Everytime I set the config file with the options that
>>seem to be correct from Books on-line, the email
> delivery
>>either fails or the e-mail delivery option on the
>>subscription is not available - usually meaning problems
>>with reportServer reading the config file.
>>Has anyone set up SMTP authentication with report server.
>>Below are pertinent data related to this problem.
>>notes from Books on-line --
>>SMTPAuthenticate Specifies an integer value that
>>indicates the kind of authentication to use when sending
>>messages to an SMTP service over a TCP/IP connection.
>>0=no authentication.
>>1=basic authentication. Credentials are passed in clear
>>text using either sendusername and senduserpassword, or
>>postusername and postuserpassword fields.
>>2= NTML (NT LanMan) authentication. The security context
>>of the current process is used to authenticate the
>>service.
>>It appears the sendusername and senduserpassword are
> from
>>CDO objects but when you look in the CDO Docs on MSDN it
>>identifies sendusername and sendpassword fields.
>>I have tried to set the following in the config file...
>><SendUserName>wc.smith@.sbcglobal.net</SendUserName>
>><SendPassword>7776787</SendPassword> (bogus password
> here)
>>and although ReportServer does not seem to error on the
>>config file the e-mail option on the subscription is not
>>available. It only has the fileshare option.
>>I am logged into Report Manager as admin.
>>Here is the snippet from the config file...
>> <Extensions>
>> <Delivery>
>> <Extension Name="Report Server
>>FileShare"
>>Type="Microsoft.ReportingServices.FileShareDeliveryProvid
> e
>>r.FileShareProvider,ReportingServicesFileShareDeliveryPro
> v
>>ider">
>> <MaxRetries>3</MaxRetries>
>> <SecondsBeforeRetry>900</SecondsBeforeRetry>
>> <Configuration>
>> <FileShareConfiguration>
>> <ExcludedRenderFormats>
>> <RenderingExtension>HTMLOWC</RenderingExtension>
>> <RenderingExtension>NULL</RenderingExtension>
>> </ExcludedRenderFormats>
>> </FileShareConfiguration>
>> </Configuration>
>> </Extension>
>> <Extension Name="Report Server
>>Email"
>>Type="Microsoft.ReportingServices.EmailDeliveryProvider.E
> m
>>ailProvider,ReportingServicesEmailDeliveryProvider">
>> <MaxRetries>3</MaxRetries>
>> <SecondsBeforeRetry>900</SecondsBeforeRetry>
>> <Configuration>
>> <RSEmailDPConfiguration>
>> <SMTPServer>smtp.sbcglobal.yahoo.com</SMTPServer>
>> <SMTPServerPort>25</SMTPServerPort>
>> <SMTPAccountName>WarrenSmith-sbc</SMTPAccountName>
>> <SMTPConnectionTimeout></SMTPConnectionTimeout>
>> <SMTPServerPickupDirectory></SMTPServerPickupDirec
>>tory>
>> <SMTPUseSSL></SMTPUseSSL>
>> <SendUsing>2</SendUsing>
>> <SMTPAuthenticate>1</SMTPAuthenticate>
>> <From>wc.smith@.sbcglobal.net</From>
>> <EmbeddedRenderFormats>
>> <RenderingExtension>MHTML</RenderingExtension>
>> </EmbeddedRenderFormats>
>> <PrivilegedUserRenderFormats></PrivilegedUserRende
>>rFormats>
>> <ExcludedRenderFormats>
>> <RenderingExtension>HTMLOWC</RenderingExtension>
>> <RenderingExtension>NULL</RenderingExtension>
>> </ExcludedRenderFormats>
>> <SendEmailToUserAlias>True</SendEmailToUserAlias>
>> <DefaultHostName></DefaultHostName>
>> <PermittedHosts></PermittedHosts>
>> </RSEmailDPConfiguration>
>> </Configuration>
>> </Extension>
>> <Extension Name="NULL"
>>Type="Microsoft.ReportingServices.NullDeliveryProvider.Nu
> l
>>lProvider,ReportingServicesNullDeliveryProvider"/>
>>
>>Does anyone know where you set the SendUserName and
>>SendPassword fields?
>>Thanks,
>>Warren
>>
>>.|||I have found that I had to exempt my RS machine's ip from SMTP Auth to get this to go.
"Brian Welcker [MSFT]" wrote:
> Unfortunately, SendUserName and SendPassword are not supported in the e-mail
> delivery extension. The only value that works other than 0 is 2 (which uses
> the service account credentials).
> --
> Brian Welcker
> Group Program Manager
> SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
> <anonymous@.discussions.microsoft.com> wrote in message
> news:2fb0d01c46d34$380d4fe0$a301280a@.phx.gbl...
> > As an update to the problem. If I put a 1 in the
> > SMTPAuthenticate field the config file errors off. I can
> > leave it blank and then my smtp server complains that I
> > am not authenticating. I can put a 2 in the field and
> > then report services does not deliver the email because I
> > am not using winnt authentication.
> >
> > I have also tried to put in the SendUserName and
> > SendPassword (spelled this way and all lowercase, as in
> > the DOCS) as attributes...
> > <SMTPAuthenticate SendUserName="wc.smith@.sbcglobal.net"
> > SendPassword="3333333"></SMTPAuthenticate>
> >
> > That does not error the config file unless, again you put
> > a 1 for the value of the element. Again a blank for the
> > SMTPAuthenticate element causes report services to fail
> > with a non-authentication (503) from the smtp server...
> >
> > Here is the error I get for the subscription...
> >
> > Failure sending mail: The server rejected the sender
> > address. The server response was: 530 authentication
> > required - for help go to
> > http://help.yahoo.com/help/us/sbc/dsl/mail/pop/pop-
> > 11.html
> >
> >
> > Here is the delivery extensions area of the
> > RSReportServer.config file...
> >
> > <Extension Name="Report Server
> > Email"
> > Type="Microsoft.ReportingServices.EmailDeliveryProvider.Em
> > ailProvider,ReportingServicesEmailDeliveryProvider">
> > <MaxRetries>3</MaxRetries>
> >
> > <SecondsBeforeRetry>900</SecondsBeforeRetry>
> > <Configuration>
> >
> > <RSEmailDPConfiguration>
> >
> > <SMTPServer>smtp.sbcglobal.yahoo.com</SMTPServer>
> >
> > <SMTPServerPort>25</SMTPServerPort>
> >
> > <SMTPAccountName>WarrenSmith</SMTPAccountName>
> >
> > <SMTPConnectionTimeout></SMTPConnectionTimeout>
> >
> > <SMTPServerPickupDirectory></SMTPServerPickupDirec
> > tory>
> >
> > <SMTPUseSSL></SMTPUseSSL>
> >
> > <SendUsing>2</SendUsing>
> >
> > <SMTPAuthenticate></SMTPAuthenticate>
> >
> > <From>wc.smith@.sbcglobal.net</From>
> >
> > <EmbeddedRenderFormats>
> >
> > <RenderingExtension>MHTML</RenderingExtension>
> >
> > </EmbeddedRenderFormats>
> >
> > <PrivilegedUserRenderFormats></PrivilegedUserRende
> > rFormats>
> >
> > <ExcludedRenderFormats>
> >
> > <RenderingExtension>HTMLOWC</RenderingExtension>
> >
> > <RenderingExtension>NULL</RenderingExtension>
> >
> > </ExcludedRenderFormats>
> >
> > <SendEmailToUserAlias>True</SendEmailToUserAlias>
> >
> > <DefaultHostName>sbcglobal.net</DefaultHostName>
> >
> > <PermittedHosts></PermittedHosts>
> >
> > </RSEmailDPConfiguration>
> > </Configuration>
> > </Extension>
> >
> >
> >
> >>--Original Message--
> >>I have looked high and low - everywhere - but can't seem
> >>to find the answer.
> >>
> >>Books on-line talks about the SMTPAuthenticate field in
> >>the RSReportServer.config file and indicates that the
> >>fields sendusername and senduserpassword need to be set
> >>if authentication to the smtp server is required (in my
> >>case it is).
> >>
> >>Everytime I set the config file with the options that
> >>seem to be correct from Books on-line, the email
> > delivery
> >>either fails or the e-mail delivery option on the
> >>subscription is not available - usually meaning problems
> >>with reportServer reading the config file.
> >>
> >>Has anyone set up SMTP authentication with report server.
> >>
> >>Below are pertinent data related to this problem.
> >>
> >>notes from Books on-line --
> >>SMTPAuthenticate Specifies an integer value that
> >>indicates the kind of authentication to use when sending
> >>messages to an SMTP service over a TCP/IP connection.
> >>0=no authentication.
> >>1=basic authentication. Credentials are passed in clear
> >>text using either sendusername and senduserpassword, or
> >>postusername and postuserpassword fields.
> >>
> >>2= NTML (NT LanMan) authentication. The security context
> >>of the current process is used to authenticate the
> >>service.
> >>
> >>It appears the sendusername and senduserpassword are
> > from
> >>CDO objects but when you look in the CDO Docs on MSDN it
> >>identifies sendusername and sendpassword fields.
> >>
> >>I have tried to set the following in the config file...
> >><SendUserName>wc.smith@.sbcglobal.net</SendUserName>
> >><SendPassword>7776787</SendPassword> (bogus password
> > here)
> >>and although ReportServer does not seem to error on the
> >>config file the e-mail option on the subscription is not
> >>available. It only has the fileshare option.
> >>
> >>I am logged into Report Manager as admin.
> >>
> >>Here is the snippet from the config file...
> >>
> >> <Extensions>
> >> <Delivery>
> >> <Extension Name="Report Server
> >>FileShare"
> >>Type="Microsoft.ReportingServices.FileShareDeliveryProvid
> > e
> >>r.FileShareProvider,ReportingServicesFileShareDeliveryPro
> > v
> >>ider">
> >> <MaxRetries>3</MaxRetries>
> >>
> >> <SecondsBeforeRetry>900</SecondsBeforeRetry>
> >> <Configuration>
> >>
> >> <FileShareConfiguration>
> >>
> >> <ExcludedRenderFormats>
> >>
> >> <RenderingExtension>HTMLOWC</RenderingExtension>
> >>
> >> <RenderingExtension>NULL</RenderingExtension>
> >>
> >> </ExcludedRenderFormats>
> >>
> >> </FileShareConfiguration>
> >> </Configuration>
> >> </Extension>
> >> <Extension Name="Report Server
> >>Email"
> >>Type="Microsoft.ReportingServices.EmailDeliveryProvider.E
> > m
> >>ailProvider,ReportingServicesEmailDeliveryProvider">
> >> <MaxRetries>3</MaxRetries>
> >>
> >> <SecondsBeforeRetry>900</SecondsBeforeRetry>
> >> <Configuration>
> >>
> >> <RSEmailDPConfiguration>
> >>
> >> <SMTPServer>smtp.sbcglobal.yahoo.com</SMTPServer>
> >>
> >> <SMTPServerPort>25</SMTPServerPort>
> >>
> >> <SMTPAccountName>WarrenSmith-sbc</SMTPAccountName>
> >>
> >> <SMTPConnectionTimeout></SMTPConnectionTimeout>
> >>
> >> <SMTPServerPickupDirectory></SMTPServerPickupDirec
> >>tory>
> >>
> >> <SMTPUseSSL></SMTPUseSSL>
> >>
> >> <SendUsing>2</SendUsing>
> >>
> >> <SMTPAuthenticate>1</SMTPAuthenticate>
> >>
> >> <From>wc.smith@.sbcglobal.net</From>
> >>
> >> <EmbeddedRenderFormats>
> >>
> >> <RenderingExtension>MHTML</RenderingExtension>
> >>
> >> </EmbeddedRenderFormats>
> >>
> >> <PrivilegedUserRenderFormats></PrivilegedUserRende
> >>rFormats>
> >>
> >> <ExcludedRenderFormats>
> >>
> >> <RenderingExtension>HTMLOWC</RenderingExtension>
> >>
> >> <RenderingExtension>NULL</RenderingExtension>
> >>
> >> </ExcludedRenderFormats>
> >>
> >> <SendEmailToUserAlias>True</SendEmailToUserAlias>
> >>
> >> <DefaultHostName></DefaultHostName>
> >>
> >> <PermittedHosts></PermittedHosts>
> >>
> >> </RSEmailDPConfiguration>
> >> </Configuration>
> >> </Extension>
> >> <Extension Name="NULL"
> >>Type="Microsoft.ReportingServices.NullDeliveryProvider.Nu
> > l
> >>lProvider,ReportingServicesNullDeliveryProvider"/>
> >>
> >>
> >>Does anyone know where you set the SendUserName and
> >>SendPassword fields?
> >>
> >>Thanks,
> >>
> >>Warren
> >>
> >>
> >>.
> >>
>
>
E-mail delivery
Hi All,
I need to programatically create a report, and deliver it.
I managed to create the report and a schedule.
When I call CreateSubcription, it fails
(InvalidDataSourceCredentialSettingException is thrown)
the message is:
"The current action cannot be completed because the user data source
credentials that are
required to execute this report are not stored in the report server
database."
Any ideas ?Make sure you are using stored credentials on the data source the report
uses. This is required for subscription processing.
--
Adrian M.
MCP
"Geek 007" <holmes@.programmer.net> wrote in message
news:uML1ADLTFHA.2304@.tk2msftngp13.phx.gbl...
> Hi All,
> I need to programatically create a report, and deliver it.
> I managed to create the report and a schedule.
> When I call CreateSubcription, it fails
> (InvalidDataSourceCredentialSettingException is thrown)
> the message is:
> "The current action cannot be completed because the user data source
> credentials that are
> required to execute this report are not stored in the report server
> database."
> Any ideas ?
>
>
>
I need to programatically create a report, and deliver it.
I managed to create the report and a schedule.
When I call CreateSubcription, it fails
(InvalidDataSourceCredentialSettingException is thrown)
the message is:
"The current action cannot be completed because the user data source
credentials that are
required to execute this report are not stored in the report server
database."
Any ideas ?Make sure you are using stored credentials on the data source the report
uses. This is required for subscription processing.
--
Adrian M.
MCP
"Geek 007" <holmes@.programmer.net> wrote in message
news:uML1ADLTFHA.2304@.tk2msftngp13.phx.gbl...
> Hi All,
> I need to programatically create a report, and deliver it.
> I managed to create the report and a schedule.
> When I call CreateSubcription, it fails
> (InvalidDataSourceCredentialSettingException is thrown)
> the message is:
> "The current action cannot be completed because the user data source
> credentials that are
> required to execute this report are not stored in the report server
> database."
> Any ideas ?
>
>
>
Email Delivery
I'm using the web service to run reports from an application. However, I don't want to wait for a report to complete; I would like to just have the report emailed to the user when it is complete. I've only found email delivery through subscriptions. Is there another way to deliver reports via email?
If I have to use subscriptions I would like to set them to run "immediately". I've found that setting the start date to sometime in the past does not seem to run the report. Is there some way to set a schedule to run immediately. I've thought of setting the time to the near future, but I seem to have the problem of getting the proper timestamp. Can I get this through the web service some how?
Thanks,
Sam
No there is no such functionality. As you are creating a subscription, as job is created at the SQL Server Agent Service which will keep track of the execution of it, therefore setting the value to a past datetime won′t effect the execution.
Jens K. Suessmeyer.
http://www.sqlserver2005.de
Email as Rpt Delivery Option for Subscription
Is email an option for delivery of a subscription? Right now the only thing
showing up in my reporting services as a report delivery option is "Report
Server File Share".
Is there a way to configure this to deliver via email?
If so, where can I find documentation on how to set this up?You can do this by opening up the Reporting Services Configuration Manager on
the server and going to "Email Settings". There you need to specify a valid
SMTP server to use to mail the reports. After you do that, you should see
Email as an option for Subscriptions.
"Dan" wrote:
> Is email an option for delivery of a subscription? Right now the only thing
> showing up in my reporting services as a report delivery option is "Report
> Server File Share".
> Is there a way to configure this to deliver via email?
> If so, where can I find documentation on how to set this up?
showing up in my reporting services as a report delivery option is "Report
Server File Share".
Is there a way to configure this to deliver via email?
If so, where can I find documentation on how to set this up?You can do this by opening up the Reporting Services Configuration Manager on
the server and going to "Email Settings". There you need to specify a valid
SMTP server to use to mail the reports. After you do that, you should see
Email as an option for Subscriptions.
"Dan" wrote:
> Is email an option for delivery of a subscription? Right now the only thing
> showing up in my reporting services as a report delivery option is "Report
> Server File Share".
> Is there a way to configure this to deliver via email?
> If so, where can I find documentation on how to set this up?
Subscribe to:
Posts (Atom)