creation of table that type of format........

hello all
i want to create a phone table and it contains two fields empid ,ph.
the phone table following format:

Phone table
-------------
empid ph
-- ----------
office Mobile home
--- --- ---
100 9380768532 98455555 98822213

--------------

i want above type of format and then how to insert into values that
phone table . please help me.surya (suryaitha@.gmail.com) writes:
> i want to create a phone table and it contains two fields empid ,ph.
> the phone table following format:
> Phone table
> -------------
> empid ph
> -- ----------
> office Mobile home
> --- --- ---
> 100 9380768532 98455555 98822213
> --------------
> i want above type of format and then how to insert into values that
> phone table . please help me.

The INSERT statement would be:

INSERT phonetable (empid, office, mobile, home)
VALUES (100, '9380768532', '98455555', '98822213')

If you are using some application environment, it is not unlikely that
the Client API offers some interface that constructs the INSERT statement
under the covers, but gives you a "nicer" interface.

The table design as such is not unquestionable. You have indicated
that office, modbile and home are infact subfields of ph, but there
is no such thing in a database table.

Depending on your requirements, it may be better to do:

CREATE TABLE phonetypes
(phonetype char(3) NOT NULL,
phonetypename varchar(20) NOT NULL,
CONSTRAINT pk_phonetypes PRIMARY KEY(phonetypeid))

INSERT phonetypes (phonetypes, phonetypename)
VALUES ('OFC', 'Office')
INSERT phonetype (phonetypes, phonetypename)
VALUES ('MOB', 'Mobile')
INSERT phonetype (phonetypes, phonetypename)
VALUES ('HOME', 'Home')

CREATE TABLE phonenumbers
(empid int NOT NULL,
phoneno varchar(200) NOT NULL,
phonetype char(3) NOT NULL,
isdefault bit NOT NULL,
CONSTRAINT pk_phonenumbers PRIMARY KEY(empid, phoneno),
CONSTRAINT fk_phonetype FORIEGN KEY (phonetype)
REFERENCES phonetypes (phonetype),
CONSTRAINT fk_employees (empid)
REFERENCES employees(empid))

There would be a trigger on phonenumbers, that enforces that isdefault may
be 1 for at most one combination of (empid, phoneno).

This design buys you more flexibility. Some people have more than one mobile
phone. It also permits you to add other telephone types such as FAX or
IP telephone like Skype. Since on services like Skype you don't have
traditional telephone numbers, but, as I understand it, something that looks
more like an email address, I've made phoneno varchar(200).

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||"surya" <suryaitha@.gmail.com> wrote in news:1144477944.400250.34550
@.z34g2000cwc.googlegroups.com:

> hello all
> i want to create a phone table and it contains two fields empid ,ph.
> the phone table following format:

Aren't you going to fail your class if you don't
do your own homework?

Creating XML output...unusual/impossible format?

Hi all,

I'm Trying to replicate the creation of an "xml" file that is currently created using a C++ application. I want to take that application out of the picture, but need to create the same format XML file because a step later in the production process uses this file, and I cannot change it.

The output format I am looking for is:<?xml version="1.0" encoding="utf-8"?>
<FUNDS>
<AMRGX>
<NAME>AMERICAN GROWTH D</NAME>
</AMRGX>
<AHERX>
<NAME>AMERICAN HERITAGE FUND</NAME>
</AHERX>
<AMRVX>
<NAME>AMERICAN INVESTORS GROWTH FUND</NAME>
</AMRVX>
.
.
.
</FUNDS>The problem I am having is that I cannot seem to get the level/node of the fund symbol (AMRGX, AHERX, and AMRVX in the example above) as it needs to be. I think this must be some non-standard use of XML, since the tag is really the data itself (?)

