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.