Embedding reporting services as a standalone product

Hi,
In the application that I am working on, we currently use Crystal Reports as
the embedded reporting engine. I am trying to evaluate if we should move
over to Microsoft Reporting Services. However, one thing confuses me. It
seems Microsoft Reporting Services will work only as a server under IIS.
This will not work for our customers. I am wondering if Reporting Services
has any embedded component much like Crystal Reports that we could use.
Thank you in advance for your help.
SunnyVersion 2 will have a web form and a winform that does not require the
server (works with the server if there but does not require it).
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Sansanee" <sansanee@.nospam.com> wrote in message
news:%23LD40RJ3EHA.1144@.TK2MSFTNGP09.phx.gbl...
> Hi,
> In the application that I am working on, we currently use Crystal Reports
as
> the embedded reporting engine. I am trying to evaluate if we should move
> over to Microsoft Reporting Services. However, one thing confuses me. It
> seems Microsoft Reporting Services will work only as a server under IIS.
> This will not work for our customers. I am wondering if Reporting Services
> has any embedded component much like Crystal Reports that we could use.
> Thank you in advance for your help.
> Sunny
>

Embedded PDF and Excel Files

I want to upload PDF and Excel files to the Report Server database. I
would like to display them in a custom web application. When working
with the ReportViewer control, I can easily show reports. I can't
figure out the process on how to show a PDF to a user. In particular,
if the user selects a PDF ( I can check the MIMETYPE), then, how do I
get the file from Report Server so I can stream it to the user?On Oct 10, 3:21 pm, "goo...@.landy.net" <goo...@.landy.net> wrote:
> I want to upload PDF and Excel files to the Report Server database. I
> would like to display them in a custom web application. When working
> with the ReportViewer control, I can easily show reports. I can't
> figure out the process on how to show a PDF to a user. In particular,
> if the user selects a PDF ( I can check the MIMETYPE), then, how do I
> get the file from Report Server so I can stream it to the user?
If you create a report that has the same format and output as the PDF
and Excel files, you could call the report and automatically render it
to PDF or Excel with a download prompt via URL. Here are a couple
examples.
http://ServerX/reportserver?/SomeDirectory/ReportName&rs:Command=Render&Param1=SomeValue&rs:Format=PDF
-or-
http://ServerX/reportserver?/SomeDirectory/ReportName&rs:Command=Render&Param1=SomeValue&rs:Format=Excel
Here's the URL format:
http://<ServerName>/reportserver?/<Directory>/<ReportName>&rs:Command=Render&<ParameterName>=<ParameterValue>&rs:Format=<PDF/CSV/XML/Excel/MHTML>
Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||On Oct 10, 8:36 pm, EMartinez <emartinez...@.gmail.com> wrote:
> On Oct 10, 3:21 pm, "goo...@.landy.net" <goo...@.landy.net> wrote:
> > I want to upload PDF and Excel files to the Report Server database. I
> > would like to display them in a custom web application. When working
> > with the ReportViewer control, I can easily show reports. I can't
> > figure out the process on how to show a PDF to a user. In particular,
> > if the user selects a PDF ( I can check the MIMETYPE), then, how do I
> > get the file from Report Server so I can stream it to the user?
> If you create a report that has the same format and output as the PDF
> and Excel files, you could call the report and automatically render it
> to PDF or Excel with a download prompt via URL. Here are a couple
> examples.http://ServerX/reportserver?/SomeDirectory/ReportName&rs:Command=
=3DRend...
> -or-http://ServerX/reportserver?/SomeDirectory/ReportName&rs:Command=3DRe=
nd...
> Here's the URL format:
> http://<ServerName>/reportserver?/<Directory>/<ReportName>&rs:Command=3DR=
ende=ADr&<ParameterName>=3D<ParameterValue>&rs:Format=3D<PDF/CSV/XML/Excel/=MHTML>
> Hope this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
These are generic PDF files, not based on a report so they cannot be
rendered. We are using Reporting Services to provide security not
only to reports, but also some ancillary PDF and Excel files.|||Where does an uploaded pdf get stored'
Our uploaded pdf changes every week and rather than reupload everytime I was
hoping we could just save changes to the location it was uploaded to.
Many Thanks
"google@.landy.net" wrote:
> On Oct 10, 8:36 pm, EMartinez <emartinez...@.gmail.com> wrote:
> > On Oct 10, 3:21 pm, "goo...@.landy.net" <goo...@.landy.net> wrote:
> >
> > > I want to upload PDF and Excel files to the Report Server database. I
> > > would like to display them in a custom web application. When working
> > > with the ReportViewer control, I can easily show reports. I can't
> > > figure out the process on how to show a PDF to a user. In particular,
> > > if the user selects a PDF ( I can check the MIMETYPE), then, how do I
> > > get the file from Report Server so I can stream it to the user?
> >
> > If you create a report that has the same format and output as the PDF
> > and Excel files, you could call the report and automatically render it
> > to PDF or Excel with a download prompt via URL. Here are a couple
> > examples.http://ServerX/reportserver?/SomeDirectory/ReportName&rs:Command=Rend...
> > -or-http://ServerX/reportserver?/SomeDirectory/ReportName&rs:Command=Rend...
> >
> > Here's the URL format:
> > http://<ServerName>/reportserver?/<Directory>/<ReportName>&rs:Command=Rende-r&<ParameterName>=<ParameterValue>&rs:Format=<PDF/CSV/XML/Excel/MHTML>
> > Hope this helps.
> >
> > Regards,
> >
> > Enrique Martinez
> > Sr. Software Consultant
> These are generic PDF files, not based on a report so they cannot be
> rendered. We are using Reporting Services to provide security not
> only to reports, but also some ancillary PDF and Excel files.
>

emails reside in Inbox?

Hi,
I'm working on MS SqL 2K
and I have installed MS Outlook.
I've configured the SQL Mail and SQL Agent Mail.
when I use the xp_sendmail, the emails reside in the Inbox of the Outlook
and are not sent to the right recipients, so I should re-send them from
Outlook.
I'm missing something for sure, what is it?
thanks in advance.
joujHi
Your emails should be sent, but at a guess your are using Outlook 2002 or
later in which case it has to be running on the server see
http://support.microsoft.com/default.aspx?scid=kb;en-us;263556
The easiest solution is to install Outlook 2000 or use xpsmtp
http://www.sqldev.net/xp/xpsmtp.htm
John
"jouj" <jouj@.discussions.microsoft.com> wrote in message
news:89B5CE19-71C3-41B4-B846-9CF844AAF58A@.microsoft.com...
> Hi,
> I'm working on MS SqL 2K
> and I have installed MS Outlook.
> I've configured the SQL Mail and SQL Agent Mail.
> when I use the xp_sendmail, the emails reside in the Inbox of the Outlook
> and are not sent to the right recipients, so I should re-send them from
> Outlook.
> I'm missing something for sure, what is it?
> thanks in advance.
> jouj
>

emails reside in Inbox?

Hi,
I'm working on MS SqL 2K
and I have installed MS Outlook.
I've configured the SQL Mail and SQL Agent Mail.
when I use the xp_sendmail, the emails reside in the Inbox of the Outlook
and are not sent to the right recipients, so I should re-send them from
Outlook.
I'm missing something for sure, what is it?
thanks in advance.
jouj
Hi
Your emails should be sent, but at a guess your are using Outlook 2002 or
later in which case it has to be running on the server see
http://support.microsoft.com/default...b;en-us;263556
The easiest solution is to install Outlook 2000 or use xpsmtp
http://www.sqldev.net/xp/xpsmtp.htm
John
"jouj" <jouj@.discussions.microsoft.com> wrote in message
news:89B5CE19-71C3-41B4-B846-9CF844AAF58A@.microsoft.com...
> Hi,
> I'm working on MS SqL 2K
> and I have installed MS Outlook.
> I've configured the SQL Mail and SQL Agent Mail.
> when I use the xp_sendmail, the emails reside in the Inbox of the Outlook
> and are not sent to the right recipients, so I should re-send them from
> Outlook.
> I'm missing something for sure, what is it?
> thanks in advance.
> jouj
>