The closest I have been able to get so far is:
<FUNDS>
<SYMBOL>AMRGX</SYMBOL>
<NAME>AMERICAN GROWTH D</NAME>
</FUNDS>
<FUNDS>
<SYMBOL>AHERX</SYMBOL>
<NAME>AMERICAN HERITAGE FUND</NAME>
</FUNDS>
.
.
.As you can see (hopefully) I am able to get the data I need but cannot get:
(1) the FUNDS tag(s) to be the very highest level/root.
nor (2) the SYMBOL part (tag label?) to be the actual variable stock fund.

Am I 'splaining this well enough? I don't necessarily need all the code, since I know I haven't given enough info to help with that, but my basic question is - - Is it possible to get a variable TAG based on the table DATA?

I want my SYMBOL tag to be the actual SYMBOL for the stock fund.

Confused? Not as much as I am *LOL* I am new to the use of all but XML EXPLICIT use, so any help would be appreciated - at least regarding my two formatting questions.

Yes, I have (and am still) searching around BOL for my answers, but so I have found nothing that helps me out. Meanwhile, suggestions are welcome!

Thanks!You cannot achieve this with a single SELECT statement because you can have only one column name for the entire result set.(you stated this already). If you need to have the column value as a tag then a stored procedure is the way to go where you can generate your own XML TAGs.
Hi all,

I'm Trying to replicate the creation of an "xml" file that is currently created using a C++ application. I want to take that application out of the picture, but need to create the same format XML file because a step later in the production process uses this file, and I cannot change it.

The output format I am looking for is:<?xml version="1.0" encoding="utf-8"?>
<FUNDS>
<AMRGX>
<NAME>AMERICAN GROWTH D</NAME>
</AMRGX>
<AHERX>
<NAME>AMERICAN HERITAGE FUND</NAME>
</AHERX>
<AMRVX>
<NAME>AMERICAN INVESTORS GROWTH FUND</NAME>
</AMRVX>
.
.
.
</FUNDS>The problem I am having is that I cannot seem to get the level/node of the fund symbol (AMRGX, AHERX, and AMRVX in the example above) as it needs to be. I think this must be some non-standard use of XML, since the tag is really the data itself (?)

The closest I have been able to get so far is:
<FUNDS>
<SYMBOL>AMRGX</SYMBOL>
<NAME>AMERICAN GROWTH D</NAME>
</FUNDS>
<FUNDS>
<SYMBOL>AHERX</SYMBOL>
<NAME>AMERICAN HERITAGE FUND</NAME>
</FUNDS>
.
.
.As you can see (hopefully) I am able to get the data I need but cannot get:
(1) the FUNDS tag(s) to be the very highest level/root.
nor (2) the SYMBOL part (tag label?) to be the actual variable stock fund.

Am I 'splaining this well enough? I don't necessarily need all the code, since I know I haven't given enough info to help with that, but my basic question is - - Is it possible to get a variable TAG based on the table DATA?

I want my SYMBOL tag to be the actual SYMBOL for the stock fund.

Confused? Not as much as I am *LOL* I am new to the use of all but XML EXPLICIT use, so any help would be appreciated - at least regarding my two formatting questions.

Yes, I have (and am still) searching around BOL for my answers, but so I have found nothing that helps me out. Meanwhile, suggestions are welcome!

Thanks!|||Thanks for the reply.

I was afraid of that. The previous version of the product used a C++ program to generate the XML (or pseudo-XML) output. I was hoping it was just because the developer didn't know how to use the XML extraction stuff in SQL Server. *sigh*

Oh well, I guess I get to gain some C# practice, as the C++ application has the source of the data "hard coded" in the logic, and we need to use a predefined, "standard" linked server reference (aka "alias").|||"Can't be Done"?

The three words I tell developers to never let me hear, otherwise I bring out the baseball bat

Dude, you know the drill

DDL, DML, I gues we got the expected results already...|||Never mind...but I'm only guessing...

USE Northwind
GO

CREATE TABLE myTable99(FundSymbol char(5), FundName varchar(255))
GO

INSERT INTO myTable99(FundSymbol, FundName)
SELECT 'AMRGX', 'AMERICAN GROWTH D' UNION ALL
SELECT 'AHERX', 'AHERX HERITAGE FUND' UNION ALL
SELECT 'AMRVX', 'AMERICAN INVESTORS GROWTH FUND'

