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
>

Embedding PDF Document

Does reporting services allow emdedding of PDF documents? I dont want to convert the document to JPEG as the size increases many times (for me the image size is around 1.6MB vs. 100KB for PDF) and i have several of these images. Would appreciate if anyone has done similar exercise to embed document within reports.
thanks !!Not sure what we would really embed it in? HTML isn't really a format that
supports embedding. You can embed docs in e-mail messages as well as link to
docs on a web page. I suppose we could have an MHTML format that embedded a
PDF file but this hasn't been high on the priority list.
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Ashok Jain" <Ashok Jain@.discussions.microsoft.com> wrote in message
news:0D468114-DF97-4800-ADB8-411D1C362954@.microsoft.com...
> Does reporting services allow emdedding of PDF documents? I dont want to
> convert the document to JPEG as the size increases many times (for me the
> image size is around 1.6MB vs. 100KB for PDF) and i have several of these
> images. Would appreciate if anyone has done similar exercise to embed
> document within reports.
> thanks !!|||But where is the PDF document stored? You can't 'embed' documents in a web
page. Can you just link to the document on a web site from the report? You
could even store the PDF in the Report Server database and link to it.
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Ashok Jain" <AshokJain@.discussions.microsoft.com> wrote in message
news:111C7F98-B8FF-4F7A-AF74-E14F9EE1650E@.microsoft.com...
> Thanks Brian !
> The issue I have is that I need to embed pre-generated PDF documents into
> the report and I am not sure how can I do that unless I convert the PDF
> into JPEG and then use the IMAGE control to embed. This works fine -
> however the size increase makes the report useless. For example, a 100KB
> PDF becomes 1.6MB JPEG file and you can imagine the generate and print
> pains if I have 10-20 of those images.
> Would love to have the feature where PDF or WORD docs can be imported into
> report pages -- is there an alternative like may be using a 3rd party
> activex or something like that?
> thanks again,
> Ashok
>
>
> "Brian Welcker [MSFT]" wrote:
>> Not sure what we would really embed it in? HTML isn't really a format
>> that
>> supports embedding. You can embed docs in e-mail messages as well as link
>> to
>> docs on a web page. I suppose we could have an MHTML format that embedded
>> a
>> PDF file but this hasn't been high on the priority list.
>> --
>> Brian Welcker
>> Group Program Manager
>> SQL Server Reporting Services
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>> "Ashok Jain" <Ashok Jain@.discussions.microsoft.com> wrote in message
>> news:0D468114-DF97-4800-ADB8-411D1C362954@.microsoft.com...
>> > Does reporting services allow emdedding of PDF documents? I dont want
>> > to
>> > convert the document to JPEG as the size increases many times (for me
>> > the
>> > image size is around 1.6MB vs. 100KB for PDF) and i have several of
>> > these
>> > images. Would appreciate if anyone has done similar exercise to embed
>> > document within reports.
>> >
>> > thanks !!
>>

Embedding HTML in a Report