emails reside in Inbox?

Hi,
I'm working on MS SqL 2K
and I have installed MS Outlook.
I've configured the SQL Mail and SQL Agent Mail.
when I use the xp_sendmail, the emails reside in the Inbox of the Outlook
and are not sent to the right recipients, so I should re-send them from
Outlook.
I'm missing something for sure, what is it?
thanks in advance.
joujHi
Your emails should be sent, but at a guess your are using Outlook 2002 or
later in which case it has to be running on the server see
http://support.microsoft.com/defaul...kb;en-us;263556
The easiest solution is to install Outlook 2000 or use xpsmtp
http://www.sqldev.net/xp/xpsmtp.htm
John
"jouj" <jouj@.discussions.microsoft.com> wrote in message
news:89B5CE19-71C3-41B4-B846-9CF844AAF58A@.microsoft.com...
> Hi,
> I'm working on MS SqL 2K
> and I have installed MS Outlook.
> I've configured the SQL Mail and SQL Agent Mail.
> when I use the xp_sendmail, the emails reside in the Inbox of the Outlook
> and are not sent to the right recipients, so I should re-send them from
> Outlook.
> I'm missing something for sure, what is it?
> thanks in advance.
> jouj
>

emailing excel and pdf not working

I can email Web Archive reports successfully. However, I cannot send reports
in Excel or PDF.
I have Acrobat Pro 6 installed.
I DO NOT have Excel 2003 installed, but I can if necessary.
Did I missing a configuration step or something?Afte a few weeks of troubleshooting I got it to work. It was totally
unrelated to RS.
"Matt Temple" <mtemple@.dslextreme.com> wrote in message
news:10djruhppn13j04@.corp.supernews.com...
> I can email Web Archive reports successfully. However, I cannot send
reports
> in Excel or PDF.
> I have Acrobat Pro 6 installed.
> I DO NOT have Excel 2003 installed, but I can if necessary.
> Did I missing a configuration step or something?
>

e-mail subscription quit working - can't figure out why

Hi All,
I am using SQL Reporting Services MOM Reporting. I set up some reports and
they have been delivering flawlessley now for over a month. Now this morning
I got the error:
"Failure sending mail: The transport failed to connect to the server. "
It isn't descriptive enough to know what exactly failed. I can ping and
telnet to the SMTP port of the mail server and not being blocked. Also, the
same settings are being used for alerts from MOM without any problems. Is
there a way to run a test or get a better log to know what the error is?
This error is useless.
Thanks,
--GREG--I had experienced similar behavior. We resolved this by changing the
SMTP server specified in the Email Settings within Report Services
Configuration tool from the server name to the mail server's IP
address. Hope this helps!
Midas

Email Subscription not working - help please