SELECT XML_Output
FROM (
SELECT '<?xml version="1.0" encoding="utf-8"?>' AS XML_Output, 1 AS XML_Group, Null AS FundSymbol
UNION ALL
SELECT '<FUNDS>'AS XML_Output, 2 AS XML_Group, Null AS FundSymbol
UNION ALL
SELECT REPLICATE(' ',20)+'<'+FundSymbol+'>'+CHAR(13)+CHAR(10)
+ REPLICATE(' ',40)+'<NAME>'+FundName+'</NAME>'+CHAR(13)+CHAR(10)
+ REPLICATE(' ',20)+'</'+FundSymbol+'>'+CHAR(13)+CHAR(10)AS XML_Output
, 3 AS XML_Group, FundSymbol
FROM myTable99
UNION ALL
SELECT '<FUNDS>'AS XML_Output, 4 AS XML_Group, Null AS FundSymbol
) AS XXX
ORDER BY XML_Group, FundSymbol
GO

DROP TABLE myTable99
GO|||*sigh* What can I say? Every day you guys amaze me more-n-more :)

That's EXACLY what I was a-lookin for! I appreciate you doing my homework for me *hanging head* I tend to forget the usefullness of UNION, and have yet to use "REPLICATE", so now I need to go look THAT one up in BOL so that I can once again expand my horizons just a little more.

Funny (to me, anyway) that because every other application in our world here that creates XML output uses the FOR XML directive to create the output, that I get tunnel vision and just can't seem to see the easy answer lies in "standard" SQL. I guess kinda like my kids, who can't seem to get their heads around the ideas that (a) you can make your own ice cream, (b)clothes can come from a sewing machine instead of a store, (c) there's a way to change your oil without going to Jiffy Lube, and myriad other such examples of "OMG, you mean you can do that the old-fashioned way?".

But I digress...Thanks once again, Brett, for taking the time and effort to plainly show how I can get around yet another stumbling block.

It's too bad though, that since it can't be done, I will have to disregard your fantasy code and open my C# book. ;)

Thanks again!|||A mere trifle...

I was interested, because of a discussion I had with a Java developer.

If I could deliver the content in a manner like you are looking for, then the development life cycle for java gets cut in half.

I'm just exploring this now, but I was leaning on having metadata stored in the database, where I could configure all of the results via table.

Each element would have it's own properties stored.

So if the don't like the text to be black, I can make it red, on the fly. No application release headaches.

I was going to extend that and see if I could also incorporate the style sheets in the database as well..

FOR XML...what a bunch of crap

Creating table daily

How can I create a table daily, whose name was the current date in the yy/mm/dd format plus the algarism to identify the weekday (for example Wednesday = 4), for instance if the query was run on 01/15/2003 (wednesday), the tabelname would be 3_01_15_4 ?Originally posted by cassianorsilva
How can I create a table daily, whose name was the current date in the yy/mm/dd format plus the algarism to identify the weekday (for example Wednesday = 4), for instance if the query was run on 01/15/2003 (wednesday), the tabelname would be 3_01_15_4 ?

declare @.date char(9)
set @.date = substring(convert(char(4),getdate(),121),4,1)+'_'+ substring(convert(char(7),getdate(),121),6,2)+'_'+ substring(convert(char(10),getdate(),121),9,2)
+'_'+cast(DATEPART(dw, GETDATE()) as char(1))|||Thank you !

The table creation is not included on the proceedure above, right ?|||Originally posted by cassianorsilva
Thank you !

The table creation is not included on the proceedure above, right ?

No it's not, once u have the string in the @.date variable, just concatenate that with ur tablename and use that string in ur table creation

says ur final tablename is in a variable @.tablename.

exec('Create table '+@.tablename)

Sumthin around those lines

