Credentials trouble, please help

Hello,
When I created the datasource for my report, I checkd the save checkbox to
save the username and password to connect to the database, but invoking the
report thru URL integration fails and gives an error b/c of credentials. Why
is that happening if the credentials are saved with the datasource inside the
report?
What is the limitation to the number of characters that can be passed in a
URL string?
Thank you in advance,
RichardI had a similiar problem with the report server. I ended up changing
the credentials to server credentials in both the report properties and
in the properties of the report once it was on the server. Hope this
helps.

creating view as a parameter query

Hi,
I created a view in EM and when i right-click to go to the query designer
it allows me to set some parameter but i seem not able to save this as part
of a view ?
how can i do that or is there other alternatives ?
tks & rdgs
You can create a table function to simulate a parameterized view. See "create
function" in BOL.
AMB
"maxzsim" wrote:

> Hi,
> I created a view in EM and when i right-click to go to the query designer
> it allows me to set some parameter but i seem not able to save this as part
> of a view ?
> how can i do that or is there other alternatives ?
> tks & rdgs

creating view as a parameter query

Hi,
I created a view in EM and when i right-click to go to the query designer
it allows me to set some parameter but i seem not able to save this as part
of a view ?
how can i do that or is there other alternatives ?
tks & rdgsYou can create a table function to simulate a parameterized view. See "creat
e
function" in BOL.
AMB
"maxzsim" wrote:

> Hi,
> I created a view in EM and when i right-click to go to the query designer
> it allows me to set some parameter but i seem not able to save this as par
t
> of a view ?
> how can i do that or is there other alternatives ?
> tks & rdgs

creating view as a parameter query

Hi,
I created a view in EM and when i right-click to go to the query designer
it allows me to set some parameter but i seem not able to save this as part
of a view ?
how can i do that or is there other alternatives ?
tks & rdgsYou can create a table function to simulate a parameterized view. See "create
function" in BOL.
AMB
"maxzsim" wrote:
> Hi,
> I created a view in EM and when i right-click to go to the query designer
> it allows me to set some parameter but i seem not able to save this as part
> of a view ?
> how can i do that or is there other alternatives ?
> tks & rdgssql

Creating UDF?

I find PLENTY of examples of User Defined functions. However, I
struggle to see how/where to SAVE this function! I can go under the
database, Programmability, Functions, Scalar Functions, and create a
scalar function. However, when I click SAVE I get prompted to save the
.sql file to disk. If I close that (query) tab, then the function is
gone as well.
How do I persist the function in a database?Once you have coded your function, you need to execute it. When you use
Programmability > Functions > New > Scalar-valued Function, what SSMS is
doing is just giving you a template that you fill out. Once done, you need
to execute it (using the Execute button on the toolbar). This will then
persist it. The "Save" option is to save what you have written into disk.
--
HTH,
SriSamp
Email: srisamp@.gmail.com
Blog: http://blogs.sqlxml.org/srinivassampath
URL: http://www32.brinkster.com/srisamp
<mikes@.vmsmailingservices.com> wrote in message
news:1132627531.702420.199000@.z14g2000cwz.googlegroups.com...
>I find PLENTY of examples of User Defined functions. However, I
> struggle to see how/where to SAVE this function! I can go under the
> database, Programmability, Functions, Scalar Functions, and create a
> scalar function. However, when I click SAVE I get prompted to save the
> .sql file to disk. If I close that (query) tab, then the function is
> gone as well.
> How do I persist the function in a database?
>

Creating UDF In SQL Server 2005?

I find PLENTY of examples of User Defined functions. However, I
struggle to see how/where to SAVE this function! I can go under the
database, Programmability, Functions, Scalar Functions, and create a
scalar function. However, when I click SAVE I get prompted to save the
.sql file to disk. If I close that (query) tab, then the function is
gone as well.
How do I persist the function in a database? I should note that this is
for SQL Server 2005.<mikes@.vmsmailingservices.com> wrote in message
news:1132627572.039473.90980@.g47g2000cwa.googlegroups.com...
> I find PLENTY of examples of User Defined functions. However, I
> struggle to see how/where to SAVE this function! I can go under
the
> database, Programmability, Functions, Scalar Functions, and create
a
> scalar function. However, when I click SAVE I get prompted to save
the
> .sql file to disk. If I close that (query) tab, then the function
is
> gone as well.
> How do I persist the function in a database? I should note that
this is
> for SQL Server 2005.
>
mikes,
The .sql files are just text files with another extension. Of
course you want to save them as your scripts, but if you want to
check out your stored procedures and functions in the database,
then:
SELECT R1.*
FROM INFORMATION_SCHEMA.ROUTINES AS R1
Sincerely,
Chris O.|||Hi Mike,
When you run the text that you have just created then teh SQL server creates
the object in the database. The text is no longer needed by the SQL Server.
You should however save this text to a file and that file can be stored
anywhere you like
kind regards
Greg O
--
Looking to use CLR in SQL 2005. Try some pre-build CLR Functions and SP
AGS SQL 2005 Utilities, over 20+ functions
http://www.ag-software.com/?tabid=38
<mikes@.vmsmailingservices.com> wrote in message
news:1132627572.039473.90980@.g47g2000cwa.googlegroups.com...
>I find PLENTY of examples of User Defined functions. However, I
> struggle to see how/where to SAVE this function! I can go under the
> database, Programmability, Functions, Scalar Functions, and create a
> scalar function. However, when I click SAVE I get prompted to save the
> .sql file to disk. If I close that (query) tab, then the function is
> gone as well.
> How do I persist the function in a database? I should note that this is
> for SQL Server 2005.
>|||Why save it when sql will give you the create statement any time you need
it?
William Stacey [MVP]
"GregO" <grego@.community.nospam> wrote in message
news:e8rKpwx7FHA.2816@.tk2msftngp13.phx.gbl...
> Hi Mike,
> When you run the text that you have just created then teh SQL server
> creates the object in the database. The text is no longer needed by the
> SQL Server. You should however save this text to a file and that file can
> be stored anywhere you like
> kind regards
> Greg O
> --
> Looking to use CLR in SQL 2005. Try some pre-build CLR Functions and SP
> AGS SQL 2005 Utilities, over 20+ functions
> http://www.ag-software.com/?tabid=38
> <mikes@.vmsmailingservices.com> wrote in message
> news:1132627572.039473.90980@.g47g2000cwa.googlegroups.com...
>|||Hello mikes@.vmsmailingservices.com,

> I find PLENTY of examples of User Defined functions. However, I
> struggle to see how/where to SAVE this function! I can go under the
> database, Programmability, Functions, Scalar Functions, and create a
> scalar function. However, when I click SAVE I get prompted to save the
> .sql file to disk. If I close that (query) tab, then the function is
> gone as well.
> How do I persist the function in a database? I should note that this
> is for SQL Server 2005.
Rephrasing some of the answers you've gotten thus far, as soon as you execut
e
the CREATE FUNCTION statement, a "complied" version of the function is commi
tted
to the database. There's no need to save the text version of it, since, when
you issued that same CREATE FUNCTION statement, SQL Server also saved that
to the database.
Make sense?
Thank you,
Kent Tegels
DevelopMentor
http://staff.develop.com/ktegels/|||Hi William
Seriously?
What happens when some deletes it or changes the structure. You need
something to compare it to. There so many reasons for keeping the command
syntax and next to none for not keeping it. When in doubt keep the command.
kind regards
Greg O
--
Looking to use CLR in SQL 2005. Try some pre-build CLR Functions and SP
AGS SQL 2005 Utilities, over 20+ functions
http://www.ag-software.com/?tabid=38
"William Stacey [MVP]" <william.stacey@.gmail.com> wrote in message
news:OVdiJWy7FHA.472@.TK2MSFTNGP15.phx.gbl...
> Why save it when sql will give you the create statement any time you need
> it?
> --
> William Stacey [MVP]
> "GregO" <grego@.community.nospam> wrote in message
> news:e8rKpwx7FHA.2816@.tk2msftngp13.phx.gbl...
>|||>
> Rephrasing some of the answers you've gotten thus far, as soon as you exec
ute
> the CREATE FUNCTION statement, a "complied" version of the function is com
mitted
> to the database. There's no need to save the text version of it, since, wh
en
> you issued that same CREATE FUNCTION statement, SQL Server also saved that
> to the database.
> Make sense?
> Thank you,
> Kent Tegels
> DevelopMentor
> http://staff.develop.com/ktegels/
This helps a lot, thanks everyone!
a couple more related questions, based on your responses...
How does the DB engine manage a new function of the same name? Prompted
to override?
How can one determine a list of the functions in a database?
How is (function) debugging done, if the function is internal to the DB
Engine?|||Hello mikes@.vmsmailingservices.com,

> How does the DB engine manage a new function of the same name?
> Prompted to override?
No, unlike other development tools, most of the SQL Server tools *trusts*
the operator to know what he or she is doing. Most shops have a CVS (or simi
lar)
set up for storing scripts for objects. MS is offering one with team system
too. Native integration of that into SQL Server is probably a couple of vers
ions
away I suspect.

> How can one determine a list of the functions in a database?
select * from sys.objects where type_desc like '%_FUNCTION'

> How is (function) debugging done, if the function is internal to the
> DB Engine?
Like any other environment, the execution engine know that it has breakpoint
s
that it yields control to another process. It just so happens that SQL Serve
r's
engine uses a common Visual Studio API for debugging. No magic.
Thank you,
Kent Tegels
DevelopMentor
http://staff.develop.com/ktegels/

creating sql script with records

hello!
which program is the besto for creating sql scripts with records from tables
I choose? I mean, if I want to create whole database, but only save records
from 5 tables.
thanks!
> which program is the besto for creating sql scripts with records from
tables
> I choose? I mean, if I want to create whole database, but only save
records
> from 5 tables.
You can script objects and then use DTS or bcp.exe to transfer the data.
Additioanally, you can use a procedure that generates insert statements from
a table. Check for sch a procedure, for example, at
http://www.thecodeproject.com/databa...ratorPack.asp.
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com
|||It is possible that some of the stuff I've listed here has this feature:
http://www.karaszi.com/SQLServer/inf...ate_script.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Bernard" <bernard@.form.hr> wrote in message news:cklc5l$an$1@.ls219.htnet.hr...
> hello!
> which program is the besto for creating sql scripts with records from tables I choose? I mean, if
> I want to create whole database, but only save records from 5 tables.
> thanks!
>

creating sql script with records

hello!
which program is the besto for creating sql scripts with records from tables
I choose? I mean, if I want to create whole database, but only save records
from 5 tables.
thanks!> which program is the besto for creating sql scripts with records from
tables
> I choose? I mean, if I want to create whole database, but only save
records
> from 5 tables.
You can script objects and then use DTS or bcp.exe to transfer the data.
Additioanally, you can use a procedure that generates insert statements from
a table. Check for sch a procedure, for example, at
http://www.thecodeproject.com/datab...eratorPack.asp.
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com|||It is possible that some of the stuff I've listed here has this feature:
http://www.karaszi.com/SQLServer/in...rate_script.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Bernard" <bernard@.form.hr> wrote in message news:cklc5l$an$1@.ls219.htnet.hr...en">
> hello!
> which program is the besto for creating sql scripts with records from tabl
es I choose? I mean, if
> I want to create whole database, but only save records from 5 tables.
> thanks!
>

Creating Multiple PDFs