Nothing shows up under the "Last Run" column. No error msg or entry in
reporting services or SMTP log.
Looks like reporting server is completly ignoring the subscription entry.
I'm using "once" option and selecting a time just 10-15 minutes ahead.
Here are the entries in my RSReportServer.config file:
----
<Extensions>
<Delivery>
<Extension Name="Report Server FileShare"
Type="Microsoft.ReportingServices.FileShareDeliveryProvider.FileShareProvider,ReportingServicesFileShareDeliveryProvider">
<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.EmailProvider,ReportingServicesEmailDeliveryProvider">
<MaxRetries>3</MaxRetries>
<SecondsBeforeRetry>900</SecondsBeforeRetry>
<Configuration>
<RSEmailDPConfiguration>
<SMTPServer>150.8.111.82</SMTPServer>
<SMTPServerPort></SMTPServerPort>
<SMTPAccountName></SMTPAccountName>
<SMTPConnectionTimeout></SMTPConnectionTimeout>
<SMTPServerPickupDirectory></SMTPServerPickupDirectory>
<SMTPUseSSL></SMTPUseSSL>
<SendUsing></SendUsing>
<SMTPAuthenticate></SMTPAuthenticate>
<From>altbill@.discountcar.com</From>
<EmbeddedRenderFormats>
<RenderingExtension>MHTML</RenderingExtension>
</EmbeddedRenderFormats>
<PrivilegedUserRenderFormats></PrivilegedUserRenderFormats>
<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.NullProvider,ReportingServicesNullDeliveryProvider"/>
</Delivery>
----
What could be wrong... any ideas...
Thanks
AJHi, I have the exact same problem. I'm running win2003, and you?
"Amit Jain" wrote:
> Nothing shows up under the "Last Run" column. No error msg or entry in
> reporting services or SMTP log.
> Looks like reporting server is completly ignoring the subscription entry.
> I'm using "once" option and selecting a time just 10-15 minutes ahead.
> Here are the entries in my RSReportServer.config file:
> ----
> <Extensions>
> <Delivery>
> <Extension Name="Report Server FileShare"
> Type="Microsoft.ReportingServices.FileShareDeliveryProvider.FileShareProvider,ReportingServicesFileShareDeliveryProvider">
> <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.EmailProvider,ReportingServicesEmailDeliveryProvider">
> <MaxRetries>3</MaxRetries>
> <SecondsBeforeRetry>900</SecondsBeforeRetry>
> <Configuration>
> <RSEmailDPConfiguration>
> <SMTPServer>150.8.111.82</SMTPServer>
> <SMTPServerPort></SMTPServerPort>
> <SMTPAccountName></SMTPAccountName>
> <SMTPConnectionTimeout></SMTPConnectionTimeout>
> <SMTPServerPickupDirectory></SMTPServerPickupDirectory>
> <SMTPUseSSL></SMTPUseSSL>
> <SendUsing></SendUsing>
> <SMTPAuthenticate></SMTPAuthenticate>
> <From>altbill@.discountcar.com</From>
> <EmbeddedRenderFormats>
> <RenderingExtension>MHTML</RenderingExtension>
> </EmbeddedRenderFormats>
> <PrivilegedUserRenderFormats></PrivilegedUserRenderFormats>
> <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.NullProvider,ReportingServicesNullDeliveryProvider"/>
> </Delivery>
> ----
> What could be wrong... any ideas...
> Thanks
> AJ
>
>|||I've tried it on Win2K server and Win2K professional, same issue on both
installations.
"Hennie" <Hennie@.discussions.microsoft.com> wrote in message
news:15DCD777-B85F-4D3D-893C-618D7B138F94@.microsoft.com...
> Hi, I have the exact same problem. I'm running win2003, and you?
> "Amit Jain" wrote:
>> Nothing shows up under the "Last Run" column. No error msg or entry in
>> reporting services or SMTP log.
>> Looks like reporting server is completly ignoring the subscription entry.
>> I'm using "once" option and selecting a time just 10-15 minutes ahead.
>> Here are the entries in my RSReportServer.config file:
>> ----
>> <Extensions>
>> <Delivery>
>> <Extension Name="Report Server FileShare"
>> Type="Microsoft.ReportingServices.FileShareDeliveryProvider.FileShareProvider,ReportingServicesFileShareDeliveryProvider">
>> <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.EmailProvider,ReportingServicesEmailDeliveryProvider">
>> <MaxRetries>3</MaxRetries>
>> <SecondsBeforeRetry>900</SecondsBeforeRetry>
>> <Configuration>
>> <RSEmailDPConfiguration>
>> <SMTPServer>150.8.111.82</SMTPServer>
>> <SMTPServerPort></SMTPServerPort>
>> <SMTPAccountName></SMTPAccountName>
>> <SMTPConnectionTimeout></SMTPConnectionTimeout>
>> <SMTPServerPickupDirectory></SMTPServerPickupDirectory>
>> <SMTPUseSSL></SMTPUseSSL>
>> <SendUsing></SendUsing>
>> <SMTPAuthenticate></SMTPAuthenticate>
>> <From>altbill@.discountcar.com</From>
>> <EmbeddedRenderFormats>
>> <RenderingExtension>MHTML</RenderingExtension>
>> </EmbeddedRenderFormats>
>> <PrivilegedUserRenderFormats></PrivilegedUserRenderFormats>
>> <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.NullProvider,ReportingServicesNullDeliveryProvider"/>
>> </Delivery>
>> ----
>> What could be wrong... any ideas...
>> Thanks
>> AJ
>>|||I fixed it by starting the ReportServer service. I should've have checked
it before posting.
"AJ" <amitjn_ca@.yahoo.ca> wrote in message
news:uIW6bH7AFHA.3120@.TK2MSFTNGP12.phx.gbl...
> I've tried it on Win2K server and Win2K professional, same issue on both
> installations.
> "Hennie" <Hennie@.discussions.microsoft.com> wrote in message
> news:15DCD777-B85F-4D3D-893C-618D7B138F94@.microsoft.com...
>> Hi, I have the exact same problem. I'm running win2003, and you?
>> "Amit Jain" wrote:
>> Nothing shows up under the "Last Run" column. No error msg or entry in
>> reporting services or SMTP log.
>> Looks like reporting server is completly ignoring the subscription
>> entry.
>> I'm using "once" option and selecting a time just 10-15 minutes ahead.
>> Here are the entries in my RSReportServer.config file:
>> ----
>> <Extensions>
>> <Delivery>
>> <Extension Name="Report Server FileShare"
>> Type="Microsoft.ReportingServices.FileShareDeliveryProvider.FileShareProvider,ReportingServicesFileShareDeliveryProvider">
>> <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.EmailProvider,ReportingServicesEmailDeliveryProvider">
>> <MaxRetries>3</MaxRetries>
>> <SecondsBeforeRetry>900</SecondsBeforeRetry>
>> <Configuration>
>> <RSEmailDPConfiguration>
>> <SMTPServer>150.8.111.82</SMTPServer>
>> <SMTPServerPort></SMTPServerPort>
>> <SMTPAccountName></SMTPAccountName>
>> <SMTPConnectionTimeout></SMTPConnectionTimeout>
>> <SMTPServerPickupDirectory></SMTPServerPickupDirectory>
>> <SMTPUseSSL></SMTPUseSSL>
>> <SendUsing></SendUsing>
>> <SMTPAuthenticate></SMTPAuthenticate>
>> <From>altbill@.discountcar.com</From>
>> <EmbeddedRenderFormats>
>> <RenderingExtension>MHTML</RenderingExtension>
>> </EmbeddedRenderFormats>
>> <PrivilegedUserRenderFormats></PrivilegedUserRenderFormats>
>> <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.NullProvider,ReportingServicesNullDeliveryProvider"/>
>> </Delivery>
>> ----
>> What could be wrong... any ideas...
>> Thanks
>> AJ
>>
>|||In general, when you encounter issues like this, check the reporting
services log files. You should see a event polling message and status for
any notifications that are entered. This will also tell you if there are
errors. If you do not see any service log files, you'll need to start the
service called reportserver
-Lukasz
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Amit Jain" <amitjn_ca@.yahoo.ca> wrote in message
news:eNlilGyAFHA.2540@.TK2MSFTNGP09.phx.gbl...
> Nothing shows up under the "Last Run" column. No error msg or entry in
> reporting services or SMTP log.
> Looks like reporting server is completly ignoring the subscription entry.
> I'm using "once" option and selecting a time just 10-15 minutes ahead.
> Here are the entries in my RSReportServer.config file:
> ----
> <Extensions>
> <Delivery>
> <Extension Name="Report Server FileShare"
> Type="Microsoft.ReportingServices.FileShareDeliveryProvider.FileShareProvider,ReportingServicesFileShareDeliveryProvider">
> <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.EmailProvider,ReportingServicesEmailDeliveryProvider">
> <MaxRetries>3</MaxRetries>
> <SecondsBeforeRetry>900</SecondsBeforeRetry>
> <Configuration>
> <RSEmailDPConfiguration>
> <SMTPServer>150.8.111.82</SMTPServer>
> <SMTPServerPort></SMTPServerPort>
> <SMTPAccountName></SMTPAccountName>
> <SMTPConnectionTimeout></SMTPConnectionTimeout>
> <SMTPServerPickupDirectory></SMTPServerPickupDirectory>
> <SMTPUseSSL></SMTPUseSSL>
> <SendUsing></SendUsing>
> <SMTPAuthenticate></SMTPAuthenticate>
> <From>altbill@.discountcar.com</From>
> <EmbeddedRenderFormats>
> <RenderingExtension>MHTML</RenderingExtension>
> </EmbeddedRenderFormats>
> <PrivilegedUserRenderFormats></PrivilegedUserRenderFormats>
> <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.NullProvider,ReportingServicesNullDeliveryProvider"/>
> </Delivery>
> ----
> What could be wrong... any ideas...
> Thanks
> AJ
>|||Like Lukasz says, check the report Server Log, if any error occured you will
find them there, in the first example of Amit i would suggest looking in the
logs of the SMTP Server (For example you could send the EMail temporary to
an virtual SMTP Server where you have full control of and relay it to the
productive server to check the logs) or just to check if the SMTP Server
accepted relayed EMails to conenct to the mail server via telnet.
--> telnet Mailserver 25
Rest can be found here:
http://www.yuki-onna.co.uk/email/smtp.html
HTH, Jens Süßmeyer.
--
http://www.sqlserver2005.de
--
"Koen" <Koen@.discussions.microsoft.com> schrieb im Newsbeitrag
news:F6365949-8F76-41B7-B74A-182A7A5869C6@.microsoft.com...
> Is there an internal clock or so in reporting services ? Because i'm
> facing
> the same problem, but when i check my log files, i see that the time when
> these files were created is impossible (eg: 2 AM, when nobody's at the
> office
> and the server is shut down).
> Thanks in advance
> "Lukasz Pawlowski [MSFT]" wrote:
>> In general, when you encounter issues like this, check the reporting
>> services log files. You should see a event polling message and status
>> for
>> any notifications that are entered. This will also tell you if there are
>> errors. If you do not see any service log files, you'll need to start
>> the
>> service called reportserver
>> -Lukasz
>> --
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>>
>> "Amit Jain" <amitjn_ca@.yahoo.ca> wrote in message
>> news:eNlilGyAFHA.2540@.TK2MSFTNGP09.phx.gbl...
>> > Nothing shows up under the "Last Run" column. No error msg or entry in
>> > reporting services or SMTP log.
>> > Looks like reporting server is completly ignoring the subscription
>> > entry.
>> > I'm using "once" option and selecting a time just 10-15 minutes ahead.
>> > Here are the entries in my RSReportServer.config file:
>> > ----
>> > <Extensions>
>> > <Delivery>
>> > <Extension Name="Report Server FileShare"
>> > Type="Microsoft.ReportingServices.FileShareDeliveryProvider.FileShareProvider,ReportingServicesFileShareDeliveryProvider">
>> > <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.EmailProvider,ReportingServicesEmailDeliveryProvider">
>> > <MaxRetries>3</MaxRetries>
>> > <SecondsBeforeRetry>900</SecondsBeforeRetry>
>> > <Configuration>
>> > <RSEmailDPConfiguration>
>> > <SMTPServer>150.8.111.82</SMTPServer>
>> > <SMTPServerPort></SMTPServerPort>
>> > <SMTPAccountName></SMTPAccountName>
>> > <SMTPConnectionTimeout></SMTPConnectionTimeout>
>> > <SMTPServerPickupDirectory></SMTPServerPickupDirectory>
>> > <SMTPUseSSL></SMTPUseSSL>
>> > <SendUsing></SendUsing>
>> > <SMTPAuthenticate></SMTPAuthenticate>
>> > <From>altbill@.discountcar.com</From>
>> > <EmbeddedRenderFormats>
>> > <RenderingExtension>MHTML</RenderingExtension>
>> > </EmbeddedRenderFormats>
>> > <PrivilegedUserRenderFormats></PrivilegedUserRenderFormats>
>> > <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.NullProvider,ReportingServicesNullDeliveryProvider"/>
>> > </Delivery>
>> > ----
>> > What could be wrong... any ideas...
>> > Thanks
>> > AJ
>> >
>>

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
> > >