Creating stored procs that need to continusiouly append to a new table (this is to scrub d

I have 1 table with a huge amount of data that I recive from someone else in a flat file format. I want to be able to filter through that data and scrub it and find out the good data and bad data from it.

I'm scrubbing the data using different stored procs that i've created and through a web interface that the user can pick which records they wish to create.

If I were to create a new table for clean records, what is the syntax to keep Appending to that table through the data that i'm obtainig via the stored procs that i've created.

Any thoughts or suggestions are greatly appriciated in advance

Thanks again in advance
RBCheck outINSERT (INTO)

Or you might consider adding a STATUS column and flagging all records initially as BAD and then flagging with GOOD as appropriate as you progress through your scrubbing routines.

Terri

Creating SQL View - syntax is wrong

We are creating a view in SQL to format data to DTS to another database. Here is the section of the view which does not work -- eliminating this section from the query allows the view to be created:

CASE APTran.LineNbr
WHEN < '0' THEN 'O'
--Offsetting Document (or transaction line as we have (AP Liab. AP Cash Entry).
WHEN > '0' THEN 'D'
--Regular Document (or transaction line as we have (This is either a Debit or a Credit line not AP Liab. AP Cash Entry).
ELSE 'E'
END AS JED_DIST_OR_OFF,

I am attaching the whole query stmt here.

Thanks very much for all assistance.Is LineNbr numeric?

--EDIT:

Can you tell us the error?

Might help|||The error received in Query analyzer is:
Server: Msg 170, Level 15, State 1, Procedure xvr_03901EXPORTER, Line 107
Line 107: Incorrect syntax near '<'.
Server: Msg 170, Level 15, State 1, Procedure xvr_03901EXPORTER, Line 133
Line 133: Incorrect syntax near 'APTran'.
Server: Msg 170, Level 15, State 1, Procedure xvr_03901EXPORTER, Line 186
Line 186: Incorrect syntax near 'APDoc'.

The field aptran.linenbr is datatype smallint.

Thanks, Dave Spangler|||CASE
WHEN cast(APTran.LineNbr as int) < 0 THEN 'O'
--Offsetting Document (or transaction line as we have (AP Liab. AP Cash Entry).
WHEN cast(APTran.LineNbr as int) > 0 THEN 'D'
--Regular Document (or transaction line as we have (This is either a Debit or a Credit line not AP Liab. AP Cash Entry).
ELSE 'E'
END AS JED_DIST_OR_OFF,|||Hey, based on the code you submitted before I clicked on Post, I thought (here's that magic word again ;)) that it was a varchar field!

CASE
WHEN APTran.LineNbr < 0 THEN 'O'
--Offsetting Document (or transaction line as we have (AP Liab. AP Cash Entry).
WHEN APTran.LineNbr > 0 THEN 'D'
--Regular Document (or transaction line as we have (This is either a Debit or a Credit line not AP Liab. AP Cash Entry).
ELSE 'E'
END AS JED_DIST_OR_OFF,

And you probably need to test for NULL unless this is taken care of by the 'IsNullable' property of the field.|||Originally posted by rdjabarov
Hey, based on the code you submitted before I clicked on Post, I thought (here's that magic word again ;)) that it was a varchar field!

CASE
WHEN APTran.LineNbr < 0 THEN 'O'
--Offsetting Document (or transaction line as we have (AP Liab. AP Cash Entry).
WHEN APTran.LineNbr > 0 THEN 'D'
--Regular Document (or transaction line as we have (This is either a Debit or a Credit line not AP Liab. AP Cash Entry).
ELSE 'E'
END AS JED_DIST_OR_OFF,

And you probably need to test for NULL unless this is taken care of by the 'IsNullable' property of the field.

Hey, get your own ideas...:D

And why would they have to check for Nulls Null would give them an "E"|||Yup, forgot about ELSE

Creating SQL database "Users" pulled from Active directory OU

Is there a tool, or does anyone have a script format that might automaticall
y
pull in AD accounts from an OU and put them in the Users group of a specific
database.
If there is an article or existing document on this I have not been able to
find it.
I would appreciate any help anyone can give whereas if I can't find this, I
will have to type in about 2000 users into my database from a hard copy.
There has to be a way. Even if someone can tell me what table and field the
users are listed in, I can probably script it from that.
Thanks in advance
gordonJust so I understand, when you create a database, you want SQL to
automatically pull in users AD and grant them access to the database?
"gordon" wrote:

> Is there a tool, or does anyone have a script format that might automatica
lly
> pull in AD accounts from an OU and put them in the Users group of a specif
ic
> database.
> If there is an article or existing document on this I have not been able t
o
> find it.
> I would appreciate any help anyone can give whereas if I can't find this,
I
> will have to type in about 2000 users into my database from a hard copy.
> There has to be a way. Even if someone can tell me what table and field t
he
> users are listed in, I can probably script it from that.
> Thanks in advance
> gordon|||Yes. Actually the database is already created. Right now, I have to
manually add every user in an AD OU to the "Users" group in SQL 2000. Then
I
have to assign them either Public or another role, manually. As you might
imagine, this is very time consuming. I have seen ADSI scripts pull
information from OU's in AD to tables in SQL, but not to the USERS group (yo
u
know, where you have diagrams, views, tables, users, roles etc. ) I want to
add the AD user to the USers in SQL.
Thanks for the response!!!!
"John Barr" wrote:
> Just so I understand, when you create a database, you want SQL to
> automatically pull in users AD and grant them access to the database?
> "gordon" wrote:
>|||I understand, and yes, it is possible, but it will taking some coding.You
will have to create a VBScript to read AD based on an OU name that you pass
and access SQL Server to execute a stored procedure to do dynamic SQL to add
the user if it is not existing, and grant it the rights you will need. It
will be time consuming to create, but it will eliminate the manual addtions.
You can get the VBScript to access AD in the Script Center on Microsofts
Site, and write those users into a table using ADO, then execute a Stored
Procedure. Seems a little hectic, but it would work.
"gordon" wrote:
> Yes. Actually the database is already created. Right now, I have to
> manually add every user in an AD OU to the "Users" group in SQL 2000. The
n I
> have to assign them either Public or another role, manually. As you might
> imagine, this is very time consuming. I have seen ADSI scripts pull
> information from OU's in AD to tables in SQL, but not to the USERS group (
you
> know, where you have diagrams, views, tables, users, roles etc. ) I want t
o
> add the AD user to the USers in SQL.
> Thanks for the response!!!!
>
> "John Barr" wrote:
>|||I appreciate it. I knew it would be that much work, was wondering ifanyone
had done it and I could use their code and modify it for my OU's. Or if
there were any Microsoft Technical articles showing how.
Thanks for the responses.
"John Barr" wrote:
> I understand, and yes, it is possible, but it will taking some coding.You
> will have to create a VBScript to read AD based on an OU name that you pas
s
> and access SQL Server to execute a stored procedure to do dynamic SQL to a
dd
> the user if it is not existing, and grant it the rights you will need. It
> will be time consuming to create, but it will eliminate the manual addtion
s.
> You can get the VBScript to access AD in the Script Center on Microsofts
> Site, and write those users into a table using ADO, then execute a Stored
> Procedure. Seems a little hectic, but it would work.
> "gordon" wrote:
>|||Hi
What are you not using roles and permissioning via AD group membership? It
is the recommenced way to manage users in SQL Server.
Add the users in AD to a group, then add the group the SQL Server. Then when
a new user arrives, you just add the person to the AD group and then the
user has the permission in the DB. When the user leaves, there is no
maintenance to be done at SQL Server level, only at AD level.
Books online has a lot of information DB roles and AD group membership.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"gordon" <gordon@.discussions.microsoft.com> wrote in message
news:03540F8D-A377-4207-8093-4DA0F6225D81@.microsoft.com...
> Yes. Actually the database is already created. Right now, I have to
> manually add every user in an AD OU to the "Users" group in SQL 2000.
> Then I
> have to assign them either Public or another role, manually. As you might
> imagine, this is very time consuming. I have seen ADSI scripts pull
> information from OU's in AD to tables in SQL, but not to the USERS group
> (you
> know, where you have diagrams, views, tables, users, roles etc. ) I want
> to
> add the AD user to the USers in SQL.
> Thanks for the response!!!!
>
> "John Barr" wrote:
>

Creating SQL 2005 Logins during installation

Hello,

We use one standard account with a password that is never given out.

In SQL 2000 we had a script to extract the password in encrypted format so that it could be run as part of the installation process.

That same process does not work for SQL 2005.

Below is a sample of the script that we were deploying for SQL 2000 installations.
-
-- Login: CPAPP

declare @.pwd varchar(50);

SET @.pwd = CONVERT (varbinary(256), 0x01003402EC1BDADF45C9D788C23459BC36D73E5B2B9F2F235138F6BB8D0CD2317FCBA41EB59D191801AC287A14FF) EXEC master..sp_addlogin 'CPAPP', @.pwd, @.defdb = 'CPSQL' , @.sid = 0xE5994FEF661AF842A0CA38AAFEB4360F, @.encryptopt = 'skip_encryption'

SET @.pwd = CONVERT (varbinary(256), 0x01003402EC1B9DA21489EC2D47CA9B8549255E9C9ACD4260661DFE04E9A0AFA631A27676C7A79E2DE20A52265666) EXEC master..sp_addlogin 'CPREPORT', @.pwd,@.defdb = 'CPSQL' , @.sid = 0xD7E65E9AE7E87F4F9C72929A0B37F35C, @.encryptopt = 'skip_encryption'

SET @.pwd = CONVERT (varbinary(256), 0x0100A44D0526FABFF90D4CA524FA6415DD998256EB62963309D5F561AC5B116318E4F93D2159D9BAC95F356EBDC2) EXEC master..sp_addlogin 'cpdata', @.pwd, @.defdb = 'CPSQL' , @.sid = 0xBE1AC61A2A8D8543ACAF2D403AAD96A4, @.encryptopt = 'skip_encryption'

-
The procedure that we are using to script the logins is from the Microsoft support page:
http://support.microsoft.com/default.aspx?scid=kb;en-us;246133

Is this what we should be using for SQL 2005?

Please advise.

Thanks in advance

IN SQL 2005 you should be using

CREATE LOGIN loginname PASSWORD ='hased password' HASHED , SID ='.....'

Have a look at

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/eb737149-7c92-4552-946b-91085d8b1b01.htm

|||

Simon,

Thanks for your prompt reply.

We were able to run the script and create a login with a encrypted password successfully using "HASHED"

I tried connecting to the server using SQL Management studio by entering the newly created username and the encrypted password (long mix of chars and numerical) in the Connect to Server dialog box in the SQL Server authentication mode.

But we got the error (Microsoft SQL Server, Error :18456)

A couple of quick questions:

1) Is there a way to extract the encrypted password and check our script is working fine by connecting to server --programatically

2)How can we test connection to server using the newly created login name and encrypted password

Are we missing something ?

Could you please throw light on this?

Thanks in advance

|||Probably easiest to ceate your users again usnig the real password and then script them. From there, not sure if the Hash alogorithm has changed.|||

1) You cannot connect knowing only the hash, you need to know the password from which the hash was computed (or some other password that would collide with the original for the same hash value, but chances of finding such a password are slim).

2) To test the connection, you need to know the actual password and use it in the connection test.

The hashing algorithm has not changed, it's still SHA1. What has changed is that in SQL Server 2000, we actually kept two hashes - one for the actual password, the other for the password converted to uppercase. In SQL Server 2005, we dropped the second hash because it was making the hash vulnerable to a dictionary attack (the attack was described in http://www.nextgenss.com/papers/cracking-sql-passwords.pdf). How could this change impact you? It would impact you if you had set the password using a special casing, for example, "PasSworD", but you used to connect with "Password" and forgot the original casing over time. After moving the hash to SQL Server 2005, you must use the original password casing. Other than this, I can't think of any other changes.

Thanks
Laurentiu

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.