Hi, I am new to SQL Reporting Services. I have built a report that takes a
query parameter (Business ID). I save the report in pdf format using the
toolbar. Now I would like to build a single report that traverses all the
Business IDs (my table has BusinessIDs from 1 to 50), and creates 50 separate
PDFs as outputs that we can send to 50 separate businesses.
Is there a way to do this with SQL Reporting Services automatically?
Currently, I am doing this manually.Use a data driven subscription. It is really quite simple if you need help
let me know.
"MTsang987" wrote:
> Hi, I am new to SQL Reporting Services. I have built a report that takes a
> query parameter (Business ID). I save the report in pdf format using the
> toolbar. Now I would like to build a single report that traverses all the
> Business IDs (my table has BusinessIDs from 1 to 50), and creates 50 separate
> PDFs as outputs that we can send to 50 separate businesses.
> Is there a way to do this with SQL Reporting Services automatically?
> Currently, I am doing this manually.|||You can use Data Driven Subscriptions and the File share delivery provider
to do this. Have the DD Subscription query for all of the buisinessIDs and
pass them in as the report parameter. Then deliver them to a file share so
you can ship them off later.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"MTsang987" <MTsang987@.discussions.microsoft.com> wrote in message
news:2F75685A-EEF4-457D-991C-A7A1D61932E7@.microsoft.com...
> Hi, I am new to SQL Reporting Services. I have built a report that takes
> a
> query parameter (Business ID). I save the report in pdf format using the
> toolbar. Now I would like to build a single report that traverses all the
> Business IDs (my table has BusinessIDs from 1 to 50), and creates 50
> separate
> PDFs as outputs that we can send to 50 separate businesses.
> Is there a way to do this with SQL Reporting Services automatically?
> Currently, I am doing this manually.|||I need help with the DDS. These are the steps that I used and it didn't run:
Step 1 - Create a data-driven subscription:
Specify how recipients are notified:
Report Server File Share
Specify a data source that contains recipient information:
Specify for this subscription only
Step 2 - Create a data-driven subscription: rptMonthEnd
Connection Type: Microsoft SQL Server
Connection String: <connection string>
Connect Using:
Credentials stored securely in the report server
User name: <username>
Pssword: <password>
x Use as Windows credentials when connecting to the data source
Step 3 - Create a data-driven subscription:
Specify a command or query that returns a list of recipients and optionally
returns fields used to vary delivery settings and report parameter values for
each recipient:
Select * FROM MyTable
File name
Get the value from the database: <reportfilename>
File Extension
Specify a static value: False
Path
Specify a static value: <mypath>
Render Format
Specify a static value: Acrobat (PDF)
User name <myuser>
Password <mypassword>
Get the value from the database: Choose a field ResGroupID BegOfMonth
Please select a database field to use.
Blank database field names can not be used.
Write mode
Overwrite
Specify report parameter values for rpt
<parameter1>
Get the value from the database: <dbfield1>
<parameter2>
Get the value from the database: <dbfield2>
Step 6 - Create a data-driven subscription: rpt
Specify when the subscription is processed.
On a schedule created for this subscription
Step 7 - Create a data-driven subscription: rptMonthEnd
Use the following schedule to determine when the subscription is processed.
Choose whether to run the report on an hourly, daily, weekly, monthly, or
one time basis.
All times are expressed in (GMT -08:00) Pacific Standard Time.
Once
One-time Schedule
Report runs only once.
<set the time 10 minutes from now>
Then I clicked Finish.
"johnE" wrote:
> Use a data driven subscription. It is really quite simple if you need help
> let me know.
> "MTsang987" wrote:
> > Hi, I am new to SQL Reporting Services. I have built a report that takes a
> > query parameter (Business ID). I save the report in pdf format using the
> > toolbar. Now I would like to build a single report that traverses all the
> > Business IDs (my table has BusinessIDs from 1 to 50), and creates 50 separate
> > PDFs as outputs that we can send to 50 separate businesses.
> >
> > Is there a way to do this with SQL Reporting Services automatically?
> > Currently, I am doing this manually.|||Hi, I need help with DDS with File share delivery, see my reply post to johnE
"Daniel Reib [MSFT]" wrote:
> You can use Data Driven Subscriptions and the File share delivery provider
> to do this. Have the DD Subscription query for all of the buisinessIDs and
> pass them in as the report parameter. Then deliver them to a file share so
> you can ship them off later.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "MTsang987" <MTsang987@.discussions.microsoft.com> wrote in message
> news:2F75685A-EEF4-457D-991C-A7A1D61932E7@.microsoft.com...
> > Hi, I am new to SQL Reporting Services. I have built a report that takes
> > a
> > query parameter (Business ID). I save the report in pdf format using the
> > toolbar. Now I would like to build a single report that traverses all the
> > Business IDs (my table has BusinessIDs from 1 to 50), and creates 50
> > separate
> > PDFs as outputs that we can send to 50 separate businesses.
> >
> > Is there a way to do this with SQL Reporting Services automatically?
> > Currently, I am doing this manually.
>
>|||What happened? Did you get an error? Can you look in the
reportserverservice<timestamp>.log file to see what error where produced?
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"MTsang987" <MTsang987@.discussions.microsoft.com> wrote in message
news:EA2A52C6-92E3-4831-8230-919743ECE5BF@.microsoft.com...
>I need help with the DDS. These are the steps that I used and it didn't
>run:
>
> Step 1 - Create a data-driven subscription:
> Specify how recipients are notified:
> Report Server File Share
> Specify a data source that contains recipient information:
> Specify for this subscription only
>
> Step 2 - Create a data-driven subscription: rptMonthEnd
> Connection Type: Microsoft SQL Server
> Connection String: <connection string>
> Connect Using:
> Credentials stored securely in the report server
> User name: <username>
> Pssword: <password>
> x Use as Windows credentials when connecting to the data source
> Step 3 - Create a data-driven subscription:
> Specify a command or query that returns a list of recipients and
> optionally
> returns fields used to vary delivery settings and report parameter values
> for
> each recipient:
> Select * FROM MyTable
> File name
> Get the value from the database: <reportfilename>
> File Extension
> Specify a static value: False
> Path
> Specify a static value: <mypath>
> Render Format
> Specify a static value: Acrobat (PDF)
> User name <myuser>
> Password <mypassword>
>
> Get the value from the database: Choose a field ResGroupID BegOfMonth
> Please select a database field to use.
> Blank database field names can not be used.
>
> Write mode
> Overwrite
> Specify report parameter values for rpt
> <parameter1>
> Get the value from the database: <dbfield1>
> <parameter2>
> Get the value from the database: <dbfield2>
> Step 6 - Create a data-driven subscription: rpt
> Specify when the subscription is processed.
> On a schedule created for this subscription
> Step 7 - Create a data-driven subscription: rptMonthEnd
> Use the following schedule to determine when the subscription is
> processed.
> Choose whether to run the report on an hourly, daily, weekly, monthly, or
> one time basis.
> All times are expressed in (GMT -08:00) Pacific Standard Time.
> Once
> One-time Schedule
> Report runs only once.
> <set the time 10 minutes from now>
>
> Then I clicked Finish.
>
> "johnE" wrote:
>> Use a data driven subscription. It is really quite simple if you need
>> help
>> let me know.
>> "MTsang987" wrote:
>> > Hi, I am new to SQL Reporting Services. I have built a report that
>> > takes a
>> > query parameter (Business ID). I save the report in pdf format using
>> > the
>> > toolbar. Now I would like to build a single report that traverses all
>> > the
>> > Business IDs (my table has BusinessIDs from 1 to 50), and creates 50
>> > separate
>> > PDFs as outputs that we can send to 50 separate businesses.
>> >
>> > Is there a way to do this with SQL Reporting Services automatically?
>> > Currently, I am doing this manually.|||Nothing happened. Where does this file live. I did a MyComputer Search for
a file with name reportserverservice as part of the file name and it couldn't
be found unless you want to search system files.
"Daniel Reib [MSFT]" wrote:
> What happened? Did you get an error? Can you look in the
> reportserverservice<timestamp>.log file to see what error where produced?
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "MTsang987" <MTsang987@.discussions.microsoft.com> wrote in message
> news:EA2A52C6-92E3-4831-8230-919743ECE5BF@.microsoft.com...
> >I need help with the DDS. These are the steps that I used and it didn't
> >run:
> >
> >
> > Step 1 - Create a data-driven subscription:
> >
> > Specify how recipients are notified:
> > Report Server File Share
> > Specify a data source that contains recipient information:
> > Specify for this subscription only
> >
> >
> > Step 2 - Create a data-driven subscription: rptMonthEnd
> >
> > Connection Type: Microsoft SQL Server
> > Connection String: <connection string>
> >
> > Connect Using:
> > Credentials stored securely in the report server
> > User name: <username>
> > Pssword: <password>
> >
> > x Use as Windows credentials when connecting to the data source
> >
> > Step 3 - Create a data-driven subscription:
> > Specify a command or query that returns a list of recipients and
> > optionally
> > returns fields used to vary delivery settings and report parameter values
> > for
> > each recipient:
> >
> > Select * FROM MyTable
> >
> > File name
> > Get the value from the database: <reportfilename>
> >
> > File Extension
> > Specify a static value: False
> >
> > Path
> > Specify a static value: <mypath>
> >
> > Render Format
> > Specify a static value: Acrobat (PDF)
> >
> > User name <myuser>
> > Password <mypassword>
> >
> >
> > Get the value from the database: Choose a field ResGroupID BegOfMonth
> > Please select a database field to use.
> > Blank database field names can not be used.
> >
> >
> > Write mode
> > Overwrite
> >
> > Specify report parameter values for rpt
> >
> > <parameter1>
> > Get the value from the database: <dbfield1>
> >
> > <parameter2>
> > Get the value from the database: <dbfield2>
> >
> > Step 6 - Create a data-driven subscription: rpt
> > Specify when the subscription is processed.
> >
> > On a schedule created for this subscription
> >
> > Step 7 - Create a data-driven subscription: rptMonthEnd
> > Use the following schedule to determine when the subscription is
> > processed.
> >
> > Choose whether to run the report on an hourly, daily, weekly, monthly, or
> > one time basis.
> > All times are expressed in (GMT -08:00) Pacific Standard Time.
> > Once
> >
> > One-time Schedule
> > Report runs only once.
> > <set the time 10 minutes from now>
> >
> >
> > Then I clicked Finish.
> >
> >
> > "johnE" wrote:
> >
> >> Use a data driven subscription. It is really quite simple if you need
> >> help
> >> let me know.
> >>
> >> "MTsang987" wrote:
> >>
> >> > Hi, I am new to SQL Reporting Services. I have built a report that
> >> > takes a
> >> > query parameter (Business ID). I save the report in pdf format using
> >> > the
> >> > toolbar. Now I would like to build a single report that traverses all
> >> > the
> >> > Business IDs (my table has BusinessIDs from 1 to 50), and creates 50
> >> > separate
> >> > PDFs as outputs that we can send to 50 separate businesses.
> >> >
> >> > Is there a way to do this with SQL Reporting Services automatically?
> >> > Currently, I am doing this manually.
>
>|||Sorry, I found a file timestamped at 10:38 although I've tried to run it at
11:00, 12:00, 1:00, and 2:00.
<Header>
<Product>Microsoft SQL Server Reporting Services Version
8.00.878.00</Product>
<Locale>en-US</Locale>
<TimeZone>Pacific Standard Time</TimeZone>
<Path>C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\LogFiles\ReportServerService__01_07_2005_10_38_43.log</Path>
<SystemName>DEV-REPORT</SystemName>
<OSName>Microsoft Windows NT 5.2.3790.0</OSName>
<OSVersion>5.2.3790.0</OSVersion>
</Header>
ReportingServicesService!servicecontroller!708!1/7/2005-10:38:43:: Service
controller exiting.
<Header>
<Product>Microsoft SQL Server Reporting Services Version
8.00.878.00</Product>
<Locale>en-US</Locale>
<TimeZone>Pacific Standard Time</TimeZone>
<Path>C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\LogFiles\ReportServerService__main_01_07_2005_10_38_42.log</Path>
<SystemName>DEV-REPORT</SystemName>
<OSName>Microsoft Windows NT 5.2.3790.0</OSName>
<OSVersion>5.2.3790.0</OSVersion>
</Header>
ReportingServicesService!servicecontroller!708!1/7/2005-10:38:42:: i INFO:
Recycling the service from default domain
ReportingServicesService!servicecontroller!708!1/7/2005-10:38:43:: i INFO:
New app domain started
"Daniel Reib [MSFT]" wrote:
> What happened? Did you get an error? Can you look in the
> reportserverservice<timestamp>.log file to see what error where produced?
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "MTsang987" <MTsang987@.discussions.microsoft.com> wrote in message
> news:EA2A52C6-92E3-4831-8230-919743ECE5BF@.microsoft.com...
> >I need help with the DDS. These are the steps that I used and it didn't
> >run:
> >
> >
> > Step 1 - Create a data-driven subscription:
> >
> > Specify how recipients are notified:
> > Report Server File Share
> > Specify a data source that contains recipient information:
> > Specify for this subscription only
> >
> >
> > Step 2 - Create a data-driven subscription: rptMonthEnd
> >
> > Connection Type: Microsoft SQL Server
> > Connection String: <connection string>
> >
> > Connect Using:
> > Credentials stored securely in the report server
> > User name: <username>
> > Pssword: <password>
> >
> > x Use as Windows credentials when connecting to the data source
> >
> > Step 3 - Create a data-driven subscription:
> > Specify a command or query that returns a list of recipients and
> > optionally
> > returns fields used to vary delivery settings and report parameter values
> > for
> > each recipient:
> >
> > Select * FROM MyTable
> >
> > File name
> > Get the value from the database: <reportfilename>
> >
> > File Extension
> > Specify a static value: False
> >
> > Path
> > Specify a static value: <mypath>
> >
> > Render Format
> > Specify a static value: Acrobat (PDF)
> >
> > User name <myuser>
> > Password <mypassword>
> >
> >
> > Get the value from the database: Choose a field ResGroupID BegOfMonth
> > Please select a database field to use.
> > Blank database field names can not be used.
> >
> >
> > Write mode
> > Overwrite
> >
> > Specify report parameter values for rpt
> >
> > <parameter1>
> > Get the value from the database: <dbfield1>
> >
> > <parameter2>
> > Get the value from the database: <dbfield2>
> >
> > Step 6 - Create a data-driven subscription: rpt
> > Specify when the subscription is processed.
> >
> > On a schedule created for this subscription
> >
> > Step 7 - Create a data-driven subscription: rptMonthEnd
> > Use the following schedule to determine when the subscription is
> > processed.
> >
> > Choose whether to run the report on an hourly, daily, weekly, monthly, or
> > one time basis.
> > All times are expressed in (GMT -08:00) Pacific Standard Time.
> > Once
> >
> > One-time Schedule
> > Report runs only once.
> > <set the time 10 minutes from now>
> >
> >
> > Then I clicked Finish.
> >
> >
> > "johnE" wrote:
> >
> >> Use a data driven subscription. It is really quite simple if you need
> >> help
> >> let me know.
> >>
> >> "MTsang987" wrote:
> >>
> >> > Hi, I am new to SQL Reporting Services. I have built a report that
> >> > takes a
> >> > query parameter (Business ID). I save the report in pdf format using
> >> > the
> >> > toolbar. Now I would like to build a single report that traverses all
> >> > the
> >> > Business IDs (my table has BusinessIDs from 1 to 50), and creates 50
> >> > separate
> >> > PDFs as outputs that we can send to 50 separate businesses.
> >> >
> >> > Is there a way to do this with SQL Reporting Services automatically?
> >> > Currently, I am doing this manually.
>
>|||Were those the only files? If so it shows that the service is not running.
Can you check and see if the ReportService windows service is running?
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"MTsang987" <MTsang987@.discussions.microsoft.com> wrote in message
news:5A41927C-F043-4232-8A08-B4371142FD3E@.microsoft.com...
> Sorry, I found a file timestamped at 10:38 although I've tried to run it
> at
> 11:00, 12:00, 1:00, and 2:00.
> <Header>
> <Product>Microsoft SQL Server Reporting Services Version
> 8.00.878.00</Product>
> <Locale>en-US</Locale>
> <TimeZone>Pacific Standard Time</TimeZone>
> <Path>C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> Services\LogFiles\ReportServerService__01_07_2005_10_38_43.log</Path>
> <SystemName>DEV-REPORT</SystemName>
> <OSName>Microsoft Windows NT 5.2.3790.0</OSName>
> <OSVersion>5.2.3790.0</OSVersion>
> </Header>
> ReportingServicesService!servicecontroller!708!1/7/2005-10:38:43:: Service
> controller exiting.
>
> <Header>
> <Product>Microsoft SQL Server Reporting Services Version
> 8.00.878.00</Product>
> <Locale>en-US</Locale>
> <TimeZone>Pacific Standard Time</TimeZone>
> <Path>C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> Services\LogFiles\ReportServerService__main_01_07_2005_10_38_42.log</Path>
> <SystemName>DEV-REPORT</SystemName>
> <OSName>Microsoft Windows NT 5.2.3790.0</OSName>
> <OSVersion>5.2.3790.0</OSVersion>
> </Header>
> ReportingServicesService!servicecontroller!708!1/7/2005-10:38:42:: i INFO:
> Recycling the service from default domain
> ReportingServicesService!servicecontroller!708!1/7/2005-10:38:43:: i INFO:
> New app domain started
>
> "Daniel Reib [MSFT]" wrote:
>> What happened? Did you get an error? Can you look in the
>> reportserverservice<timestamp>.log file to see what error where produced?
>> --
>> -Daniel
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "MTsang987" <MTsang987@.discussions.microsoft.com> wrote in message
>> news:EA2A52C6-92E3-4831-8230-919743ECE5BF@.microsoft.com...
>> >I need help with the DDS. These are the steps that I used and it didn't
>> >run:
>> >
>> >
>> > Step 1 - Create a data-driven subscription:
>> >
>> > Specify how recipients are notified:
>> > Report Server File Share
>> > Specify a data source that contains recipient information:
>> > Specify for this subscription only
>> >
>> >
>> > Step 2 - Create a data-driven subscription: rptMonthEnd
>> >
>> > Connection Type: Microsoft SQL Server
>> > Connection String: <connection string>
>> >
>> > Connect Using:
>> > Credentials stored securely in the report server
>> > User name: <username>
>> > Pssword: <password>
>> >
>> > x Use as Windows credentials when connecting to the data source
>> >
>> > Step 3 - Create a data-driven subscription:
>> > Specify a command or query that returns a list of recipients and
>> > optionally
>> > returns fields used to vary delivery settings and report parameter
>> > values
>> > for
>> > each recipient:
>> >
>> > Select * FROM MyTable
>> >
>> > File name
>> > Get the value from the database: <reportfilename>
>> >
>> > File Extension
>> > Specify a static value: False
>> >
>> > Path
>> > Specify a static value: <mypath>
>> >
>> > Render Format
>> > Specify a static value: Acrobat (PDF)
>> >
>> > User name <myuser>
>> > Password <mypassword>
>> >
>> >
>> > Get the value from the database: Choose a field ResGroupID BegOfMonth
>> > Please select a database field to use.
>> > Blank database field names can not be used.
>> >
>> >
>> > Write mode
>> > Overwrite
>> >
>> > Specify report parameter values for rpt
>> >
>> > <parameter1>
>> > Get the value from the database: <dbfield1>
>> >
>> > <parameter2>
>> > Get the value from the database: <dbfield2>
>> >
>> > Step 6 - Create a data-driven subscription: rpt
>> > Specify when the subscription is processed.
>> >
>> > On a schedule created for this subscription
>> >
>> > Step 7 - Create a data-driven subscription: rptMonthEnd
>> > Use the following schedule to determine when the subscription is
>> > processed.
>> >
>> > Choose whether to run the report on an hourly, daily, weekly, monthly,
>> > or
>> > one time basis.
>> > All times are expressed in (GMT -08:00) Pacific Standard Time.
>> > Once
>> >
>> > One-time Schedule
>> > Report runs only once.
>> > <set the time 10 minutes from now>
>> >
>> >
>> > Then I clicked Finish.
>> >
>> >
>> > "johnE" wrote:
>> >
>> >> Use a data driven subscription. It is really quite simple if you need
>> >> help
>> >> let me know.
>> >>
>> >> "MTsang987" wrote:
>> >>
>> >> > Hi, I am new to SQL Reporting Services. I have built a report that
>> >> > takes a
>> >> > query parameter (Business ID). I save the report in pdf format
>> >> > using
>> >> > the
>> >> > toolbar. Now I would like to build a single report that traverses
>> >> > all
>> >> > the
>> >> > Business IDs (my table has BusinessIDs from 1 to 50), and creates 50
>> >> > separate
>> >> > PDFs as outputs that we can send to 50 separate businesses.
>> >> >
>> >> > Is there a way to do this with SQL Reporting Services automatically?
>> >> > Currently, I am doing this manually.
>>|||Note that I had tried it again earlier this morning, and it shows the
reportserver service started, but the report did not run. There is a new log
file, the contents are:
<Header>
<Product>Microsoft SQL Server Reporting Services Version
8.00.878.00</Product>
<Locale>en-US</Locale>
<TimeZone>Pacific Standard Time</TimeZone>
<Path>C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\LogFiles\ReportServer__01_10_2005_09_59_26.log</Path>
<SystemName>DEV-REPORT</SystemName>
<OSName>Microsoft Windows NT 5.2.3790.0</OSName>
<OSVersion>5.2.3790.0</OSVersion>
</Header>
w3wp!webserver!ea0!1/10/2005-09:59:26:: i INFO: Reporting Web Server started
w3wp!library!ea0!1/10/2005-09:59:26:: i INFO: Initializing ConnectionType to
'1' as specified in Configuration file.
w3wp!library!ea0!1/10/2005-09:59:26:: i INFO: Initializing
IsSchedulingService to 'True' as specified in Configuration file.
w3wp!library!ea0!1/10/2005-09:59:26:: i INFO: Initializing
IsNotificationService to 'True' as specified in Configuration file.
w3wp!library!ea0!1/10/2005-09:59:26:: i INFO: Initializing IsEventService to
'True' as specified in Configuration file.
w3wp!library!ea0!1/10/2005-09:59:26:: i INFO: Initializing PollingInterval
to '10' second(s) as specified in Configuration file.
w3wp!library!ea0!1/10/2005-09:59:26:: i INFO: Initializing MemoryLimit to
'60' percent as specified in Configuration file.
w3wp!library!ea0!1/10/2005-09:59:26:: i INFO: Initializing RecycleTime to
'720' minute(s) as specified in Configuration file.
w3wp!library!ea0!1/10/2005-09:59:26:: i INFO: Initializing
MaximumMemoryLimit to '80' percent as specified in Configuration file.
w3wp!library!ea0!1/10/2005-09:59:26:: i INFO: Initializing
MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration file.
w3wp!library!ea0!1/10/2005-09:59:26:: i INFO: Initializing MaxQueueThreads
to '0' thread(s) as specified in Configuration file.
w3wp!library!ea0!1/10/2005-09:59:26:: i INFO: Initializing
MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
w3wp!library!ea0!1/10/2005-09:59:26:: i INFO: Initializing MaxScheduleWait
to '5' second(s) as specified in Configuration file.
w3wp!library!ea0!1/10/2005-09:59:26:: i INFO: Initializing
DatabaseQueryTimeout to '120' second(s) as specified in Configuration file.
w3wp!library!ea0!1/10/2005-09:59:26:: i INFO: Initializing InstanceName to
'MSSQLSERVER' as specified in Configuration file.
w3wp!library!ea0!1/10/2005-09:59:26:: i INFO: Initializing
ProcessRecycleOptions to '0' as specified in Configuration file.
w3wp!library!ea0!1/10/2005-09:59:26:: i INFO: Initializing
RunningRequestsScavengerCycle to '60' second(s) as specified in Configuration
file.
w3wp!library!ea0!1/10/2005-09:59:26:: i INFO: Initializing
RunningRequestsDbCycle to '60' second(s) as specified in Configuration file.
w3wp!library!ea0!1/10/2005-09:59:26:: i INFO: Initializing
RunningRequestsAge to '30' second(s) as specified in Configuration file.
w3wp!library!ea0!1/10/2005-09:59:26:: i INFO: Initializing
CleanupCycleMinutes to '10' minute(s) as specified in Configuration file.
w3wp!library!ea0!1/10/2005-09:59:26:: i INFO: Initializing
SecureConnectionLevel to '0' as specified in Configuration file.
w3wp!library!ea0!1/10/2005-09:59:26:: i INFO: Initializing DisplayErrorLink
to 'True' as specified in Configuration file.
w3wp!library!ea0!1/10/2005-09:59:26:: i INFO: Initializing
WebServiceUseFileShareStorage to default value of 'False' because it was not
specified in Configuration file.
w3wp!resourceutilities!ea0!1/10/2005-09:59:26:: i INFO: Running on 0
physical processors, 1 logical processors
w3wp!resourceutilities!ea0!1/10/2005-09:59:26:: i INFO: Reporting Services
starting SKU: Enterprise
w3wp!runningjobs!ea0!1/10/2005-09:59:26:: i INFO: Database Cleanup (Web
Service) timer enabled: Cycle: 600 seconds
w3wp!runningjobs!ea0!1/10/2005-09:59:26:: i INFO: Running Requests Scavenger
timer enabled: Cycle: 60 seconds
w3wp!runningjobs!ea0!1/10/2005-09:59:26:: i INFO: Running Requests DB timer
enabled: Cycle: 60 seconds
w3wp!runningjobs!ea0!1/10/2005-09:59:26:: i INFO: Memory stats update timer
enabled: Cycle: 60 seconds
w3wp!library!ca8!01/10/2005-09:59:29:: i INFO: Call to GetPermissions:/
w3wp!crypto!ca8!01/10/2005-09:59:29:: i INFO: Initializing crypto as user:
NT AUTHORITY\NETWORK SERVICE
w3wp!crypto!ca8!01/10/2005-09:59:29:: i INFO: Exporting public key
w3wp!crypto!ca8!01/10/2005-09:59:29:: i INFO: Performing sku validation
w3wp!crypto!ca8!01/10/2005-09:59:29:: i INFO: Importing existing encryption
key
w3wp!library!ca8!01/10/2005-09:59:30:: i INFO: Call to GetSystemPermissions
w3wp!library!ca8!01/10/2005-09:59:36:: i INFO: Call to
GetPermissions:/MonthEndInvoices
w3wp!library!ca8!01/10/2005-09:59:36:: i INFO: Call to GetSystemPermissions
w3wp!library!aac!01/10/2005-09:59:44:: i INFO: Call to
GetPermissions:/MonthEndInvoices/HOSS
w3wp!library!aac!01/10/2005-09:59:44:: i INFO: Call to GetSystemPermissions
w3wp!library!aac!01/10/2005-09:59:59:: i INFO: Call to
GetPermissions:/MonthEndInvoices/HOSS
w3wp!library!aac!01/10/2005-09:59:59:: i INFO: Call to GetSystemPermissions
w3wp!library!aac!01/10/2005-10:00:07:: i INFO: Call to
GetPermissions:/MonthEndInvoices/HOSS
w3wp!library!aac!01/10/2005-10:00:07:: i INFO: Call to GetSystemPermissions
w3wp!library!aac!01/10/2005-10:00:10:: i INFO: Call to
GetPermissions:/MonthEndInvoices/HOSS
w3wp!library!aac!01/10/2005-10:00:10:: i INFO: Call to GetSystemPermissions
w3wp!library!ea0!01/10/2005-10:00:12:: i INFO: Call to
GetPermissions:/MonthEndInvoices/HOSS
w3wp!library!ea0!01/10/2005-10:00:12:: i INFO: Call to GetSystemPermissions
w3wp!library!ca8!01/10/2005-10:00:14:: i INFO: Call to
GetPermissions:/MonthEndInvoices/rptMonthEnd
w3wp!library!ca8!01/10/2005-10:00:14:: i INFO: Initializing
EnableIntegratedSecurity to 'True' as specified in Server system properties.
w3wp!library!aac!01/10/2005-10:00:15:: i INFO: Call to GetSystemPermissions
w3wp!library!aac!01/10/2005-10:00:15:: i INFO: Initializing
ResponseBufferSizeKb to default value of '64' KB because it was not specified
in Server system properties.
w3wp!library!aac!01/10/2005-10:00:15:: i INFO: Initializing
UseSessionCookies to 'True' as specified in Server system properties.
w3wp!library!ea0!01/10/2005-10:00:19:: i INFO: Call to
GetPermissions:/MonthEndInvoices/rptMonthEnd
w3wp!library!ea0!01/10/2005-10:00:20:: i INFO: Call to GetSystemPermissions
w3wp!library!aac!01/10/2005-10:00:22:: i INFO: Call to GetSystemPermissions
w3wp!library!aac!01/10/2005-10:00:30:: i INFO: Call to GetSystemPermissions
w3wp!library!aac!01/10/2005-10:00:47:: i INFO: Call to GetSystemPermissions
w3wp!library!ea0!01/10/2005-10:00:52:: i INFO: Call to GetSystemPermissions
w3wp!library!aac!01/10/2005-10:00:55:: i INFO: Call to GetSystemPermissions
w3wp!library!ea0!01/10/2005-10:01:24:: i INFO: Call to GetSystemPermissions
w3wp!library!ea0!01/10/2005-10:01:28:: i INFO: Call to GetSystemPermissions
w3wp!library!ea0!01/10/2005-10:01:34:: i INFO: Call to GetSystemPermissions
w3wp!library!ea0!01/10/2005-10:01:50:: i INFO: Call to GetSystemPermissions
w3wp!library!aac!01/10/2005-10:01:52:: i INFO: Call to
GetPermissions:/MonthEndInvoices/rptMonthEnd
w3wp!library!aac!01/10/2005-10:01:52:: i INFO: Call to GetSystemPermissions
w3wp!library!ea0!01/10/2005-10:02:06:: i INFO: Call to
GetPermissions:/MonthEndInvoices/rptMonthEnd
w3wp!library!ea0!01/10/2005-10:02:06:: i INFO: Call to GetSystemPermissions
w3wp!library!ea0!01/10/2005-10:02:09:: i INFO: Call to
GetPermissions:/MonthEndInvoices/rptMonthEnd
w3wp!library!ea0!01/10/2005-10:02:09:: i INFO: Call to GetSystemPermissions
w3wp!library!ea0!1/10/2005-10:09:28:: i INFO: Cleaned 0 batch records, 0
policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs
w3wp!library!aac!1/10/2005-10:19:29:: i INFO: Cleaned 0 batch records, 0
policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs
w3wp!webserver!260!1/10/2005-10:22:29:: i INFO: Reporting Web Server stopped
"Daniel Reib [MSFT]" wrote:
> Were those the only files? If so it shows that the service is not running.
> Can you check and see if the ReportService windows service is running?
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "MTsang987" <MTsang987@.discussions.microsoft.com> wrote in message
> news:5A41927C-F043-4232-8A08-B4371142FD3E@.microsoft.com...
> > Sorry, I found a file timestamped at 10:38 although I've tried to run it
> > at
> > 11:00, 12:00, 1:00, and 2:00.
> >
> > <Header>
> > <Product>Microsoft SQL Server Reporting Services Version
> > 8.00.878.00</Product>
> > <Locale>en-US</Locale>
> > <TimeZone>Pacific Standard Time</TimeZone>
> > <Path>C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> > Services\LogFiles\ReportServerService__01_07_2005_10_38_43.log</Path>
> > <SystemName>DEV-REPORT</SystemName>
> > <OSName>Microsoft Windows NT 5.2.3790.0</OSName>
> > <OSVersion>5.2.3790.0</OSVersion>
> > </Header>
> > ReportingServicesService!servicecontroller!708!1/7/2005-10:38:43:: Service
> > controller exiting.
> >
> >
> >
> > <Header>
> > <Product>Microsoft SQL Server Reporting Services Version
> > 8.00.878.00</Product>
> > <Locale>en-US</Locale>
> > <TimeZone>Pacific Standard Time</TimeZone>
> > <Path>C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> > Services\LogFiles\ReportServerService__main_01_07_2005_10_38_42.log</Path>
> > <SystemName>DEV-REPORT</SystemName>
> > <OSName>Microsoft Windows NT 5.2.3790.0</OSName>
> > <OSVersion>5.2.3790.0</OSVersion>
> > </Header>
> > ReportingServicesService!servicecontroller!708!1/7/2005-10:38:42:: i INFO:
> > Recycling the service from default domain
> > ReportingServicesService!servicecontroller!708!1/7/2005-10:38:43:: i INFO:
> > New app domain started
> >
> >
> > "Daniel Reib [MSFT]" wrote:
> >
> >> What happened? Did you get an error? Can you look in the
> >> reportserverservice<timestamp>.log file to see what error where produced?
> >>
> >> --
> >> -Daniel
> >> This posting is provided "AS IS" with no warranties, and confers no
> >> rights.
> >>
> >>
> >> "MTsang987" <MTsang987@.discussions.microsoft.com> wrote in message
> >> news:EA2A52C6-92E3-4831-8230-919743ECE5BF@.microsoft.com...
> >> >I need help with the DDS. These are the steps that I used and it didn't
> >> >run:
> >> >
> >> >
> >> > Step 1 - Create a data-driven subscription:
> >> >
> >> > Specify how recipients are notified:
> >> > Report Server File Share
> >> > Specify a data source that contains recipient information:
> >> > Specify for this subscription only
> >> >
> >> >
> >> > Step 2 - Create a data-driven subscription: rptMonthEnd
> >> >
> >> > Connection Type: Microsoft SQL Server
> >> > Connection String: <connection string>
> >> >
> >> > Connect Using:
> >> > Credentials stored securely in the report server
> >> > User name: <username>
> >> > Pssword: <password>
> >> >
> >> > x Use as Windows credentials when connecting to the data source
> >> >
> >> > Step 3 - Create a data-driven subscription:
> >> > Specify a command or query that returns a list of recipients and
> >> > optionally
> >> > returns fields used to vary delivery settings and report parameter
> >> > values
> >> > for
> >> > each recipient:
> >> >
> >> > Select * FROM MyTable
> >> >
> >> > File name
> >> > Get the value from the database: <reportfilename>
> >> >
> >> > File Extension
> >> > Specify a static value: False
> >> >
> >> > Path
> >> > Specify a static value: <mypath>
> >> >
> >> > Render Format
> >> > Specify a static value: Acrobat (PDF)
> >> >
> >> > User name <myuser>
> >> > Password <mypassword>
> >> >
> >> >
> >> > Get the value from the database: Choose a field ResGroupID BegOfMonth
> >> > Please select a database field to use.
> >> > Blank database field names can not be used.
> >> >
> >> >
> >> > Write mode
> >> > Overwrite
> >> >
> >> > Specify report parameter values for rpt
> >> >
> >> > <parameter1>
> >> > Get the value from the database: <dbfield1>
> >> >
> >> > <parameter2>
> >> > Get the value from the database: <dbfield2>
> >> >
> >> > Step 6 - Create a data-driven subscription: rpt
> >> > Specify when the subscription is processed.
> >> >
> >> > On a schedule created for this subscription
> >> >
> >> > Step 7 - Create a data-driven subscription: rptMonthEnd
> >> > Use the following schedule to determine when the subscription is
> >> > processed.
> >> >
> >> > Choose whether to run the report on an hourly, daily, weekly, monthly,
> >> > or
> >> > one time basis.
> >> > All times are expressed in (GMT -08:00) Pacific Standard Time.
> >> > Once
> >> >
> >> > One-time Schedule
> >> > Report runs only once.
> >> > <set the time 10 minutes from now>
> >> >
> >> >
> >> > Then I clicked Finish.
> >> >
> >> >
> >> > "johnE" wrote:
> >> >
> >> >> Use a data driven subscription. It is really quite simple if you need
> >> >> help
> >> >> let me know.
> >> >>
> >> >> "MTsang987" wrote:
> >> >>
> >> >> > Hi, I am new to SQL Reporting Services. I have built a report that
> >> >> > takes a
> >> >> > query parameter (Business ID). I save the report in pdf format
> >> >> > using
> >> >> > the
> >> >> > toolbar. Now I would like to build a single report that traverses
> >> >> > all
> >> >> > the
> >> >> > Business IDs (my table has BusinessIDs from 1 to 50), and creates 50
> >> >> > separate
> >> >> > PDFs as outputs that we can send to 50 separate businesses.
> >> >> >
> >> >> > Is there a way to do this with SQL Reporting Services automatically?
> >> >> > Currently, I am doing this manually.
> >>
> >>
> >>
>
>|||This is the web service log file. You need the windows service log file
(reportserverservice)
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"MTsang987" <MTsang987@.discussions.microsoft.com> wrote in message
news:80897360-2A36-4775-856F-6855C4A62202@.microsoft.com...
> Note that I had tried it again earlier this morning, and it shows the
> reportserver service started, but the report did not run. There is a new
> log
> file, the contents are:
> <Header>
> <Product>Microsoft SQL Server Reporting Services Version
> 8.00.878.00</Product>
> <Locale>en-US</Locale>
> <TimeZone>Pacific Standard Time</TimeZone>
> <Path>C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> Services\LogFiles\ReportServer__01_10_2005_09_59_26.log</Path>
> <SystemName>DEV-REPORT</SystemName>
> <OSName>Microsoft Windows NT 5.2.3790.0</OSName>
> <OSVersion>5.2.3790.0</OSVersion>
> </Header>
> w3wp!webserver!ea0!1/10/2005-09:59:26:: i INFO: Reporting Web Server
> started
> w3wp!library!ea0!1/10/2005-09:59:26:: i INFO: Initializing ConnectionType
> to
> '1' as specified in Configuration file.
> w3wp!library!ea0!1/10/2005-09:59:26:: i INFO: Initializing
> IsSchedulingService to 'True' as specified in Configuration file.
> w3wp!library!ea0!1/10/2005-09:59:26:: i INFO: Initializing
> IsNotificationService to 'True' as specified in Configuration file.
> w3wp!library!ea0!1/10/2005-09:59:26:: i INFO: Initializing IsEventService
> to
> 'True' as specified in Configuration file.
> w3wp!library!ea0!1/10/2005-09:59:26:: i INFO: Initializing PollingInterval
> to '10' second(s) as specified in Configuration file.
> w3wp!library!ea0!1/10/2005-09:59:26:: i INFO: Initializing MemoryLimit to
> '60' percent as specified in Configuration file.
> w3wp!library!ea0!1/10/2005-09:59:26:: i INFO: Initializing RecycleTime to
> '720' minute(s) as specified in Configuration file.
> w3wp!library!ea0!1/10/2005-09:59:26:: i INFO: Initializing
> MaximumMemoryLimit to '80' percent as specified in Configuration file.
> w3wp!library!ea0!1/10/2005-09:59:26:: i INFO: Initializing
> MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration
> file.
> w3wp!library!ea0!1/10/2005-09:59:26:: i INFO: Initializing MaxQueueThreads
> to '0' thread(s) as specified in Configuration file.
> w3wp!library!ea0!1/10/2005-09:59:26:: i INFO: Initializing
> MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration
> file.
> w3wp!library!ea0!1/10/2005-09:59:26:: i INFO: Initializing MaxScheduleWait
> to '5' second(s) as specified in Configuration file.
> w3wp!library!ea0!1/10/2005-09:59:26:: i INFO: Initializing
> DatabaseQueryTimeout to '120' second(s) as specified in Configuration
> file.
> w3wp!library!ea0!1/10/2005-09:59:26:: i INFO: Initializing InstanceName to
> 'MSSQLSERVER' as specified in Configuration file.
> w3wp!library!ea0!1/10/2005-09:59:26:: i INFO: Initializing
> ProcessRecycleOptions to '0' as specified in Configuration file.
> w3wp!library!ea0!1/10/2005-09:59:26:: i INFO: Initializing
> RunningRequestsScavengerCycle to '60' second(s) as specified in
> Configuration
> file.
> w3wp!library!ea0!1/10/2005-09:59:26:: i INFO: Initializing
> RunningRequestsDbCycle to '60' second(s) as specified in Configuration
> file.
> w3wp!library!ea0!1/10/2005-09:59:26:: i INFO: Initializing
> RunningRequestsAge to '30' second(s) as specified in Configuration file.
> w3wp!library!ea0!1/10/2005-09:59:26:: i INFO: Initializing
> CleanupCycleMinutes to '10' minute(s) as specified in Configuration file.
> w3wp!library!ea0!1/10/2005-09:59:26:: i INFO: Initializing
> SecureConnectionLevel to '0' as specified in Configuration file.
> w3wp!library!ea0!1/10/2005-09:59:26:: i INFO: Initializing
> DisplayErrorLink
> to 'True' as specified in Configuration file.
> w3wp!library!ea0!1/10/2005-09:59:26:: i INFO: Initializing
> WebServiceUseFileShareStorage to default value of 'False' because it was
> not
> specified in Configuration file.
> w3wp!resourceutilities!ea0!1/10/2005-09:59:26:: i INFO: Running on 0
> physical processors, 1 logical processors
> w3wp!resourceutilities!ea0!1/10/2005-09:59:26:: i INFO: Reporting Services
> starting SKU: Enterprise
> w3wp!runningjobs!ea0!1/10/2005-09:59:26:: i INFO: Database Cleanup (Web
> Service) timer enabled: Cycle: 600 seconds
> w3wp!runningjobs!ea0!1/10/2005-09:59:26:: i INFO: Running Requests
> Scavenger
> timer enabled: Cycle: 60 seconds
> w3wp!runningjobs!ea0!1/10/2005-09:59:26:: i INFO: Running Requests DB
> timer
> enabled: Cycle: 60 seconds
> w3wp!runningjobs!ea0!1/10/2005-09:59:26:: i INFO: Memory stats update
> timer
> enabled: Cycle: 60 seconds
> w3wp!library!ca8!01/10/2005-09:59:29:: i INFO: Call to GetPermissions:/
> w3wp!crypto!ca8!01/10/2005-09:59:29:: i INFO: Initializing crypto as user:
> NT AUTHORITY\NETWORK SERVICE
> w3wp!crypto!ca8!01/10/2005-09:59:29:: i INFO: Exporting public key
> w3wp!crypto!ca8!01/10/2005-09:59:29:: i INFO: Performing sku validation
> w3wp!crypto!ca8!01/10/2005-09:59:29:: i INFO: Importing existing
> encryption
> key
> w3wp!library!ca8!01/10/2005-09:59:30:: i INFO: Call to
> GetSystemPermissions
> w3wp!library!ca8!01/10/2005-09:59:36:: i INFO: Call to
> GetPermissions:/MonthEndInvoices
> w3wp!library!ca8!01/10/2005-09:59:36:: i INFO: Call to
> GetSystemPermissions
> w3wp!library!aac!01/10/2005-09:59:44:: i INFO: Call to
> GetPermissions:/MonthEndInvoices/HOSS
> w3wp!library!aac!01/10/2005-09:59:44:: i INFO: Call to
> GetSystemPermissions
> w3wp!library!aac!01/10/2005-09:59:59:: i INFO: Call to
> GetPermissions:/MonthEndInvoices/HOSS
> w3wp!library!aac!01/10/2005-09:59:59:: i INFO: Call to
> GetSystemPermissions
> w3wp!library!aac!01/10/2005-10:00:07:: i INFO: Call to
> GetPermissions:/MonthEndInvoices/HOSS
> w3wp!library!aac!01/10/2005-10:00:07:: i INFO: Call to
> GetSystemPermissions
> w3wp!library!aac!01/10/2005-10:00:10:: i INFO: Call to
> GetPermissions:/MonthEndInvoices/HOSS
> w3wp!library!aac!01/10/2005-10:00:10:: i INFO: Call to
> GetSystemPermissions
> w3wp!library!ea0!01/10/2005-10:00:12:: i INFO: Call to
> GetPermissions:/MonthEndInvoices/HOSS
> w3wp!library!ea0!01/10/2005-10:00:12:: i INFO: Call to
> GetSystemPermissions
> w3wp!library!ca8!01/10/2005-10:00:14:: i INFO: Call to
> GetPermissions:/MonthEndInvoices/rptMonthEnd
> w3wp!library!ca8!01/10/2005-10:00:14:: i INFO: Initializing
> EnableIntegratedSecurity to 'True' as specified in Server system
> properties.
> w3wp!library!aac!01/10/2005-10:00:15:: i INFO: Call to
> GetSystemPermissions
> w3wp!library!aac!01/10/2005-10:00:15:: i INFO: Initializing
> ResponseBufferSizeKb to default value of '64' KB because it was not
> specified
> in Server system properties.
> w3wp!library!aac!01/10/2005-10:00:15:: i INFO: Initializing
> UseSessionCookies to 'True' as specified in Server system properties.
> w3wp!library!ea0!01/10/2005-10:00:19:: i INFO: Call to
> GetPermissions:/MonthEndInvoices/rptMonthEnd
> w3wp!library!ea0!01/10/2005-10:00:20:: i INFO: Call to
> GetSystemPermissions
> w3wp!library!aac!01/10/2005-10:00:22:: i INFO: Call to
> GetSystemPermissions
> w3wp!library!aac!01/10/2005-10:00:30:: i INFO: Call to
> GetSystemPermissions
> w3wp!library!aac!01/10/2005-10:00:47:: i INFO: Call to
> GetSystemPermissions
> w3wp!library!ea0!01/10/2005-10:00:52:: i INFO: Call to
> GetSystemPermissions
> w3wp!library!aac!01/10/2005-10:00:55:: i INFO: Call to
> GetSystemPermissions
> w3wp!library!ea0!01/10/2005-10:01:24:: i INFO: Call to
> GetSystemPermissions
> w3wp!library!ea0!01/10/2005-10:01:28:: i INFO: Call to
> GetSystemPermissions
> w3wp!library!ea0!01/10/2005-10:01:34:: i INFO: Call to
> GetSystemPermissions
> w3wp!library!ea0!01/10/2005-10:01:50:: i INFO: Call to
> GetSystemPermissions
> w3wp!library!aac!01/10/2005-10:01:52:: i INFO: Call to
> GetPermissions:/MonthEndInvoices/rptMonthEnd
> w3wp!library!aac!01/10/2005-10:01:52:: i INFO: Call to
> GetSystemPermissions
> w3wp!library!ea0!01/10/2005-10:02:06:: i INFO: Call to
> GetPermissions:/MonthEndInvoices/rptMonthEnd
> w3wp!library!ea0!01/10/2005-10:02:06:: i INFO: Call to
> GetSystemPermissions
> w3wp!library!ea0!01/10/2005-10:02:09:: i INFO: Call to
> GetPermissions:/MonthEndInvoices/rptMonthEnd
> w3wp!library!ea0!01/10/2005-10:02:09:: i INFO: Call to
> GetSystemPermissions
> w3wp!library!ea0!1/10/2005-10:09:28:: i INFO: Cleaned 0 batch records, 0
> policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running
> jobs
> w3wp!library!aac!1/10/2005-10:19:29:: i INFO: Cleaned 0 batch records, 0
> policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running
> jobs
> w3wp!webserver!260!1/10/2005-10:22:29:: i INFO: Reporting Web Server
> stopped
> "Daniel Reib [MSFT]" wrote:
>> Were those the only files? If so it shows that the service is not
>> running.
>> Can you check and see if the ReportService windows service is running?
>> --
>> -Daniel
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "MTsang987" <MTsang987@.discussions.microsoft.com> wrote in message
>> news:5A41927C-F043-4232-8A08-B4371142FD3E@.microsoft.com...
>> > Sorry, I found a file timestamped at 10:38 although I've tried to run
>> > it
>> > at
>> > 11:00, 12:00, 1:00, and 2:00.
>> >
>> > <Header>
>> > <Product>Microsoft SQL Server Reporting Services Version
>> > 8.00.878.00</Product>
>> > <Locale>en-US</Locale>
>> > <TimeZone>Pacific Standard Time</TimeZone>
>> > <Path>C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
>> > Services\LogFiles\ReportServerService__01_07_2005_10_38_43.log</Path>
>> > <SystemName>DEV-REPORT</SystemName>
>> > <OSName>Microsoft Windows NT 5.2.3790.0</OSName>
>> > <OSVersion>5.2.3790.0</OSVersion>
>> > </Header>
>> > ReportingServicesService!servicecontroller!708!1/7/2005-10:38:43::
>> > Service
>> > controller exiting.
>> >
>> >
>> >
>> > <Header>
>> > <Product>Microsoft SQL Server Reporting Services Version
>> > 8.00.878.00</Product>
>> > <Locale>en-US</Locale>
>> > <TimeZone>Pacific Standard Time</TimeZone>
>> > <Path>C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
>> > Services\LogFiles\ReportServerService__main_01_07_2005_10_38_42.log</Path>
>> > <SystemName>DEV-REPORT</SystemName>
>> > <OSName>Microsoft Windows NT 5.2.3790.0</OSName>
>> > <OSVersion>5.2.3790.0</OSVersion>
>> > </Header>
>> > ReportingServicesService!servicecontroller!708!1/7/2005-10:38:42:: i
>> > INFO:
>> > Recycling the service from default domain
>> > ReportingServicesService!servicecontroller!708!1/7/2005-10:38:43:: i
>> > INFO:
>> > New app domain started
>> >
>> >
>> > "Daniel Reib [MSFT]" wrote:
>> >
>> >> What happened? Did you get an error? Can you look in the
>> >> reportserverservice<timestamp>.log file to see what error where
>> >> produced?
>> >>
>> >> --
>> >> -Daniel
>> >> This posting is provided "AS IS" with no warranties, and confers no
>> >> rights.
>> >>
>> >>
>> >> "MTsang987" <MTsang987@.discussions.microsoft.com> wrote in message
>> >> news:EA2A52C6-92E3-4831-8230-919743ECE5BF@.microsoft.com...
>> >> >I need help with the DDS. These are the steps that I used and it
>> >> >didn't
>> >> >run:
>> >> >
>> >> >
>> >> > Step 1 - Create a data-driven subscription:
>> >> >
>> >> > Specify how recipients are notified:
>> >> > Report Server File Share
>> >> > Specify a data source that contains recipient information:
>> >> > Specify for this subscription only
>> >> >
>> >> >
>> >> > Step 2 - Create a data-driven subscription: rptMonthEnd
>> >> >
>> >> > Connection Type: Microsoft SQL Server
>> >> > Connection String: <connection string>
>> >> >
>> >> > Connect Using:
>> >> > Credentials stored securely in the report server
>> >> > User name: <username>
>> >> > Pssword: <password>
>> >> >
>> >> > x Use as Windows credentials when connecting to the data source
>> >> >
>> >> > Step 3 - Create a data-driven subscription:
>> >> > Specify a command or query that returns a list of recipients and
>> >> > optionally
>> >> > returns fields used to vary delivery settings and report parameter
>> >> > values
>> >> > for
>> >> > each recipient:
>> >> >
>> >> > Select * FROM MyTable
>> >> >
>> >> > File name
>> >> > Get the value from the database: <reportfilename>
>> >> >
>> >> > File Extension
>> >> > Specify a static value: False
>> >> >
>> >> > Path
>> >> > Specify a static value: <mypath>
>> >> >
>> >> > Render Format
>> >> > Specify a static value: Acrobat (PDF)
>> >> >
>> >> > User name <myuser>
>> >> > Password <mypassword>
>> >> >
>> >> >
>> >> > Get the value from the database: Choose a field ResGroupID
>> >> > BegOfMonth
>> >> > Please select a database field to use.
>> >> > Blank database field names can not be used.
>> >> >
>> >> >
>> >> > Write mode
>> >> > Overwrite
>> >> >
>> >> > Specify report parameter values for rpt
>> >> >
>> >> > <parameter1>
>> >> > Get the value from the database: <dbfield1>
>> >> >
>> >> > <parameter2>
>> >> > Get the value from the database: <dbfield2>
>> >> >
>> >> > Step 6 - Create a data-driven subscription: rpt
>> >> > Specify when the subscription is processed.
>> >> >
>> >> > On a schedule created for this subscription
>> >> >
>> >> > Step 7 - Create a data-driven subscription: rptMonthEnd
>> >> > Use the following schedule to determine when the subscription is
>> >> > processed.
>> >> >
>> >> > Choose whether to run the report on an hourly, daily, weekly,
>> >> > monthly,
>> >> > or
>> >> > one time basis.
>> >> > All times are expressed in (GMT -08:00) Pacific Standard Time.
>> >> > Once
>> >> >
>> >> > One-time Schedule
>> >> > Report runs only once.
>> >> > <set the time 10 minutes from now>
>> >> >
>> >> >
>> >> > Then I clicked Finish.
>> >> >
>> >> >
>> >> > "johnE" wrote:
>> >> >
>> >> >> Use a data driven subscription. It is really quite simple if you
>> >> >> need
>> >> >> help
>> >> >> let me know.
>> >> >>
>> >> >> "MTsang987" wrote:
>> >> >>
>> >> >> > Hi, I am new to SQL Reporting Services. I have built a report
>> >> >> > that
>> >> >> > takes a
>> >> >> > query parameter (Business ID). I save the report in pdf format
>> >> >> > using
>> >> >> > the
>> >> >> > toolbar. Now I would like to build a single report that
>> >> >> > traverses
>> >> >> > all
>> >> >> > the
>> >> >> > Business IDs (my table has BusinessIDs from 1 to 50), and creates
>> >> >> > 50
>> >> >> > separate
>> >> >> > PDFs as outputs that we can send to 50 separate businesses.
>> >> >> >
>> >> >> > Is there a way to do this with SQL Reporting Services
>> >> >> > automatically?
>> >> >> > Currently, I am doing this manually.
>> >>
>> >>
>> >>
>>|||Sorry, here is the proper file.
<Header>
<Product>Microsoft SQL Server Reporting Services Version
8.00.878.00</Product>
<Locale>en-US</Locale>
<TimeZone>Pacific Standard Time</TimeZone>
<Path>C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\LogFiles\ReportServerService__01_10_2005_08_37_26.log</Path>
<SystemName>DEV-REPORT</SystemName>
<OSName>Microsoft Windows NT 5.2.3790.0</OSName>
<OSVersion>5.2.3790.0</OSVersion>
</Header>
ReportingServicesService!crypto!a88!1/10/2005-08:37:25:: i INFO:
Initializing crypto as user: NT AUTHORITY\SYSTEM
ReportingServicesService!library!a88!1/10/2005-08:37:25:: e ERROR:
Transaction begin failed. Exception thrown:
System.Data.SqlClient.SqlException: General network error. Check your
network documentation.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception,
TdsParserState state)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
exception, TdsParserState state)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
at System.Data.SqlClient.TdsParser.FlushBuffer(Byte status)
at System.Data.SqlClient.TdsParser.TdsExecuteSQLBatch(String text, Int32
timeout)
at System.Data.SqlClient.SqlInternalConnection.ExecuteTransaction(String
sqlBatch, String method)
at System.Data.SqlClient.SqlConnection.BeginTransaction(IsolationLevel iso)
at
Microsoft.ReportingServices.Library.ConnectionManager.BeginTransaction(IsolationLevel isoLevel)
ReportingServicesService!library!a88!1/10/2005-08:37:25:: Exception caught
while starting service. Error: System.Data.SqlClient.SqlException: General
network error. Check your network documentation.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception,
TdsParserState state)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
exception, TdsParserState state)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
at System.Data.SqlClient.TdsParser.FlushBuffer(Byte status)
at System.Data.SqlClient.TdsParser.TdsExecuteSQLBatch(String text, Int32
timeout)
at System.Data.SqlClient.SqlInternalConnection.ExecuteTransaction(String
sqlBatch, String method)
at System.Data.SqlClient.SqlConnection.BeginTransaction(IsolationLevel iso)
at
Microsoft.ReportingServices.Library.ConnectionManager.BeginTransaction(IsolationLevel isoLevel)
at Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
at Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
at
Microsoft.ReportingServices.Library.ServiceController.ServiceStartThread()
ReportingServicesService!library!a88!1/10/2005-08:37:25:: Attempting to
start service again...
ReportingServicesService!crypto!a88!1/10/2005-08:37:31:: i INFO:
Initializing crypto as user: NT AUTHORITY\SYSTEM
ReportingServicesService!crypto!a88!1/10/2005-08:37:31:: i INFO: Exporting
public key
ReportingServicesService!crypto!a88!1/10/2005-08:37:31:: i INFO: Performing
sku validation
ReportingServicesService!crypto!a88!1/10/2005-08:37:31:: i INFO: Importing
existing encryption key
ReportingServicesService!library!a88!1/10/2005-08:37:31:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDisabledException:
The report server cannot decrypt the symmetric key used to access sensitive
or encrypted data in a report server database. You must either restore a
backup key or delete all encrypted content and then restart the service.
Check the documentation for more information., ;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDisabledException:
The report server cannot decrypt the symmetric key used to access sensitive
or encrypted data in a report server database. You must either restore a
backup key or delete all encrypted content and then restart the service.
Check the documentation for more information. -->
System.Runtime.InteropServices.COMException (0x80090005): Bad Data.
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
errorCode, IntPtr errorInfo)
at RSManagedCrypto.RSCrypto.ImportSymmetricKey(Byte[] pSymKeyBlob)
at Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
-- End of inner exception stack trace --
ReportingServicesService!library!a88!1/10/2005-08:37:31:: Exception caught
while starting service. Error:
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDisabledException:
The report server cannot decrypt the symmetric key used to access sensitive
or encrypted data in a report server database. You must either restore a
backup key or delete all encrypted content and then restart the service.
Check the documentation for more information. -->
System.Runtime.InteropServices.COMException (0x80090005): Bad Data.
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
errorCode, IntPtr errorInfo)
at RSManagedCrypto.RSCrypto.ImportSymmetricKey(Byte[] pSymKeyBlob)
at Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
-- End of inner exception stack trace --
at Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
at Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
at
Microsoft.ReportingServices.Library.ServiceController.ServiceStartThread()
ReportingServicesService!library!a88!1/10/2005-08:37:31:: Attempting to
start service again...
ReportingServicesService!crypto!a88!1/10/2005-09:50:13:: i INFO:
Initializing crypto as user: NT AUTHORITY\SYSTEM
ReportingServicesService!library!a88!1/10/2005-09:50:13:: e ERROR:
Transaction begin failed. Exception thrown:
System.Data.SqlClient.SqlException: General network error. Check your
network documentation.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception,
TdsParserState state)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
exception, TdsParserState state)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
at System.Data.SqlClient.TdsParser.ReadNetlib(Int32 bytesExpected)
at System.Data.SqlClient.TdsParser.ReadBuffer()
at System.Data.SqlClient.TdsParser.ReadByte()
at System.Data.SqlClient.TdsParser.Run(RunBehavior run, SqlCommand
cmdHandler, SqlDataReader dataStream)
at System.Data.SqlClient.SqlInternalConnection.ExecuteTransaction(String
sqlBatch, String method)
at System.Data.SqlClient.SqlConnection.BeginTransaction(IsolationLevel iso)
at
Microsoft.ReportingServices.Library.ConnectionManager.BeginTransaction(IsolationLevel isoLevel)
ReportingServicesService!library!a88!1/10/2005-09:50:13:: Exception caught
while starting service. Error: System.Data.SqlClient.SqlException: General
network error. Check your network documentation.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception,
TdsParserState state)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
exception, TdsParserState state)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
at System.Data.SqlClient.TdsParser.ReadNetlib(Int32 bytesExpected)
at System.Data.SqlClient.TdsParser.ReadBuffer()
at System.Data.SqlClient.TdsParser.ReadByte()
at System.Data.SqlClient.TdsParser.Run(RunBehavior run, SqlCommand
cmdHandler, SqlDataReader dataStream)
at System.Data.SqlClient.SqlInternalConnection.ExecuteTransaction(String
sqlBatch, String method)
at System.Data.SqlClient.SqlConnection.BeginTransaction(IsolationLevel iso)
at
Microsoft.ReportingServices.Library.ConnectionManager.BeginTransaction(IsolationLevel isoLevel)
at Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
at Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
at
Microsoft.ReportingServices.Library.ServiceController.ServiceStartThread()
ReportingServicesService!library!a88!1/10/2005-09:50:13:: Attempting to
start service again...
ReportingServicesService!library!a88!1/10/2005-09:50:18:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDatabaseUnavailableException:
The report server cannot open a connection to the report server database. A
connection to the database is required for all requests and processing., ;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDatabaseUnavailableException:
The report server cannot open a connection to the report server database. A
connection to the database is required for all requests and processing. -->
System.Data.SqlClient.SqlException: SQL Server has been paused. No new
connections will be allowed.
Login failed for user '(null)'.
at System.Data.SqlClient.ConnectionPool.GetConnection(Boolean&
isInTransaction)
at
System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString options, Boolean& isInTransaction)
at System.Data.SqlClient.SqlConnection.Open()
at Microsoft.ReportingServices.Library.ConnectionManager.OpenConnection()
-- End of inner exception stack trace --
ReportingServicesService!library!a88!1/10/2005-09:50:18:: Exception caught
while starting service. Error:
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDatabaseUnavailableException:
The report server cannot open a connection to the report server database. A
connection to the database is required for all requests and processing. -->
System.Data.SqlClient.SqlException: SQL Server has been paused. No new
connections will be allowed.
Login failed for user '(null)'.
at System.Data.SqlClient.ConnectionPool.GetConnection(Boolean&
isInTransaction)
at
System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString options, Boolean& isInTransaction)
at System.Data.SqlClient.SqlConnection.Open()
at Microsoft.ReportingServices.Library.ConnectionManager.OpenConnection()
-- End of inner exception stack trace --
at Microsoft.ReportingServices.Library.ConnectionManager.OpenConnection()
at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
at Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
at
Microsoft.ReportingServices.Library.ServiceController.ServiceStartThread()
ReportingServicesService!library!a88!1/10/2005-09:50:18:: Attempting to
start service again...
ReportingServicesService!crypto!a88!1/10/2005-10:01:11:: i INFO:
Initializing crypto as user: NT AUTHORITY\SYSTEM
ReportingServicesService!crypto!a88!1/10/2005-10:01:11:: i INFO: Exporting
public key
ReportingServicesService!crypto!a88!1/10/2005-10:01:11:: i INFO: Performing
sku validation
ReportingServicesService!crypto!a88!1/10/2005-10:01:11:: i INFO: Importing
existing encryption key
ReportingServicesService!library!a88!1/10/2005-10:01:11:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDisabledException:
The report server cannot decrypt the symmetric key used to access sensitive
or encrypted data in a report server database. You must either restore a
backup key or delete all encrypted content and then restart the service.
Check the documentation for more information., ;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDisabledException:
The report server cannot decrypt the symmetric key used to access sensitive
or encrypted data in a report server database. You must either restore a
backup key or delete all encrypted content and then restart the service.
Check the documentation for more information. -->
System.Runtime.InteropServices.COMException (0x80090005): Bad Data.
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
errorCode, IntPtr errorInfo)
at RSManagedCrypto.RSCrypto.ImportSymmetricKey(Byte[] pSymKeyBlob)
at Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
-- End of inner exception stack trace --
ReportingServicesService!library!a88!1/10/2005-10:01:11:: Exception caught
while starting service. Error:
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDisabledException:
The report server cannot decrypt the symmetric key used to access sensitive
or encrypted data in a report server database. You must either restore a
backup key or delete all encrypted content and then restart the service.
Check the documentation for more information. -->
System.Runtime.InteropServices.COMException (0x80090005): Bad Data.
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
errorCode, IntPtr errorInfo)
at RSManagedCrypto.RSCrypto.ImportSymmetricKey(Byte[] pSymKeyBlob)
at Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
-- End of inner exception stack trace --
at Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
at Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
at
Microsoft.ReportingServices.Library.ServiceController.ServiceStartThread()
ReportingServicesService!library!a88!1/10/2005-10:01:11:: Attempting to
start service again...
ReportingServicesService!servicecontroller!708!1/10/2005-10:38:49:: Service
controller exiting.
"Daniel Reib [MSFT]" wrote:
> This is the web service log file. You need the windows service log file
> (reportserverservice)
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "MTsang987" <MTsang987@.discussions.microsoft.com> wrote in message
> news:80897360-2A36-4775-856F-6855C4A62202@.microsoft.com...
> > Note that I had tried it again earlier this morning, and it shows the
> > reportserver service started, but the report did not run. There is a new
> > log
> > file, the contents are:
> > <Header>
> > <Product>Microsoft SQL Server Reporting Services Version
> > 8.00.878.00</Product>
> > <Locale>en-US</Locale>
> > <TimeZone>Pacific Standard Time</TimeZone>
> > <Path>C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> > Services\LogFiles\ReportServer__01_10_2005_09_59_26.log</Path>
> > <SystemName>DEV-REPORT</SystemName>
> > <OSName>Microsoft Windows NT 5.2.3790.0</OSName>
> > <OSVersion>5.2.3790.0</OSVersion>
> > </Header>
> > w3wp!webserver!ea0!1/10/2005-09:59:26:: i INFO: Reporting Web Server
> > started
> > w3wp!library!ea0!1/10/2005-09:59:26:: i INFO: Initializing ConnectionType
> > to
> > '1' as specified in Configuration file.
> > w3wp!library!ea0!1/10/2005-09:59:26:: i INFO: Initializing
> > IsSchedulingService to 'True' as specified in Configuration file.
> > w3wp!library!ea0!1/10/2005-09:59:26:: i INFO: Initializing
> > IsNotificationService to 'True' as specified in Configuration file.
> > w3wp!library!ea0!1/10/2005-09:59:26:: i INFO: Initializing IsEventService
> > to
> > 'True' as specified in Configuration file.
> > w3wp!library!ea0!1/10/2005-09:59:26:: i INFO: Initializing PollingInterval
> > to '10' second(s) as specified in Configuration file.
> > w3wp!library!ea0!1/10/2005-09:59:26:: i INFO: Initializing MemoryLimit to
> > '60' percent as specified in Configuration file.
> > w3wp!library!ea0!1/10/2005-09:59:26:: i INFO: Initializing RecycleTime to
> > '720' minute(s) as specified in Configuration file.
> > w3wp!library!ea0!1/10/2005-09:59:26:: i INFO: Initializing
> > MaximumMemoryLimit to '80' percent as specified in Configuration file.
> > w3wp!library!ea0!1/10/2005-09:59:26:: i INFO: Initializing
> > MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration
> > file.
> > w3wp!library!ea0!1/10/2005-09:59:26:: i INFO: Initializing MaxQueueThreads
> > to '0' thread(s) as specified in Configuration file.
> > w3wp!library!ea0!1/10/2005-09:59:26:: i INFO: Initializing
> > MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration
> > file.
> > w3wp!library!ea0!1/10/2005-09:59:26:: i INFO: Initializing MaxScheduleWait
> > to '5' second(s) as specified in Configuration file.
> > w3wp!library!ea0!1/10/2005-09:59:26:: i INFO: Initializing
> > DatabaseQueryTimeout to '120' second(s) as specified in Configuration
> > file.
> > w3wp!library!ea0!1/10/2005-09:59:26:: i INFO: Initializing InstanceName to
> > 'MSSQLSERVER' as specified in Configuration file.
> > w3wp!library!ea0!1/10/2005-09:59:26:: i INFO: Initializing
> > ProcessRecycleOptions to '0' as specified in Configuration file.
> > w3wp!library!ea0!1/10/2005-09:59:26:: i INFO: Initializing
> > RunningRequestsScavengerCycle to '60' second(s) as specified in
> > Configuration
> > file.
> > w3wp!library!ea0!1/10/2005-09:59:26:: i INFO: Initializing
> > RunningRequestsDbCycle to '60' second(s) as specified in Configuration
> > file.
> > w3wp!library!ea0!1/10/2005-09:59:26:: i INFO: Initializing
> > RunningRequestsAge to '30' second(s) as specified in Configuration file.
> > w3wp!library!ea0!1/10/2005-09:59:26:: i INFO: Initializing
> > CleanupCycleMinutes to '10' minute(s) as specified in Configuration file.
> > w3wp!library!ea0!1/10/2005-09:59:26:: i INFO: Initializing
> > SecureConnectionLevel to '0' as specified in Configuration file.
> > w3wp!library!ea0!1/10/2005-09:59:26:: i INFO: Initializing
> > DisplayErrorLink
> > to 'True' as specified in Configuration file.
> > w3wp!library!ea0!1/10/2005-09:59:26:: i INFO: Initializing
> > WebServiceUseFileShareStorage to default value of 'False' because it was
> > not
> > specified in Configuration file.
> > w3wp!resourceutilities!ea0!1/10/2005-09:59:26:: i INFO: Running on 0
> > physical processors, 1 logical processors
> > w3wp!resourceutilities!ea0!1/10/2005-09:59:26:: i INFO: Reporting Services
> > starting SKU: Enterprise
> > w3wp!runningjobs!ea0!1/10/2005-09:59:26:: i INFO: Database Cleanup (Web
> > Service) timer enabled: Cycle: 600 seconds
> > w3wp!runningjobs!ea0!1/10/2005-09:59:26:: i INFO: Running Requests
> > Scavenger
> > timer enabled: Cycle: 60 seconds
> > w3wp!runningjobs!ea0!1/10/2005-09:59:26:: i INFO: Running Requests DB
> > timer
> > enabled: Cycle: 60 seconds
> > w3wp!runningjobs!ea0!1/10/2005-09:59:26:: i INFO: Memory stats update
> > timer
> > enabled: Cycle: 60 seconds
> > w3wp!library!ca8!01/10/2005-09:59:29:: i INFO: Call to GetPermissions:/
> > w3wp!crypto!ca8!01/10/2005-09:59:29:: i INFO: Initializing crypto as user:
> > NT AUTHORITY\NETWORK SERVICE
> > w3wp!crypto!ca8!01/10/2005-09:59:29:: i INFO: Exporting public key
> > w3wp!crypto!ca8!01/10/2005-09:59:29:: i INFO: Performing sku validation
> > w3wp!crypto!ca8!01/10/2005-09:59:29:: i INFO: Importing existing
> > encryption
> > key
> > w3wp!library!ca8!01/10/2005-09:59:30:: i INFO: Call to
> > GetSystemPermissions
> > w3wp!library!ca8!01/10/2005-09:59:36:: i INFO: Call to
> > GetPermissions:/MonthEndInvoices
> > w3wp!library!ca8!01/10/2005-09:59:36:: i INFO: Call to
> > GetSystemPermissions
> > w3wp!library!aac!01/10/2005-09:59:44:: i INFO: Call to
> > GetPermissions:/MonthEndInvoices/HOSS
> > w3wp!library!aac!01/10/2005-09:59:44:: i INFO: Call to
> > GetSystemPermissions
> > w3wp!library!aac!01/10/2005-09:59:59:: i INFO: Call to
> > GetPermissions:/MonthEndInvoices/HOSS
> > w3wp!library!aac!01/10/2005-09:59:59:: i INFO: Call to
> > GetSystemPermissions
> > w3wp!library!aac!01/10/2005-10:00:07:: i INFO: Call to
> > GetPermissions:/MonthEndInvoices/HOSS
> > w3wp!library!aac!01/10/2005-10:00:07:: i INFO: Call to
> > GetSystemPermissions
> > w3wp!library!aac!01/10/2005-10:00:10:: i INFO: Call to
> > GetPermissions:/MonthEndInvoices/HOSS
> > w3wp!library!aac!01/10/2005-10:00:10:: i INFO: Call to
> > GetSystemPermissions
> > w3wp!library!ea0!01/10/2005-10:00:12:: i INFO: Call to
> > GetPermissions:/MonthEndInvoices/HOSS
> > w3wp!library!ea0!01/10/2005-10:00:12:: i INFO: Call to
> > GetSystemPermissions
> > w3wp!library!ca8!01/10/2005-10:00:14:: i INFO: Call to
> > GetPermissions:/MonthEndInvoices/rptMonthEnd
> > w3wp!library!ca8!01/10/2005-10:00:14:: i INFO: Initializing
> > EnableIntegratedSecurity to 'True' as specified in Server system
> > properties.
> > w3wp!library!aac!01/10/2005-10:00:15:: i INFO: Call to
> > GetSystemPermissions
> > w3wp!library!aac!01/10/2005-10:00:15:: i INFO: Initializing
> > ResponseBufferSizeKb to default value of '64' KB because it was not
> > specified
> > in Server system properties.
> > w3wp!library!aac!01/10/2005-10:00:15:: i INFO: Initializing
> > UseSessionCookies to 'True' as specified in Server system properties.
> > w3wp!library!ea0!01/10/2005-10:00:19:: i INFO: Call to
> > GetPermissions:/MonthEndInvoices/rptMonthEnd
> > w3wp!library!ea0!01/10/2005-10:00:20:: i INFO: Call to
> > GetSystemPermissions
> > w3wp!library!aac!01/10/2005-10:00:22:: i INFO: Call to
> > GetSystemPermissions
> > w3wp!library!aac!01/10/2005-10:00:30:: i INFO: Call to
> > GetSystemPermissions
> > w3wp!library!aac!01/10/2005-10:00:47:: i INFO: Call to
> > GetSystemPermissions
> > w3wp!library!ea0!01/10/2005-10:00:52:: i INFO: Call to
> > GetSystemPermissions
> > w3wp!library!aac!01/10/2005-10:00:55:: i INFO: Call to
> > GetSystemPermissions
> > w3wp!library!ea0!01/10/2005-10:01:24:: i INFO: Call to
> > GetSystemPermissions
> > w3wp!library!ea0!01/10/2005-10:01:28:: i INFO: Call to
> > GetSystemPermissions
> > w3wp!library!ea0!01/10/2005-10:01:34:: i INFO: Call to
> > GetSystemPermissions
> > w3wp!library!ea0!01/10/2005-10:01:50:: i INFO: Call to
> > GetSystemPermissions
> > w3wp!library!aac!01/10/2005-10:01:52:: i INFO: Call to
> > GetPermissions:/MonthEndInvoices/rptMonthEnd
> > w3wp!library!aac!01/10/2005-10:01:52:: i INFO: Call to
> > GetSystemPermissions
> > w3wp!library!ea0!01/10/2005-10:02:06:: i INFO: Call to
> > GetPermissions:/MonthEndInvoices/rptMonthEnd
> > w3wp!library!ea0!01/10/2005-10:02:06:: i INFO: Call to
> > GetSystemPermissions
> > w3wp!library!ea0!01/10/2005-10:02:09:: i INFO: Call to
> > GetPermissions:/MonthEndInvoices/rptMonthEnd
> > w3wp!library!ea0!01/10/2005-10:02:09:: i INFO: Call to
> > GetSystemPermissions
> > w3wp!library!ea0!1/10/2005-10:09:28:: i INFO: Cleaned 0 batch records, 0
> > policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running
> > jobs
> > w3wp!library!aac!1/10/2005-10:19:29:: i INFO: Cleaned 0 batch records, 0
> > policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running
> > jobs
> > w3wp!webserver!260!1/10/2005-10:22:29:: i INFO: Reporting Web Server
> > stopped
> >
> > "Daniel Reib [MSFT]" wrote:
> >
> >> Were those the only files? If so it shows that the service is not
> >> running.
> >> Can you check and see if the ReportService windows service is running?
> >>
> >> --
> >> -Daniel
> >> This posting is provided "AS IS" with no warranties, and confers no
> >> rights.
> >>
> >>
> >> "MTsang987" <MTsang987@.discussions.microsoft.com> wrote in message
> >> news:5A41927C-F043-4232-8A08-B4371142FD3E@.microsoft.com...
> >> > Sorry, I found a file timestamped at 10:38 although I've tried to run
> >> > it
> >> > at
> >> > 11:00, 12:00, 1:00, and 2:00.
> >> >
> >> > <Header>
> >> > <Product>Microsoft SQL Server Reporting Services Version
> >> > 8.00.878.00</Product>
> >> > <Locale>en-US</Locale>
> >> > <TimeZone>Pacific Standard Time</TimeZone>
> >> > <Path>C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> >> > Services\LogFiles\ReportServerService__01_07_2005_10_38_43.log</Path>
> >> > <SystemName>DEV-REPORT</SystemName>
> >> > <OSName>Microsoft Windows NT 5.2.3790.0</OSName>
> >> > <OSVersion>5.2.3790.0</OSVersion>
> >> > </Header>
> >> > ReportingServicesService!servicecontroller!708!1/7/2005-10:38:43::
> >> > Service
> >> > controller exiting.
> >> >
> >> >
> >> >
> >> > <Header>
> >> > <Product>Microsoft SQL Server Reporting Services Version
> >> > 8.00.878.00</Product>
> >> > <Locale>en-US</Locale>
> >> > <TimeZone>Pacific Standard Time</TimeZone>
> >> > <Path>C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> >> > Services\LogFiles\ReportServerService__main_01_07_2005_10_38_42.log</Path>
> >> > <SystemName>DEV-REPORT</SystemName>
> >> > <OSName>Microsoft Windows NT 5.2.3790.0</OSName>
> >> > <OSVersion>5.2.3790.0</OSVersion>
> >> > </Header>
> >> > ReportingServicesService!servicecontroller!708!1/7/2005-10:38:42:: i
> >> > INFO:
> >> > Recycling the service from default domain
> >> > ReportingServicesService!servicecontroller!708!1/7/2005-10:38:43:: i
> >> > INFO:
> >> > New app domain started
> >> >
> >> >
> >> > "Daniel Reib [MSFT]" wrote:
> >> >
> >> >> What happened? Did you get an error? Can you look in the
> >> >> reportserverservice<timestamp>.log file to see what error where
> >> >> produced?
> >> >>
> >> >> --
> >> >> -Daniel
> >> >> This posting is provided "AS IS" with no warranties, and confers no
> >> >> rights.
> >> >>
> >> >>
> >> >> "MTsang987" <MTsang987@.discussions.microsoft.com> wrote in message
> >> >> news:EA2A52C6-92E3-4831-8230-919743ECE5BF@.microsoft.com...
> >> >> >I need help with the DDS. These are the steps that I used and it
> >> >> >didn't
> >> >> >run:
> >> >> >
> >> >> >
> >> >> > Step 1 - Create a data-driven subscription:
> >> >> >
> >> >> > Specify how recipients are notified:
> >> >> > Report Server File Share
> >> >> > Specify a data source that contains recipient information:
> >> >> > Specify for this subscription only
> >> >> >
> >> >> >
> >> >> > Step 2 - Create a data-driven subscription: rptMonthEnd
> >> >> >
> >> >> > Connection Type: Microsoft SQL Server
> >> >> > Connection String: <connection string>
> >> >> >
> >> >> > Connect Using:
> >> >> > Credentials stored securely in the report server
> >> >> > User name: <username>
> >> >> > Pssword: <password>
> >> >> >
> >> >> > x Use as Windows credentials when connecting to the data source
> >> >> >
> >> >> > Step 3 - Create a data-driven subscription:
> >> >> > Specify a command or query that returns a list of recipients and
> >> >> > optionally
> >> >> > returns fields used to vary delivery settings and report parameter
> >> >> > values
> >> >> > for
> >> >> > each recipient:
> >> >> >
> >> >> > Select * FROM MyTable
> >> >> >
> >> >> > File name
> >> >> > Get the value from the database: <reportfilename>
> >> >> >
> >> >> > File Extension
> >> >> > Specify a static value: False
> >> >> >
> >> >> > Path
> >> >> > Specify a static value: <mypath>
> >> >> >
> >> >> > Render Format
> >> >> > Specify a static value: Acrobat (PDF)
> >> >> >
> >> >> > User name <myuser>
> >> >> > Password <mypassword>
> >> >> >
> >> >> >
> >> >> > Get the value from the database: Choose a field ResGroupID
> >> >> > BegOfMonth
> >> >> > Please select a database field to use.
> >> >> > Blank database field names can not be used.
> >> >> >
> >> >> >
> >> >> > Write mode
> >> >> > Overwrite
> >> >> >
> >> >> > Specify report parameter values for rpt
> >> >> >
> >> >> > <parameter1>
> >> >> > Get the value from the database: <dbfield1>
> >> >> >
> >> >> > <parameter2>
> >> >> > Get the value from the database: <dbfield2>
> >> >> >
> >> >> > Step 6 - Create a data-driven subscription: rpt
> >> >> > Specify when the subscription is processed.
> >> >> >
> >> >> > On a schedule created for this subscription
> >> >> >
> >> >> > Step 7 - Create a data-driven subscription: rptMonthEnd
> >> >> > Use the following schedule to determine when the subscription is
> >> >> > processed.
> >> >> >
> >> >> > Choose whether to run the report on an hourly, daily, weekly,
> >> >> > monthly,
> >> >> > or
> >> >> > one time basis.
> >> >> > All times are expressed in (GMT -08:00) Pacific Standard Time.
> >> >> > Once
> >> >> >
> >> >> > One-time Schedule
> >> >> > Report runs only once.
> >> >> > <set the time 10 minutes from now>
> >> >> >
> >> >> >
> >> >> > Then I clicked Finish.
> >> >> >
> >> >> >
> >> >> > "johnE" wrote:
> >> >> >
> >> >> >> Use a data driven subscription. It is really quite simple if you
> >> >> >> need
> >> >> >> help
> >> >> >> let me know.
> >> >> >>
> >> >> >> "MTsang987" wrote:
> >> >> >>
> >> >> >> > Hi, I am new to SQL Reporting Services. I have built a report
> >> >> >> > that
> >> >> >> > takes a
> >> >> >> > query parameter (Business ID). I save the report in pdf format
> >> >> >> > using
> >> >> >> > the
> >> >> >> > toolbar. Now I would like to build a single report that
> >> >> >> > traverses
> >> >> >> > all
> >> >> >> > the
> >> >> >> > Business IDs (my table has BusinessIDs from 1 to 50), and creates
> >> >> >> > 50
> >> >> >> > separate
> >> >> >> > PDFs as outputs that we can send to 50 separate businesses.
> >> >> >> >
> >> >> >> > Is there a way to do this with SQL Reporting Services
> >> >> >> > automatically?
> >> >> >> > Currently, I am doing this manually.
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>|||Well according to the log files you are having all kinds of issues
connecting to the database. The last of which is an inability to decrypt
data. Have you changed the windows user recently? You may need to run
rsactivate to get your keys back into a reasonable state. Until the service
is starting without any errors you will not get any subscriptions processed.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"MTsang987" <MTsang987@.discussions.microsoft.com> wrote in message
news:71D51455-FAD1-4EA1-9042-2CCA35AEB9A3@.microsoft.com...
> Sorry, here is the proper file.
> <Header>
> <Product>Microsoft SQL Server Reporting Services Version
> 8.00.878.00</Product>
> <Locale>en-US</Locale>
> <TimeZone>Pacific Standard Time</TimeZone>
> <Path>C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> Services\LogFiles\ReportServerService__01_10_2005_08_37_26.log</Path>
> <SystemName>DEV-REPORT</SystemName>
> <OSName>Microsoft Windows NT 5.2.3790.0</OSName>
> <OSVersion>5.2.3790.0</OSVersion>
> </Header>
> ReportingServicesService!crypto!a88!1/10/2005-08:37:25:: i INFO:
> Initializing crypto as user: NT AUTHORITY\SYSTEM
> ReportingServicesService!library!a88!1/10/2005-08:37:25:: e ERROR:
> Transaction begin failed. Exception thrown:
> System.Data.SqlClient.SqlException: General network error. Check your
> network documentation.
> at System.Data.SqlClient.SqlConnection.OnError(SqlException exception,
> TdsParserState state)
> at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
> exception, TdsParserState state)
> at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
> at System.Data.SqlClient.TdsParser.FlushBuffer(Byte status)
> at System.Data.SqlClient.TdsParser.TdsExecuteSQLBatch(String text, Int32
> timeout)
> at System.Data.SqlClient.SqlInternalConnection.ExecuteTransaction(String
> sqlBatch, String method)
> at System.Data.SqlClient.SqlConnection.BeginTransaction(IsolationLevel
> iso)
> at
> Microsoft.ReportingServices.Library.ConnectionManager.BeginTransaction(IsolationLevel
> isoLevel)
> ReportingServicesService!library!a88!1/10/2005-08:37:25:: Exception caught
> while starting service. Error: System.Data.SqlClient.SqlException: General
> network error. Check your network documentation.
> at System.Data.SqlClient.SqlConnection.OnError(SqlException exception,
> TdsParserState state)
> at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
> exception, TdsParserState state)
> at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
> at System.Data.SqlClient.TdsParser.FlushBuffer(Byte status)
> at System.Data.SqlClient.TdsParser.TdsExecuteSQLBatch(String text, Int32
> timeout)
> at System.Data.SqlClient.SqlInternalConnection.ExecuteTransaction(String
> sqlBatch, String method)
> at System.Data.SqlClient.SqlConnection.BeginTransaction(IsolationLevel
> iso)
> at
> Microsoft.ReportingServices.Library.ConnectionManager.BeginTransaction(IsolationLevel
> isoLevel)
> at
> Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
> at
> Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
> at
> Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
> at
> Microsoft.ReportingServices.Library.ServiceController.ServiceStartThread()
> ReportingServicesService!library!a88!1/10/2005-08:37:25:: Attempting to
> start service again...
> ReportingServicesService!crypto!a88!1/10/2005-08:37:31:: i INFO:
> Initializing crypto as user: NT AUTHORITY\SYSTEM
> ReportingServicesService!crypto!a88!1/10/2005-08:37:31:: i INFO: Exporting
> public key
> ReportingServicesService!crypto!a88!1/10/2005-08:37:31:: i INFO:
> Performing
> sku validation
> ReportingServicesService!crypto!a88!1/10/2005-08:37:31:: i INFO: Importing
> existing encryption key
> ReportingServicesService!library!a88!1/10/2005-08:37:31:: e ERROR:
> Throwing
> Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDisabledException:
> The report server cannot decrypt the symmetric key used to access
> sensitive
> or encrypted data in a report server database. You must either restore a
> backup key or delete all encrypted content and then restart the service.
> Check the documentation for more information., ;
> Info:
> Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDisabledException:
> The report server cannot decrypt the symmetric key used to access
> sensitive
> or encrypted data in a report server database. You must either restore a
> backup key or delete all encrypted content and then restart the service.
> Check the documentation for more information. -->
> System.Runtime.InteropServices.COMException (0x80090005): Bad Data.
> at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
> errorCode, IntPtr errorInfo)
> at RSManagedCrypto.RSCrypto.ImportSymmetricKey(Byte[] pSymKeyBlob)
> at
> Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
> -- End of inner exception stack trace --
> ReportingServicesService!library!a88!1/10/2005-08:37:31:: Exception caught
> while starting service. Error:
> Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDisabledException:
> The report server cannot decrypt the symmetric key used to access
> sensitive
> or encrypted data in a report server database. You must either restore a
> backup key or delete all encrypted content and then restart the service.
> Check the documentation for more information. -->
> System.Runtime.InteropServices.COMException (0x80090005): Bad Data.
> at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
> errorCode, IntPtr errorInfo)
> at RSManagedCrypto.RSCrypto.ImportSymmetricKey(Byte[] pSymKeyBlob)
> at
> Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
> -- End of inner exception stack trace --
> at
> Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
> at
> Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
> at
> Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
> at
> Microsoft.ReportingServices.Library.ServiceController.ServiceStartThread()
> ReportingServicesService!library!a88!1/10/2005-08:37:31:: Attempting to
> start service again...
> ReportingServicesService!crypto!a88!1/10/2005-09:50:13:: i INFO:
> Initializing crypto as user: NT AUTHORITY\SYSTEM
> ReportingServicesService!library!a88!1/10/2005-09:50:13:: e ERROR:
> Transaction begin failed. Exception thrown:
> System.Data.SqlClient.SqlException: General network error. Check your
> network documentation.
> at System.Data.SqlClient.SqlConnection.OnError(SqlException exception,
> TdsParserState state)
> at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
> exception, TdsParserState state)
> at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
> at System.Data.SqlClient.TdsParser.ReadNetlib(Int32 bytesExpected)
> at System.Data.SqlClient.TdsParser.ReadBuffer()
> at System.Data.SqlClient.TdsParser.ReadByte()
> at System.Data.SqlClient.TdsParser.Run(RunBehavior run, SqlCommand
> cmdHandler, SqlDataReader dataStream)
> at System.Data.SqlClient.SqlInternalConnection.ExecuteTransaction(String
> sqlBatch, String method)
> at System.Data.SqlClient.SqlConnection.BeginTransaction(IsolationLevel
> iso)
> at
> Microsoft.ReportingServices.Library.ConnectionManager.BeginTransaction(IsolationLevel
> isoLevel)
> ReportingServicesService!library!a88!1/10/2005-09:50:13:: Exception caught
> while starting service. Error: System.Data.SqlClient.SqlException: General
> network error. Check your network documentation.
> at System.Data.SqlClient.SqlConnection.OnError(SqlException exception,
> TdsParserState state)
> at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
> exception, TdsParserState state)
> at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
> at System.Data.SqlClient.TdsParser.ReadNetlib(Int32 bytesExpected)
> at System.Data.SqlClient.TdsParser.ReadBuffer()
> at System.Data.SqlClient.TdsParser.ReadByte()
> at System.Data.SqlClient.TdsParser.Run(RunBehavior run, SqlCommand
> cmdHandler, SqlDataReader dataStream)
> at System.Data.SqlClient.SqlInternalConnection.ExecuteTransaction(String
> sqlBatch, String method)
> at System.Data.SqlClient.SqlConnection.BeginTransaction(IsolationLevel
> iso)
> at
> Microsoft.ReportingServices.Library.ConnectionManager.BeginTransaction(IsolationLevel
> isoLevel)
> at
> Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
> at
> Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
> at
> Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
> at
> Microsoft.ReportingServices.Library.ServiceController.ServiceStartThread()
> ReportingServicesService!library!a88!1/10/2005-09:50:13:: Attempting to
> start service again...
> ReportingServicesService!library!a88!1/10/2005-09:50:18:: e ERROR:
> Throwing
> Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDatabaseUnavailableException:
> The report server cannot open a connection to the report server database.
> A
> connection to the database is required for all requests and processing., ;
> Info:
> Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDatabaseUnavailableException:
> The report server cannot open a connection to the report server database.
> A
> connection to the database is required for all requests and
> processing. -->
> System.Data.SqlClient.SqlException: SQL Server has been paused. No new
> connections will be allowed.
> Login failed for user '(null)'.
> at System.Data.SqlClient.ConnectionPool.GetConnection(Boolean&
> isInTransaction)
> at
> System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString
> options, Boolean& isInTransaction)
> at System.Data.SqlClient.SqlConnection.Open()
> at
> Microsoft.ReportingServices.Library.ConnectionManager.OpenConnection()
> -- End of inner exception stack trace --
> ReportingServicesService!library!a88!1/10/2005-09:50:18:: Exception caught
> while starting service. Error:
> Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDatabaseUnavailableException:
> The report server cannot open a connection to the report server database.
> A
> connection to the database is required for all requests and
> processing. -->
> System.Data.SqlClient.SqlException: SQL Server has been paused. No new
> connections will be allowed.
> Login failed for user '(null)'.
> at System.Data.SqlClient.ConnectionPool.GetConnection(Boolean&
> isInTransaction)
> at
> System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString
> options, Boolean& isInTransaction)
> at System.Data.SqlClient.SqlConnection.Open()
> at
> Microsoft.ReportingServices.Library.ConnectionManager.OpenConnection()
> -- End of inner exception stack trace --
> at
> Microsoft.ReportingServices.Library.ConnectionManager.OpenConnection()
> at
> Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
> at
> Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
> at
> Microsoft.ReportingServices.Library.ServiceController.ServiceStartThread()
> ReportingServicesService!library!a88!1/10/2005-09:50:18:: Attempting to
> start service again...
> ReportingServicesService!crypto!a88!1/10/2005-10:01:11:: i INFO:
> Initializing crypto as user: NT AUTHORITY\SYSTEM
> ReportingServicesService!crypto!a88!1/10/2005-10:01:11:: i INFO: Exporting
> public key
> ReportingServicesService!crypto!a88!1/10/2005-10:01:11:: i INFO:
> Performing
> sku validation
> ReportingServicesService!crypto!a88!1/10/2005-10:01:11:: i INFO: Importing
> existing encryption key
> ReportingServicesService!library!a88!1/10/2005-10:01:11:: e ERROR:
> Throwing
> Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDisabledException:
> The report server cannot decrypt the symmetric key used to access
> sensitive
> or encrypted data in a report server database. You must either restore a
> backup key or delete all encrypted content and then restart the service.
> Check the documentation for more information., ;
> Info:
> Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDisabledException:
> The report server cannot decrypt the symmetric key used to access
> sensitive
> or encrypted data in a report server database. You must either restore a
> backup key or delete all encrypted content and then restart the service.
> Check the documentation for more information. -->
> System.Runtime.InteropServices.COMException (0x80090005): Bad Data.
> at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
> errorCode, IntPtr errorInfo)
> at RSManagedCrypto.RSCrypto.ImportSymmetricKey(Byte[] pSymKeyBlob)
> at
> Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
> -- End of inner exception stack trace --
> ReportingServicesService!library!a88!1/10/2005-10:01:11:: Exception caught
> while starting service. Error:
> Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDisabledException:
> The report server cannot decrypt the symmetric key used to access
> sensitive
> or encrypted data in a report server database. You must either restore a
> backup key or delete all encrypted content and then restart the service.
> Check the documentation for more information. -->
> System.Runtime.InteropServices.COMException (0x80090005): Bad Data.
> at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
> errorCode, IntPtr errorInfo)
> at RSManagedCrypto.RSCrypto.ImportSymmetricKey(Byte[] pSymKeyBlob)
> at
> Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
> -- End of inner exception stack trace --
> at
> Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
> at
> Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
> at
> Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
> at
> Microsoft.ReportingServices.Library.ServiceController.ServiceStartThread()
> ReportingServicesService!library!a88!1/10/2005-10:01:11:: Attempting to
> start service again...
> ReportingServicesService!servicecontroller!708!1/10/2005-10:38:49::
> Service
> controller exiting.
>
> "Daniel Reib [MSFT]" wrote:
>> This is the web service log file. You need the windows service log file
>> (reportserverservice)
>> --
>> -Daniel
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "MTsang987" <MTsang987@.discussions.microsoft.com> wrote in message
>> news:80897360-2A36-4775-856F-6855C4A62202@.microsoft.com...
>> > Note that I had tried it again earlier this morning, and it shows the
>> > reportserver service started, but the report did not run. There is a
>> > new
>> > log
>> > file, the contents are:
>> > <Header>
>> > <Product>Microsoft SQL Server Reporting Services Version
>> > 8.00.878.00</Product>
>> > <Locale>en-US</Locale>
>> > <TimeZone>Pacific Standard Time</TimeZone>
>> > <Path>C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
>> > Services\LogFiles\ReportServer__01_10_2005_09_59_26.log</Path>
>> > <SystemName>DEV-REPORT</SystemName>
>> > <OSName>Microsoft Windows NT 5.2.3790.0</OSName>
>> > <OSVersion>5.2.3790.0</OSVersion>
>> > </Header>
>> > w3wp!webserver!ea0!1/10/2005-09:59:26:: i INFO: Reporting Web Server
>> > started
>> > w3wp!library!ea0!1/10/2005-09:59:26:: i INFO: Initializing
>> > ConnectionType
>> > to
>> > '1' as specified in Configuration file.
>> > w3wp!library!ea0!1/10/2005-09:59:26:: i INFO: Initializing
>> > IsSchedulingService to 'True' as specified in Configuration file.
>> > w3wp!library!ea0!1/10/2005-09:59:26:: i INFO: Initializing
>> > IsNotificationService to 'True' as specified in Configuration file.
>> > w3wp!library!ea0!1/10/2005-09:59:26:: i INFO: Initializing
>> > IsEventService
>> > to
>> > 'True' as specified in Configuration file.
>> > w3wp!library!ea0!1/10/2005-09:59:26:: i INFO: Initializing
>> > PollingInterval
>> > to '10' second(s) as specified in Configuration file.
>> > w3wp!library!ea0!1/10/2005-09:59:26:: i INFO: Initializing MemoryLimit
>> > to
>> > '60' percent as specified in Configuration file.
>> > w3wp!library!ea0!1/10/2005-09:59:26:: i INFO: Initializing RecycleTime
>> > to
>> > '720' minute(s) as specified in Configuration file.
>> > w3wp!library!ea0!1/10/2005-09:59:26:: i INFO: Initializing
>> > MaximumMemoryLimit to '80' percent as specified in Configuration file.
>> > w3wp!library!ea0!1/10/2005-09:59:26:: i INFO: Initializing
>> > MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration
>> > file.
>> > w3wp!library!ea0!1/10/2005-09:59:26:: i INFO: Initializing
>> > MaxQueueThreads
>> > to '0' thread(s) as specified in Configuration file.
>> > w3wp!library!ea0!1/10/2005-09:59:26:: i INFO: Initializing
>> > MaxActiveReqForOneUser to '20' requests(s) as specified in
>> > Configuration
>> > file.
>> > w3wp!library!ea0!1/10/2005-09:59:26:: i INFO: Initializing
>> > MaxScheduleWait
>> > to '5' second(s) as specified in Configuration file.
>> > w3wp!library!ea0!1/10/2005-09:59:26:: i INFO: Initializing
>> > DatabaseQueryTimeout to '120' second(s) as specified in Configuration
>> > file.
>> > w3wp!library!ea0!1/10/2005-09:59:26:: i INFO: Initializing InstanceName
>> > to
>> > 'MSSQLSERVER' as specified in Configuration file.
>> > w3wp!library!ea0!1/10/2005-09:59:26:: i INFO: Initializing
>> > ProcessRecycleOptions to '0' as specified in Configuration file.
>> > w3wp!library!ea0!1/10/2005-09:59:26:: i INFO: Initializing
>> > RunningRequestsScavengerCycle to '60' second(s) as specified in
>> > Configuration
>> > file.
>> > w3wp!library!ea0!1/10/2005-09:59:26:: i INFO: Initializing
>> > RunningRequestsDbCycle to '60' second(s) as specified in Configuration
>> > file.
>> > w3wp!library!ea0!1/10/2005-09:59:26:: i INFO: Initializing
>> > RunningRequestsAge to '30' second(s) as specified in Configuration
>> > file.
>> > w3wp!library!ea0!1/10/2005-09:59:26:: i INFO: Initializing
>> > CleanupCycleMinutes to '10' minute(s) as specified in Configuration
>> > file.
>> > w3wp!library!ea0!1/10/2005-09:59:26:: i INFO: Initializing
>> > SecureConnectionLevel to '0' as specified in Configuration file.
>> > w3wp!library!ea0!1/10/2005-09:59:26:: i INFO: Initializing
>> > DisplayErrorLink
>> > to 'True' as specified in Configuration file.
>> > w3wp!library!ea0!1/10/2005-09:59:26:: i INFO: Initializing
>> > WebServiceUseFileShareStorage to default value of 'False' because it
>> > was
>> > not
>> > specified in Configuration file.
>> > w3wp!resourceutilities!ea0!1/10/2005-09:59:26:: i INFO: Running on 0
>> > physical processors, 1 logical processors
>> > w3wp!resourceutilities!ea0!1/10/2005-09:59:26:: i INFO: Reporting
>> > Services
>> > starting SKU: Enterprise
>> > w3wp!runningjobs!ea0!1/10/2005-09:59:26:: i INFO: Database Cleanup (Web
>> > Service) timer enabled: Cycle: 600 seconds
>> > w3wp!runningjobs!ea0!1/10/2005-09:59:26:: i INFO: Running Requests
>> > Scavenger
>> > timer enabled: Cycle: 60 seconds
>> > w3wp!runningjobs!ea0!1/10/2005-09:59:26:: i INFO: Running Requests DB
>> > timer
>> > enabled: Cycle: 60 seconds
>> > w3wp!runningjobs!ea0!1/10/2005-09:59:26:: i INFO: Memory stats update
>> > timer
>> > enabled: Cycle: 60 seconds
>> > w3wp!library!ca8!01/10/2005-09:59:29:: i INFO: Call to GetPermissions:/
>> > w3wp!crypto!ca8!01/10/2005-09:59:29:: i INFO: Initializing crypto as
>> > user:
>> > NT AUTHORITY\NETWORK SERVICE
>> > w3wp!crypto!ca8!01/10/2005-09:59:29:: i INFO: Exporting public key
>> > w3wp!crypto!ca8!01/10/2005-09:59:29:: i INFO: Performing sku validation
>> > w3wp!crypto!ca8!01/10/2005-09:59:29:: i INFO: Importing existing
>> > encryption
>> > key
>> > w3wp!library!ca8!01/10/2005-09:59:30:: i INFO: Call to
>> > GetSystemPermissions
>> > w3wp!library!ca8!01/10/2005-09:59:36:: i INFO: Call to
>> > GetPermissions:/MonthEndInvoices
>> > w3wp!library!ca8!01/10/2005-09:59:36:: i INFO: Call to
>> > GetSystemPermissions
>> > w3wp!library!aac!01/10/2005-09:59:44:: i INFO: Call to
>> > GetPermissions:/MonthEndInvoices/HOSS
>> > w3wp!library!aac!01/10/2005-09:59:44:: i INFO: Call to
>> > GetSystemPermissions
>> > w3wp!library!aac!01/10/2005-09:59:59:: i INFO: Call to
>> > GetPermissions:/MonthEndInvoices/HOSS
>> > w3wp!library!aac!01/10/2005-09:59:59:: i INFO: Call to
>> > GetSystemPermissions
>> > w3wp!library!aac!01/10/2005-10:00:07:: i INFO: Call to
>> > GetPermissions:/MonthEndInvoices/HOSS
>> > w3wp!library!aac!01/10/2005-10:00:07:: i INFO: Call to
>> > GetSystemPermissions
>> > w3wp!library!aac!01/10/2005-10:00:10:: i INFO: Call to
>> > GetPermissions:/MonthEndInvoices/HOSS
>> > w3wp!library!aac!01/10/2005-10:00:10:: i INFO: Call to
>> > GetSystemPermissions
>> > w3wp!library!ea0!01/10/2005-10:00:12:: i INFO: Call to
>> > GetPermissions:/MonthEndInvoices/HOSS
>> > w3wp!library!ea0!01/10/2005-10:00:12:: i INFO: Call to
>> > GetSystemPermissions
>> > w3wp!library!ca8!01/10/2005-10:00:14:: i INFO: Call to
>> > GetPermissions:/MonthEndInvoices/rptMonthEnd
>> > w3wp!library!ca8!01/10/2005-10:00:14:: i INFO: Initializing
>> > EnableIntegratedSecurity to 'True' as specified in Server system
>> > properties.
>> > w3wp!library!aac!01/10/2005-10:00:15:: i INFO: Call to
>> > GetSystemPermissions
>> > w3wp!library!aac!01/10/2005-10:00:15:: i INFO: Initializing
>> > ResponseBufferSizeKb to default value of '64' KB because it was not
>> > specified
>> > in Server system properties.
>> > w3wp!library!aac!01/10/2005-10:00:15:: i INFO: Initializing
>> > UseSessionCookies to 'True' as specified in Server system properties.
>> > w3wp!library!ea0!01/10/2005-10:00:19:: i INFO: Call to
>> > GetPermissions:/MonthEndInvoices/rptMonthEnd
>> > w3wp!library!ea0!01/10/2005-10:00:20:: i INFO: Call to
>> > GetSystemPermissions
>> > w3wp!library!aac!01/10/2005-10:00:22:: i INFO: Call to
>> > GetSystemPermissions
>> > w3wp!library!aac!01/10/2005-10:00:30:: i INFO: Call to
>> > GetSystemPermissions
>> > w3wp!library!aac!01/10/2005-10:00:47:: i INFO: Call to
>> > GetSystemPermissions
>> > w3wp!library!ea0!01/10/2005-10:00:52:: i INFO: Call to
>> > GetSystemPermissions
>> > w3wp!library!aac!01/10/2005-10:00:55:: i INFO: Call to
>> > GetSystemPermissions
>> > w3wp!library!ea0!01/10/2005-10:01:24:: i INFO: Call to
>> > GetSystemPermissions
>> > w3wp!library!ea0!01/10/2005-10:01:28:: i INFO: Call to
>> > GetSystemPermissions
>> > w3wp!library!ea0!01/10/2005-10:01:34:: i INFO: Call to
>> > GetSystemPermissions
>> > w3wp!library!ea0!01/10/2005-10:01:50:: i INFO: Call to
>> > GetSystemPermissions
>> > w3wp!library!aac!01/10/2005-10:01:52:: i INFO: Call to
>> > GetPermissions:/MonthEndInvoices/rptMonthEnd
>> > w3wp!library!aac!01/10/2005-10:01:52:: i INFO: Call to
>> > GetSystemPermissions
>> > w3wp!library!ea0!01/10/2005-10:02:06:: i INFO: Call to
>> > GetPermissions:/MonthEndInvoices/rptMonthEnd
>> > w3wp!library!ea0!01/10/2005-10:02:06:: i INFO: Call to
>> > GetSystemPermissions
>> > w3wp!library!ea0!01/10/2005-10:02:09:: i INFO: Call to
>> > GetPermissions:/MonthEndInvoices/rptMonthEnd
>> > w3wp!library!ea0!01/10/2005-10:02:09:: i INFO: Call to
>> > GetSystemPermissions
>> > w3wp!library!ea0!1/10/2005-10:09:28:: i INFO: Cleaned 0 batch records,
>> > 0
>> > policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running
>> > jobs
>> > w3wp!library!aac!1/10/2005-10:19:29:: i INFO: Cleaned 0 batch records,
>> > 0
>> > policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running
>> > jobs
>> > w3wp!webserver!260!1/10/2005-10:22:29:: i INFO: Reporting Web Server
>> > stopped
>> >
>> > "Daniel Reib [MSFT]" wrote:
>> >
>> >> Were those the only files? If so it shows that the service is not
>> >> running.
>> >> Can you check and see if the ReportService windows service is running?
>> >>
>> >> --
>> >> -Daniel
>> >> This posting is provided "AS IS" with no warranties, and confers no
>> >> rights.
>> >>
>> >>
>> >> "MTsang987" <MTsang987@.discussions.microsoft.com> wrote in message
>> >> news:5A41927C-F043-4232-8A08-B4371142FD3E@.microsoft.com...
>> >> > Sorry, I found a file timestamped at 10:38 although I've tried to
>> >> > run
>> >> > it
>> >> > at
>> >> > 11:00, 12:00, 1:00, and 2:00.
>> >> >
>> >> > <Header>
>> >> > <Product>Microsoft SQL Server Reporting Services Version
>> >> > 8.00.878.00</Product>
>> >> > <Locale>en-US</Locale>
>> >> > <TimeZone>Pacific Standard Time</TimeZone>
>> >> > <Path>C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
>> >> > Services\LogFiles\ReportServerService__01_07_2005_10_38_43.log</Path>
>> >> > <SystemName>DEV-REPORT</SystemName>
>> >> > <OSName>Microsoft Windows NT 5.2.3790.0</OSName>
>> >> > <OSVersion>5.2.3790.0</OSVersion>
>> >> > </Header>
>> >> > ReportingServicesService!servicecontroller!708!1/7/2005-10:38:43::
>> >> > Service
>> >> > controller exiting.
>> >> >
>> >> >
>> >> >
>> >> > <Header>
>> >> > <Product>Microsoft SQL Server Reporting Services Version
>> >> > 8.00.878.00</Product>
>> >> > <Locale>en-US</Locale>
>> >> > <TimeZone>Pacific Standard Time</TimeZone>
>> >> > <Path>C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
>> >> > Services\LogFiles\ReportServerService__main_01_07_2005_10_38_42.log</Path>
>> >> > <SystemName>DEV-REPORT</SystemName>
>> >> > <OSName>Microsoft Windows NT 5.2.3790.0</OSName>
>> >> > <OSVersion>5.2.3790.0</OSVersion>
>> >> > </Header>
>> >> > ReportingServicesService!servicecontroller!708!1/7/2005-10:38:42:: i
>> >> > INFO:
>> >> > Recycling the service from default domain
>> >> > ReportingServicesService!servicecontroller!708!1/7/2005-10:38:43:: i
>> >> > INFO:
>> >> > New app domain started
>> >> >
>> >> >
>> >> > "Daniel Reib [MSFT]" wrote:
>> >> >
>> >> >> What happened? Did you get an error? Can you look in the
>> >> >> reportserverservice<timestamp>.log file to see what error where
>> >> >> produced?
>> >> >>
>> >> >> --
>> >> >> -Daniel
>> >> >> This posting is provided "AS IS" with no warranties, and confers no
>> >> >> rights.
>> >> >>
>> >> >>
>> >> >> "MTsang987" <MTsang987@.discussions.microsoft.com> wrote in message
>> >> >> news:EA2A52C6-92E3-4831-8230-919743ECE5BF@.microsoft.com...
>> >> >> >I need help with the DDS. These are the steps that I used and it
>> >> >> >didn't
>> >> >> >run:
>> >> >> >
>> >> >> >
>> >> >> > Step 1 - Create a data-driven subscription:
>> >> >> >
>> >> >> > Specify how recipients are notified:
>> >> >> > Report Server File Share
>> >> >> > Specify a data source that contains recipient information:
>> >> >> > Specify for this subscription only
>> >> >> >
>> >> >> >
>> >> >> > Step 2 - Create a data-driven subscription: rptMonthEnd
>> >> >> >
>> >> >> > Connection Type: Microsoft SQL Server
>> >> >> > Connection String: <connection string>
>> >> >> >
>> >> >> > Connect Using:
>> >> >> > Credentials stored securely in the report server
>> >> >> > User name: <username>
>> >> >> > Pssword: <password>
>> >> >> >
>> >> >> > x Use as Windows credentials when connecting to the data source
>> >> >> >
>> >> >> > Step 3 - Create a data-driven subscription:
>> >> >> > Specify a command or query that returns a list of recipients and
>> >> >> > optionally
>> >> >> > returns fields used to vary delivery settings and report
>> >> >> > parameter
>> >> >> > values
>> >> >> > for
>> >> >> > each recipient:
>> >> >> >
>> >> >> > Select * FROM MyTable
>> >> >> >
>> >> >> > File name
>> >> >> > Get the value from the database: <reportfilename>
>> >> >> >
>> >> >> > File Extension
>> >> >> > Specify a static value: False
>> >> >> >
>> >> >> > Path
>> >> >> > Specify a static value: <mypath>
>> >> >> >
>> >> >> > Render Format
>> >> >> > Specify a static value: Acrobat (PDF)
>> >> >> >
>> >> >> > User name <myuser>
>> >> >> > Password <mypassword>
>> >> >> >
>> >> >> >
>> >> >> > Get the value from the database: Choose a field ResGroupID
>> >> >> > BegOfMonth
>> >> >> > Please select a database field to use.
>> >> >> > Blank database field names can not be used.
>> >> >> >
>> >> >> >
>> >> >> > Write mode
>> >> >> > Overwrite
>> >> >> >
>> >> >> > Specify report parameter values for rpt
>> >> >> >
>> >> >> > <parameter1>
>> >> >> > Get the value from the database: <dbfield1>
>> >> >> >
>> >> >> > <parameter2>
>> >> >> > Get the value from the database: <dbfield2>
>> >> >> >
>> >> >> > Step 6 - Create a data-driven subscription: rpt
>> >> >> > Specify when the subscription is processed.
>> >> >> >
>> >> >> > On a schedule created for this subscription
>> >> >> >
>> >> >> > Step 7 - Create a data-driven subscription: rptMonthEnd
>> >> >> > Use the following schedule to determine when the subscription is
>> >> >> > processed.
>> >> >> >
>> >> >> > Choose whether to run the report on an hourly, daily, weekly,
>> >> >> > monthly,
>> >> >> > or
>> >> >> > one time basis.
>> >> >> > All times are expressed in (GMT -08:00) Pacific Standard Time.
>> >> >> > Once
>> >> >> >
>> >> >> > One-time Schedule
>> >> >> > Report runs only once.
>> >> >> > <set the time 10 minutes from now>
>> >> >> >
>> >> >> >
>> >> >> > Then I clicked Finish.
>> >> >> >
>> >> >> >
>> >> >> > "johnE" wrote:
>> >> >> >
>> >> >> >> Use a data driven subscription. It is really quite simple if
>> >> >> >> you
>> >> >> >> need
>> >> >> >> help
>> >> >> >> let me know.
>> >> >> >>
>> >> >> >> "MTsang987" wrote:
>> >> >> >>
>> >> >> >> > Hi, I am new to SQL Reporting Services. I have built a report
>> >> >> >> > that
>> >> >> >> > takes a
>> >> >> >> > query parameter (Business ID). I save the report in pdf
>> >> >> >> > format
>> >> >> >> > using
>> >> >> >> > the
>> >> >> >> > toolbar. Now I would like to build a single report that
>> >> >> >> > traverses
>> >> >> >> > all
>> >> >> >> > the
>> >> >> >> > Business IDs (my table has BusinessIDs from 1 to 50), and
>> >> >> >> > creates
>> >> >> >> > 50
>> >> >> >> > separate
>> >> >> >> > PDFs as outputs that we can send to 50 separate businesses.
>> >> >> >> >
>> >> >> >> > Is there a way to do this with SQL Reporting Services
>> >> >> >> > automatically?
>> >> >> >> > Currently, I am doing this manually.
>> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>> >>
>>|||We changed the windows user, and then switched it back. I tried to run
rsactivate from the command line and from Start-->Run but it says rsactivate
not found. Do I need to install this separately when installing
ReportServices?
Also, how do you escape a "-" in a parameter on the command line - my report
server is called "Dev-Report" and when I tried to run rsactivate I used a
double-quote with the switch, -m"Dev-Report" is this correct?
"Daniel Reib [MSFT]" wrote:
> Well according to the log files you are having all kinds of issues
> connecting to the database. The last of which is an inability to decrypt
> data. Have you changed the windows user recently? You may need to run
> rsactivate to get your keys back into a reasonable state. Until the service
> is starting without any errors you will not get any subscriptions processed.
> --|||Daniel, thank you for all your help.
I can still run the report manually. We don't have Visual Studio.Net on the
server, so I tried running rsactivate from my machine with the -t option, and
I was using double quotes to escape the "-" embedded in the server name (see
my other post). Here is the message I got:
Failure initializing remote NT Service:
System.IO.FileNotFoundException: File or assembly name
ReportingServicesNativeCl
ient, or one of its dependencies, was not found.
File name: "ReportingServicesNativeClient"
at
Microsoft.ReportingServices.RSActivate.RSActivate.RpcActivateService(Int32
clientType)
at Microsoft.ReportingServices.RSActivate.RSActivate.InstanceMain()
at Microsoft.ReportingServices.BaseCmdLine.CommandLineMain(String[] args,
Bas
eCmdLine instance)
=== Pre-bind state information ===LOG: DisplayName = ReportingServicesNativeClient, Version=0.0.0.0,
Culture=neutr
al, PublicKeyToken=89845dcd8080cc91
(Fully-specified)
LOG: Appbase = C:\Program Files\Microsoft SQL Server\80\Tools\BINN\
LOG: Initial PrivatePath = NULL
Calling assembly : RSActivate, Version=8.0.242.0, Culture=neutral,
PublicKeyToke
n=89845dcd8080cc91.
===
LOG: Publisher policy file is not found.
LOG: Host configuration file not found.
LOG: Using machine configuration file from
C:\WINDOWS\Microsoft.NET\Framework\v1
.1.4322\config\machine.config.
LOG: Post-policy reference: ReportingServicesNativeClient, Version=0.0.0.0,
Cult
ure=neutral, PublicKeyToken=89845dcd8080cc91
LOG: Attempting download of new URL file:///C:/Program Files/Microsoft SQL
Serve
r/80/Tools/BINN/ReportingServicesNativeClient.DLL.
LOG: Attempting download of new URL file:///C:/Program Files/Microsoft SQL
Serv
r/80/Tools/BINN/ReportingServicesNativeClient/ReportingServicesNativeClient.DLL.
LOG: Attempting download of new URL file:///C:/Program Files/Microsoft SQL
Serve
r/80/Tools/BINN/ReportingServicesNativeClient.EXE.
LOG: Attempting download of new URL file:///C:/Program Files/Microsoft SQL
Serv
r/80/Tools/BINN/ReportingServicesNativeClient/ReportingServicesNativeClient.EXE.
"Daniel Reib [MSFT]" wrote:
> Well according to the log files you are having all kinds of issues
> connecting to the database. The last of which is an inability to decrypt
> data. Have you changed the windows user recently? You may need to run
> rsactivate to get your keys back into a reasonable state. Until the service
> is starting without any errors you will not get any subscriptions processed.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>|||From my previous reply, I did not mean to imply that the problem is solved -
it is still not running.
"Daniel Reib [MSFT]" wrote:
> Well according to the log files you are having all kinds of issues
> connecting to the database. The last of which is an inability to decrypt
> data. Have you changed the windows user recently? You may need to run
> rsactivate to get your keys back into a reasonable state. Until the service
> is starting without any errors you will not get any subscriptions processed.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.