Email report

Hi Freinds,
SQL2005 beta,
I create a subscription and want to email report based on a schedule. It
doesn't seems working, no error either.
Where can I track it down? Which config files keep the mail SMTP
information?
Thanks,
PatLook in the windows service log file in the LogFiles folder.
The file rsreportserver.config contains the email delivery extension
configuration.
-Lukasz
This posting is provided "AS IS" with no warranties, and confers no rights.
"Patrick" <patriarck@.gmail.com> wrote in message
news:OQwr7TeHFHA.2704@.tk2msftngp13.phx.gbl...
> Hi Freinds,
> SQL2005 beta,
> I create a subscription and want to email report based on a schedule. It
> doesn't seems working, no error either.
> Where can I track it down? Which config files keep the mail SMTP
> information?
> Thanks,
> Pat
>

email error

the site i am working on iswww.papertrailinvites.com

on the left when you enter your email address and hit submit i get this error:

Server Error in '/' Application.

---

Must declare the scalar variable "@.Email".

Description:An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details:System.Data.SqlClient.SqlException: Must declare the scalar variable "@.Email".

Source Error:

Line 29: Line 30: conn.Open();Line 31: cmd.ExecuteNonQuery();Line 32: Line 33: }

My code is below:

protected void Button1_Click(object sender, EventArgs e) {using (SqlConnection conn =new SqlConnection(ConfigurationManager.ConnectionStrings["cardsConnectionString1"].ConnectionString)) {string email = Newsletter_Email.Text; SqlCommand cmd =new SqlCommand("INSERT INTO Email (EmailAddress) Values (@.Email)", conn); cmd.CommandType = CommandType.Text; cmd.Parameters.AddWithValue("@.Name", email); conn.Open(); cmd.ExecuteNonQuery(); } }

it looks like you mixed up "name" and "email"

try this:

protected void Button1_Click(object sender, EventArgs e) {using (SqlConnection conn =new SqlConnection(ConfigurationManager.ConnectionStrings["cardsConnectionString1"].ConnectionString)) {string email = Newsletter_Email.Text; SqlCommand cmd =new SqlCommand("INSERT INTO Email (EmailAddress) Values (@.Email)", conn); cmd.CommandType = CommandType.Text;//re-name param to match the cmd statement cmd.Parameters.AddWithValue("@.Email", email); conn.Open(); cmd.ExecuteNonQuery(); } }

|||

gers my code and i still get the error...

protectedvoid Button1_Click(object sender,EventArgs e)

{

using (SqlConnection conn =newSqlConnection(ConfigurationManager.ConnectionStrings["cardsConnectionString1"].ConnectionString)) {String newemail = Newsletter_Email.Text;

SqlCommand cmd =newSqlCommand("INSERT INTO Email (EmailAddress) Values (@.EmailAddress)", conn);

cmd.CommandType =

CommandType.Text;

cmd.Parameters.AddWithValue(

"@.EmailAdress", newemail);

conn.Open();

cmd.ExecuteNonQuery();

}

|||

double check your spelling.

your sql says: @.EmailAddress

your param says: @.EmailAdress

Email doesn't work

I've just installed Reporting Services and am working through the
walkthroughs. I am stuck on one that deals with subscriptions and sending
reports via email. I used Report Manager to setup the report subscriptions,
but I get the following status message:
"Failure sending mail: The Report Server has encountered a configuration
error; more details in the log files"
What am I doing wrong?
How do I setup ReportServer to send email?
I used the information in this article:
http://www.msdn.microsoft.com/library/default.asp?url=/library/en-us/rsadmin/htm/arp_configserver_v1_4bzl.asp
I updated the rsreportserver.config file as directed. Here is the email
section:
<Extension Name="Report Server Email"
Type="Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider,ReportingServicesEmailDeliveryProvider">
<MaxRetries>3</MaxRetries>
<SecondsBeforeRetry>900</SecondsBeforeRetry>
<Configuration>
<RSEmailDPConfiguration>
<SMTPServer>MyServer</SMTPServer>
<SMTPServerPort></SMTPServerPort>
<SMTPAccountName></SMTPAccountName>
<SMTPConnectionTimeout></SMTPConnectionTimeout>
<SMTPServerPickupDirectory></SMTPServerPickupDirectory>
<SMTPUseSSL></SMTPUseSSL>
<SendUsing>0</SendUsing>
<SMTPAuthenticate></SMTPAuthenticate>
<From>test@.borim.com</From>
<EmbeddedRenderFormats>
<RenderingExtension>MHTML</RenderingExtension>
</EmbeddedRenderFormats>
<PrivilegedUserRenderFormats></PrivilegedUserRenderFormats>
<ExcludedRenderFormats>
<RenderingExtension>HTMLOWC</RenderingExtension>
<RenderingExtension>NULL</RenderingExtension>
</ExcludedRenderFormats>
<SendEmailToUserAlias>False</SendEmailToUserAlias>
<DefaultHostName></DefaultHostName>
<PermittedHosts></PermittedHosts>
</RSEmailDPConfiguration>
</Configuration>
</Extension>Either remove the value for the <SendUsing> tag or set it to 2.
-Lukasz
This posting is provided "AS IS" with no warranties, and confers no rights.
"DaveM" <DaveM@.discussions.microsoft.com> wrote in message
news:87E61ABC-CB00-4803-A74E-243C8F863CB2@.microsoft.com...
> I've just installed Reporting Services and am working through the
> walkthroughs. I am stuck on one that deals with subscriptions and sending
> reports via email. I used Report Manager to setup the report
> subscriptions,
> but I get the following status message:
> "Failure sending mail: The Report Server has encountered a configuration
> error; more details in the log files"
>
> What am I doing wrong?
> How do I setup ReportServer to send email?
> I used the information in this article:
> http://www.msdn.microsoft.com/library/default.asp?url=/library/en-us/rsadmin/htm/arp_configserver_v1_4bzl.asp
> I updated the rsreportserver.config file as directed. Here is the email
> section:
> <Extension Name="Report Server Email"
> Type="Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider,ReportingServicesEmailDeliveryProvider">
> <MaxRetries>3</MaxRetries>
> <SecondsBeforeRetry>900</SecondsBeforeRetry>
> <Configuration>
> <RSEmailDPConfiguration>
> <SMTPServer>MyServer</SMTPServer>
> <SMTPServerPort></SMTPServerPort>
> <SMTPAccountName></SMTPAccountName>
> <SMTPConnectionTimeout></SMTPConnectionTimeout>
> <SMTPServerPickupDirectory></SMTPServerPickupDirectory>
> <SMTPUseSSL></SMTPUseSSL>
> <SendUsing>0</SendUsing>
> <SMTPAuthenticate></SMTPAuthenticate>
> <From>test@.borim.com</From>
> <EmbeddedRenderFormats>
> <RenderingExtension>MHTML</RenderingExtension>
> </EmbeddedRenderFormats>
> <PrivilegedUserRenderFormats></PrivilegedUserRenderFormats>
> <ExcludedRenderFormats>
> <RenderingExtension>HTMLOWC</RenderingExtension>
> <RenderingExtension>NULL</RenderingExtension>
> </ExcludedRenderFormats>
> <SendEmailToUserAlias>False</SendEmailToUserAlias>
> <DefaultHostName></DefaultHostName>
> <PermittedHosts></PermittedHosts>
> </RSEmailDPConfiguration>
> </Configuration>
> </Extension>|||Sorry, I caught that and already changed it to 2.
Update on the problem:
I can send emails that only include the link, but not the report.
Furthermore, if I create a subscription that writes to a local file, it also
fails...?
1) IIS, SQL Server, Report Server all run under a domain admin account
2) I've installed Reporting Services SP1
3) I've made sure that the account that I am specifying for report access is
a domain admin (also tried local admin account) and has 'dbo' for access role
for all databases
4) All services run locally.
I'm stumped...
"Lukasz Pawlowski [MSFT]" wrote:
> Either remove the value for the <SendUsing> tag or set it to 2.
> -Lukasz
>
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "DaveM" <DaveM@.discussions.microsoft.com> wrote in message
> news:87E61ABC-CB00-4803-A74E-243C8F863CB2@.microsoft.com...
> > I've just installed Reporting Services and am working through the
> > walkthroughs. I am stuck on one that deals with subscriptions and sending
> > reports via email. I used Report Manager to setup the report
> > subscriptions,
> > but I get the following status message:
> >
> > "Failure sending mail: The Report Server has encountered a configuration
> > error; more details in the log files"
> >
> >
> >
> > What am I doing wrong?
> >
> > How do I setup ReportServer to send email?
> >
> > I used the information in this article:
> > http://www.msdn.microsoft.com/library/default.asp?url=/library/en-us/rsadmin/htm/arp_configserver_v1_4bzl.asp
> >
> > I updated the rsreportserver.config file as directed. Here is the email
> > section:
> >
> > <Extension Name="Report Server Email"
> > Type="Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider,ReportingServicesEmailDeliveryProvider">
> > <MaxRetries>3</MaxRetries>
> > <SecondsBeforeRetry>900</SecondsBeforeRetry>
> > <Configuration>
> > <RSEmailDPConfiguration>
> > <SMTPServer>MyServer</SMTPServer>
> > <SMTPServerPort></SMTPServerPort>
> > <SMTPAccountName></SMTPAccountName>
> >
> > <SMTPConnectionTimeout></SMTPConnectionTimeout>
> >
> > <SMTPServerPickupDirectory></SMTPServerPickupDirectory>
> > <SMTPUseSSL></SMTPUseSSL>
> > <SendUsing>0</SendUsing>
> > <SMTPAuthenticate></SMTPAuthenticate>
> > <From>test@.borim.com</From>
> > <EmbeddedRenderFormats>
> >
> > <RenderingExtension>MHTML</RenderingExtension>
> > </EmbeddedRenderFormats>
> >
> > <PrivilegedUserRenderFormats></PrivilegedUserRenderFormats>
> > <ExcludedRenderFormats>
> >
> > <RenderingExtension>HTMLOWC</RenderingExtension>
> >
> > <RenderingExtension>NULL</RenderingExtension>
> > </ExcludedRenderFormats>
> >
> > <SendEmailToUserAlias>False</SendEmailToUserAlias>
> > <DefaultHostName></DefaultHostName>
> > <PermittedHosts></PermittedHosts>
> > </RSEmailDPConfiguration>
> > </Configuration>
> > </Extension>
>
>|||Dave,
I'm having the same issue. My 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
"DaveM" wrote:
> Sorry, I caught that and already changed it to 2.
> Update on the problem:
> I can send emails that only include the link, but not the report.
> Furthermore, if I create a subscription that writes to a local file, it also
> fails...?
> 1) IIS, SQL Server, Report Server all run under a domain admin account
> 2) I've installed Reporting Services SP1
> 3) I've made sure that the account that I am specifying for report access is
> a domain admin (also tried local admin account) and has 'dbo' for access role
> for all databases
> 4) All services run locally.
> I'm stumped...
>
> "Lukasz Pawlowski [MSFT]" wrote:
> > Either remove the value for the <SendUsing> tag or set it to 2.
> >
> > -Lukasz
> >
> >
> > --
> > This posting is provided "AS IS" with no warranties, and confers no rights.
> >
> >
> >
> > "DaveM" <DaveM@.discussions.microsoft.com> wrote in message
> > news:87E61ABC-CB00-4803-A74E-243C8F863CB2@.microsoft.com...
> > > I've just installed Reporting Services and am working through the
> > > walkthroughs. I am stuck on one that deals with subscriptions and sending
> > > reports via email. I used Report Manager to setup the report
> > > subscriptions,
> > > but I get the following status message:
> > >
> > > "Failure sending mail: The Report Server has encountered a configuration
> > > error; more details in the log files"
> > >
> > >
> > >
> > > What am I doing wrong?
> > >
> > > How do I setup ReportServer to send email?
> > >
> > > I used the information in this article:
> > > http://www.msdn.microsoft.com/library/default.asp?url=/library/en-us/rsadmin/htm/arp_configserver_v1_4bzl.asp
> > >
> > > I updated the rsreportserver.config file as directed. Here is the email
> > > section:
> > >
> > > <Extension Name="Report Server Email"
> > > Type="Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider,ReportingServicesEmailDeliveryProvider">
> > > <MaxRetries>3</MaxRetries>
> > > <SecondsBeforeRetry>900</SecondsBeforeRetry>
> > > <Configuration>
> > > <RSEmailDPConfiguration>
> > > <SMTPServer>MyServer</SMTPServer>
> > > <SMTPServerPort></SMTPServerPort>
> > > <SMTPAccountName></SMTPAccountName>
> > >
> > > <SMTPConnectionTimeout></SMTPConnectionTimeout>
> > >
> > > <SMTPServerPickupDirectory></SMTPServerPickupDirectory>
> > > <SMTPUseSSL></SMTPUseSSL>
> > > <SendUsing>0</SendUsing>
> > > <SMTPAuthenticate></SMTPAuthenticate>
> > > <From>test@.borim.com</From>
> > > <EmbeddedRenderFormats>
> > >
> > > <RenderingExtension>MHTML</RenderingExtension>
> > > </EmbeddedRenderFormats>
> > >
> > > <PrivilegedUserRenderFormats></PrivilegedUserRenderFormats>
> > > <ExcludedRenderFormats>
> > >
> > > <RenderingExtension>HTMLOWC</RenderingExtension>
> > >
> > > <RenderingExtension>NULL</RenderingExtension>
> > > </ExcludedRenderFormats>
> > >
> > > <SendEmailToUserAlias>False</SendEmailToUserAlias>
> > > <DefaultHostName></DefaultHostName>
> > > <PermittedHosts></PermittedHosts>
> > > </RSEmailDPConfiguration>
> > > </Configuration>
> > > </Extension>
> >
> >
> >

EMAIL Coruption In attachments