Does anyone know of a time frame on when SQL 2005 Reporting Services
will be able to handle the embedding of HTML into a report? I saw on
an old post that it is was supposed to be released in a follow on SP.
Does anyone have suggestions in displaying HTML into a field in a
report beyond converting it to an image first?On Apr 18, 4:17 pm, cara...@.gmail.com wrote:
> Does anyone know of a time frame on when SQL 2005 Reporting Services
> will be able to handle the embedding of HTML into a report? I saw on
> an old post that it is was supposed to be released in a follow on SP.
> Does anyone have suggestions in displaying HTML into a field in a
> report beyond converting it to an image first?
In terms of the time frame, I'm not sure; however, you could try a
workaround of using the Jump to URL property of a report control.
Sorry I could not be of greater assistance.
Regards,
Enrique Martinez
Sr. Software Consultant|||On Apr 19, 6:50 am, EMartinez <emartinez...@.gmail.com> wrote:
> On Apr 18, 4:17 pm, cara...@.gmail.com wrote:
> > Does anyone know of a time frame on whenSQL2005 Reporting Services
> > will be able to handle theembeddingofHTMLinto areport? I saw on
> > an old post that it is was supposed to be released in a follow on SP.
> > Does anyone have suggestions in displayingHTMLinto a field in a
> >reportbeyond converting it to an image first?
> In terms of the time frame, I'm not sure; however, you could try a
> workaround of using the Jump to URL property of areportcontrol.
> Sorry I could not be of greater assistance.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
Where can I find how to do that "Jump to URL" work around?|||On Apr 19, 8:01 am, Mike512 <mmahon...@.gmail.com> wrote:
> On Apr 19, 6:50 am, EMartinez <emartinez...@.gmail.com> wrote:
>
> > On Apr 18, 4:17 pm, cara...@.gmail.com wrote:
> > > Does anyone know of a time frame on whenSQL2005 Reporting Services
> > > will be able to handle theembeddingofHTMLinto areport? I saw on
> > > an old post that it is was supposed to be released in a follow on SP.
> > > Does anyone have suggestions in displayingHTMLinto a field in a
> > >reportbeyond converting it to an image first?
> > In terms of the time frame, I'm not sure; however, you could try a
> > workaround of using the Jump to URL property of areportcontrol.
> > Sorry I could not be of greater assistance.
> > Regards,
> > Enrique Martinez
> > Sr. Software Consultant
> Where can I find how to do that "Jump to URL" work around?
First you will want to deploy the HTML file to the webserver/IIS so
that a hyperlink can access it.
Then, depending on how you want to do it, add a report control (table/
image/textbox) to the report in Layout view, select the Properties
(via right-click), select the Navigation tab, and below 'Hyperlink
action:' select Jump to URL and enter in the URL of the newly deployed
HTML file (i.e., http://localhost/SomeVirtualDirectoryName/HTMLFileName.html).
Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||One other option is to have dotnet code (behind report or an assembly) that
strips the html control characters from the text.
I haven't done this but I know that people have done this.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Mike512" <mmahon512@.gmail.com> wrote in message
news:1176987680.073062.65410@.d57g2000hsg.googlegroups.com...
> On Apr 19, 6:50 am, EMartinez <emartinez...@.gmail.com> wrote:
>> On Apr 18, 4:17 pm, cara...@.gmail.com wrote:
>> > Does anyone know of a time frame on whenSQL2005 Reporting Services
>> > will be able to handle theembeddingofHTMLinto areport? I saw on
>> > an old post that it is was supposed to be released in a follow on SP.
>> > Does anyone have suggestions in displayingHTMLinto a field in a
>> >reportbeyond converting it to an image first?
>> In terms of the time frame, I'm not sure; however, you could try a
>> workaround of using the Jump to URL property of areportcontrol.
>> Sorry I could not be of greater assistance.
>> Regards,
>> Enrique Martinez
>> Sr. Software Consultant
> Where can I find how to do that "Jump to URL" work around?
>|||Thanks for the reply. At first I was trying to retain the HTML in the report
then I just decided to scrap it. So I did that by adding this function:
This was taken from this guy and convert to VB:
http://weblogs.asp.net/rosherove/archive/2003/05/13/6963.aspx
To call the function in the Expression Editor of the textbox just use:
=Code.StripHTML(Fields!<whateverfieldyouwanttostriphtmlfrom>.Value)
I hope this helps someone just trying to strip the HTML out since MS hasn't
hacked out a friggin control to render it.
Cheers,
Mike
"EMartinez" wrote:
> On Apr 19, 8:01 am, Mike512 <mmahon...@.gmail.com> wrote:
> > On Apr 19, 6:50 am, EMartinez <emartinez...@.gmail.com> wrote:
> >
> >
> >
> > > On Apr 18, 4:17 pm, cara...@.gmail.com wrote:
> >
> > > > Does anyone know of a time frame on whenSQL2005 Reporting Services
> > > > will be able to handle theembeddingofHTMLinto areport? I saw on
> > > > an old post that it is was supposed to be released in a follow on SP.
> > > > Does anyone have suggestions in displayingHTMLinto a field in a
> > > >reportbeyond converting it to an image first?
> >
> > > In terms of the time frame, I'm not sure; however, you could try a
> > > workaround of using the Jump to URL property of areportcontrol.
> > > Sorry I could not be of greater assistance.
> >
> > > Regards,
> >
> > > Enrique Martinez
> > > Sr. Software Consultant
> >
> > Where can I find how to do that "Jump to URL" work around?
> First you will want to deploy the HTML file to the webserver/IIS so
> that a hyperlink can access it.
> Then, depending on how you want to do it, add a report control (table/
> image/textbox) to the report in Layout view, select the Properties
> (via right-click), select the Navigation tab, and below 'Hyperlink
> action:' select Jump to URL and enter in the URL of the newly deployed
> HTML file (i.e., http://localhost/SomeVirtualDirectoryName/HTMLFileName.html).
> Hope this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>|||> Does anyone have suggestions in displaying HTML into a field in a
> report beyond converting it to an image first?
Yes, I do. But I'm going to start sounding like a broken record <g>.
You can do this by taking the XML output and applying an XSLT to it! It's
really up to you to decide how the HTML output looks, not what they decided
to provide as an HTML presentation.
The catch here would be how you wanted to display that report in other
formats, such as PDF. You can write XSLT to go to (say) rich text or post
script or use XSL:FO.
But you're still going to have to manage the impedance mismatch between the
HTML formatting you're trying to reproduce and these other formats. That's
why "converting to an image" makes sense to a lot of people -- it's not the
HTML display that's the problem, it's the multiple output targets that have
to render that HTML field.
HTML, almost by definition, mixes formatting and content. That's why it's a
PITA for any reporting engine with multiple output targets. You have to
separate the two and then translate the formatting so you can apply it to
the content as appropriate to the current target.
>L<
<caragav@.gmail.com> wrote in message
news:1176931060.300151.199480@.y5g2000hsa.googlegroups.com...
> Does anyone know of a time frame on when SQL 2005 Reporting Services
> will be able to handle the embedding of HTML into a report? I saw on
> an old post that it is was supposed to be released in a follow on SP.
> Does anyone have suggestions in displaying HTML into a field in a
> report beyond converting it to an image first?
>

Embedding a reporting Services object

Hi,
Can I embedde a reporting services object in my web based application so the
clients can use the reporting seemlessly.
Thanks in advance,
BenjaminYes, you can. Take a look at the ReportViewer sample that Microsoft
includes.
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"BenJ" <BenJ@.netvu.com> wrote in message
news:O3XVHB4HFHA.2456@.TK2MSFTNGP09.phx.gbl...
> Hi,
> Can I embedde a reporting services object in my web based application so
> the
> clients can use the reporting seemlessly.
> Thanks in advance,
> Benjamin
>|||Check this example
http://www.rdlcomponents.com/ASPExamples/default.aspx
"Jeff A. Stucker" wrote:
> Yes, you can. Take a look at the ReportViewer sample that Microsoft
> includes.
> --
> Cheers,
> '(' Jeff A. Stucker
> \
> Business Intelligence
> www.criadvantage.com
> ---
> "BenJ" <BenJ@.netvu.com> wrote in message
> news:O3XVHB4HFHA.2456@.TK2MSFTNGP09.phx.gbl...
> > Hi,
> >
> > Can I embedde a reporting services object in my web based application so
> > the
> > clients can use the reporting seemlessly.
> >
> > Thanks in advance,
> > Benjamin
> >
> >
>
>

Embedded Word Document in RDL

I have a word document that I would to migrate to reporting services
2005. Instead of recreating the word document in reporting services, I
would like to know if I can embed the word document in a report? If
not, what other options are there?
Thanks.If you would like the word document to be hosted by RS then in your project
add a new existing item and then select your Word file. Then you can deploy
it. Note that when you update it and want to redeploy I have found that I
have to delete it from the report server first prior to deployment.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"TCogan" <tcogan@.starcon.org> wrote in message
news:1174500858.861820.168170@.y66g2000hsf.googlegroups.com...
>I have a word document that I would to migrate to reporting services
> 2005. Instead of recreating the word document in reporting services, I
> would like to know if I can embed the word document in a report? If
> not, what other options are there?
> Thanks.
>|||On Mar 21, 1:45 pm, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
wrote:
> If you would like the word document to be hosted by RS then in your project
> add a new existing item and then select your Word file. Then you can deploy
> it. Note that when you update it and want to redeploy I have found that I
> have to delete it from the report server first prior to deployment.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "TCogan" <tco...@.starcon.org> wrote in message
> news:1174500858.861820.168170@.y66g2000hsf.googlegroups.com...
>
> >I have a word document that I would to migrate to reporting services
> > 2005. Instead of recreating the word document in reporting services, I
> > would like to know if I can embed the word document in a report? If
> > not, what other options are there?
> > Thanks.- Hide quoted text -
> - Show quoted text -
I have tried that and that does work. But I was trying to find the
best way to migrate the word document into an RDL file. I want it to
be an RDL file because I have some other data that I want to
incorporate into the report from a database. I am not sure this can
be done, but I would like to avoid from having to recreate the word
document in an RDL file.|||There might be a third party tool that allows this but not straight out of
the box.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"TCogan" <tcogan@.starcon.org> wrote in message
news:1174503465.010122.233220@.p15g2000hsd.googlegroups.com...
> On Mar 21, 1:45 pm, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
> wrote:
>> If you would like the word document to be hosted by RS then in your
>> project
>> add a new existing item and then select your Word file. Then you can
>> deploy
>> it. Note that when you update it and want to redeploy I have found that I
>> have to delete it from the report server first prior to deployment.
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "TCogan" <tco...@.starcon.org> wrote in message
>> news:1174500858.861820.168170@.y66g2000hsf.googlegroups.com...
>>
>> >I have a word document that I would to migrate to reporting services
>> > 2005. Instead of recreating the word document in reporting services, I
>> > would like to know if I can embed the word document in a report? If
>> > not, what other options are there?
>> > Thanks.- Hide quoted text -
>> - Show quoted text -
> I have tried that and that does work. But I was trying to find the
> best way to migrate the word document into an RDL file. I want it to
> be an RDL file because I have some other data that I want to
> incorporate into the report from a database. I am not sure this can
> be done, but I would like to avoid from having to recreate the word
> document in an RDL file.
>

Embedded Images Not Displaying properly

Hi,

I have a question which i hope someone can help with. When using an embedded image stored on a server in my reporting services report i can see it when proeviewing the report but when it is deployed it no longer is shown on the report. If i try this with an image stored on my local drive it works fine in both preview and deployed mode.

I am wondering why this could be? My initial thoughts are that the security on the file stored on the server may not allow access when the report is run in a deployed state yet it is accessible to the report developper as they have access to the server directory. Does this sound feasible and if not can someone let me know as to why this may not work.

Many thanks,

Grant

Grant,

if you point to the picture just as an resource you should also publish the picture to the proper RS folder like the report.

Or use a web link which should be a "public" one and has to be accessible by every User using RS.

cheers,
Markus

Embedded HTML in RS 2005?

Reporting Services is a great product, especially considering that is a 1.x
release. Unfortunately, not being able to render embedded HTML (in report
data) is a serious limitation. This is a critical need for our business.
I would like to know from a MSFT source if this will be supported in SQL
Server 2005? What is the timeframe for this?
Thanks,
Jeremy Carter
ING Investment ManagementWe are aware that embedded rich text is very important for many of our
customers. However we didn't have time to add this in SQL Server 2005
Reporting Services. This will be added in a future version.
--
Rajeev Karunakaran [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"JerC" <JerC@.discussions.microsoft.com> wrote in message
news:1E2BB6D8-2A77-4616-A578-879C33F2DABA@.microsoft.com...
> Reporting Services is a great product, especially considering that is a
> 1.x
> release. Unfortunately, not being able to render embedded HTML (in report
> data) is a serious limitation. This is a critical need for our business.
> I would like to know from a MSFT source if this will be supported in SQL
> Server 2005? What is the timeframe for this?
> Thanks,
> Jeremy Carter
> ING Investment Management
>

embed barcode in pdf

We export a report (pdf format) from Reporting Services that contains
barcodes. If someone tries to view the pdf on a computer that doesn't have
the barcode font loaded it doesn't show up. Is there a way to embed the
barcode image in the pdf?
Thanks,
TimPerhaps someone else will jump in but I am pretty sure there is no way to
embed the font in RS 2005.
RS 2008 will have barcode support (part of the Dundas controls that
Microsoft purchased and is including in RS 2008). This support will allow
you to get around this problem. Today your only choice is to have anyone
that needs to print barcodes to have the font on their machine.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Tim Kelley" <tkelley@.company.com> wrote in message
news:u4W0JmwpIHA.4292@.TK2MSFTNGP04.phx.gbl...
> We export a report (pdf format) from Reporting Services that contains
> barcodes. If someone tries to view the pdf on a computer that doesn't
> have the barcode font loaded it doesn't show up. Is there a way to embed
> the barcode image in the pdf?
> Thanks,
> Tim
>

Emails Are Being Lost - Not Sent

I am running SQL Server 2000 Reporting Services SP2.
I have data driven subscriptions that are being logged in the
reporting services logs as being emailed successfully, but there is no
record of them in the email server logs. Only some of the recipeints
are not receiving the emails - most of them do go through succesfully.
Has anyone else experienced anything like this? Where should I look?I'm experiencing pretty much the same problem. I've got a few subscriptions
scheduled on a Windows 2000 SP4 Server with Reporting Services Enterprise
version 8.0.1038.00 that are displayed as successfully delivered, but there
is no trace of the emails being sent. If I restart the ReportServer service
and reschedule the subscription, it runs and the email is successfully
delivered, but I'm not sure why the subscriptions are failing. Anyone
experience this or have a resolution?
Thanks,
Derek
"leppes@.fei.org" wrote:
> I am running SQL Server 2000 Reporting Services SP2.
> I have data driven subscriptions that are being logged in the
> reporting services logs as being emailed successfully, but there is no
> record of them in the email server logs. Only some of the recipeints
> are not receiving the emails - most of them do go through succesfully.
> Has anyone else experienced anything like this? Where should I look?
>

e-mailing reports and refreshing reports automatically

Hello:
I know that you can e-mail SQL Reporting Services reports. But, can the
reports be configured to refresh their data automatically and be e-mailed to
users automatically with the refreshed data?
Or, would someone have to go into SQL Reporting Services, manually refresh,
and manually e-mail the reports?
Thanks!
childofthe1980sOrdinarily, this is automatic. Unless you tell a report to pull from a
stored snapshot, it is running your queries and re-pulling the data
automatically each time the report is run...
Maybe I misunderstand your question?
>L<
"childofthe1980s" <childofthe1980s@.discussions.microsoft.com> wrote in
message news:1303F3AC-1430-46BB-ADF4-17FA3FE03798@.microsoft.com...
> Hello:
> I know that you can e-mail SQL Reporting Services reports. But, can the
> reports be configured to refresh their data automatically and be e-mailed
> to
> users automatically with the refreshed data?
> Or, would someone have to go into SQL Reporting Services, manually
> refresh,
> and manually e-mail the reports?
> Thanks!
> childofthe1980s|||Well, what I meant is have SQL refresh reports and e-mail the results
automatically behind the scenes without user intervention.
Thanks!
childofthe1980s
"Lisa Slater Nicholls" wrote:
> Ordinarily, this is automatic. Unless you tell a report to pull from a
> stored snapshot, it is running your queries and re-pulling the data
> automatically each time the report is run...
> Maybe I misunderstand your question?
> >L<
> "childofthe1980s" <childofthe1980s@.discussions.microsoft.com> wrote in
> message news:1303F3AC-1430-46BB-ADF4-17FA3FE03798@.microsoft.com...
> > Hello:
> >
> > I know that you can e-mail SQL Reporting Services reports. But, can the
> > reports be configured to refresh their data automatically and be e-mailed
> > to
> > users automatically with the refreshed data?
> >
> > Or, would someone have to go into SQL Reporting Services, manually
> > refresh,
> > and manually e-mail the reports?
> >
> > Thanks!
> >
> > childofthe1980s
>|||Then, like I said, this is the way it works <s>. You don't have to
"intervene". Unless you *told* the report to hold a static snapshot, it
*always* pulls the data live, at each subscription run instance.
>L<
"childofthe1980s" <childofthe1980s@.discussions.microsoft.com> wrote in
message news:8BDC82B6-1B23-452E-A01A-4730069AEF60@.microsoft.com...
> Well, what I meant is have SQL refresh reports and e-mail the results
> automatically behind the scenes without user intervention.
> Thanks!
> childofthe1980s
> "Lisa Slater Nicholls" wrote:
>> Ordinarily, this is automatic. Unless you tell a report to pull from a
>> stored snapshot, it is running your queries and re-pulling the data
>> automatically each time the report is run...
>> Maybe I misunderstand your question?
>> >L<
>> "childofthe1980s" <childofthe1980s@.discussions.microsoft.com> wrote in
>> message news:1303F3AC-1430-46BB-ADF4-17FA3FE03798@.microsoft.com...
>> > Hello:
>> >
>> > I know that you can e-mail SQL Reporting Services reports. But, can
>> > the
>> > reports be configured to refresh their data automatically and be
>> > e-mailed
>> > to
>> > users automatically with the refreshed data?
>> >
>> > Or, would someone have to go into SQL Reporting Services, manually
>> > refresh,
>> > and manually e-mail the reports?
>> >
>> > Thanks!
>> >
>> > childofthe1980s
>>

Emailing and Report Services

I've installed report services and configured the email service by entering a
<smtpserver>192.168.1.100</smtpserver> value and a <from>from@.test.com</from>
value. Then a subscription was made, however no email was sent. I'm using
Windows 2003 a
What kinds of troubleshooting can be done to fix this problem?
Thanks,
JimAdditional Information:
SP1 is installed and the email extension has been configured.
ReportServerService_01_11_2005_15_42_05.log is as shown below. No errors
seen:
<Header>
<Product>Microsoft SQL Server Reporting Services Version
8.00.878.00</Product>
<Locale>en-US</Locale>
<TimeZone>Mountain Standard Time</TimeZone>
<Path>C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\LogFiles\ReportServerService__01_11_2005_15_42_05.log</Path>
<SystemName>MINDSET</SystemName>
<OSName>Microsoft Windows NT 5.2.3790.0</OSName>
<OSVersion>5.2.3790.0</OSVersion>
</Header>
ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
Initializing ConnectionType to '1' as specified in Configuration file.
ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
Initializing IsSchedulingService to 'True' as specified in Configuration
file.
ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
Initializing IsNotificationService to 'True' as specified in Configuration
file.
ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
Initializing IsEventService to 'True' as specified in Configuration file.
ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
Initializing PollingInterval to '10' second(s) as specified in Configuration
file.
ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
Initializing MemoryLimit to '60' percent as specified in Configuration file.
ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
Initializing RecycleTime to '720' minute(s) as specified in Configuration
file.
ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
Initializing MaximumMemoryLimit to '80' percent as specified in Configuration
file.
ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in
Configuration file.
ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
Initializing MaxQueueThreads to '0' thread(s) as specified in Configuration
file.
ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in
Configuration file.
ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
Initializing MaxScheduleWait to '5' second(s) as specified in Configuration
file.
ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
Initializing DatabaseQueryTimeout to '120' second(s) as specified in
Configuration file.
ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
Initializing InstanceName to 'MSSQLSERVER' as specified in Configuration
file.
ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
Initializing ProcessRecycleOptions to '0' as specified in Configuration file.
ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
Initializing RunningRequestsScavengerCycle to '60' second(s) as specified in
Configuration file.
ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
Initializing RunningRequestsDbCycle to '60' second(s) as specified in
Configuration file.
ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
Initializing RunningRequestsAge to '30' second(s) as specified in
Configuration file.
ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
Initializing CleanupCycleMinutes to '10' minute(s) as specified in
Configuration file.
ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
Initializing SecureConnectionLevel to '0' as specified in Configuration file.
ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
Initializing DisplayErrorLink to 'True' as specified in Configuration file.
ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
Initializing WebServiceUseFileShareStorage to default value of 'False'
because it was not specified in Configuration file.
ReportingServicesService!resourceutilities!1250!1/11/2005-15:42:05:: i INFO:
Running on 2 physical processors, 4 logical processors
ReportingServicesService!resourceutilities!1250!1/11/2005-15:42:05:: i INFO:
Reporting Services starting SKU: Developer
ReportingServicesService!runningjobs!1250!1/11/2005-15:42:05:: i INFO:
Database Cleanup (NT Service) timer enabled: Cycle: 600 seconds
ReportingServicesService!runningjobs!1250!1/11/2005-15:42:05:: i INFO:
Running Requests Scavenger timer enabled: Cycle: 60 seconds
ReportingServicesService!runningjobs!1250!1/11/2005-15:42:05:: i INFO:
Running Requests DB timer enabled: Cycle: 60 seconds
ReportingServicesService!runningjobs!1250!1/11/2005-15:42:05:: i INFO:
Execution Log Entry Expiration timer enabled: Cycle: 37074 seconds
ReportingServicesService!runningjobs!1250!1/11/2005-15:42:05:: i INFO:
Memory stats update timer enabled: Cycle: 60 seconds
ReportingServicesService!crypto!dd8!1/11/2005-15:42:06:: i INFO:
Initializing crypto as user: winhealth\Administrator
ReportingServicesService!crypto!dd8!1/11/2005-15:42:06:: i INFO: Exporting
public key
ReportingServicesService!crypto!dd8!1/11/2005-15:42:06:: i INFO: Performing
sku validation
ReportingServicesService!crypto!dd8!1/11/2005-15:42:06:: i INFO: Importing
existing encryption key
ReportingServicesService!dbpolling!dd8!01/11/2005-15:42:06:: EventPolling
polling service started
ReportingServicesService!dbpolling!dd8!01/11/2005-15:42:06::
NotificationPolling polling service started
ReportingServicesService!dbpolling!dd8!01/11/2005-15:42:06:: SchedulePolling
polling service started
ReportingServicesService!dbpolling!12d8!1/11/2005-15:42:06:: EventPolling
heartbeat thread started.
ReportingServicesService!dbpolling!15c0!1/11/2005-15:42:06::
NotificationPolling heartbeat thread started.
ReportingServicesService!dbpolling!6f8!1/11/2005-15:42:06:: Polling started
ReportingServicesService!library!1250!1/11/2005-15:52:05:: i INFO: Cleaned 0
batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
"Jim" wrote:
> I've installed report services and configured the email service by entering a
> <smtpserver>192.168.1.100</smtpserver> value and a <from>from@.test.com</from>
> value. Then a subscription was made, however no email was sent. I'm using
> Windows 2003 a
> What kinds of troubleshooting can be done to fix this problem?
> Thanks,
> Jim
"Jim" wrote:
> I've installed report services and configured the email service by entering a
> <smtpserver>192.168.1.100</smtpserver> value and a <from>from@.test.com</from>
> value. Then a subscription was made, however no email was sent. I'm using
> Windows 2003 a
> What kinds of troubleshooting can be done to fix this problem?
> Thanks,
> Jim|||Error found in ReportServerWebApp:
w3wp!library!fc4!1/11/2005-15:46:38:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
The Report Server has encountered a configuration error; more details in the
log files, ;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
The Report Server has encountered a configuration error; more details in the
log files --> System.Xml.XmlException: There are multiple root elements.
Line 1, position 111.
at System.Xml.XmlTextReader.ParseRoot()
at System.Xml.XmlTextReader.Read()
at System.Xml.XmlValidatingReader.ReadNoCollectTextToken()
at System.Xml.XmlValidatingReader.Read()
at System.Xml.XmlLoader.LoadDocSequence(XmlDocument parentDoc)
at System.Xml.XmlLoader.Load(XmlDocument doc, XmlReader reader, Boolean
preserveWhitespace)
at System.Xml.XmlDocument.Load(XmlReader reader)
at System.Xml.XmlDocument.LoadXml(String xml)
at
Microsoft.ReportingServices.EmailDeliveryProvider.EmailDeliveryProviderControl.SetConfiguration(String configInfo)
-- End of inner exception stack trace --
w3wp!extensionfactory!fc4!1/11/2005-15:46:42:: e ERROR: Exception caught
instantiating report server extension:
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
The Report Server has encountered a configuration error; more details in the
log files --> System.Xml.XmlException: There are multiple root elements.
Line 1, position 111.
at System.Xml.XmlTextReader.ParseRoot()
at System.Xml.XmlTextReader.Read()
at System.Xml.XmlValidatingReader.ReadNoCollectTextToken()
at System.Xml.XmlValidatingReader.Read()
at System.Xml.XmlLoader.LoadDocSequence(XmlDocument parentDoc)
at System.Xml.XmlLoader.Load(XmlDocument doc, XmlReader reader, Boolean
preserveWhitespace)
at System.Xml.XmlDocument.Load(XmlReader reader)
at System.Xml.XmlDocument.LoadXml(String xml)
at
Microsoft.ReportingServices.EmailDeliveryProvider.EmailDeliveryProviderControl.SetConfiguration(String configInfo)
-- End of inner exception stack trace --
at
Microsoft.ReportingServices.EmailDeliveryProvider.EmailDeliveryProviderControl.SetConfiguration(String configInfo)
at
Microsoft.ReportingServices.Diagnostics.ExtensionClassFactory.GetNewExtensionInstance(String extensionName, String extensionType).
w3wp!ui!fc4!1/11/2005-15:46:42:: e ERROR: Object reference not set to an
instance of an object.
w3wp!ui!fc4!1/11/2005-15:46:42:: e ERROR: HTTP status code --> 500
"Jim" wrote:
> Additional Information:
> SP1 is installed and the email extension has been configured.
> ReportServerService_01_11_2005_15_42_05.log is as shown below. No errors
> seen:
> <Header>
> <Product>Microsoft SQL Server Reporting Services Version
> 8.00.878.00</Product>
> <Locale>en-US</Locale>
> <TimeZone>Mountain Standard Time</TimeZone>
> <Path>C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> Services\LogFiles\ReportServerService__01_11_2005_15_42_05.log</Path>
> <SystemName>MINDSET</SystemName>
> <OSName>Microsoft Windows NT 5.2.3790.0</OSName>
> <OSVersion>5.2.3790.0</OSVersion>
> </Header>
> ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> Initializing ConnectionType to '1' as specified in Configuration file.
> ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> Initializing IsSchedulingService to 'True' as specified in Configuration
> file.
> ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> Initializing IsNotificationService to 'True' as specified in Configuration
> file.
> ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> Initializing IsEventService to 'True' as specified in Configuration file.
> ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> Initializing PollingInterval to '10' second(s) as specified in Configuration
> file.
> ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> Initializing MemoryLimit to '60' percent as specified in Configuration file.
> ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> Initializing RecycleTime to '720' minute(s) as specified in Configuration
> file.
> ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> Initializing MaximumMemoryLimit to '80' percent as specified in Configuration
> file.
> ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in
> Configuration file.
> ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> Initializing MaxQueueThreads to '0' thread(s) as specified in Configuration
> file.
> ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in
> Configuration file.
> ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> Initializing MaxScheduleWait to '5' second(s) as specified in Configuration
> file.
> ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> Initializing DatabaseQueryTimeout to '120' second(s) as specified in
> Configuration file.
> ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> Initializing InstanceName to 'MSSQLSERVER' as specified in Configuration
> file.
> ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> Initializing ProcessRecycleOptions to '0' as specified in Configuration file.
> ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> Initializing RunningRequestsScavengerCycle to '60' second(s) as specified in
> Configuration file.
> ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> Initializing RunningRequestsDbCycle to '60' second(s) as specified in
> Configuration file.
> ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> Initializing RunningRequestsAge to '30' second(s) as specified in
> Configuration file.
> ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> Initializing CleanupCycleMinutes to '10' minute(s) as specified in
> Configuration file.
> ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> Initializing SecureConnectionLevel to '0' as specified in Configuration file.
> ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> Initializing DisplayErrorLink to 'True' as specified in Configuration file.
> ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> Initializing WebServiceUseFileShareStorage to default value of 'False'
> because it was not specified in Configuration file.
> ReportingServicesService!resourceutilities!1250!1/11/2005-15:42:05:: i INFO:
> Running on 2 physical processors, 4 logical processors
> ReportingServicesService!resourceutilities!1250!1/11/2005-15:42:05:: i INFO:
> Reporting Services starting SKU: Developer
> ReportingServicesService!runningjobs!1250!1/11/2005-15:42:05:: i INFO:
> Database Cleanup (NT Service) timer enabled: Cycle: 600 seconds
> ReportingServicesService!runningjobs!1250!1/11/2005-15:42:05:: i INFO:
> Running Requests Scavenger timer enabled: Cycle: 60 seconds
> ReportingServicesService!runningjobs!1250!1/11/2005-15:42:05:: i INFO:
> Running Requests DB timer enabled: Cycle: 60 seconds
> ReportingServicesService!runningjobs!1250!1/11/2005-15:42:05:: i INFO:
> Execution Log Entry Expiration timer enabled: Cycle: 37074 seconds
> ReportingServicesService!runningjobs!1250!1/11/2005-15:42:05:: i INFO:
> Memory stats update timer enabled: Cycle: 60 seconds
> ReportingServicesService!crypto!dd8!1/11/2005-15:42:06:: i INFO:
> Initializing crypto as user: winhealth\Administrator
> ReportingServicesService!crypto!dd8!1/11/2005-15:42:06:: i INFO: Exporting
> public key
> ReportingServicesService!crypto!dd8!1/11/2005-15:42:06:: i INFO: Performing
> sku validation
> ReportingServicesService!crypto!dd8!1/11/2005-15:42:06:: i INFO: Importing
> existing encryption key
> ReportingServicesService!dbpolling!dd8!01/11/2005-15:42:06:: EventPolling
> polling service started
> ReportingServicesService!dbpolling!dd8!01/11/2005-15:42:06::
> NotificationPolling polling service started
> ReportingServicesService!dbpolling!dd8!01/11/2005-15:42:06:: SchedulePolling
> polling service started
> ReportingServicesService!dbpolling!12d8!1/11/2005-15:42:06:: EventPolling
> heartbeat thread started.
> ReportingServicesService!dbpolling!15c0!1/11/2005-15:42:06::
> NotificationPolling heartbeat thread started.
> ReportingServicesService!dbpolling!6f8!1/11/2005-15:42:06:: Polling started
> ReportingServicesService!library!1250!1/11/2005-15:52:05:: i INFO: Cleaned 0
> batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
> "Jim" wrote:
> > I've installed report services and configured the email service by entering a
> > <smtpserver>192.168.1.100</smtpserver> value and a <from>from@.test.com</from>
> > value. Then a subscription was made, however no email was sent. I'm using
> > Windows 2003 a
> >
> > What kinds of troubleshooting can be done to fix this problem?
> >
> > Thanks,
> > Jim
> "Jim" wrote:
> > I've installed report services and configured the email service by entering a
> > <smtpserver>192.168.1.100</smtpserver> value and a <from>from@.test.com</from>
> > value. Then a subscription was made, however no email was sent. I'm using
> > Windows 2003 a
> >
> > What kinds of troubleshooting can be done to fix this problem?
> >
> > Thanks,
> > Jim|||RSReportServer.config
<Configuration
<Dsn>AQAAANCMnd8BFdERjHoAwE/Cl+sBAAAAnJp1x4j7cEGBDP0ctf5/AQQAAAAiAAAAUgBlAHAAbwBy
AHQAaQBuAGcAIABTAGUAcgB2AGUAcgAAAANmAACoAAAAEAAAAHb4gJw7ytct/ngXumtCq1cAAAAA
BIAAAKAAAAAQAAAAuU177KbSl3yj06++1ndRxiABAADJ4zNwz9gEYLzmptYuirj70DzoEXokoZbC
myrFj9XESEy4CNvxshVF4b5Dy0kWc/RwSodif+RIZ5XihCPy7TUhKREPn3HMOL0a+07XukXQGvDt
hdrunLeEwMF6+xoKIcSfulfuFuaLbnVvbTb3M3i8OV3FggECBA/Z18KFfMNVSyVxN61HMlqDC9EJ
pMSJ/l5eXiqxA1f4y8jbbo4isCClOjDu1dHoN/ZfmgnyFVzHU/LGwjP4eNy15YcRrALuPVuDUQ6A
lhlQNSy0l0VMzoHNpSav+Wo7TZBvJ8fnh9/xUOcw04t64YS3RPiwiNg658GU4JP6E+cHObltTmVd
pDQGl2dFYgyYR8TPq/6zBiYoE26cWc2nZTEccuN4aKXbCTcUAAAAflUIGOptOCGJjLJ3qiRZ1DG+
jaQ=</Dsn>
<ConnectionType>Impersonate</ConnectionType
<LogonUser>AQAAANCMnd8BFdERjHoAwE/Cl+sBAAAAnJp1x4j7cEGBDP0ctf5/AQQAAAAiAAAAUgBlAHAAbwBy
AHQAaQBuAGcAIABTAGUAcgB2AGUAcgAAAANmAACoAAAAEAAAAGewGAGsiAwdRIKiQmHB13cAAAAA
BIAAAKAAAAAQAAAA9AntV5LwzNyUpaFnazAlJCAAAABlxhi7DJRmfGDbxkWtxLXvof+zbk0NxOF7
kTDYDd0+QRQAAAB4UYlEm9ffpMuBj8dYIkIaSorj2A==</LogonUser
<LogonDomain>AQAAANCMnd8BFdERjHoAwE/Cl+sBAAAAnJp1x4j7cEGBDP0ctf5/AQQAAAAiAAAAUgBlAHAAbwBy
AHQAaQBuAGcAIABTAGUAcgB2AGUAcgAAAANmAACoAAAAEAAAAN36zORf3lIDr88ypo3HOxYAAAAA
BIAAAKAAAAAQAAAAOlPeo81ePGGjrFcdPd6H1BgAAAD+vOIAfw3KfimAHuOzDF/Dlyk+BavrCfcU
AAAAdn2Zn81tgGb+Z7OEUysH/6JBwWY=</LogonDomain
<LogonCred>AQAAANCMnd8BFdERjHoAwE/Cl+sBAAAAnJp1x4j7cEGBDP0ctf5/AQQAAAAiAAAAUgBlAHAAbwBy
AHQAaQBuAGcAIABTAGUAcgB2AGUAcgAAAANmAACoAAAAEAAAAB49nHK2Y64P/UUlwTjf1Z4AAAAA
BIAAAKAAAAAQAAAA5gbVWKy0UKm8eJdi2QTEWhgAAACZ41XN1cBha9JipJexVj+0hZ6dBSyqB+wU
AAAAQpp1vLQTYO+MSx6K2zMnAreGVNU=</LogonCred>
<InstanceId>MSSQL.1</InstanceId>
<InstallationID>{130e9fe9-cbe3-4f6b-88ad-10003bc9f414}</InstallationID>
<Add Key="SecureConnectionLevel" Value="0"/>
<Add Key="InstanceName" Value="MSSQLSERVER"/>
<Add Key="ProcessRecycleOptions" Value="0"/>
<Add Key="CleanupCycleMinutes" Value="10"/>
<Add Key="SQLCommandTimeoutSeconds" Value="60"/>
<Add Key="MaxActiveReqForOneUser" Value="20"/>
<Add Key="DatabaseQueryTimeout" Value="120"/>
<Add Key="RunningRequestsScavengerCycle" Value="60"/>
<Add Key="RunningRequestsDbCycle" Value="60"/>
<Add Key="RunningRequestsAge" Value="30"/>
<Add Key="MaxScheduleWait" Value="5"/>
<Add Key="DisplayErrorLink" Value="true"/>
<Service>
<IsSchedulingService>True</IsSchedulingService>
<IsNotificationService>True</IsNotificationService>
<IsEventService>True</IsEventService>
<PollingInterval>10</PollingInterval>
<MemoryLimit>60</MemoryLimit>
<RecycleTime>720</RecycleTime>
<MaximumMemoryLimit>80</MaximumMemoryLimit>
<MaxAppDomainUnloadTime>30</MaxAppDomainUnloadTime>
<MaxQueueThreads>0</MaxQueueThreads>
<UrlRoot>http://MINDSET/ReportServer</UrlRoot>
<UnattendedExecutionAccount>
<UserName></UserName>
<Password></Password>
<Domain></Domain>
</UnattendedExecutionAccount>
<PolicyLevel>rssrvpolicy.config</PolicyLevel>
</Service>
<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>192.168.1.100</SMTPServer>
<SMTPServerPort></SMTPServerPort>
<SMTPAccountName></SMTPAccountName>
<SMTPConnectionTimeout></SMTPConnectionTimeout>
<SMTPServerPickupDirectory></SMTPServerPickupDirectory>
<SMTPUseSSL></SMTPUseSSL>
<SendUsing></SendUsing>
<SMTPAuthenticate></SMTPAuthenticate>
<From>reportserver@.winhealthpartners.org</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>
<Render>
<Extension Name="XML"
Type="Microsoft.ReportingServices.Rendering.XmlDataRenderer.XmlDataReport,Microsoft.ReportingServices.XmlRendering"/>
<Extension Name="NULL"
Type="Microsoft.ReportingServices.Rendering.NullRenderer.NullReport,Microsoft.ReportingServices.NullRendering" Visible="false"/>
<Extension Name="CSV"
Type="Microsoft.ReportingServices.Rendering.CsvRenderer.CsvReport,Microsoft.ReportingServices.CsvRendering"/>
<Extension Name="IMAGE"
Type="Microsoft.ReportingServices.Rendering.ImageRenderer.ImageReport,Microsoft.ReportingServices.ImageRendering"/>
<Extension Name="PDF"
Type="Microsoft.ReportingServices.Rendering.ImageRenderer.PdfReport,Microsoft.ReportingServices.ImageRendering"/>
<Extension Name="HTML4.0"
Type="Microsoft.ReportingServices.Rendering.HtmlRenderer.Html40RenderingExtension,Microsoft.ReportingServices.HtmlRendering" Visible="false"/>
<Extension Name="HTML3.2"
Type="Microsoft.ReportingServices.Rendering.HtmlRenderer.Html32RenderingExtension,Microsoft.ReportingServices.HtmlRendering" Visible="false"/>
<Extension Name="MHTML"
Type="Microsoft.ReportingServices.Rendering.HtmlRenderer.MHtmlRenderingExtension,Microsoft.ReportingServices.HtmlRendering"/>
<Extension Name="EXCEL"
Type="Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer,Microsoft.ReportingServices.ExcelRendering"/>
<Extension Name="HTMLOWC"
Type="Microsoft.ReportingServices.Rendering.HtmlRenderer.HtmlOWCRenderingExtension,Microsoft.ReportingServices.HtmlRendering">
<Configuration>
<OWCConfiguration>
<OWCDownloadLocation
language="de">http://office.microsoft.com/germany/downloads/2002/owc10.aspx</OWCDownloadLocation>
<OWCDownloadLocation
language="en">http://office.microsoft.com/downloads/2002/owc10.aspx</OWCDownloadLocation>
<OWCDownloadLocation
language="ja">http://office.microsoft.com/japan/downloads/2002/owc10.aspx</OWCDownloadLocation>
<OWCDownloadLocation
language="zh-chs">http://office.microsoft.com/china/downloads/2002/owc10.aspx</OWCDownloadLocation>
<OWCDownloadLocation
language="zh-cht">http://office.microsoft.com/china/downloads/2002/owc10.aspx</OWCDownloadLocation>
<OWCDownloadLocation
language="es">http://office.microsoft.com/spain/downloads/2002/owc10.aspx</OWCDownloadLocation>
<OWCDownloadLocation
language="ko">http://office.microsoft.com/korea/downloads/2002/owc10.aspx</OWCDownloadLocation>
<OWCDownloadLocation
language="fr">http://office.microsoft.com/france/downloads/2002/owc10.aspx</OWCDownloadLocation>
<OWCDownloadLocation
language="it">http://office.microsoft.com/italy/downloads/2002/owc10.aspx</OWCDownloadLocation>
</OWCConfiguration>
</Configuration>
</Extension>
</Render>
<Data>
<Extension Name="SQL"
Type="Microsoft.ReportingServices.DataExtensions.SqlConnectionWrapper,Microsoft.ReportingServices.DataExtensions"/>
<Extension Name="OLEDB"
Type="Microsoft.ReportingServices.DataExtensions.OleDbConnectionWrapper,Microsoft.ReportingServices.DataExtensions"/>
<Extension Name="ORACLE"
Type="Microsoft.ReportingServices.DataExtensions.OracleClientConnectionWrapper,Microsoft.ReportingServices.DataExtensions"/>
<Extension Name="ODBC"
Type="Microsoft.ReportingServices.DataExtensions.OdbcConnectionWrapper,Microsoft.ReportingServices.DataExtensions"/>
</Data>
<Security>
<Extension Name="Windows"
Type="Microsoft.ReportingServices.Authorization.WindowsAuthorization,
Microsoft.ReportingServices.Authorization"/>
</Security>
<Authentication>
<Extension Name="Windows"
Type="Microsoft.ReportingServices.Authentication.WindowsAuthentication,
Microsoft.ReportingServices.Authorization"/>
</Authentication>
<EventProcessing>
<Extension Name="SnapShot Extension"
Type="Microsoft.ReportingServices.Library.HistorySnapShotCreatedHandler,ReportingServicesLibrary">
<Event>
<Type>ReportHistorySnapshotCreated</Type>
</Event>
</Extension>
<Extension Name="Timed Subscription Extension"
Type="Microsoft.ReportingServices.Library.TimedSubscriptionHandler,ReportingServicesLibrary">
<Event>
<Type>TimedSubscription</Type>
</Event>
</Extension>
<Extension Name="Cache Update Extension"
Type="Microsoft.ReportingServices.Library.ReportExecutionSnapshotUpdateEventHandler,ReportingServicesLibrary">
<Event>
<Type>SnapshotUpdated</Type>
</Event>
</Extension>
</EventProcessing>
</Extensions>
</Configuration>
"Jim" wrote:
> Error found in ReportServerWebApp:
> w3wp!library!fc4!1/11/2005-15:46:38:: e ERROR: Throwing
> Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
> The Report Server has encountered a configuration error; more details in the
> log files, ;
> Info:
> Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
> The Report Server has encountered a configuration error; more details in the
> log files --> System.Xml.XmlException: There are multiple root elements.
> Line 1, position 111.
> at System.Xml.XmlTextReader.ParseRoot()
> at System.Xml.XmlTextReader.Read()
> at System.Xml.XmlValidatingReader.ReadNoCollectTextToken()
> at System.Xml.XmlValidatingReader.Read()
> at System.Xml.XmlLoader.LoadDocSequence(XmlDocument parentDoc)
> at System.Xml.XmlLoader.Load(XmlDocument doc, XmlReader reader, Boolean
> preserveWhitespace)
> at System.Xml.XmlDocument.Load(XmlReader reader)
> at System.Xml.XmlDocument.LoadXml(String xml)
> at
> Microsoft.ReportingServices.EmailDeliveryProvider.EmailDeliveryProviderControl.SetConfiguration(String configInfo)
> -- End of inner exception stack trace --
> w3wp!extensionfactory!fc4!1/11/2005-15:46:42:: e ERROR: Exception caught
> instantiating report server extension:
> Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
> The Report Server has encountered a configuration error; more details in the
> log files --> System.Xml.XmlException: There are multiple root elements.
> Line 1, position 111.
> at System.Xml.XmlTextReader.ParseRoot()
> at System.Xml.XmlTextReader.Read()
> at System.Xml.XmlValidatingReader.ReadNoCollectTextToken()
> at System.Xml.XmlValidatingReader.Read()
> at System.Xml.XmlLoader.LoadDocSequence(XmlDocument parentDoc)
> at System.Xml.XmlLoader.Load(XmlDocument doc, XmlReader reader, Boolean
> preserveWhitespace)
> at System.Xml.XmlDocument.Load(XmlReader reader)
> at System.Xml.XmlDocument.LoadXml(String xml)
> at
> Microsoft.ReportingServices.EmailDeliveryProvider.EmailDeliveryProviderControl.SetConfiguration(String configInfo)
> -- End of inner exception stack trace --
> at
> Microsoft.ReportingServices.EmailDeliveryProvider.EmailDeliveryProviderControl.SetConfiguration(String configInfo)
> at
> Microsoft.ReportingServices.Diagnostics.ExtensionClassFactory.GetNewExtensionInstance(String extensionName, String extensionType).
> w3wp!ui!fc4!1/11/2005-15:46:42:: e ERROR: Object reference not set to an
> instance of an object.
> w3wp!ui!fc4!1/11/2005-15:46:42:: e ERROR: HTTP status code --> 500
> "Jim" wrote:
> > Additional Information:
> >
> > SP1 is installed and the email extension has been configured.
> >
> > ReportServerService_01_11_2005_15_42_05.log is as shown below. No errors
> > seen:
> >
> > <Header>
> > <Product>Microsoft SQL Server Reporting Services Version
> > 8.00.878.00</Product>
> > <Locale>en-US</Locale>
> > <TimeZone>Mountain Standard Time</TimeZone>
> > <Path>C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> > Services\LogFiles\ReportServerService__01_11_2005_15_42_05.log</Path>
> > <SystemName>MINDSET</SystemName>
> > <OSName>Microsoft Windows NT 5.2.3790.0</OSName>
> > <OSVersion>5.2.3790.0</OSVersion>
> > </Header>
> > ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> > Initializing ConnectionType to '1' as specified in Configuration file.
> > ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> > Initializing IsSchedulingService to 'True' as specified in Configuration
> > file.
> > ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> > Initializing IsNotificationService to 'True' as specified in Configuration
> > file.
> > ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> > Initializing IsEventService to 'True' as specified in Configuration file.
> > ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> > Initializing PollingInterval to '10' second(s) as specified in Configuration
> > file.
> > ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> > Initializing MemoryLimit to '60' percent as specified in Configuration file.
> > ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> > Initializing RecycleTime to '720' minute(s) as specified in Configuration
> > file.
> > ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> > Initializing MaximumMemoryLimit to '80' percent as specified in Configuration
> > file.
> > ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> > Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in
> > Configuration file.
> > ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> > Initializing MaxQueueThreads to '0' thread(s) as specified in Configuration
> > file.
> > ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> > Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in
> > Configuration file.
> > ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> > Initializing MaxScheduleWait to '5' second(s) as specified in Configuration
> > file.
> > ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> > Initializing DatabaseQueryTimeout to '120' second(s) as specified in
> > Configuration file.
> > ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> > Initializing InstanceName to 'MSSQLSERVER' as specified in Configuration
> > file.
> > ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> > Initializing ProcessRecycleOptions to '0' as specified in Configuration file.
> > ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> > Initializing RunningRequestsScavengerCycle to '60' second(s) as specified in
> > Configuration file.
> > ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> > Initializing RunningRequestsDbCycle to '60' second(s) as specified in
> > Configuration file.
> > ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> > Initializing RunningRequestsAge to '30' second(s) as specified in
> > Configuration file.
> > ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> > Initializing CleanupCycleMinutes to '10' minute(s) as specified in
> > Configuration file.
> > ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> > Initializing SecureConnectionLevel to '0' as specified in Configuration file.
> > ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> > Initializing DisplayErrorLink to 'True' as specified in Configuration file.
> > ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> > Initializing WebServiceUseFileShareStorage to default value of 'False'
> > because it was not specified in Configuration file.
> > ReportingServicesService!resourceutilities!1250!1/11/2005-15:42:05:: i INFO:
> > Running on 2 physical processors, 4 logical processors
> > ReportingServicesService!resourceutilities!1250!1/11/2005-15:42:05:: i INFO:
> > Reporting Services starting SKU: Developer
> > ReportingServicesService!runningjobs!1250!1/11/2005-15:42:05:: i INFO:
> > Database Cleanup (NT Service) timer enabled: Cycle: 600 seconds
> > ReportingServicesService!runningjobs!1250!1/11/2005-15:42:05:: i INFO:
> > Running Requests Scavenger timer enabled: Cycle: 60 seconds
> > ReportingServicesService!runningjobs!1250!1/11/2005-15:42:05:: i INFO:
> > Running Requests DB timer enabled: Cycle: 60 seconds
> > ReportingServicesService!runningjobs!1250!1/11/2005-15:42:05:: i INFO:
> > Execution Log Entry Expiration timer enabled: Cycle: 37074 seconds
> > ReportingServicesService!runningjobs!1250!1/11/2005-15:42:05:: i INFO:
> > Memory stats update timer enabled: Cycle: 60 seconds
> > ReportingServicesService!crypto!dd8!1/11/2005-15:42:06:: i INFO:
> > Initializing crypto as user: winhealth\Administrator
> > ReportingServicesService!crypto!dd8!1/11/2005-15:42:06:: i INFO: Exporting
> > public key
> > ReportingServicesService!crypto!dd8!1/11/2005-15:42:06:: i INFO: Performing
> > sku validation
> > ReportingServicesService!crypto!dd8!1/11/2005-15:42:06:: i INFO: Importing
> > existing encryption key
> > ReportingServicesService!dbpolling!dd8!01/11/2005-15:42:06:: EventPolling
> > polling service started
> > ReportingServicesService!dbpolling!dd8!01/11/2005-15:42:06::
> > NotificationPolling polling service started
> > ReportingServicesService!dbpolling!dd8!01/11/2005-15:42:06:: SchedulePolling
> > polling service started
> > ReportingServicesService!dbpolling!12d8!1/11/2005-15:42:06:: EventPolling
> > heartbeat thread started.
> > ReportingServicesService!dbpolling!15c0!1/11/2005-15:42:06::
> > NotificationPolling heartbeat thread started.
> > ReportingServicesService!dbpolling!6f8!1/11/2005-15:42:06:: Polling started
> > ReportingServicesService!library!1250!1/11/2005-15:52:05:: i INFO: Cleaned 0
> > batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> > chunks, 0 running jobs
> >
> > "Jim" wrote:
> >
> > > I've installed report services and configured the email service by entering a
> > > <smtpserver>192.168.1.100</smtpserver> value and a <from>from@.test.com</from>
> > > value. Then a subscription was made, however no email was sent. I'm using
> > > Windows 2003 a
> > >
> > > What kinds of troubleshooting can be done to fix this problem?
> > >
> > > Thanks,
> > > Jim
> >
> > "Jim" wrote:
> >
> > > I've installed report services and configured the email service by entering a
> > > <smtpserver>192.168.1.100</smtpserver> value and a <from>from@.test.com</from>
> > > value. Then a subscription was made, however no email was sent. I'm using
> > > Windows 2003 a
> > >
> > > What kinds of troubleshooting can be done to fix this problem?
> > >
> > > Thanks,
> > > Jim|||Reinstalled Report Services and used the built-in account user account for
Report Services. It now works.
"Jim" wrote:
> RSReportServer.config
> <Configuration>
> <Dsn>AQAAANCMnd8BFdERjHoAwE/Cl+sBAAAAnJp1x4j7cEGBDP0ctf5/AQQAAAAiAAAAUgBlAHAAbwBy
> AHQAaQBuAGcAIABTAGUAcgB2AGUAcgAAAANmAACoAAAAEAAAAHb4gJw7ytct/ngXumtCq1cAAAAA
> BIAAAKAAAAAQAAAAuU177KbSl3yj06++1ndRxiABAADJ4zNwz9gEYLzmptYuirj70DzoEXokoZbC
> myrFj9XESEy4CNvxshVF4b5Dy0kWc/RwSodif+RIZ5XihCPy7TUhKREPn3HMOL0a+07XukXQGvDt
> hdrunLeEwMF6+xoKIcSfulfuFuaLbnVvbTb3M3i8OV3FggECBA/Z18KFfMNVSyVxN61HMlqDC9EJ
> pMSJ/l5eXiqxA1f4y8jbbo4isCClOjDu1dHoN/ZfmgnyFVzHU/LGwjP4eNy15YcRrALuPVuDUQ6A
> lhlQNSy0l0VMzoHNpSav+Wo7TZBvJ8fnh9/xUOcw04t64YS3RPiwiNg658GU4JP6E+cHObltTmVd
> pDQGl2dFYgyYR8TPq/6zBiYoE26cWc2nZTEccuN4aKXbCTcUAAAAflUIGOptOCGJjLJ3qiRZ1DG+
> jaQ=</Dsn>
> <ConnectionType>Impersonate</ConnectionType>
> <LogonUser>AQAAANCMnd8BFdERjHoAwE/Cl+sBAAAAnJp1x4j7cEGBDP0ctf5/AQQAAAAiAAAAUgBlAHAAbwBy
> AHQAaQBuAGcAIABTAGUAcgB2AGUAcgAAAANmAACoAAAAEAAAAGewGAGsiAwdRIKiQmHB13cAAAAA
> BIAAAKAAAAAQAAAA9AntV5LwzNyUpaFnazAlJCAAAABlxhi7DJRmfGDbxkWtxLXvof+zbk0NxOF7
> kTDYDd0+QRQAAAB4UYlEm9ffpMuBj8dYIkIaSorj2A==</LogonUser>
> <LogonDomain>AQAAANCMnd8BFdERjHoAwE/Cl+sBAAAAnJp1x4j7cEGBDP0ctf5/AQQAAAAiAAAAUgBlAHAAbwBy
> AHQAaQBuAGcAIABTAGUAcgB2AGUAcgAAAANmAACoAAAAEAAAAN36zORf3lIDr88ypo3HOxYAAAAA
> BIAAAKAAAAAQAAAAOlPeo81ePGGjrFcdPd6H1BgAAAD+vOIAfw3KfimAHuOzDF/Dlyk+BavrCfcU
> AAAAdn2Zn81tgGb+Z7OEUysH/6JBwWY=</LogonDomain>
> <LogonCred>AQAAANCMnd8BFdERjHoAwE/Cl+sBAAAAnJp1x4j7cEGBDP0ctf5/AQQAAAAiAAAAUgBlAHAAbwBy
> AHQAaQBuAGcAIABTAGUAcgB2AGUAcgAAAANmAACoAAAAEAAAAB49nHK2Y64P/UUlwTjf1Z4AAAAA
> BIAAAKAAAAAQAAAA5gbVWKy0UKm8eJdi2QTEWhgAAACZ41XN1cBha9JipJexVj+0hZ6dBSyqB+wU
> AAAAQpp1vLQTYO+MSx6K2zMnAreGVNU=</LogonCred>
> <InstanceId>MSSQL.1</InstanceId>
> <InstallationID>{130e9fe9-cbe3-4f6b-88ad-10003bc9f414}</InstallationID>
> <Add Key="SecureConnectionLevel" Value="0"/>
> <Add Key="InstanceName" Value="MSSQLSERVER"/>
> <Add Key="ProcessRecycleOptions" Value="0"/>
> <Add Key="CleanupCycleMinutes" Value="10"/>
> <Add Key="SQLCommandTimeoutSeconds" Value="60"/>
> <Add Key="MaxActiveReqForOneUser" Value="20"/>
> <Add Key="DatabaseQueryTimeout" Value="120"/>
> <Add Key="RunningRequestsScavengerCycle" Value="60"/>
> <Add Key="RunningRequestsDbCycle" Value="60"/>
> <Add Key="RunningRequestsAge" Value="30"/>
> <Add Key="MaxScheduleWait" Value="5"/>
> <Add Key="DisplayErrorLink" Value="true"/>
> <Service>
> <IsSchedulingService>True</IsSchedulingService>
> <IsNotificationService>True</IsNotificationService>
> <IsEventService>True</IsEventService>
> <PollingInterval>10</PollingInterval>
> <MemoryLimit>60</MemoryLimit>
> <RecycleTime>720</RecycleTime>
> <MaximumMemoryLimit>80</MaximumMemoryLimit>
> <MaxAppDomainUnloadTime>30</MaxAppDomainUnloadTime>
> <MaxQueueThreads>0</MaxQueueThreads>
> <UrlRoot>http://MINDSET/ReportServer</UrlRoot>
> <UnattendedExecutionAccount>
> <UserName></UserName>
> <Password></Password>
> <Domain></Domain>
> </UnattendedExecutionAccount>
> <PolicyLevel>rssrvpolicy.config</PolicyLevel>
> </Service>
> <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>192.168.1.100</SMTPServer>
> <SMTPServerPort></SMTPServerPort>
> <SMTPAccountName></SMTPAccountName>
> <SMTPConnectionTimeout></SMTPConnectionTimeout>
> <SMTPServerPickupDirectory></SMTPServerPickupDirectory>
> <SMTPUseSSL></SMTPUseSSL>
> <SendUsing></SendUsing>
> <SMTPAuthenticate></SMTPAuthenticate>
> <From>reportserver@.winhealthpartners.org</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>
> <Render>
> <Extension Name="XML"
> Type="Microsoft.ReportingServices.Rendering.XmlDataRenderer.XmlDataReport,Microsoft.ReportingServices.XmlRendering"/>
> <Extension Name="NULL"
> Type="Microsoft.ReportingServices.Rendering.NullRenderer.NullReport,Microsoft.ReportingServices.NullRendering" Visible="false"/>
> <Extension Name="CSV"
> Type="Microsoft.ReportingServices.Rendering.CsvRenderer.CsvReport,Microsoft.ReportingServices.CsvRendering"/>
> <Extension Name="IMAGE"
> Type="Microsoft.ReportingServices.Rendering.ImageRenderer.ImageReport,Microsoft.ReportingServices.ImageRendering"/>
> <Extension Name="PDF"
> Type="Microsoft.ReportingServices.Rendering.ImageRenderer.PdfReport,Microsoft.ReportingServices.ImageRendering"/>
> <Extension Name="HTML4.0"
> Type="Microsoft.ReportingServices.Rendering.HtmlRenderer.Html40RenderingExtension,Microsoft.ReportingServices.HtmlRendering" Visible="false"/>
> <Extension Name="HTML3.2"
> Type="Microsoft.ReportingServices.Rendering.HtmlRenderer.Html32RenderingExtension,Microsoft.ReportingServices.HtmlRendering" Visible="false"/>
> <Extension Name="MHTML"
> Type="Microsoft.ReportingServices.Rendering.HtmlRenderer.MHtmlRenderingExtension,Microsoft.ReportingServices.HtmlRendering"/>
> <Extension Name="EXCEL"
> Type="Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer,Microsoft.ReportingServices.ExcelRendering"/>
> <Extension Name="HTMLOWC"
> Type="Microsoft.ReportingServices.Rendering.HtmlRenderer.HtmlOWCRenderingExtension,Microsoft.ReportingServices.HtmlRendering">
> <Configuration>
> <OWCConfiguration>
> <OWCDownloadLocation
> language="de">http://office.microsoft.com/germany/downloads/2002/owc10.aspx</OWCDownloadLocation>
> <OWCDownloadLocation
> language="en">http://office.microsoft.com/downloads/2002/owc10.aspx</OWCDownloadLocation>
> <OWCDownloadLocation
> language="ja">http://office.microsoft.com/japan/downloads/2002/owc10.aspx</OWCDownloadLocation>
> <OWCDownloadLocation
> language="zh-chs">http://office.microsoft.com/china/downloads/2002/owc10.aspx</OWCDownloadLocation>
> <OWCDownloadLocation
> language="zh-cht">http://office.microsoft.com/china/downloads/2002/owc10.aspx</OWCDownloadLocation>
> <OWCDownloadLocation
> language="es">http://office.microsoft.com/spain/downloads/2002/owc10.aspx</OWCDownloadLocation>
> <OWCDownloadLocation
> language="ko">http://office.microsoft.com/korea/downloads/2002/owc10.aspx</OWCDownloadLocation>
> <OWCDownloadLocation
> language="fr">http://office.microsoft.com/france/downloads/2002/owc10.aspx</OWCDownloadLocation>
> <OWCDownloadLocation
> language="it">http://office.microsoft.com/italy/downloads/2002/owc10.aspx</OWCDownloadLocation>
> </OWCConfiguration>
> </Configuration>
> </Extension>
> </Render>
> <Data>
> <Extension Name="SQL"
> Type="Microsoft.ReportingServices.DataExtensions.SqlConnectionWrapper,Microsoft.ReportingServices.DataExtensions"/>
> <Extension Name="OLEDB"
> Type="Microsoft.ReportingServices.DataExtensions.OleDbConnectionWrapper,Microsoft.ReportingServices.DataExtensions"/>
> <Extension Name="ORACLE"
> Type="Microsoft.ReportingServices.DataExtensions.OracleClientConnectionWrapper,Microsoft.ReportingServices.DataExtensions"/>
> <Extension Name="ODBC"
> Type="Microsoft.ReportingServices.DataExtensions.OdbcConnectionWrapper,Microsoft.ReportingServices.DataExtensions"/>
> </Data>
> <Security>
> <Extension Name="Windows"
> Type="Microsoft.ReportingServices.Authorization.WindowsAuthorization,
> Microsoft.ReportingServices.Authorization"/>
> </Security>
> <Authentication>
> <Extension Name="Windows"
> Type="Microsoft.ReportingServices.Authentication.WindowsAuthentication,
> Microsoft.ReportingServices.Authorization"/>
> </Authentication>
> <EventProcessing>
> <Extension Name="SnapShot Extension"
> Type="Microsoft.ReportingServices.Library.HistorySnapShotCreatedHandler,ReportingServicesLibrary">
> <Event>
> <Type>ReportHistorySnapshotCreated</Type>
> </Event>
> </Extension>
> <Extension Name="Timed Subscription Extension"
> Type="Microsoft.ReportingServices.Library.TimedSubscriptionHandler,ReportingServicesLibrary">
> <Event>
> <Type>TimedSubscription</Type>
> </Event>
> </Extension>
> <Extension Name="Cache Update Extension"
> Type="Microsoft.ReportingServices.Library.ReportExecutionSnapshotUpdateEventHandler,ReportingServicesLibrary">
> <Event>
> <Type>SnapshotUpdated</Type>
> </Event>
> </Extension>
> </EventProcessing>
> </Extensions>
> </Configuration>
>
> "Jim" wrote:
> > Error found in ReportServerWebApp:
> >
> > w3wp!library!fc4!1/11/2005-15:46:38:: e ERROR: Throwing
> > Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
> > The Report Server has encountered a configuration error; more details in the
> > log files, ;
> > Info:
> > Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
> > The Report Server has encountered a configuration error; more details in the
> > log files --> System.Xml.XmlException: There are multiple root elements.
> > Line 1, position 111.
> > at System.Xml.XmlTextReader.ParseRoot()
> > at System.Xml.XmlTextReader.Read()
> > at System.Xml.XmlValidatingReader.ReadNoCollectTextToken()
> > at System.Xml.XmlValidatingReader.Read()
> > at System.Xml.XmlLoader.LoadDocSequence(XmlDocument parentDoc)
> > at System.Xml.XmlLoader.Load(XmlDocument doc, XmlReader reader, Boolean
> > preserveWhitespace)
> > at System.Xml.XmlDocument.Load(XmlReader reader)
> > at System.Xml.XmlDocument.LoadXml(String xml)
> > at
> > Microsoft.ReportingServices.EmailDeliveryProvider.EmailDeliveryProviderControl.SetConfiguration(String configInfo)
> > -- End of inner exception stack trace --
> > w3wp!extensionfactory!fc4!1/11/2005-15:46:42:: e ERROR: Exception caught
> > instantiating report server extension:
> > Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
> > The Report Server has encountered a configuration error; more details in the
> > log files --> System.Xml.XmlException: There are multiple root elements.
> > Line 1, position 111.
> > at System.Xml.XmlTextReader.ParseRoot()
> > at System.Xml.XmlTextReader.Read()
> > at System.Xml.XmlValidatingReader.ReadNoCollectTextToken()
> > at System.Xml.XmlValidatingReader.Read()
> > at System.Xml.XmlLoader.LoadDocSequence(XmlDocument parentDoc)
> > at System.Xml.XmlLoader.Load(XmlDocument doc, XmlReader reader, Boolean
> > preserveWhitespace)
> > at System.Xml.XmlDocument.Load(XmlReader reader)
> > at System.Xml.XmlDocument.LoadXml(String xml)
> > at
> > Microsoft.ReportingServices.EmailDeliveryProvider.EmailDeliveryProviderControl.SetConfiguration(String configInfo)
> > -- End of inner exception stack trace --
> > at
> > Microsoft.ReportingServices.EmailDeliveryProvider.EmailDeliveryProviderControl.SetConfiguration(String configInfo)
> > at
> > Microsoft.ReportingServices.Diagnostics.ExtensionClassFactory.GetNewExtensionInstance(String extensionName, String extensionType).
> > w3wp!ui!fc4!1/11/2005-15:46:42:: e ERROR: Object reference not set to an
> > instance of an object.
> > w3wp!ui!fc4!1/11/2005-15:46:42:: e ERROR: HTTP status code --> 500
> >
> > "Jim" wrote:
> >
> > > Additional Information:
> > >
> > > SP1 is installed and the email extension has been configured.
> > >
> > > ReportServerService_01_11_2005_15_42_05.log is as shown below. No errors
> > > seen:
> > >
> > > <Header>
> > > <Product>Microsoft SQL Server Reporting Services Version
> > > 8.00.878.00</Product>
> > > <Locale>en-US</Locale>
> > > <TimeZone>Mountain Standard Time</TimeZone>
> > > <Path>C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> > > Services\LogFiles\ReportServerService__01_11_2005_15_42_05.log</Path>
> > > <SystemName>MINDSET</SystemName>
> > > <OSName>Microsoft Windows NT 5.2.3790.0</OSName>
> > > <OSVersion>5.2.3790.0</OSVersion>
> > > </Header>
> > > ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> > > Initializing ConnectionType to '1' as specified in Configuration file.
> > > ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> > > Initializing IsSchedulingService to 'True' as specified in Configuration
> > > file.
> > > ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> > > Initializing IsNotificationService to 'True' as specified in Configuration
> > > file.
> > > ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> > > Initializing IsEventService to 'True' as specified in Configuration file.
> > > ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> > > Initializing PollingInterval to '10' second(s) as specified in Configuration
> > > file.
> > > ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> > > Initializing MemoryLimit to '60' percent as specified in Configuration file.
> > > ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> > > Initializing RecycleTime to '720' minute(s) as specified in Configuration
> > > file.
> > > ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> > > Initializing MaximumMemoryLimit to '80' percent as specified in Configuration
> > > file.
> > > ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> > > Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in
> > > Configuration file.
> > > ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> > > Initializing MaxQueueThreads to '0' thread(s) as specified in Configuration
> > > file.
> > > ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> > > Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in
> > > Configuration file.
> > > ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> > > Initializing MaxScheduleWait to '5' second(s) as specified in Configuration
> > > file.
> > > ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> > > Initializing DatabaseQueryTimeout to '120' second(s) as specified in
> > > Configuration file.
> > > ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> > > Initializing InstanceName to 'MSSQLSERVER' as specified in Configuration
> > > file.
> > > ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> > > Initializing ProcessRecycleOptions to '0' as specified in Configuration file.
> > > ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> > > Initializing RunningRequestsScavengerCycle to '60' second(s) as specified in
> > > Configuration file.
> > > ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> > > Initializing RunningRequestsDbCycle to '60' second(s) as specified in
> > > Configuration file.
> > > ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> > > Initializing RunningRequestsAge to '30' second(s) as specified in
> > > Configuration file.
> > > ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> > > Initializing CleanupCycleMinutes to '10' minute(s) as specified in
> > > Configuration file.
> > > ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> > > Initializing SecureConnectionLevel to '0' as specified in Configuration file.
> > > ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> > > Initializing DisplayErrorLink to 'True' as specified in Configuration file.
> > > ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> > > Initializing WebServiceUseFileShareStorage to default value of 'False'
> > > because it was not specified in Configuration file.
> > > ReportingServicesService!resourceutilities!1250!1/11/2005-15:42:05:: i INFO:
> > > Running on 2 physical processors, 4 logical processors
> > > ReportingServicesService!resourceutilities!1250!1/11/2005-15:42:05:: i INFO:
> > > Reporting Services starting SKU: Developer
> > > ReportingServicesService!runningjobs!1250!1/11/2005-15:42:05:: i INFO:
> > > Database Cleanup (NT Service) timer enabled: Cycle: 600 seconds
> > > ReportingServicesService!runningjobs!1250!1/11/2005-15:42:05:: i INFO:
> > > Running Requests Scavenger timer enabled: Cycle: 60 seconds
> > > ReportingServicesService!runningjobs!1250!1/11/2005-15:42:05:: i INFO:
> > > Running Requests DB timer enabled: Cycle: 60 seconds
> > > ReportingServicesService!runningjobs!1250!1/11/2005-15:42:05:: i INFO:
> > > Execution Log Entry Expiration timer enabled: Cycle: 37074 seconds
> > > ReportingServicesService!runningjobs!1250!1/11/2005-15:42:05:: i INFO:
> > > Memory stats update timer enabled: Cycle: 60 seconds
> > > ReportingServicesService!crypto!dd8!1/11/2005-15:42:06:: i INFO:
> > > Initializing crypto as user: winhealth\Administrator
> > > ReportingServicesService!crypto!dd8!1/11/2005-15:42:06:: i INFO: Exporting
> > > public key
> > > ReportingServicesService!crypto!dd8!1/11/2005-15:42:06:: i INFO: Performing
> > > sku validation
> > > ReportingServicesService!crypto!dd8!1/11/2005-15:42:06:: i INFO: Importing
> > > existing encryption key
> > > ReportingServicesService!dbpolling!dd8!01/11/2005-15:42:06:: EventPolling
> > > polling service started
> > > ReportingServicesService!dbpolling!dd8!01/11/2005-15:42:06::
> > > NotificationPolling polling service started
> > > ReportingServicesService!dbpolling!dd8!01/11/2005-15:42:06:: SchedulePolling
> > > polling service started
> > > ReportingServicesService!dbpolling!12d8!1/11/2005-15:42:06:: EventPolling
> > > heartbeat thread started.
> > > ReportingServicesService!dbpolling!15c0!1/11/2005-15:42:06::
> > > NotificationPolling heartbeat thread started.
> > > ReportingServicesService!dbpolling!6f8!1/11/2005-15:42:06:: Polling started
> > > ReportingServicesService!library!1250!1/11/2005-15:52:05:: i INFO: Cleaned 0
> > > batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> > > chunks, 0 running jobs
> > >
> > > "Jim" wrote:
> > >
> > > > I've installed report services and configured the email service by entering a
> > > > <smtpserver>192.168.1.100</smtpserver> value and a <from>from@.test.com</from>
> > > > value. Then a subscription was made, however no email was sent. I'm using
> > > > Windows 2003 a
> > > >
> > > > What kinds of troubleshooting can be done to fix this problem?
> > > >
> > > > Thanks,
> > > > Jim
> > >
> > > "Jim" wrote:
> > >
> > > > I've installed report services and configured the email service by entering a
> > > > <smtpserver>192.168.1.100</smtpserver> value and a <from>from@.test.com</from>
> > > > value. Then a subscription was made, however no email was sent. I'm using
> > > > Windows 2003 a
> > > >
> > > > What kinds of troubleshooting can be done to fix this problem?
> > > >
> > > > Thanks,
> > > > Jim

Emailing a Report on the Fly

Hi,
I am rendering a report in PDF Format using web services API using a click
of a button which its doing perfectly.
As soon as this report is rendered in PDF format, Is there a way to send
him a particular user this report by Email thru C# FrontEnd.
An Email has to be sent when a report is rendered by the user automatically
using WebServices API.
plz put some sample code as well.
I am doing from C# in Winforms
Thanks For ur help
Thanks
Chandra
--
Message posted via http://www.sqlmonster.comThis is not built into RS so you would need to call the mail library
yourself. We would like to add a "send now" feature but it won't make it
into SQL 2005.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Chandra Kotha via SQLMonster.com" <forum@.nospam.SQLMonster.com> wrote in
message news:fb6aea0a57554e4cbbda5c3bef6d90ff@.SQLMonster.com...
> Hi,
> I am rendering a report in PDF Format using web services API using a click
> of a button which its doing perfectly.
> As soon as this report is rendered in PDF format, Is there a way to send
> him a particular user this report by Email thru C# FrontEnd.
> An Email has to be sent when a report is rendered by the user
> automatically
> using WebServices API.
> plz put some sample code as well.
> I am doing from C# in Winforms
> Thanks For ur help
> Thanks
> Chandra
> --
> Message posted via http://www.sqlmonster.com|||Thanks very much I will be using Mail API from C#.NET
--
Message posted via http://www.sqlmonster.com

Email validation in ReportManager

Setting up a timed subscription in Reporting Services works just fine on our
server when the email address is joe@.domain.com. The Report server is set
up pointing to our SMTP server and works like a champ. Reports go out and
our chosen format (PDF) is generated and all is good.
When we enter a non-standard Email in the TO field (a RightFax email
address), the timed event runs and gives us a status of "The e-mail address
of one or more recipients is not valid."
Our question is: How can we turn off email validation within reporting
services so it will connect to the SMTP server (Exchange)?
ThanksHi,
This issue is usually caused by the fact that Email Relay is not turned on.
You may see something like the following in the Reporting Services Logfiles:
ReportingServicesService!emailextension!b14!10/14/2004-08:20:06:: Error
sending mail, CDO error -2147220977, will not resend
ReportingServicesService!emailextension!b14!10/14/2004-08:20:06:: Error
sending email. System.Runtime.InteropServices.COMException (0x8004020F):
The server
rejected one or more recipient addresses. The server response was: 550
5.7.1 Unable to relay for xxx@.xxx.xxx
at ReportingServicesCDOInterop.MessageClass.Send()
at
Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.Deliver(Noti
fication notification)
ReportingServicesService!notification!b14!10/14/2004-08:20:06::
Notification 02710147-2025-4ed0-9c58-b37f12b64a79 completed. Success:
False, Status: The e-mail
address of one or more recipients is not valid., DeliveryExtension: Report
Server
Emai
If this is the case, you need to turn on email relay on the SMTP server.
If the error in the Reporting Services log file is not the same, please let
me know the exact error message so that we could get a better idea of the
issue.
The log file is usually located at:
C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\Logfiles
Thanks & Regards,
Justin Shen
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================Business-Critical Phone Support (BCPS) provides you with technical phone
support at no charge during critical LAN outages or "business down"
situations. This benefit is available 24 hours a day, 7 days a week to all
Microsoft technology partners in the United States and Canada.
This and other support options are available here:
BCPS:
https://partner.microsoft.com/US/technicalsupport/supportoverview/40010469
Others: https://partner.microsoft.com/US/technicalsupport/supportoverview/
If you are outside the United States, please visit our International
Support page:
http://support.microsoft.com/default.aspx?scid=%2finternational.aspx.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
| Reply-To: "isicoder" <isicoder@.newsgroups.nospam>
| From: "isicoder" <isicoder@.newsgroups.nospam>
| Subject: Email validation in ReportManager
| Date: Fri, 27 Jan 2006 12:35:16 -0800
| Lines: 16
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
| X-RFC2646: Format=Flowed; Original
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
| Message-ID: <OPD1vE4IGHA.424@.TK2MSFTNGP12.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| NNTP-Posting-Host: 67.96.36.252
| Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP12.phx.gbl
| Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.reportingsvcs:67707
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| Setting up a timed subscription in Reporting Services works just fine on
our
| server when the email address is joe@.domain.com. The Report server is
set
| up pointing to our SMTP server and works like a champ. Reports go out
and
| our chosen format (PDF) is generated and all is good.
|
| When we enter a non-standard Email in the TO field (a RightFax email
| address), the timed event runs and gives us a status of "The e-mail
address
| of one or more recipients is not valid."
|
| Our question is: How can we turn off email validation within reporting
| services so it will connect to the SMTP server (Exchange)?
|
| Thanks
|
|
|
|