Hi All
As per my post in microsoft... server NG, I keep getting a problem where my
DB maintenance plan just stops doing what it should, which in turn means
that if I don't paranoid-ly check it each day I get the scenario (like
today) where I find my backups haven't been working for a month!!!
What I would like to do is email the maintenance plan to a designated email
address so that I can easily see every morning whether or not it has worked.
I know the old SQL 6.5 used to provide SQL Mail, but this links in with MS
Exchange Server and I don't use this. I don't even have it running on my
SBS 2000 Server.
Is there anyway in SQL 2000 that I can get it to email the report via SMTP?
I'm familiar with JMail and it's COM/DLL is installed on my server if I
could use that.
Thanks RobbieFirst of all, can I suggest that you not use the maintenance plan for
backups? You can create jobs within the SQL Server Agent that will backup
your databases. Books Online (within the SQL Server program group) contains
T-SQL examples of backup scripts. If you are so inclined you can also
create jobs that perform the appropriate maintenance tasks (such as checkdb,
checkcatalog, updateusage, update statistics).
You could use XPSMTP http://sqldev.net/xp/xpsmtp.htm to send email alerts.
Keith
"Astra" <info@.noemail.com> wrote in message
news:uXPyFCzGFHA.2452@.TK2MSFTNGP10.phx.gbl...
> Hi All
> As per my post in microsoft... server NG, I keep getting a problem where
my
> DB maintenance plan just stops doing what it should, which in turn means
> that if I don't paranoid-ly check it each day I get the scenario (like
> today) where I find my backups haven't been working for a month!!!
> What I would like to do is email the maintenance plan to a designated
email
> address so that I can easily see every morning whether or not it has
worked.
> I know the old SQL 6.5 used to provide SQL Mail, but this links in with MS
> Exchange server and I don't use this. I don't even have it running on my
> SBS 2000 Server.
> Is there anyway in SQL 2000 that I can get it to email the report via
SMTP?
> I'm familiar with JMail and it's COM/DLL is installed on my server if I
> could use that.
> Thanks Robbie
>|||Hi
Check out http://www.sqldev.net/xp/xpsmtp.htm
Other possible mechanisms might mbe Notification Services or Reporting
Services.
John
"Astra" wrote:
> Hi All
> As per my post in microsoft... server NG, I keep getting a problem where
my
> DB maintenance plan just stops doing what it should, which in turn means
> that if I don't paranoid-ly check it each day I get the scenario (like
> today) where I find my backups haven't been working for a month!!!
> What I would like to do is email the maintenance plan to a designated emai
l
> address so that I can easily see every morning whether or not it has worke
d.
> I know the old SQL 6.5 used to provide SQL Mail, but this links in with MS
> Exchange server and I don't use this. I don't even have it running on my
> SBS 2000 Server.
> Is there anyway in SQL 2000 that I can get it to email the report via SMTP
?
> I'm familiar with JMail and it's COM/DLL is installed on my server if I
> could use that.
> Thanks Robbie
>
>|||Check out http://www.sqldev.net/xp.htm
HTH...
Joe Webb
SQL Server MVP
~~~
Get up to speed quickly with SQLNS
http://www.amazon.com/exec/obidos/t...il/-/0972688811
Keith Kratochvil wrote:
> First of all, can I suggest that you not use the maintenance plan for
> backups? You can create jobs within the SQL Server Agent that will backup
> your databases. Books Online (within the SQL Server program group) contai
ns
> T-SQL examples of backup scripts. If you are so inclined you can also
> create jobs that perform the appropriate maintenance tasks (such as checkd
b,
> checkcatalog, updateusage, update statistics).
> You could use XPSMTP http://sqldev.net/xp/xpsmtp.htm to send email alerts.
>|||Thanks Guys
"John Bell" <JohnBell@.discussions.microsoft.com> wrote in message
news:2E065D49-E910-48D1-8B7D-1B4FFB55DA73@.microsoft.com...
Hi
Check out http://www.sqldev.net/xp/xpsmtp.htm
Other possible mechanisms might mbe Notification Services or Reporting
Services.
John
"Astra" wrote:
> Hi All
> As per my post in microsoft... server NG, I keep getting a problem where
> my
> DB maintenance plan just stops doing what it should, which in turn means
> that if I don't paranoid-ly check it each day I get the scenario (like
> today) where I find my backups haven't been working for a month!!!
> What I would like to do is email the maintenance plan to a designated
> email
> address so that I can easily see every morning whether or not it has
> worked.
> I know the old SQL 6.5 used to provide SQL Mail, but this links in with MS
> Exchange server and I don't use this. I don't even have it running on my
> SBS 2000 Server.
> Is there anyway in SQL 2000 that I can get it to email the report via
> SMTP?
> I'm familiar with JMail and it's COM/DLL is installed on my server if I
> could use that.
> Thanks Robbie
>
>|||Keith,
I have found this useful as well, so thanks for the tip.
I am having difficulty putting in carriage returns and linefeeds and
wondered if you could help.
This works (names changed!):
exec master.dbo.xp_smtp_sendmail
@.FROM = 'Fred@.mail.com',
@.TO = 'Jim@.mail.com',
@.subject = 'Hello SQL Server SMTP Mail',
@.message = 'Goodbye MAPI and Outlook
@.server = 'ServerIPAddress'
But when I try and add a carriage return and line feed I get 'Incorrect
syntax near '+'' error:
exec master.dbo.xp_smtp_sendmail
@.FROM = 'Fred@.mail.com',
@.TO = 'Jim@.mail.com',
@.subject = 'Hello SQL Server SMTP Mail',
@.message = 'Goodbye MAPI and Outlook' + CHAR(13) + CHAR(10),
@.server = 'ServerIPAddress'
I would welcome some help.
Thanks,
Adrian
"Keith Kratochvil" <sqlguy.back2u@.comcast.net> wrote in message
news:Oia5I9zGFHA.1172@.TK2MSFTNGP12.phx.gbl...
> First of all, can I suggest that you not use the maintenance plan for
> backups? You can create jobs within the SQL Server Agent that will backup
> your databases. Books Online (within the SQL Server program group)
contains
> T-SQL examples of backup scripts. If you are so inclined you can also
> create jobs that perform the appropriate maintenance tasks (such as
checkdb,
> checkcatalog, updateusage, update statistics).
> You could use XPSMTP http://sqldev.net/xp/xpsmtp.htm to send email alerts.
> --
> Keith
>
> "Astra" <info@.noemail.com> wrote in message
> news:uXPyFCzGFHA.2452@.TK2MSFTNGP10.phx.gbl...
where
> my
> email
> worked.
MS
my
> SMTP?
>|||On Fri, 25 Feb 2005 16:33:12 -0000, Adrian wrote:
(snip)
>But when I try and add a carriage return and line feed I get 'Incorrect
>syntax near '+'' error:
>exec master.dbo.xp_smtp_sendmail
> @.FROM = 'Fred@.mail.com',
> @.TO = 'Jim@.mail.com',
> @.subject = 'Hello SQL Server SMTP Mail',
> @.message = 'Goodbye MAPI and Outlook' + CHAR(13) + CHAR(10),
> @.server = 'ServerIPAddress'
>I would welcome some help.
Hi Adrian,
Try this:
DECLARE @.msg varchar(40)
SET @.msg = 'Goodbye MAPI and Outlook' + CHAR(13) + CHAR(10)
exec master.dbo.xp_smtp_sendmail
@.FROM = 'Fred@.mail.com',
@.TO = 'Jim@.mail.com',
@.subject = 'Hello SQL Server SMTP Mail',
@.message = @.msg,
@.server = 'ServerIPAddress'
Best, Hugo
--
(Remove _NO_ and _SPAM_ to get my e-mail address)|||CHAR(13) + CHAR(10)
should do it
...
select 'test' + CHAR(13) + CHAR(10) + 'ing'
Keith
"Adrian" <NoSpam@.hotmail.com> wrote in message
news:uMM70e1GFHA.588@.TK2MSFTNGP10.phx.gbl...
> Keith,
> I have found this useful as well, so thanks for the tip.
> I am having difficulty putting in carriage returns and linefeeds and
> wondered if you could help.
> This works (names changed!):
> exec master.dbo.xp_smtp_sendmail
> @.FROM = 'Fred@.mail.com',
> @.TO = 'Jim@.mail.com',
> @.subject = 'Hello SQL Server SMTP Mail',
> @.message = 'Goodbye MAPI and Outlook
> @.server = 'ServerIPAddress'
> But when I try and add a carriage return and line feed I get 'Incorrect
> syntax near '+'' error:
> exec master.dbo.xp_smtp_sendmail
> @.FROM = 'Fred@.mail.com',
> @.TO = 'Jim@.mail.com',
> @.subject = 'Hello SQL Server SMTP Mail',
> @.message = 'Goodbye MAPI and Outlook' + CHAR(13) + CHAR(10),
> @.server = 'ServerIPAddress'
> I would welcome some help.
> Thanks,
> Adrian
> "Keith Kratochvil" <sqlguy.back2u@.comcast.net> wrote in message
> news:Oia5I9zGFHA.1172@.TK2MSFTNGP12.phx.gbl...
backup
> contains
> checkdb,
alerts.
> where
means
with
> MS
> my
I
>|||Thanks Keith and Hugo.
It works now.
Adrian
"Keith Kratochvil" <sqlguy.back2u@.comcast.net> wrote in message
news:u00Ti51GFHA.2936@.TK2MSFTNGP15.phx.gbl...
> CHAR(13) + CHAR(10)
> should do it
> ...
> select 'test' + CHAR(13) + CHAR(10) + 'ing'
> --
> Keith
>
> "Adrian" <NoSpam@.hotmail.com> wrote in message
> news:uMM70e1GFHA.588@.TK2MSFTNGP10.phx.gbl...
> backup
> alerts.
> means
(like
designated
> with
on
via
if
> I
>sql
Showing posts with label emailing. Show all posts
Showing posts with label emailing. Show all posts
Monday, March 26, 2012
Emailing results from query
Hi,
I just installed sql05 ent version and set up the DB Mail and ran a test
mail without a problem. I also managed to create a job which would execute a
query. I'd like now the sql server send to several email addresses the
results of the query and here where I'm stuck.
HOWDO you do it?
TIA
Ana
Read about sp_send_dbmail.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Ana" <ananospam@.yahoo.es> wrote in message
news:E878A2A8-B75A-4040-A252-DE709E44A372@.microsoft.com...
> Hi,
> I just installed sql05 ent version and set up the DB Mail and ran a test mail without a problem. I
> also managed to create a job which would execute a query. I'd like now the sql server send to
> several email addresses the results of the query and here where I'm stuck.
> HOWDO you do it?
> TIA
> Ana
|||Hi,
This atricle may be of use:
http://builder.com.com/5100-6388-6164310-2.html#Listing%20B
Dan
"Ana" <ananospam@.yahoo.es> wrote in message
news:E878A2A8-B75A-4040-A252-DE709E44A372@.microsoft.com...
> Hi,
> I just installed sql05 ent version and set up the DB Mail and ran a test
> mail without a problem. I also managed to create a job which would execute
> a query. I'd like now the sql server send to several email addresses the
> results of the query and here where I'm stuck.
> HOWDO you do it?
> TIA
> Ana
I just installed sql05 ent version and set up the DB Mail and ran a test
mail without a problem. I also managed to create a job which would execute a
query. I'd like now the sql server send to several email addresses the
results of the query and here where I'm stuck.
HOWDO you do it?
TIA
Ana
Read about sp_send_dbmail.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Ana" <ananospam@.yahoo.es> wrote in message
news:E878A2A8-B75A-4040-A252-DE709E44A372@.microsoft.com...
> Hi,
> I just installed sql05 ent version and set up the DB Mail and ran a test mail without a problem. I
> also managed to create a job which would execute a query. I'd like now the sql server send to
> several email addresses the results of the query and here where I'm stuck.
> HOWDO you do it?
> TIA
> Ana
|||Hi,
This atricle may be of use:
http://builder.com.com/5100-6388-6164310-2.html#Listing%20B
Dan
"Ana" <ananospam@.yahoo.es> wrote in message
news:E878A2A8-B75A-4040-A252-DE709E44A372@.microsoft.com...
> Hi,
> I just installed sql05 ent version and set up the DB Mail and ran a test
> mail without a problem. I also managed to create a job which would execute
> a query. I'd like now the sql server send to several email addresses the
> results of the query and here where I'm stuck.
> HOWDO you do it?
> TIA
> Ana
Emailing results from query
Hi,
I just installed sql05 ent version and set up the DB Mail and ran a test
mail without a problem. I also managed to create a job which would execute a
query. I'd like now the sql server send to several email addresses the
results of the query and here where I'm stuck.
HOWDO you do it?
TIA
AnaRead about sp_send_dbmail.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Ana" <ananospam@.yahoo.es> wrote in message
news:E878A2A8-B75A-4040-A252-DE709E44A372@.microsoft.com...
> Hi,
> I just installed sql05 ent version and set up the DB Mail and ran a test m
ail without a problem. I
> also managed to create a job which would execute a query. I'd like now the
sql server send to
> several email addresses the results of the query and here where I'm stuck.
> HOWDO you do it?
> TIA
> Ana|||Hi,
This atricle may be of use:
http://builder.com.com/5100-6388-61...tml#Listing%20B
Dan
"Ana" <ananospam@.yahoo.es> wrote in message
news:E878A2A8-B75A-4040-A252-DE709E44A372@.microsoft.com...
> Hi,
> I just installed sql05 ent version and set up the DB Mail and ran a test
> mail without a problem. I also managed to create a job which would execute
> a query. I'd like now the sql server send to several email addresses the
> results of the query and here where I'm stuck.
> HOWDO you do it?
> TIA
> Ana
I just installed sql05 ent version and set up the DB Mail and ran a test
mail without a problem. I also managed to create a job which would execute a
query. I'd like now the sql server send to several email addresses the
results of the query and here where I'm stuck.
HOWDO you do it?
TIA
AnaRead about sp_send_dbmail.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Ana" <ananospam@.yahoo.es> wrote in message
news:E878A2A8-B75A-4040-A252-DE709E44A372@.microsoft.com...
> Hi,
> I just installed sql05 ent version and set up the DB Mail and ran a test m
ail without a problem. I
> also managed to create a job which would execute a query. I'd like now the
sql server send to
> several email addresses the results of the query and here where I'm stuck.
> HOWDO you do it?
> TIA
> Ana|||Hi,
This atricle may be of use:
http://builder.com.com/5100-6388-61...tml#Listing%20B
Dan
"Ana" <ananospam@.yahoo.es> wrote in message
news:E878A2A8-B75A-4040-A252-DE709E44A372@.microsoft.com...
> Hi,
> I just installed sql05 ent version and set up the DB Mail and ran a test
> mail without a problem. I also managed to create a job which would execute
> a query. I'd like now the sql server send to several email addresses the
> results of the query and here where I'm stuck.
> HOWDO you do it?
> TIA
> Ana
Emailing results from query
Hi,
I just installed sql05 ent version and set up the DB Mail and ran a test
mail without a problem. I also managed to create a job which would execute a
query. I'd like now the sql server send to several email addresses the
results of the query and here where I'm stuck.
HOWDO you do it?
TIA
AnaRead about sp_send_dbmail.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Ana" <ananospam@.yahoo.es> wrote in message
news:E878A2A8-B75A-4040-A252-DE709E44A372@.microsoft.com...
> Hi,
> I just installed sql05 ent version and set up the DB Mail and ran a test mail without a problem. I
> also managed to create a job which would execute a query. I'd like now the sql server send to
> several email addresses the results of the query and here where I'm stuck.
> HOWDO you do it?
> TIA
> Ana|||Hi,
This atricle may be of use:
http://builder.com.com/5100-6388-6164310-2.html#Listing%20B
--
Dan
"Ana" <ananospam@.yahoo.es> wrote in message
news:E878A2A8-B75A-4040-A252-DE709E44A372@.microsoft.com...
> Hi,
> I just installed sql05 ent version and set up the DB Mail and ran a test
> mail without a problem. I also managed to create a job which would execute
> a query. I'd like now the sql server send to several email addresses the
> results of the query and here where I'm stuck.
> HOWDO you do it?
> TIA
> Ana
I just installed sql05 ent version and set up the DB Mail and ran a test
mail without a problem. I also managed to create a job which would execute a
query. I'd like now the sql server send to several email addresses the
results of the query and here where I'm stuck.
HOWDO you do it?
TIA
AnaRead about sp_send_dbmail.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Ana" <ananospam@.yahoo.es> wrote in message
news:E878A2A8-B75A-4040-A252-DE709E44A372@.microsoft.com...
> Hi,
> I just installed sql05 ent version and set up the DB Mail and ran a test mail without a problem. I
> also managed to create a job which would execute a query. I'd like now the sql server send to
> several email addresses the results of the query and here where I'm stuck.
> HOWDO you do it?
> TIA
> Ana|||Hi,
This atricle may be of use:
http://builder.com.com/5100-6388-6164310-2.html#Listing%20B
--
Dan
"Ana" <ananospam@.yahoo.es> wrote in message
news:E878A2A8-B75A-4040-A252-DE709E44A372@.microsoft.com...
> Hi,
> I just installed sql05 ent version and set up the DB Mail and ran a test
> mail without a problem. I also managed to create a job which would execute
> a query. I'd like now the sql server send to several email addresses the
> results of the query and here where I'm stuck.
> HOWDO you do it?
> TIA
> Ana
Emailing Reports
Hi everyone I have a database that I am creating for another department. He emails applications to potential vendors. And I was wanting sql to do this for him. I was reading about xtended procedures XP_Sendmail, but this is the first time I have created an extended stored procedure. I need for it to email an attachment (the report)Read BOL on xp_sendmail. It's all there.sql
Emailing report details
Hi,
I have a simple report that displays a page of text. I want to add a
button to it and
when the button is clicked a new outlook email is created with the
report as body, ready for the user to enter an email address.
Yes I know reports have subscriptions, they want a more adhoc
solution.
And users don't want the extra clicks of saving the report to file and
attaching it themselves.
Can it be done, is there an example?
thanks in advance.On Aug 1, 11:07 pm, paulhux...@.hotmail.com wrote:
> Hi,
> I have a simple report that displays a page of text. I want to add a
> button to it and
> when the button is clicked a new outlook email is created with the
> report as body, ready for the user to enter an email address.
> Yes I know reports have subscriptions, they want a more adhoc
> solution.
> And users don't want the extra clicks of saving the report to file and
> attaching it themselves.
> Can it be done, is there an example?
> thanks in advance.
There are not really any options available for this type of
functionality (aside from what you mentioned). If exporting the report
to PDF and attaching it to an email is an option, I would suggest
going the custom/ASP.NET application route. There is an open source
library available that can assist you in doing this: iTextSharp
(http://sourceforge.net/projects/itextsharp/http://itextsharp.sourceforge.net/tutorial/
). Otherwise, you will need to design a custom application that
includes a report viewer control that incorporates an SSRS report.
Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||On Aug 3, 11:31 am, EMartinez <emartinez...@.gmail.com> wrote:
> On Aug 1, 11:07 pm, paulhux...@.hotmail.com wrote:
> > Hi,
> > I have a simple report that displays a page of text. I want to add a
> > button to it and
> > when the button is clicked a new outlook email is created with the
> > report as body, ready for the user to enter an email address.
> > Yes I know reports have subscriptions, they want a more adhoc
> > solution.
> > And users don't want the extra clicks of saving the report to file and
> > attaching it themselves.
> > Can it be done, is there an example?
> > thanks in advance.
> There are not really any options available for this type of
> functionality (aside from what you mentioned). If exporting the report
> to PDF and attaching it to an email is an option, I would suggest
> going the custom/ASP.NET application route. There is an open source
> library available that can assist you in doing this: iTextSharp
> (http://sourceforge.net/projects/itextsharp/http://itextsharp.sourceforge.net/tutorial/
> ). Otherwise, you will need to design a custom application that
> includes a report viewer control that incorporates an SSRS report.
> Hope this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
****************************
thanks Enrique|||On Aug 2, 9:05 pm, paulhux...@.hotmail.com wrote:
> On Aug 3, 11:31 am, EMartinez <emartinez...@.gmail.com> wrote:
>
> > On Aug 1, 11:07 pm, paulhux...@.hotmail.com wrote:
> > > Hi,
> > > I have a simple report that displays a page of text. I want to add a
> > > button to it and
> > > when the button is clicked a new outlook email is created with the
> > > report as body, ready for the user to enter an email address.
> > > Yes I know reports have subscriptions, they want a more adhoc
> > > solution.
> > > And users don't want the extra clicks of saving the report to file and
> > > attaching it themselves.
> > > Can it be done, is there an example?
> > > thanks in advance.
> > There are not really any options available for this type of
> > functionality (aside from what you mentioned). If exporting the report
> > to PDF and attaching it to an email is an option, I would suggest
> > going the custom/ASP.NET application route. There is an open source
> > library available that can assist you in doing this: iTextSharp
> > (http://sourceforge.net/projects/itextsharp/http://itextsharp.sourcefo...
> > ). Otherwise, you will need to design a custom application that
> > includes a report viewer control that incorporates an SSRS report.
> > Hope this helps.
> > Regards,
> > Enrique Martinez
> > Sr. Software Consultant
> ****************************
> thanks Enrique
You're welcome. Let me know if I can be of further assistance.
Regards,
Enrique Martinez
Sr. Software Consultant
I have a simple report that displays a page of text. I want to add a
button to it and
when the button is clicked a new outlook email is created with the
report as body, ready for the user to enter an email address.
Yes I know reports have subscriptions, they want a more adhoc
solution.
And users don't want the extra clicks of saving the report to file and
attaching it themselves.
Can it be done, is there an example?
thanks in advance.On Aug 1, 11:07 pm, paulhux...@.hotmail.com wrote:
> Hi,
> I have a simple report that displays a page of text. I want to add a
> button to it and
> when the button is clicked a new outlook email is created with the
> report as body, ready for the user to enter an email address.
> Yes I know reports have subscriptions, they want a more adhoc
> solution.
> And users don't want the extra clicks of saving the report to file and
> attaching it themselves.
> Can it be done, is there an example?
> thanks in advance.
There are not really any options available for this type of
functionality (aside from what you mentioned). If exporting the report
to PDF and attaching it to an email is an option, I would suggest
going the custom/ASP.NET application route. There is an open source
library available that can assist you in doing this: iTextSharp
(http://sourceforge.net/projects/itextsharp/http://itextsharp.sourceforge.net/tutorial/
). Otherwise, you will need to design a custom application that
includes a report viewer control that incorporates an SSRS report.
Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||On Aug 3, 11:31 am, EMartinez <emartinez...@.gmail.com> wrote:
> On Aug 1, 11:07 pm, paulhux...@.hotmail.com wrote:
> > Hi,
> > I have a simple report that displays a page of text. I want to add a
> > button to it and
> > when the button is clicked a new outlook email is created with the
> > report as body, ready for the user to enter an email address.
> > Yes I know reports have subscriptions, they want a more adhoc
> > solution.
> > And users don't want the extra clicks of saving the report to file and
> > attaching it themselves.
> > Can it be done, is there an example?
> > thanks in advance.
> There are not really any options available for this type of
> functionality (aside from what you mentioned). If exporting the report
> to PDF and attaching it to an email is an option, I would suggest
> going the custom/ASP.NET application route. There is an open source
> library available that can assist you in doing this: iTextSharp
> (http://sourceforge.net/projects/itextsharp/http://itextsharp.sourceforge.net/tutorial/
> ). Otherwise, you will need to design a custom application that
> includes a report viewer control that incorporates an SSRS report.
> Hope this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
****************************
thanks Enrique|||On Aug 2, 9:05 pm, paulhux...@.hotmail.com wrote:
> On Aug 3, 11:31 am, EMartinez <emartinez...@.gmail.com> wrote:
>
> > On Aug 1, 11:07 pm, paulhux...@.hotmail.com wrote:
> > > Hi,
> > > I have a simple report that displays a page of text. I want to add a
> > > button to it and
> > > when the button is clicked a new outlook email is created with the
> > > report as body, ready for the user to enter an email address.
> > > Yes I know reports have subscriptions, they want a more adhoc
> > > solution.
> > > And users don't want the extra clicks of saving the report to file and
> > > attaching it themselves.
> > > Can it be done, is there an example?
> > > thanks in advance.
> > There are not really any options available for this type of
> > functionality (aside from what you mentioned). If exporting the report
> > to PDF and attaching it to an email is an option, I would suggest
> > going the custom/ASP.NET application route. There is an open source
> > library available that can assist you in doing this: iTextSharp
> > (http://sourceforge.net/projects/itextsharp/http://itextsharp.sourcefo...
> > ). Otherwise, you will need to design a custom application that
> > includes a report viewer control that incorporates an SSRS report.
> > Hope this helps.
> > Regards,
> > Enrique Martinez
> > Sr. Software Consultant
> ****************************
> thanks Enrique
You're welcome. Let me know if I can be of further assistance.
Regards,
Enrique Martinez
Sr. Software Consultant
Emailing Report
I need to export a view into excel and mail to my manager daily morning. Is there a way i can automate this process. I know how to convert view to excel but i need a better solution to automate this process with emailing to my mgr. Please suggest a better approach of doing this.
Thanks,
The send mail task accepts the use of file attachments.You are using SSIS, right?|||Or you might want to consider Reporting Services for this.|||
Thats true but how; Firstly i need to convert view to excel and then send excel sheet as attachment in email. Could you pls. explain how i could do this. I am a newbie.
Thanks
|||If you are going to use SSIS, create a new package, add a data flow task with an OLEDB source that retrieves the view. Add an Excel destination to the data flow to capture the results. Back in the control flow, add a Send Mail task to send the email.
If you want to do it in Reporting Services, post your question in the RS forum (http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=82&SiteID=1) and I'll answer it there. 
Emailing Query Results
Is there a way to have SQL server email the results of a Select query to someone?From BOL:
xp_sendmail
Sends a message and a query result set attachment to the specified recipients.
Syntax
xp_sendmail {[@.recipients =] 'recipients [;...n]'}
[,[@.message =] 'message']
[,[@.query =] 'query']
[,[@.attachments =] 'attachments [;...n]']
[,[@.copy_recipients =] 'copy_recipients [;...n]'
[,[@.blind_copy_recipients =] 'blind_copy_recipients [;...n]'
[,[@.subject =] 'subject']
[,[@.type =] 'type']
[,[@.attach_results =] 'attach_value']
[,[@.no_output =] 'output_value']
[,[@.no_header =] 'header_value']
[,[@.width =] width]
[,[@.separator =] 'separator']
[,[@.echo_error =] 'echo_value']
[,[@.set_user =] 'user']
[,[@.dbuse =] 'database']
xp_sendmail
Sends a message and a query result set attachment to the specified recipients.
Syntax
xp_sendmail {[@.recipients =] 'recipients [;...n]'}
[,[@.message =] 'message']
[,[@.query =] 'query']
[,[@.attachments =] 'attachments [;...n]']
[,[@.copy_recipients =] 'copy_recipients [;...n]'
[,[@.blind_copy_recipients =] 'blind_copy_recipients [;...n]'
[,[@.subject =] 'subject']
[,[@.type =] 'type']
[,[@.attach_results =] 'attach_value']
[,[@.no_output =] 'output_value']
[,[@.no_header =] 'header_value']
[,[@.width =] width]
[,[@.separator =] 'separator']
[,[@.echo_error =] 'echo_value']
[,[@.set_user =] 'user']
[,[@.dbuse =] 'database']
Emailing query questions
Hello,
I am very new to sql server (as in, still reading the table of contents in
the big honkin' book I bought).
is there a way for users to send an inquiry to an email address, and get a
response from sql server? It would be very helpful if someone could send an
email to parts@.##.com with a part number in the header, and get an email in
response with information on that part.
I also have exchange server 2003, if that helps.
Thanks in advance,I do not know a way in SQL 2005 other than custom coding...
In SQL 2000 there was a stored procedure sp_processmail which could do what
you ask - but you shouldn't use it in new dev because it is going away...
--
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
I support the Professional Association for SQL Server ( PASS) and it''s
community of SQL Professionals.
"JohnGregor" wrote:
> Hello,
> I am very new to sql server (as in, still reading the table of contents in
> the big honkin' book I bought).
> is there a way for users to send an inquiry to an email address, and get a
> response from sql server? It would be very helpful if someone could send an
> email to parts@.##.com with a part number in the header, and get an email in
> response with information on that part.
> I also have exchange server 2003, if that helps.
> Thanks in advance,|||<< deep sigh >>
It's never easy.
Thanks for your help, you probably saved me a week of looking.
"Wayne Snyder" wrote:
> I do not know a way in SQL 2005 other than custom coding...
> In SQL 2000 there was a stored procedure sp_processmail which could do what
> you ask - but you shouldn't use it in new dev because it is going away...
> --
> Wayne Snyder MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> I support the Professional Association for SQL Server ( PASS) and it''s
> community of SQL Professionals.
>
> "JohnGregor" wrote:
> > Hello,
> >
> > I am very new to sql server (as in, still reading the table of contents in
> > the big honkin' book I bought).
> >
> > is there a way for users to send an inquiry to an email address, and get a
> > response from sql server? It would be very helpful if someone could send an
> > email to parts@.##.com with a part number in the header, and get an email in
> > response with information on that part.
> >
> > I also have exchange server 2003, if that helps.
> >
> > Thanks in advance,
I am very new to sql server (as in, still reading the table of contents in
the big honkin' book I bought).
is there a way for users to send an inquiry to an email address, and get a
response from sql server? It would be very helpful if someone could send an
email to parts@.##.com with a part number in the header, and get an email in
response with information on that part.
I also have exchange server 2003, if that helps.
Thanks in advance,I do not know a way in SQL 2005 other than custom coding...
In SQL 2000 there was a stored procedure sp_processmail which could do what
you ask - but you shouldn't use it in new dev because it is going away...
--
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
I support the Professional Association for SQL Server ( PASS) and it''s
community of SQL Professionals.
"JohnGregor" wrote:
> Hello,
> I am very new to sql server (as in, still reading the table of contents in
> the big honkin' book I bought).
> is there a way for users to send an inquiry to an email address, and get a
> response from sql server? It would be very helpful if someone could send an
> email to parts@.##.com with a part number in the header, and get an email in
> response with information on that part.
> I also have exchange server 2003, if that helps.
> Thanks in advance,|||<< deep sigh >>
It's never easy.
Thanks for your help, you probably saved me a week of looking.
"Wayne Snyder" wrote:
> I do not know a way in SQL 2005 other than custom coding...
> In SQL 2000 there was a stored procedure sp_processmail which could do what
> you ask - but you shouldn't use it in new dev because it is going away...
> --
> Wayne Snyder MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> I support the Professional Association for SQL Server ( PASS) and it''s
> community of SQL Professionals.
>
> "JohnGregor" wrote:
> > Hello,
> >
> > I am very new to sql server (as in, still reading the table of contents in
> > the big honkin' book I bought).
> >
> > is there a way for users to send an inquiry to an email address, and get a
> > response from sql server? It would be very helpful if someone could send an
> > email to parts@.##.com with a part number in the header, and get an email in
> > response with information on that part.
> >
> > I also have exchange server 2003, if that helps.
> >
> > Thanks in advance,
Emailing long messages from SQL2000
Hello!
The problem is this.
I have many short messages in a table. I need to tigh them together in one long email message and email to the users.
But xp_sendmail is limited to 7,790.
How could I send longer messages? Or how could I devide the long message and send it in parts (i.e. separate consequtive emails)?
This doesn't work, it still cuts the messages off at around 7,790:
E. Send messages longer than 7,990 characters
This example shows how to send a message longer than 7,990 characters. Because message is limited to the length of a varchar (less row overhead, as are all stored procedure parameters), this example writes the long message into a global temporary table consisting of a single text column. The contents of this temporary table are then sent in mail using the @.query parameter.
CREATE TABLE ##texttab (c1 text)INSERT ##texttab values ('Put your long message here.')
DECLARE @.cmd varchar(56)
SET @.cmd = 'SELECT c1 FROM ##texttab'
EXEC master.dbo.xp_sendmail 'robertk',
@.query = @.cmd, @.no_header= 'TRUE'
DROP TABLE ##texttab
you can output the query to a file
then have it as an attachment
|||Thank you very much for the quick response!
I just tried using @.attach_results with xp_sendmail, it properly created a file and emailed it, but the text in the file was still cut off at the same point as before.
Is there any any method of outputting a query to a file?
Thanks again!
|||hi,
im referrring to this not the other one
xp_sendmail {[@.recipients =] 'recipients [;...n]'}
[,[@.message =] 'message']
[,[@.query =] 'query']
[,[@.attachments =] 'attachments [;...n]']
[,[@.copy_recipients =] 'copy_recipients [;...n]'
[,[@.blind_copy_recipients =] 'blind_copy_recipients [;...n]'
[,[@.subject =] 'subject']
[,[@.type =] 'type']
[,[@.attach_results =] 'attach_value']
[,[@.no_output =] 'output_value']
[,[@.no_header =] 'header_value']
[,[@.width =] width]
[,[@.separator =] 'separator']
[,[@.echo_error =] 'echo_value']
[,[@.set_user =] 'user']
[,[@.dbuse =] 'database']Arguments
[@.attachments =] 'attachments [;...n]'
Is a semicolon-separated list of files to attach to the mail message.
hope it helps.
regards,
joey
|||Yes, the problem is I don't know how to output data from a stored procedure to a file...|||
use bcp.
call bcp from xp_cmdshell
|||
you could use a Job to move your email into a file and later, send your email.
is it work for you ?
Regards.
|||Did you try some code similar to the one in the sample? Can you check the actual datalength of the value you are trying to return in your query? Using above example, you can do "select datalength(c1) from ##texttab" to verify the length. The query functionality supports text/ntext data so you should be able to create email message >8000 characters.sqlEmailing from the SQL 2000 server
I have a few maintenance routines created and SQL 2000 has options to email
the reports. Do I need to have Outlook installed on the SQL server to do
these emails.
Also, since outlook uses user profiles I assume that I must log onto the SQL
server as the account used to run SQL server to configure Outlook. If that
is the case, how can I have other administrators configure notifications
without everyone using the same account to configure the SQL server? I
loose accountability when everyone uses the same account.Hello jordan
Yes, thats true, you must install Outlook in the SQL Servers Windows
profile.
But
I use SQLDev.NET:s xp_smtp_sendmail. Its working very good.
http://www.sqldev.net
Then you can create a SQL Alert to use for DBMaint.
http://www.dbmaint.com/SmtpAlerter.asp
Have just tried the Alert, but i dont have it in production
Best Regards
/Jens
Jordan wrote:
> I have a few maintenance routines created and SQL 2000 has options to emai
l
> the reports. Do I need to have Outlook installed on the SQL server to do
> these emails.
> Also, since outlook uses user profiles I assume that I must log onto the S
QL
> server as the account used to run SQL server to configure Outlook. If tha
t
> is the case, how can I have other administrators configure notifications
> without everyone using the same account to configure the SQL server? I
> loose accountability when everyone uses the same account.|||Jordan wrote:
> I have a few maintenance routines created and SQL 2000 has options to emai
l
> the reports. Do I need to have Outlook installed on the SQL server to do
> these emails.
> Also, since outlook uses user profiles I assume that I must log onto the S
QL
> server as the account used to run SQL server to configure Outlook. If tha
t
> is the case, how can I have other administrators configure notifications
> without everyone using the same account to configure the SQL server? I
> loose accountability when everyone uses the same account.
>
Outlook must be installed and a profile configured ONLY under the login
that the SQL services run under, not under each administrator's login.
You'll then configure the SQL Mail component to use that profile. Your
admins will continue to configure notifications as they do now.
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||Take a look into this URL on configuring Email.
http://classicasp.aspfaq.com/email/...sql-server.html
Thanks
Hari
SQL Server MVP
"Jordan" <none@.here.com> wrote in message
news:eD1DB6rwGHA.888@.TK2MSFTNGP02.phx.gbl...
>I have a few maintenance routines created and SQL 2000 has options to email
>the reports. Do I need to have Outlook installed on the SQL server to do
>these emails.
> Also, since outlook uses user profiles I assume that I must log onto the
> SQL server as the account used to run SQL server to configure Outlook. If
> that is the case, how can I have other administrators configure
> notifications without everyone using the same account to configure the SQL
> server? I loose accountability when everyone uses the same account.
>
the reports. Do I need to have Outlook installed on the SQL server to do
these emails.
Also, since outlook uses user profiles I assume that I must log onto the SQL
server as the account used to run SQL server to configure Outlook. If that
is the case, how can I have other administrators configure notifications
without everyone using the same account to configure the SQL server? I
loose accountability when everyone uses the same account.Hello jordan
Yes, thats true, you must install Outlook in the SQL Servers Windows
profile.
But
I use SQLDev.NET:s xp_smtp_sendmail. Its working very good.
http://www.sqldev.net
Then you can create a SQL Alert to use for DBMaint.
http://www.dbmaint.com/SmtpAlerter.asp
Have just tried the Alert, but i dont have it in production
Best Regards
/Jens
Jordan wrote:
> I have a few maintenance routines created and SQL 2000 has options to emai
l
> the reports. Do I need to have Outlook installed on the SQL server to do
> these emails.
> Also, since outlook uses user profiles I assume that I must log onto the S
QL
> server as the account used to run SQL server to configure Outlook. If tha
t
> is the case, how can I have other administrators configure notifications
> without everyone using the same account to configure the SQL server? I
> loose accountability when everyone uses the same account.|||Jordan wrote:
> I have a few maintenance routines created and SQL 2000 has options to emai
l
> the reports. Do I need to have Outlook installed on the SQL server to do
> these emails.
> Also, since outlook uses user profiles I assume that I must log onto the S
QL
> server as the account used to run SQL server to configure Outlook. If tha
t
> is the case, how can I have other administrators configure notifications
> without everyone using the same account to configure the SQL server? I
> loose accountability when everyone uses the same account.
>
Outlook must be installed and a profile configured ONLY under the login
that the SQL services run under, not under each administrator's login.
You'll then configure the SQL Mail component to use that profile. Your
admins will continue to configure notifications as they do now.
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||Take a look into this URL on configuring Email.
http://classicasp.aspfaq.com/email/...sql-server.html
Thanks
Hari
SQL Server MVP
"Jordan" <none@.here.com> wrote in message
news:eD1DB6rwGHA.888@.TK2MSFTNGP02.phx.gbl...
>I have a few maintenance routines created and SQL 2000 has options to email
>the reports. Do I need to have Outlook installed on the SQL server to do
>these emails.
> Also, since outlook uses user profiles I assume that I must log onto the
> SQL server as the account used to run SQL server to configure Outlook. If
> that is the case, how can I have other administrators configure
> notifications without everyone using the same account to configure the SQL
> server? I loose accountability when everyone uses the same account.
>
Emailing from the SQL 2000 server
I have a few maintenance routines created and SQL 2000 has options to email
the reports. Do I need to have Outlook installed on the SQL server to do
these emails.
Also, since outlook uses user profiles I assume that I must log onto the SQL
server as the account used to run SQL server to configure Outlook. If that
is the case, how can I have other administrators configure notifications
without everyone using the same account to configure the SQL server? I
loose accountability when everyone uses the same account.Hello jordan
Yes, thats true, you must install Outlook in the SQL Servers Windows
profile.
But
I use SQLDev.NET:s xp_smtp_sendmail. Its working very good.
http://www.sqldev.net
Then you can create a SQL Alert to use for DBMaint.
http://www.dbmaint.com/SmtpAlerter.asp
Have just tried the Alert, but i dont have it in production
Best Regards
/Jens
Jordan wrote:
> I have a few maintenance routines created and SQL 2000 has options to email
> the reports. Do I need to have Outlook installed on the SQL server to do
> these emails.
> Also, since outlook uses user profiles I assume that I must log onto the SQL
> server as the account used to run SQL server to configure Outlook. If that
> is the case, how can I have other administrators configure notifications
> without everyone using the same account to configure the SQL server? I
> loose accountability when everyone uses the same account.|||Jordan wrote:
> I have a few maintenance routines created and SQL 2000 has options to email
> the reports. Do I need to have Outlook installed on the SQL server to do
> these emails.
> Also, since outlook uses user profiles I assume that I must log onto the SQL
> server as the account used to run SQL server to configure Outlook. If that
> is the case, how can I have other administrators configure notifications
> without everyone using the same account to configure the SQL server? I
> loose accountability when everyone uses the same account.
>
Outlook must be installed and a profile configured ONLY under the login
that the SQL services run under, not under each administrator's login.
You'll then configure the SQL Mail component to use that profile. Your
admins will continue to configure notifications as they do now.
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||Take a look into this URL on configuring Email.
http://classicasp.aspfaq.com/email/how-do-i-send-e-mail-from-sql-server.html
Thanks
Hari
SQL Server MVP
"Jordan" <none@.here.com> wrote in message
news:eD1DB6rwGHA.888@.TK2MSFTNGP02.phx.gbl...
>I have a few maintenance routines created and SQL 2000 has options to email
>the reports. Do I need to have Outlook installed on the SQL server to do
>these emails.
> Also, since outlook uses user profiles I assume that I must log onto the
> SQL server as the account used to run SQL server to configure Outlook. If
> that is the case, how can I have other administrators configure
> notifications without everyone using the same account to configure the SQL
> server? I loose accountability when everyone uses the same account.
>
the reports. Do I need to have Outlook installed on the SQL server to do
these emails.
Also, since outlook uses user profiles I assume that I must log onto the SQL
server as the account used to run SQL server to configure Outlook. If that
is the case, how can I have other administrators configure notifications
without everyone using the same account to configure the SQL server? I
loose accountability when everyone uses the same account.Hello jordan
Yes, thats true, you must install Outlook in the SQL Servers Windows
profile.
But
I use SQLDev.NET:s xp_smtp_sendmail. Its working very good.
http://www.sqldev.net
Then you can create a SQL Alert to use for DBMaint.
http://www.dbmaint.com/SmtpAlerter.asp
Have just tried the Alert, but i dont have it in production
Best Regards
/Jens
Jordan wrote:
> I have a few maintenance routines created and SQL 2000 has options to email
> the reports. Do I need to have Outlook installed on the SQL server to do
> these emails.
> Also, since outlook uses user profiles I assume that I must log onto the SQL
> server as the account used to run SQL server to configure Outlook. If that
> is the case, how can I have other administrators configure notifications
> without everyone using the same account to configure the SQL server? I
> loose accountability when everyone uses the same account.|||Jordan wrote:
> I have a few maintenance routines created and SQL 2000 has options to email
> the reports. Do I need to have Outlook installed on the SQL server to do
> these emails.
> Also, since outlook uses user profiles I assume that I must log onto the SQL
> server as the account used to run SQL server to configure Outlook. If that
> is the case, how can I have other administrators configure notifications
> without everyone using the same account to configure the SQL server? I
> loose accountability when everyone uses the same account.
>
Outlook must be installed and a profile configured ONLY under the login
that the SQL services run under, not under each administrator's login.
You'll then configure the SQL Mail component to use that profile. Your
admins will continue to configure notifications as they do now.
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||Take a look into this URL on configuring Email.
http://classicasp.aspfaq.com/email/how-do-i-send-e-mail-from-sql-server.html
Thanks
Hari
SQL Server MVP
"Jordan" <none@.here.com> wrote in message
news:eD1DB6rwGHA.888@.TK2MSFTNGP02.phx.gbl...
>I have a few maintenance routines created and SQL 2000 has options to email
>the reports. Do I need to have Outlook installed on the SQL server to do
>these emails.
> Also, since outlook uses user profiles I assume that I must log onto the
> SQL server as the account used to run SQL server to configure Outlook. If
> that is the case, how can I have other administrators configure
> notifications without everyone using the same account to configure the SQL
> server? I loose accountability when everyone uses the same account.
>
Emailing from MS SQL
Hey,
I would like to set up a job to send mail out to clients on a semi-regular basis. Is there a way to mail directly from MS SQL.
or some application which I can set to interface with MS SQL and send these mails out.
I'm currently using asp.net, however, doing it through the web is very time consuming, I would much rather use some application to generate the mails on the server as it currently takes close to 20 min to send through the web interface (and that's only to 900 members, we are looking at having at least 2000 members in a few weeks). What am I looking for is something I can call perhaps with transact sql so I can run it through an ms sql server job, however any solution you have would be fantastic.
If you don't have specific details, that's fine, I'm not even sure what apps etc to look into, even a name of some technology to use (or does MS SQL have a way of doing all of this itself?)
Thanks a lot for your help, life saver ;-)have you looked at xp_sendmail in the bol??|||lol, arg, it's always something simple.
Awesome, that looks pretty much like example what I want.
Thanks a lot mate ;-)|||So worries, hope it works out for you. I have often wanted to use it but due to server setup and network admins being what they are it's never happened... :(|||it's pretty simple to set up SQLMail
the trick is to get the SQL Server agent a domain user account to use as a startup account. then just set up a user mail profile by logging in as that user account. and opening your client (Isuggest outlook 98 or newer)
it will work with any MAPI1 compatible mail server even so even lotus notes...|||KBA (http://support.microsoft.com/default.aspx?kbid=263556) to configure the SQLMail.|||even so even so even so even so
sorry i was stuck in the inner groove of sgt pepper|||Hey,
I've had a few weeks on another project, and I'm back onto this job again (um, yay?, lol).
Anyway, I have had a look over the KBA link Satya posted. I am unsure if this will solve my problem, so, here are some more details about my situation.
I have a dedicated webserver at Cradle (an internet hosting company in australia).
My machine is isolated from the other machines (I'm not 100% sure about this, but it 'seems' to be the case).
They have a mail server which is something like: host1.xxxxxx.com.au. I need to send my mail through this.
The mail I send, I also need to be able to control the <From> field.
As the user who sends the mail, needs to be the user who the message is <From>, the stuff I've read in the KBA seems to send the mail through a single mail account (correct me if I'm wrong).
Also, I don't have access to Outlook on that machine. Is there some free tool etc I can install, or will I need to ship an old copy of outlook to the server for them to install for me?
Thanks, I'll head back to the KBA and keep reading now, see if I can't try and answer my own questions (fingers crossed)|||If you don't wish to set up SQL Server with a domain account or if you don't wish to use Outlook/Exchange, there are alternatives. I use a stored procedure that just needs a SMTP server to relay mail through that I found here:
http://www.sqlservercentral.com/scripts/contributions/510.asp
You'll have to register with the site to get the script, but it's well worth it. Their script library is VERY impressive.
I would like to set up a job to send mail out to clients on a semi-regular basis. Is there a way to mail directly from MS SQL.
or some application which I can set to interface with MS SQL and send these mails out.
I'm currently using asp.net, however, doing it through the web is very time consuming, I would much rather use some application to generate the mails on the server as it currently takes close to 20 min to send through the web interface (and that's only to 900 members, we are looking at having at least 2000 members in a few weeks). What am I looking for is something I can call perhaps with transact sql so I can run it through an ms sql server job, however any solution you have would be fantastic.
If you don't have specific details, that's fine, I'm not even sure what apps etc to look into, even a name of some technology to use (or does MS SQL have a way of doing all of this itself?)
Thanks a lot for your help, life saver ;-)have you looked at xp_sendmail in the bol??|||lol, arg, it's always something simple.
Awesome, that looks pretty much like example what I want.
Thanks a lot mate ;-)|||So worries, hope it works out for you. I have often wanted to use it but due to server setup and network admins being what they are it's never happened... :(|||it's pretty simple to set up SQLMail
the trick is to get the SQL Server agent a domain user account to use as a startup account. then just set up a user mail profile by logging in as that user account. and opening your client (Isuggest outlook 98 or newer)
it will work with any MAPI1 compatible mail server even so even lotus notes...|||KBA (http://support.microsoft.com/default.aspx?kbid=263556) to configure the SQLMail.|||even so even so even so even so
sorry i was stuck in the inner groove of sgt pepper|||Hey,
I've had a few weeks on another project, and I'm back onto this job again (um, yay?, lol).
Anyway, I have had a look over the KBA link Satya posted. I am unsure if this will solve my problem, so, here are some more details about my situation.
I have a dedicated webserver at Cradle (an internet hosting company in australia).
My machine is isolated from the other machines (I'm not 100% sure about this, but it 'seems' to be the case).
They have a mail server which is something like: host1.xxxxxx.com.au. I need to send my mail through this.
The mail I send, I also need to be able to control the <From> field.
As the user who sends the mail, needs to be the user who the message is <From>, the stuff I've read in the KBA seems to send the mail through a single mail account (correct me if I'm wrong).
Also, I don't have access to Outlook on that machine. Is there some free tool etc I can install, or will I need to ship an old copy of outlook to the server for them to install for me?
Thanks, I'll head back to the KBA and keep reading now, see if I can't try and answer my own questions (fingers crossed)|||If you don't wish to set up SQL Server with a domain account or if you don't wish to use Outlook/Exchange, there are alternatives. I use a stored procedure that just needs a SMTP server to relay mail through that I found here:
http://www.sqlservercentral.com/scripts/contributions/510.asp
You'll have to register with the site to get the script, but it's well worth it. Their script library is VERY impressive.
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?
>
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?
>
Emailing Errors
I'm sort of new to SSIS so I apologize if this is a trivial question:
I setup a package and want it to email me if there is any errors. Right now I got it working to send me a pre-written message about the failure, but I want to load the full task failure message into variable and email it on the email body.
But so far I have not found a way to save the error messages into variables so I can email them. Anyone can help with that one?
As far as I know there is no one system variable that stores the error message. So, you may not be able to use expressions with variables.
Also, keep in mind that you could get multiple errors per package. So, a single variable won't do the job.
An error report is what you basically need.
Assuming you are setting the "OnError" event handler, the error message, container name, etc. are logged in the sysdtslog90 table. You can query the table using the execution guid, which is available as a system variable to the package.
You can then dump the result set into an excel or a text file and email it as an attachment.
|||How did you set up even a pre-written mail message for errors?
Right now, I have an error log and a success mail message if everything else completes, but an error mail would be awesome.
|||sorry. i figured it out. i am new to ssis (3 months) and just noticed the event handler tab. please try to control your laughter.
|||Under email task editor- build an Expression for "Message source"
you could then do something like:
" There was a critical error in the Your Load. Error Msg follows " + @.[System::ErrorDescription]
to bubble up the error message.
sqlEmailing Errors
I'm sort of new to SSIS so I apologize if this is a trivial question:
I setup a package and want it to email me if there is any errors. Right now I got it working to send me a pre-written message about the failure, but I want to load the full task failure message into variable and email it on the email body.
But so far I have not found a way to save the error messages into variables so I can email them. Anyone can help with that one?
As far as I know there is no one system variable that stores the error message. So, you may not be able to use expressions with variables.
Also, keep in mind that you could get multiple errors per package. So, a single variable won't do the job.
An error report is what you basically need.
Assuming you are setting the "OnError" event handler, the error message, container name, etc. are logged in the sysdtslog90 table. You can query the table using the execution guid, which is available as a system variable to the package.
You can then dump the result set into an excel or a text file and email it as an attachment.
|||How did you set up even a pre-written mail message for errors?
Right now, I have an error log and a success mail message if everything else completes, but an error mail would be awesome.
|||sorry. i figured it out. i am new to ssis (3 months) and just noticed the event handler tab. please try to control your laughter.
|||Under email task editor- build an Expression for "Message source"
you could then do something like:
" There was a critical error in the Your Load. Error Msg follows " + @.[System::ErrorDescription]
to bubble up the error message.
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
<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
Subscribe to:
Posts (Atom)