OK, I am looking for help on how to break this problem up for debugging. I
am testing Email report schedules. We are working with files of type:
TIF,PDF & EXCEL. I am able to schedule rendering reports to a FILE SHARE
successfully. I am able to email LINKS to reports successfully. When I
send files of these three types as Email ATTACHMENTS they arrive corupted.
The HEX dump is really ugly. Mostly FF bytes... I am passing from RS to a
SMTP server is external to the RS server, which then passes the reports to
a NOTES server and then to me. The log file for RS shows nothing unusual.
How would you approach debuging this issue?
thanks.
dlrYou can now download a hotfix that addresses this problem. See
http://support.microsoft.com/default.aspx?scid=kb;[LN];872774.
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Dennis Redfield" <dennis.redfield@.acadia-ins.com> wrote in message
news:u%23hSrFWgEHA.4092@.TK2MSFTNGP10.phx.gbl...
> OK, I am looking for help on how to break this problem up for debugging.
> I
> am testing Email report schedules. We are working with files of type:
> TIF,PDF & EXCEL. I am able to schedule rendering reports to a FILE SHARE
> successfully. I am able to email LINKS to reports successfully. When I
> send files of these three types as Email ATTACHMENTS they arrive corupted.
> The HEX dump is really ugly. Mostly FF bytes... I am passing from RS to
> a
> SMTP server is external to the RS server, which then passes the reports
> to
> a NOTES server and then to me. The log file for RS shows nothing unusual.
> How would you approach debuging this issue?
> thanks.
> dlr
>|||ok. thanks for the tip. HOTFix resolved all problems with a single
exception. WEB ARCHIVES are still not working in notes (works fine with
hotmail/outlook express) We are at v5.0.9 on Notes. Perhaps upgrading NOTES
will resolve this last problem?....
dlr
"Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in message
news:%236gRNPqgEHA.384@.TK2MSFTNGP10.phx.gbl...
> You can now download a hotfix that addresses this problem. See
> http://support.microsoft.com/default.aspx?scid=kb;[LN];872774.
> --
> Brian Welcker
> Group Program Manager
> SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> "Dennis Redfield" <dennis.redfield@.acadia-ins.com> wrote in message
> news:u%23hSrFWgEHA.4092@.TK2MSFTNGP10.phx.gbl...
> > OK, I am looking for help on how to break this problem up for debugging.
> > I
> > am testing Email report schedules. We are working with files of type:
> > TIF,PDF & EXCEL. I am able to schedule rendering reports to a FILE
SHARE
> > successfully. I am able to email LINKS to reports successfully. When I
> > send files of these three types as Email ATTACHMENTS they arrive
corupted.
> > The HEX dump is really ugly. Mostly FF bytes... I am passing from RS
to
> > a
> > SMTP server is external to the RS server, which then passes the reports
> > to
> > a NOTES server and then to me. The log file for RS shows nothing
unusual.
> > How would you approach debuging this issue?
> >
> > thanks.
> >
> > dlr
> >
> >
>|||I believe the Notes Viewer does not support MHTML. You may want to change
your RS configuration to always attach MHTML rather then embed it. You can
do this by removing this line for the RSReportServer.config file:
<RenderingExtension>MHTML</RenderingExtension>
which is under the EmbeddedRenderFormats element
--
-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:OUYrEE7gEHA.1392@.TK2MSFTNGP11.phx.gbl...
> ok. thanks for the tip. HOTFix resolved all problems with a single
> exception. WEB ARCHIVES are still not working in notes (works fine with
> hotmail/outlook express) We are at v5.0.9 on Notes. Perhaps upgrading
NOTES
> will resolve this last problem?....
> dlr
> "Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in message
> news:%236gRNPqgEHA.384@.TK2MSFTNGP10.phx.gbl...
> > You can now download a hotfix that addresses this problem. See
> > http://support.microsoft.com/default.aspx?scid=kb;[LN];872774.
> >
> > --
> > Brian Welcker
> > Group Program Manager
> > SQL Server Reporting Services
> >
> > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> >
> > "Dennis Redfield" <dennis.redfield@.acadia-ins.com> wrote in message
> > news:u%23hSrFWgEHA.4092@.TK2MSFTNGP10.phx.gbl...
> > > OK, I am looking for help on how to break this problem up for
debugging.
> > > I
> > > am testing Email report schedules. We are working with files of type:
> > > TIF,PDF & EXCEL. I am able to schedule rendering reports to a FILE
> SHARE
> > > successfully. I am able to email LINKS to reports successfully. When
I
> > > send files of these three types as Email ATTACHMENTS they arrive
> corupted.
> > > The HEX dump is really ugly. Mostly FF bytes... I am passing from RS
> to
> > > a
> > > SMTP server is external to the RS server, which then passes the
reports
> > > to
> > > a NOTES server and then to me. The log file for RS shows nothing
> unusual.
> > > How would you approach debuging this issue?
> > >
> > > thanks.
> > >
> > > dlr
> > >
> > >
> >
> >
>|||very nice Daniel. thank you!
"Daniel Reib [MSFT]" <danreib@.online.microsoft.com> wrote in message
news:esmzQT7gEHA.2952@.TK2MSFTNGP09.phx.gbl...
> I believe the Notes Viewer does not support MHTML. You may want to change
> your RS configuration to always attach MHTML rather then embed it. You
can
> do this by removing this line for the RSReportServer.config file:
> <RenderingExtension>MHTML</RenderingExtension>
> which is under the EmbeddedRenderFormats element
> --
> -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:OUYrEE7gEHA.1392@.TK2MSFTNGP11.phx.gbl...
> > ok. thanks for the tip. HOTFix resolved all problems with a single
> > exception. WEB ARCHIVES are still not working in notes (works fine with
> > hotmail/outlook express) We are at v5.0.9 on Notes. Perhaps upgrading
> NOTES
> > will resolve this last problem?....
> >
> > dlr
> >
> > "Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in message
> > news:%236gRNPqgEHA.384@.TK2MSFTNGP10.phx.gbl...
> > > You can now download a hotfix that addresses this problem. See
> > > http://support.microsoft.com/default.aspx?scid=kb;[LN];872774.
> > >
> > > --
> > > Brian Welcker
> > > Group Program Manager
> > > SQL Server Reporting Services
> > >
> > > This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> > >
> > > "Dennis Redfield" <dennis.redfield@.acadia-ins.com> wrote in message
> > > news:u%23hSrFWgEHA.4092@.TK2MSFTNGP10.phx.gbl...
> > > > OK, I am looking for help on how to break this problem up for
> debugging.
> > > > I
> > > > am testing Email report schedules. We are working with files of
type:
> > > > TIF,PDF & EXCEL. I am able to schedule rendering reports to a FILE
> > SHARE
> > > > successfully. I am able to email LINKS to reports successfully.
When
> I
> > > > send files of these three types as Email ATTACHMENTS they arrive
> > corupted.
> > > > The HEX dump is really ugly. Mostly FF bytes... I am passing from
RS
> > to
> > > > a
> > > > SMTP server is external to the RS server, which then passes the
> reports
> > > > to
> > > > a NOTES server and then to me. The log file for RS shows nothing
> > unusual.
> > > > How would you approach debuging this issue?
> > > >
> > > > thanks.
> > > >
> > > > dlr
> > > >
> > > >
> > >
> > >
> >
> >
>|||What exactly are you seeing? Can you create the subscriptions? Do they
never fire?
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Carlos E. Mosquera" <CarlosEMosquera@.discussions.microsoft.com> wrote in
message news:D7BDCEF4-6090-49AD-A937-42A26EE9C192@.microsoft.com...
> Hi Dennis,
> We install this fix and now can't send any subscriptions.
> How you install this fix?
> Do you have some other problem when you isntall it?
> Thanks.
> "Dennis Redfield" wrote:
> > ok. thanks for the tip. HOTFix resolved all problems with a single
> > exception. WEB ARCHIVES are still not working in notes (works fine with
> > hotmail/outlook express) We are at v5.0.9 on Notes. Perhaps upgrading
NOTES
> > will resolve this last problem?....
> >
> > dlr
> >
> > "Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in message
> > news:%236gRNPqgEHA.384@.TK2MSFTNGP10.phx.gbl...
> > > You can now download a hotfix that addresses this problem. See
> > > http://support.microsoft.com/default.aspx?scid=kb;[LN];872774.
> > >
> > > --
> > > Brian Welcker
> > > Group Program Manager
> > > SQL Server Reporting Services
> > >
> > > This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> > >
> > > "Dennis Redfield" <dennis.redfield@.acadia-ins.com> wrote in message
> > > news:u%23hSrFWgEHA.4092@.TK2MSFTNGP10.phx.gbl...
> > > > OK, I am looking for help on how to break this problem up for
debugging.
> > > > I
> > > > am testing Email report schedules. We are working with files of
type:
> > > > TIF,PDF & EXCEL. I am able to schedule rendering reports to a FILE
> > SHARE
> > > > successfully. I am able to email LINKS to reports successfully.
When I
> > > > send files of these three types as Email ATTACHMENTS they arrive
> > corupted.
> > > > The HEX dump is really ugly. Mostly FF bytes... I am passing from
RS
> > to
> > > > a
> > > > SMTP server is external to the RS server, which then passes the
reports
> > > > to
> > > > a NOTES server and then to me. The log file for RS shows nothing
> > unusual.
> > > > How would you approach debuging this issue?
> > > >
> > > > thanks.
> > > >
> > > > dlr|||After fix install i subscriptions show this error:
Failure sending mail: The Report Server has encountered a configuration
error; more details in the log files
But before install subscriptions work with files formats errors.
Configuration was no touched and we have RS with SP1 + 872774
How log file i should check?
"Daniel Reib [MSFT]" wrote:
> What exactly are you seeing? Can you create the subscriptions? Do they
> never fire?
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.|||This is the log (Fideicomiso is the report name):
ReportingServicesService!dbpolling!234!9/8/2004-16:30:03:: EventPolling
processing 1 more items. 1 Total items in internal queue.
ReportingServicesService!dbpolling!3844!9/8/2004-16:30:03:: EventPolling
processing item 4a28e564-b3d6-491d-826c-96a9926daf72
ReportingServicesService!library!3844!9/8/2004-16:30:03:: Schedule
a58e2b9e-782b-4589-b6c2-b920bf754c9e executed at 9/8/2004 4:30:03 PM.
ReportingServicesService!schedule!3844!9/8/2004-16:30:03:: Creating Time
based subscription notification for subscription:
4683f97c-9125-4f74-bb1c-5804303e7a54
ReportingServicesService!library!3844!9/8/2004-16:30:03:: Schedule
a58e2b9e-782b-4589-b6c2-b920bf754c9e execution completed at 9/8/2004 4:30:03
PM.
ReportingServicesService!dbpolling!3844!9/8/2004-16:30:03:: EventPolling
finished processing item 4a28e564-b3d6-491d-826c-96a9926daf72
ReportingServicesService!dbpolling!234!9/8/2004-16:30:03::
NotificationPolling processing 1 more items. 1 Total items in internal queue.
ReportingServicesService!dbpolling!3844!9/8/2004-16:30:03::
NotificationPolling processing item b8c2e7c5-0d9a-460b-b17d-e064f36198e7
ReportingServicesService!library!3844!09/08/2004-16:30:03:: i INFO:
Initializing EnableIntegratedSecurity to 'True' as specified in Server
system properties.
ReportingServicesService!library!3844!09/08/2004-16:30:04:: i INFO: Call to
RenderFirst( '/ReportSystem/Fideicomisos' )
ReportingServicesService!library!3844!09/08/2004-16:30:04:: 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!3844!09/08/2004-16:30:04:: i INFO:
Initializing EnableExecutionLogging to 'True' as specified in Server system
properties.
ReportingServicesService!emailextension!3844!09/08/2004-16:30:04:: 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!3844!09/08/2004-16:30:04::
Notification b8c2e7c5-0d9a-460b-b17d-e064f36198e7 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: Fideicomisos, Attempt 0
ReportingServicesService!dbpolling!3844!09/08/2004-16:30:04::
NotificationPolling finished processing item
b8c2e7c5-0d9a-460b-b17d-e064f36198e7
"Carlos E. Mosquera" wrote:
> After fix install i subscriptions show this error:
> Failure sending mail: The Report Server has encountered a configuration
> error; more details in the log files
> But before install subscriptions work with files formats errors.
> Configuration was no touched and we have RS with SP1 + 872774
> How log file i should check?
> "Daniel Reib [MSFT]" wrote:
> > What exactly are you seeing? Can you create the subscriptions? Do they
> > never fire?
> >
> > --
> > -Daniel
> > This posting is provided "AS IS" with no warranties, and confers no rights.|||The error you are getting is: The specified domain either does not exist or
could not be contacted.
This is indicating a problem resolving the name of the owner of the
subscription. Can you try recreating the subscription and see if the new
subscription works? Also, does this happen with all users? What about a
user local to the report server box?
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Carlos E. Mosquera" <CarlosEMosquera@.discussions.microsoft.com> wrote in
message news:F05D7D1B-BFAB-428B-9445-E3E640E0BDDE@.microsoft.com...
> This is the log (Fideicomiso is the report name):
> ReportingServicesService!dbpolling!234!9/8/2004-16:30:03:: EventPolling
> processing 1 more items. 1 Total items in internal queue.
> ReportingServicesService!dbpolling!3844!9/8/2004-16:30:03:: EventPolling
> processing item 4a28e564-b3d6-491d-826c-96a9926daf72
> ReportingServicesService!library!3844!9/8/2004-16:30:03:: Schedule
> a58e2b9e-782b-4589-b6c2-b920bf754c9e executed at 9/8/2004 4:30:03 PM.
> ReportingServicesService!schedule!3844!9/8/2004-16:30:03:: Creating Time
> based subscription notification for subscription:
> 4683f97c-9125-4f74-bb1c-5804303e7a54
> ReportingServicesService!library!3844!9/8/2004-16:30:03:: Schedule
> a58e2b9e-782b-4589-b6c2-b920bf754c9e execution completed at 9/8/2004
4:30:03
> PM.
> ReportingServicesService!dbpolling!3844!9/8/2004-16:30:03:: EventPolling
> finished processing item 4a28e564-b3d6-491d-826c-96a9926daf72
> ReportingServicesService!dbpolling!234!9/8/2004-16:30:03::
> NotificationPolling processing 1 more items. 1 Total items in internal
queue.
> ReportingServicesService!dbpolling!3844!9/8/2004-16:30:03::
> NotificationPolling processing item b8c2e7c5-0d9a-460b-b17d-e064f36198e7
> ReportingServicesService!library!3844!09/08/2004-16:30:03:: i INFO:
> Initializing EnableIntegratedSecurity to 'True' as specified in Server
> system properties.
> ReportingServicesService!library!3844!09/08/2004-16:30:04:: i INFO: Call
to
> RenderFirst( '/ReportSystem/Fideicomisos' )
> ReportingServicesService!library!3844!09/08/2004-16:30:04:: e ERROR:
> Throwing
>
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorEx
ception:
> The Report Server has encountered a configuration error; more details in
the
> log files, AuthzInitializeContextFromSid: Win32 error: 1355;
> Info:
>
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorEx
ception:
> The Report Server has encountered a configuration error; more details in
the
> log files
> ReportingServicesService!library!3844!09/08/2004-16:30:04:: i INFO:
> Initializing EnableExecutionLogging to 'True' as specified in Server
system
> properties.
> ReportingServicesService!emailextension!3844!09/08/2004-16:30:04:: 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.ServerConfigurationErrorEx
ception:
> The Report Server has encountered a configuration error; more details in
the
> log files
> at
>
Microsoft.ReportingServices.Authorization.Native.GetAuthzContextForUser(IntP
tr userSid)
> at Microsoft.ReportingServices.Authorization.Native.IsAdmin(String
> userName)
> at
>
Microsoft.ReportingServices.Authorization.WindowsAuthorization.IsAdmin(Strin
g
> userName, IntPtr userToken)
> at
>
Microsoft.ReportingServices.Authorization.WindowsAuthorization.CheckAccess(S
tring
> userName, IntPtr userToken, Byte[] secDesc, ReportOperation
requiredOperation)
> at Microsoft.ReportingServices.Library.Security.CheckAccess(ItemType
> catItemType, Byte[] secDesc, ReportOperation rptOper)
> at
>
Microsoft.ReportingServices.Library.RSService._GetReportParameterDefinitionF
romCatalog(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(Catalog
ItemContext
> 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(RS
Service
> 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.ConstructMes
sageBody(IMessage message, Notification notification, SubscriptionData data)
> at
>
Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.CreateMessag
e(Notification notification)
> at
>
Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.Deliver(Noti
fication notification)
> ReportingServicesService!notification!3844!09/08/2004-16:30:04::
> Notification b8c2e7c5-0d9a-460b-b17d-e064f36198e7 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: Fideicomisos, Attempt 0
> ReportingServicesService!dbpolling!3844!09/08/2004-16:30:04::
> NotificationPolling finished processing item
> b8c2e7c5-0d9a-460b-b17d-e064f36198e7
>
> "Carlos E. Mosquera" wrote:
> > After fix install i subscriptions show this error:
> >
> > Failure sending mail: The Report Server has encountered a configuration
> > error; more details in the log files
> >
> > But before install subscriptions work with files formats errors.
> >
> > Configuration was no touched and we have RS with SP1 + 872774
> >
> > How log file i should check?
> >
> > "Daniel Reib [MSFT]" wrote:
> >
> > > What exactly are you seeing? Can you create the subscriptions? Do
they
> > > never fire?
> > >
> > > --
> > > -Daniel
> > > This posting is provided "AS IS" with no warranties, and confers no
rights.|||Hi Daniel,
Daniel Reib [MSFT] wrote:
> The error you are getting is: The specified domain either does not
> exist or could not be contacted.
> This is indicating a problem resolving the name of the owner of the
> subscription. Can you try recreating the subscription and see if the
> new subscription works? Also, does this happen with all users? What
> about a user local to the report server box?
PMFJI, but I am having the same issue as Carlos. Everything worked fine
with subscriptions with RS SP1, but I was having the issue of Lotus Notes
users not being able to open PDF attachments, so I installed the hotfix
872774. Now I'm unable to send any emails from RS (no matter what user I
create the subscription under). I'm running Windows 2003 Server, SQL Server
2000 SP3a, and RS SP1 w/872774 hotfix. I started a thread on 9/8/2004 at
8:25am PDT which shows the log file entries, but I didn't get a response
except from Carlos. Any ideas? Thanks!
--
Regards,
Jake Marx
MS MVP - Excel
www.longhead.com
[please keep replies in the newsgroup - email address unmonitored]|||This is very strange. I am not sure what is going on. Are you also
receiving the 1355 error?
It may be best for you to contact PSS to try and find a resolution for this.
I am not sure why installing the hotfix would cause these problems.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Jake Marx" <msnews@.longhead.com> wrote in message
news:#8K95hnlEHA.1652@.TK2MSFTNGP09.phx.gbl...
> Hi Daniel,
> Daniel Reib [MSFT] wrote:
> > The error you are getting is: The specified domain either does not
> > exist or could not be contacted.
> >
> > This is indicating a problem resolving the name of the owner of the
> > subscription. Can you try recreating the subscription and see if the
> > new subscription works? Also, does this happen with all users? What
> > about a user local to the report server box?
> PMFJI, but I am having the same issue as Carlos. Everything worked fine
> with subscriptions with RS SP1, but I was having the issue of Lotus Notes
> users not being able to open PDF attachments, so I installed the hotfix
> 872774. Now I'm unable to send any emails from RS (no matter what user I
> create the subscription under). I'm running Windows 2003 Server, SQL
Server
> 2000 SP3a, and RS SP1 w/872774 hotfix. I started a thread on 9/8/2004 at
> 8:25am PDT which shows the log file entries, but I didn't get a response
> except from Carlos. Any ideas? Thanks!
> --
> Regards,
> Jake Marx
> MS MVP - Excel
> www.longhead.com
> [please keep replies in the newsgroup - email address unmonitored]
>|||Hi Daniel,
Daniel Reib [MSFT] wrote:
> This is very strange. I am not sure what is going on. Are you also
> receiving the 1355 error?
Yes - here's a snippet from my log file:
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorEx
ception: The Report Server has encountered a configuration error; more
details in the log files, AuthzInitializeContextFromSid: Win32 error: 1355;
> It may be best for you to contact PSS to try and find a resolution
> for this. I am not sure why installing the hotfix would cause these
> problems.
Thanks - I'll try contacting PSS to see if they can shed some light on this.
I'd like to resolve this without having to roll back to SP1, as I have a
client that needs PDF attachments sent from RS and she's on Lotus Notes.
--
Regards,
Jake Marx
MS MVP - Excel
www.longhead.com
[please keep replies in the newsgroup - email address unmonitored]|||Hi
Finaly my server administrator try another way to avoid reinstall of RS and
everything work fine. He check every single configuration and all was
complete.
My principal server have SQL Server 2000 Ent. + SP3 and RS + SP1 in a
Windows 2003 Server, then we try use RS with another server with Windows 2000
Server SP4 with IIS 5 and Framework 1.1 (WITHOUT FIX 872774)
GUESS WHAT? Now all subscriptions work fine with same SMTP and
subscriptors use Lotus Notes 6.5.1 (and 6.5.2) and any files corrupted.
This experience tell me something... Windows 2003 Server will have something
wrong.
Thanks a lot for all your help and contributions.
"Daniel Reib [MSFT]" wrote:
> The error you are getting is: The specified domain either does not exist or
> could not be contacted.
>
> This is indicating a problem resolving the name of the owner of the
> subscription. Can you try recreating the subscription and see if the new
> subscription works? Also, does this happen with all users? What about a
> user local to the report server box?
>
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.|||Carlos,
Carlos E. Mosquera wrote:
> My principal server have SQL Server 2000 Ent. + SP3 and RS + SP1 in a
> Windows 2003 Server, then we try use RS with another server with
> Windows 2000 Server SP4 with IIS 5 and Framework 1.1 (WITHOUT FIX
> 872774)
> GUESS WHAT? Now all subscriptions work fine with same SMTP and
> subscriptors use Lotus Notes 6.5.1 (and 6.5.2) and any files
> corrupted.
> This experience tell me something... Windows 2003 Server will have
> something wrong.
I was working with PSS on this issue, but I ran out of time and options. I
never got it working under Windows Server 2003 with the hotfix applied. And
I was unsuccessful at getting it to work even after attempting to roll back
to RS SP1.
So I ended up doing the same thing - reformatting, installing Windows 2000
Server, installing RS, and installing RS SP1 - but I continued by installing
the hotfix as well. Guess what - works great now. I haven't had a Lotus
Notes client open the attachment yet, but hopefully it will work.
I did get an email today from the PSS rep assigned to my case. I think she
is leaning toward this being a Windows Server 2003 issue that happens to
cause problems for RS with the hotfix applied. Here's the article she
provided in case anyone else runs into this issue:
http://support.microsoft.com/?id=834859
I wish I still had 2003 installed so I could request this hotfix and test it
out. It does look promising.
--
Regards,
Jake Marx
MS MVP - Excel
www.longhead.com
[please keep replies in the newsgroup - email address unmonitored]|||The hotfix actually fixed a similiar issue of ours:
Server A: Window 2003
Reporting Server: SP1 8.00.878.00
Issue: Excel Subscription Email Attachment Corrupted
Email Server: Novell Netware
Our two other environments/servers do not have problem:
Server B: Windows 2000
Reporting Server: RTM 8.00.743.00
Server C: Windows 2000
Reporting Server: SP1 8.00.878.00
So I think there is something to do with Windows2003 and Non-Exchange mail
server?
Tao
"Brian Welcker [MSFT]" wrote:
> You can now download a hotfix that addresses this problem. See
> http://support.microsoft.com/default.aspx?scid=kb;[LN];872774.
> --
> Brian Welcker
> Group Program Manager
> SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "Dennis Redfield" <dennis.redfield@.acadia-ins.com> wrote in message
> news:u%23hSrFWgEHA.4092@.TK2MSFTNGP10.phx.gbl...
> > OK, I am looking for help on how to break this problem up for debugging.
> > I
> > am testing Email report schedules. We are working with files of type:
> > TIF,PDF & EXCEL. I am able to schedule rendering reports to a FILE SHARE
> > successfully. I am able to email LINKS to reports successfully. When I
> > send files of these three types as Email ATTACHMENTS they arrive corupted.
> > The HEX dump is really ugly. Mostly FF bytes... I am passing from RS to
> > a
> > SMTP server is external to the RS server, which then passes the reports
> > to
> > a NOTES server and then to me. The log file for RS shows nothing unusual.
> > How would you approach debuging this issue?
> >
> > thanks.
> >
> > dlr
> >
> >
>
>