Cannot read the next data row for the data set

Hi,

My report runs fine when I view in VS, data shows fine when I run the query in the data window, but when I publish it to the server, I get the above error. I am running SQL server 2005 RTM and I have re-deployed the entire solution.

Any ideas?

Found the problem.

This is a problem that is down to a bug in reporting services, and I sincerely hope that "they" fix it in the first sp!

Occasionally, reporting services will change your parameter types to string. This is sooooo annoying, and normally fails when you view, but in this case, it took my parameters (date/time) that were already in the parameter boxes (I am altering an existing report) and ran the report happily. I just happened to see that there were no calendar boxes next to the parameters on my web server.

^%$￡"$%^&*&%￡$%^&(*&^%$ is all I can say - this has wasted 2 hours of my time.

Please please Microsoft, fix this bug! A hot fix would be good.....beg beg

|||

Hi,

I experienced similar problems with some of my RS reports and find a solution for my case

I tried to explain the problem and solution at the article http://www.kodyaz.com/articles/article.aspx?articleid=53

For my situation, it seemed that the NULL values within aggregate functions were causing the problem.

Actually although the sql code runs successsfully the warning message "Warning: Null value is eliminated by an aggregate or other SET operation." returned from the sql server was causing the Reporting Services to fire the below error:

An error occured during report processing.
Cannot read the next data row for the data set Dataset1.
A sever error occured on the current command. The results, if any, should be discarded.

A simple way to get rid of the problem is running the t-sql codes between "SET ANSI_WARNINGS OFF" and "SET ANSI_WARNINGS ON" commands.

Eralper

http://www.kodyaz.com

|||Rather than beg microsoft to fix their own mistakes wouldn't you rather use a system that if it had a mistake you could: contact the programmers or fix the mistake yourself?

Using open source ruby (in any OS) you can contact the community or alter the code yourself. Ruby can do anything this reporting services can do.

I've found quite a few bugs in Reporting Services, but rather than beg MS to listen to me I've stopped using MS. I post the bugs to a hacker site, this is much more likely to get MS's attention.

Cannot read the next data row for the data set

Hi,

My report runs fine when I view in VS, data shows fine when I run the query in the data window, but when I publish it to the server, I get the above error. I am running SQL server 2005 RTM and I have re-deployed the entire solution.

Any ideas?

Found the problem.

This is a problem that is down to a bug in reporting services, and I sincerely hope that "they" fix it in the first sp!

Occasionally, reporting services will change your parameter types to string. This is sooooo annoying, and normally fails when you view, but in this case, it took my parameters (date/time) that were already in the parameter boxes (I am altering an existing report) and ran the report happily. I just happened to see that there were no calendar boxes next to the parameters on my web server.

^%$￡"$%^&*&%￡$%^&(*&^%$ is all I can say - this has wasted 2 hours of my time.

Please please Microsoft, fix this bug! A hot fix would be good.....beg beg

|||

Hi,

I experienced similar problems with some of my RS reports and find a solution for my case

I tried to explain the problem and solution at the article http://www.kodyaz.com/articles/article.aspx?articleid=53

For my situation, it seemed that the NULL values within aggregate functions were causing the problem.

Actually although the sql code runs successsfully the warning message "Warning: Null value is eliminated by an aggregate or other SET operation." returned from the sql server was causing the Reporting Services to fire the below error:

An error occured during report processing.
Cannot read the next data row for the data set Dataset1.
A sever error occured on the current command. The results, if any, should be discarded.

A simple way to get rid of the problem is running the t-sql codes between "SET ANSI_WARNINGS OFF" and "SET ANSI_WARNINGS ON" commands.

Eralper

http://www.kodyaz.com

|||Rather than beg microsoft to fix their own mistakes wouldn't you rather use a system that if it had a mistake you could: contact the programmers or fix the mistake yourself?

Using open source ruby (in any OS) you can contact the community or alter the code yourself. Ruby can do anything this reporting services can do.

I've found quite a few bugs in Reporting Services, but rather than beg MS to listen to me I've stopped using MS. I post the bugs to a hacker site, this is much more likely to get MS's attention.

Cannot read the next data row for the data set

Hi,

My report runs fine when I view in VS, data shows fine when I run the query in the data window, but when I publish it to the server, I get the above error. I am running SQL server 2005 RTM and I have re-deployed the entire solution.

Any ideas?

Found the problem.

This is a problem that is down to a bug in reporting services, and I sincerely hope that "they" fix it in the first sp!

Occasionally, reporting services will change your parameter types to string. This is sooooo annoying, and normally fails when you view, but in this case, it took my parameters (date/time) that were already in the parameter boxes (I am altering an existing report) and ran the report happily. I just happened to see that there were no calendar boxes next to the parameters on my web server.

^%$￡"$%^&*&%￡$%^&(*&^%$ is all I can say - this has wasted 2 hours of my time.

Please please Microsoft, fix this bug! A hot fix would be good.....beg beg

|||

Hi,

I experienced similar problems with some of my RS reports and find a solution for my case

I tried to explain the problem and solution at the article http://www.kodyaz.com/articles/article.aspx?articleid=53

For my situation, it seemed that the NULL values within aggregate functions were causing the problem.

Actually although the sql code runs successsfully the warning message "Warning: Null value is eliminated by an aggregate or other SET operation." returned from the sql server was causing the Reporting Services to fire the below error:

An error occured during report processing.
Cannot read the next data row for the data set Dataset1.
A sever error occured on the current command. The results, if any, should be discarded.

A simple way to get rid of the problem is running the t-sql codes between "SET ANSI_WARNINGS OFF" and "SET ANSI_WARNINGS ON" commands.

Eralper

http://www.kodyaz.com

|||Rather than beg microsoft to fix their own mistakes wouldn't you rather use a system that if it had a mistake you could: contact the programmers or fix the mistake yourself?

Using open source ruby (in any OS) you can contact the community or alter the code yourself. Ruby can do anything this reporting services can do.

I've found quite a few bugs in Reporting Services, but rather than beg MS to listen to me I've stopped using MS. I post the bugs to a hacker site, this is much more likely to get MS's attention.sql

Cannot read the next data row for the data set

Hello all -
Our users are getting the above error when trying to execute a report.
Permission has been granted to the security group that they belong to, for
the report folder and report (browser permissions), as well as the Analytical
Services database and the associated data warehouse database (db_datareader).
The report uses two parameters, which have default values set (year and
month).
Any ideas as to what may be the problem?
Thanks!
Pam RichardsonIn case anyone else runs into this problem, here's the answer. In the
analysis services database, the Reader role/Cell Data had the "Enable read
permissions" checkbox checked, but nothing was in the "Allow reading of cube
content" textbox. Unchecking this checkbox solved the problem.
Thanks,
Pam Richardson
"Pam Richardson" wrote:
> Hello all -
> Our users are getting the above error when trying to execute a report.
> Permission has been granted to the security group that they belong to, for
> the report folder and report (browser permissions), as well as the Analytical
> Services database and the associated data warehouse database (db_datareader).
> The report uses two parameters, which have default values set (year and
> month).
> Any ideas as to what may be the problem?
> Thanks!
> Pam Richardson

Cannot print landscape

In Report Manager in SSRS 2005, no matter what printer I go to, there is no landscape option. It's not the driver, unless the driver for the printer isn't like SSRS because I can print landscape on any of these pritnters in any other application. Why is that? I do not see an option to switch to landscape period after looking at my printer properties afer clicking the print button from SSRS

From what I understand it is not the printer you have to choose to be landscape but the report before you print it.

Set the report width and height to be the opposite to what they are now. E.g. US letter set width to 11 and height to 8.5

Craig

Cannot print a report

Is there any way to allow the end user to print the report output without
having to export the results to a .pdf file?
--
LisaSp2 will ship with the ability to do client side printing.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Lisa" <Lisa@.discussions.microsoft.com> wrote in message
news:DC502BB2-5392-4DB6-98FE-2F2F5BB121CB@.microsoft.com...
> Is there any way to allow the end user to print the report output without
> having to export the results to a .pdf file?
> --
> Lisa|||Excellent, does SP2 have a ship date?
"Daniel Reib [MSFT]" wrote:
> Sp2 will ship with the ability to do client side printing.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Lisa" <Lisa@.discussions.microsoft.com> wrote in message
> news:DC502BB2-5392-4DB6-98FE-2F2F5BB121CB@.microsoft.com...
> > Is there any way to allow the end user to print the report output without
> > having to export the results to a .pdf file?
> > --
> > Lisa
>
>|||I thought i've heard at the end of this month, the beginning of next month,
not quite sure.
anyway, i must agree, it's worth waiting for
"Lisa" wrote:
> Excellent, does SP2 have a ship date?
> "Daniel Reib [MSFT]" wrote:
> > Sp2 will ship with the ability to do client side printing.
> >
> > --
> > -Daniel
> > This posting is provided "AS IS" with no warranties, and confers no rights.
> >
> >
> > "Lisa" <Lisa@.discussions.microsoft.com> wrote in message
> > news:DC502BB2-5392-4DB6-98FE-2F2F5BB121CB@.microsoft.com...
> > > Is there any way to allow the end user to print the report output without
> > > having to export the results to a .pdf file?
> > > --
> > > Lisa
> >
> >
> >|||The official (group program manager at Microsoft) was the middle of April.
Of course, as we rapidly head to the end of the month, that doesn't mean
they will hit that date. Hopefully it does mean that it will happen this
month.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Koen" <Koen@.discussions.microsoft.com> wrote in message
news:A79D6814-513E-42F3-911B-3FD71B1BA391@.microsoft.com...
>I thought i've heard at the end of this month, the beginning of next month,
> not quite sure.
> anyway, i must agree, it's worth waiting for
> "Lisa" wrote:
>> Excellent, does SP2 have a ship date?
>> "Daniel Reib [MSFT]" wrote:
>> > Sp2 will ship with the ability to do client side printing.
>> >
>> > --
>> > -Daniel
>> > This posting is provided "AS IS" with no warranties, and confers no
>> > rights.
>> >
>> >
>> > "Lisa" <Lisa@.discussions.microsoft.com> wrote in message
>> > news:DC502BB2-5392-4DB6-98FE-2F2F5BB121CB@.microsoft.com...
>> > > Is there any way to allow the end user to print the report output
>> > > without
>> > > having to export the results to a .pdf file?
>> > > --
>> > > Lisa
>> >
>> >
>> >sql

Cannot preview/deploy error

When I try to preview a report developed an on XP Pro box with Reporting
Services evaluation installed (Visual Studio 2003), I get a blank screen with
no preview. My SQL statement appears to be fine, because I get no errors
when I execute it on the Data tab, and see the data that should be reported
on.
When I try to deploy the report from within Visual Studio, I get an error
message telling me that "The type initializer for
'Microsoft.ReportingServices.Diagnostics.CatalogItemUrlBuilder' threw an
exception", and nothing gets deployed. Is there any way to get details on
this exception thrown, or a known way to prevent this?
If I upload the .rdl file into the http://localhost/Reports report manager
site manually, the report generates and displays without any kind of errors.Several people have reported this error, but we have never identified the
source. Can you try debugging the Report Designer process? (Attach another
instance of Visual Studio as a debugger, enable catching exceptions and view
the call stack.) Send me a dump of the call stack.
Thanks,
--
Albert Yen
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"B Shaffer" <B Shaffer@.discussions.microsoft.com> wrote in message
news:E6ED9D3F-10A7-49B5-AFD9-D2411E702815@.microsoft.com...
> When I try to preview a report developed an on XP Pro box with Reporting
> Services evaluation installed (Visual Studio 2003), I get a blank screen
> with
> no preview. My SQL statement appears to be fine, because I get no errors
> when I execute it on the Data tab, and see the data that should be
> reported
> on.
> When I try to deploy the report from within Visual Studio, I get an error
> message telling me that "The type initializer for
> 'Microsoft.ReportingServices.Diagnostics.CatalogItemUrlBuilder' threw an
> exception", and nothing gets deployed. Is there any way to get details on
> this exception thrown, or a known way to prevent this?
> If I upload the .rdl file into the http://localhost/Reports report manager
> site manually, the report generates and displays without any kind of
> errors.|||This problem was bizarre - after restarting my PC the following day, the
problems with deploying the reports and previewing reports went away. I've
been able to deploy and preview without any difficulty since.
"Albert Yen [MSFT]" wrote:
> Several people have reported this error, but we have never identified the
> source. Can you try debugging the Report Designer process? (Attach another
> instance of Visual Studio as a debugger, enable catching exceptions and view
> the call stack.) Send me a dump of the call stack.
> Thanks,
> --
> Albert Yen
> SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "B Shaffer" <B Shaffer@.discussions.microsoft.com> wrote in message
> news:E6ED9D3F-10A7-49B5-AFD9-D2411E702815@.microsoft.com...
> > When I try to preview a report developed an on XP Pro box with Reporting
> > Services evaluation installed (Visual Studio 2003), I get a blank screen
> > with
> > no preview. My SQL statement appears to be fine, because I get no errors
> > when I execute it on the Data tab, and see the data that should be
> > reported
> > on.
> >
> > When I try to deploy the report from within Visual Studio, I get an error
> > message telling me that "The type initializer for
> > 'Microsoft.ReportingServices.Diagnostics.CatalogItemUrlBuilder' threw an
> > exception", and nothing gets deployed. Is there any way to get details on
> > this exception thrown, or a known way to prevent this?
> >
> > If I upload the .rdl file into the http://localhost/Reports report manager
> > site manually, the report generates and displays without any kind of
> > errors.
>
>

Cannot preview or print: Invalid Page Number error

(This is a repost, under my correct subscriber ID.)
I have a report that I think is not too complex (a matrix inside a list).
With small datasets, all is well. But with large datasets (the threshold
seems to be around 5500 rows, which should turn out to be about 25 printed
pages), the report displays to the browser just fine, but if I attempt to
print it or preview it:
(1) I get just the 1st page, then a dialog box:
(Caption:) Invalid Page Number
(Text) The requested page does not exist.
(2) In addition, in the RS LogFiles folder, the corresponding log file has
this line in it:
aspnet_wp!chunks!72c!07/20/2006-22:22:04:: i INFO: ###
GetReportChunk('RenderingInfo_IMAGE', 2), chunk was not found!
this=93db4874-b6d5-4cf2-b885-affcf17ced96
I am guessing that the "2" here refers to page 2 of the report, which it is
bombing on.
(3) In addition, the aspnet_wp.exe process goes wild, consuming 80-95% of
the processor speed, and keeps churning until I am forced to shut it down.
========== I am seeing the same behavior (a) on my development machine, (b) on a test
server in my office, (c) at a client site. So I don't think it's an anomoly
of my environment.
I am running with SQL Server 2000, Reporting Services 2000 SP2. I also
found a hotfix on the MSFT site, which I installed, to no effect.
Any ideas, anyone'
Thanks in advance,
C17Hello,
Thank you for your post in MSDN newsgroup!
I understand that you encountered issue when prview/print a specific report
on different machines. If I'm off-base, please let me know.
Based on my research, I was not able to find any known issue on this error.
To troubleshoot the issue we may need to analyze memory dumps or use live
debug, this work has to be done by contacting Microsoft Product Support
Services. Therefore, we probably will not be able to resolve the issue
through the newsgroups. If the issue is urgent, I recommend that you open a
Support incident with Microsoft Product Support Services so that a
dedicated Support Professional can assist with this case. If you need any
help in this regard, please let me know.
For a complete list of Microsoft Product Support Services phone numbers,
please go to the following address on the World Wide Web:
http://support.microsoft.com/directory/overview.asp
If you'd still like to continue working via the newsgroup, please
understand the issue might take a long time to narrow down. During the
course of troubleshooting, we may redirect you to PSS if required. For now,
please try the following and let me know how it goes:
1. Get the sample RS project, and backend database with necessary tables
behind, and send them to me at petery@.microsoft.com. Please also let's know
the detailed reproduce steps
2. Does the issue occurs in report designer? Does the issue occur if you
configure default printer to "Microsoft Office Document Image Writer"?
3. Does the issue only occur with report with large number rows? If you
limit the rows/pages, can you reproduce the issue?
If you have other related information, please also let's know.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Community Support
==================================================Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications
<http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx>.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
<http://msdn.microsoft.com/subscriptions/support/default.aspx>.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||I think it might be a timeout issue. I get the "Invalid Page Number" from
Print Preview after EXACTLY 5 minutes.
The question is, WHAT is timing out? I have the following set:
1) Query timeout (set as property of the query on the report) = 1800 seconds
= 30 minutes. (In fact the underlying report query takes only about 20
seconds to run.)
2) Report execution timeout (set for report using Report Manager) = 1800
seconds
3) Site settings default (set for entire site using Report Manager) = 1800
seconds
4) IIS Web Site/Default Web Site properties: 900 seconds = 15 minutes
What else is there that could be causing a time out at exactly 5 minutes'
Thanks,
C17|||Hello,
Thank you for your reply. I think this may not be related to timeout but
rather than memory related issue.
Based on my further research, the GetReportChunk exception shall not be
generated by printer renderer. It might be generated by HTML renderer which
uses url?s for the chart. Printer renderer will create only one stream for
the entire report and this stream will be in memory since we need to seek
on it. If in your report, every page has a chart or graph, We need to
preprocess these graph/chart before we will embed them in the file. This
process is taking time/memory.
If this is the issue, the workaround is to use less pages/records in one
report or use smaller graph. Also, you may contact PSS to get the following
fix to see if it resolves the issue:
905121 FIX: An error message is logged when you try to export a large
report to PDF, and you cannot open a spreadsheet file in Office Excel that
was exported from SQL Server 2000 Reporting Services
http://support.microsoft.com/default.aspx?scid=kb;EN-US;905121
If you have any update, please feel free to let's know.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================|||Peter,
Thank you for the information, but I do not think that HotFix will solve the
problem, because the HotFix addresses problems with charts and images in
export to PDF. However, in my case:
* The problematic report does not contain ANY charts or images
* Export to PDF, and Export to Excel, works just fine. It's just Printing
and Print Preview that fails.
I will try the HotFix if you still think I should, but let me give you some
more information based on my testing:
1) I get the "Invalid Page Number" message box after 5 minutes with: Print
or Print Preview to *any* printer (including "Microsoft Office Document
Image Writer")
2) The problem occurs when running the report under *any* environment: (a)
when running my application, (b) within the report designer, (c) when
running the report from Report Manager.
3) The problem occurs at a threshold of about 800 rows in the underlying
query. If I change the report parameters so the query returns fewer rows,
the report successfully prints/previews in about 45 seconds. Above that
threshold, the report gives the "Invalid Page Number" message box after
exactly 5 minutes.
4) The problem does NOT occur upon Export to Excel, or Export to PDF.
(Export to PDF takes a long time to run, but I understand from reading the
newgroup that this is normal.)
I will bundle up a sample database, and the report, and email them to you as
you suggested in an earlier post. I don't think you will need my
application, because the problem occurs even when you run the report from
Report Manager.
Thanks,
--C17|||Hello Charles,
Thank you for your patience. I tested on RS 2005 SP1 machine and the issue
does not occur. I think you may consider the possibility of upgrading to
SQL 2005 as a workaround. Also, I?d check if I could find other workaround
on RS 2000. Please rest assured I?v reported this issue to the proper
channel. Thanks.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================Hello Charles,
I was able to reproduce the issue on my side. I tried to upgrade to build
1049 (hotfix 912715) but the issue still persists. It seems to be a product
issue for RS 2000. I will perform some more research and test it on RS
2005. Thank you for your patience.
Best Regards,
Best Regards,

Cannot perform needed expression

Is there a work around for trying this in my footer table field in my
SSRS 2005 report?
=SUM((Max(Fields!FeeGoal_AZ.Value) / (Fields!FeeSchedule.Value) * 100)
doesn't allow aggregate functions inside SUM...but I need to do this!Try creating a calculated field called MaxGoal using
=Max(Fields!FeeGoal_AZ.Value) as the expression, then doing
=SUM((Fields!MaxGoal.Value / Fields!FeeSchedule.Value) * 100)

Cannot pass params (data type system.guid) to subreport?

Hello experts,

I am trying to create a report including a subreport in VS.2003 Reporting services. The subreport itself runs properly, if I give it a parameter, but when I try to run the main (parent) report, I get the obvious message Subreport could not be shown.

The output windows returns a message:

The value expression used in textbox ‘AccountID’ returned a data type that is not valid.

The AccountID field is a system.guid. I tried to "cast" it as a text, but I got another error message that the system.guid cannot be explicitly converted.

Does anyone know how to get around this?

Thank you very much.

Ravie.

The .NET GUID structure has ToString() method to get the guid converted to string. On the other side, you can use the GUID(string) constructor to convert it back to guid.sql

Cannot overwrite deployed report with newer version

I have resized the elements of my report so that they will render correctly
in a browser window. I have deleted the report from within Report Manager,
but when I deploy my report from Report Designer (or update it from within
Report Manager), it still looks as it did before. How can I manually delete
all remnants of the old report so that I can upload the revised edition?
--
Bob Yankle sends .... Keep smiling!What is happening is your browser is caching it. Close the broswer and
reopen it.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Bob Yankle" <BobYankle@.discussions.microsoft.com> wrote in message
news:C3C32E98-E6EB-44A9-BF80-0C68B3E591F3@.microsoft.com...
> I have resized the elements of my report so that they will render
> correctly
> in a browser window. I have deleted the report from within Report
> Manager,
> but when I deploy my report from Report Designer (or update it from within
> Report Manager), it still looks as it did before. How can I manually
> delete
> all remnants of the old report so that I can upload the revised edition?
> --
> Bob Yankle sends .... Keep smiling!|||In development I always set my browser to not cache... It is in the
Tools->Internet Options->General->Settings section of IIS...
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Bob Yankle" <BobYankle@.discussions.microsoft.com> wrote in message
news:C3C32E98-E6EB-44A9-BF80-0C68B3E591F3@.microsoft.com...
> I have resized the elements of my report so that they will render
> correctly
> in a browser window. I have deleted the report from within Report
> Manager,
> but when I deploy my report from Report Designer (or update it from within
> Report Manager), it still looks as it did before. How can I manually
> delete
> all remnants of the old report so that I can upload the revised edition?
> --
> Bob Yankle sends .... Keep smiling!|||Hi,
To delete the reports that you have deployed to a report server, you should
go to the folder containing the report on the http://reportserver/Reports url.
Call the list by "Show Details" button to see all details.
When you click the checkbox near by a report "Delete" button will be active
on the above button bar.
You can remove unwanted reports by selecting and deleting at this containing
folder details page.
Eralper
http://www.kodyaz.com
"Bob Yankle" wrote:
> I have resized the elements of my report so that they will render correctly
> in a browser window. I have deleted the report from within Report Manager,
> but when I deploy my report from Report Designer (or update it from within
> Report Manager), it still looks as it did before. How can I manually delete
> all remnants of the old report so that I can upload the revised edition?
> --
> Bob Yankle sends .... Keep smiling!

Cannot make New role assignments

New role assignment does not work on my new installation of SQL Reporting Services Enterprise edition on a Windows 2003 server. From Report Manager I navigate to: Home->Properties and select 'New Role Assignment'. I fill in a local user and select the 'Browser' role and click 'OK'. Nothing happens - there is no post-back. I have the same problem for 'Site Settings'. It's as if the Report Manager is running in read-only mode. Do I need to change some configuration to facilitate changes?
Thanks,
--steveDo you see any script errors? They would show up in the lower left corner
of IE.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"stark" <stark@.discussions.microsoft.com> wrote in message
news:2AD202DE-EA7F-4AB2-B0D0-4B6B450C75DB@.microsoft.com...
> New role assignment does not work on my new installation of SQL Reporting
Services Enterprise edition on a Windows 2003 server. From Report Manager I
navigate to: Home->Properties and select 'New Role Assignment'. I fill in a
local user and select the 'Browser' role and click 'OK'. Nothing happens -
there is no post-back. I have the same problem for 'Site Settings'. It's as
if the Report Manager is running in read-only mode. Do I need to change some
configuration to facilitate changes?
> Thanks,
> --steve|||Dan,
I'm having the same problem on trying to create New Role on both spots as the previous poster. There is no script errors in lower left hand corner. The button "New Role" does not even post back to the browser as I always thought "submit" uses the method specified in form action? Any rate the button is not working and I'm using Windows 2003 as well with lastest Framework 1.1.
HTML Output from "EditGroup.aspx"
<input type="submit" name="ui_btnCreateNewRole" value="New Role" id="ui_btnCreateNewRole" class="msrs-button" />
"Daniel Reib [MSFT]" wrote:
> Do you see any script errors? They would show up in the lower left corner
> of IE.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "stark" <stark@.discussions.microsoft.com> wrote in message
> news:2AD202DE-EA7F-4AB2-B0D0-4B6B450C75DB@.microsoft.com...
> > New role assignment does not work on my new installation of SQL Reporting
> Services Enterprise edition on a Windows 2003 server. From Report Manager I
> navigate to: Home->Properties and select 'New Role Assignment'. I fill in a
> local user and select the 'Browser' role and click 'OK'. Nothing happens -
> there is no post-back. I have the same problem for 'Site Settings'. It's as
> if the Report Manager is running in read-only mode. Do I need to change some
> configuration to facilitate changes?
> > Thanks,
> > --steve
>
>|||I found the a partial work around to get access to exisitng parent roles.
When you create a report folder, and you click on the report folder, you will have a "security" link in left hand nav. This allowed me to assign to Browser role which I did not have access to under Parent site setting and properties. Also it will ask if youre sure you want to use specific security on that folder, you must say Yes. You can always revert back using the button provided.
"Daniel Reib [MSFT]" wrote:
> Do you see any script errors? They would show up in the lower left corner
> of IE.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "stark" <stark@.discussions.microsoft.com> wrote in message
> news:2AD202DE-EA7F-4AB2-B0D0-4B6B450C75DB@.microsoft.com...
> > New role assignment does not work on my new installation of SQL Reporting
> Services Enterprise edition on a Windows 2003 server. From Report Manager I
> navigate to: Home->Properties and select 'New Role Assignment'. I fill in a
> local user and select the 'Browser' role and click 'OK'. Nothing happens -
> there is no post-back. I have the same problem for 'Site Settings'. It's as
> if the Report Manager is running in read-only mode. Do I need to change some
> configuration to facilitate changes?
> > Thanks,
> > --steve
>
>|||We have the same problem on our reporting server as well (just after
we made the last SP installation), new rule and move report actions
are not working.
After clicking on the "OK" nothing happen, no script error or any
other error indication can be found.
Any ideas?|||Hi,
this should be it:
on the server run:
aspnet_regiis -c
from the .Net framwork dir.|||I have the same problem. This aspnet_regiis didn't solve it for me...
any other suggestions?
elad@.cydoor.com (Elad) wrote in message news:<2ba7f8ad.0408041410.38bd9598@.posting.google.com>...
> Hi,
> this should be it:
> on the server run:
> aspnet_regiis -c
> from the .Net framwork dir.|||I had the problem described above... and 'aspnet_regiis -c' worked out.
Win 2003 Server, SQL Srvr w/ sp3 and RS w/ sp1.
In case this helps anyone...
The installation had a problem (25619) with virtual directories and I had to
create them manually (setup parameter -rsdonotcreatevirtualdirectories=true)
which I found in a kb article. I followed the steps to create the vir dir's
after the install and everything functioned except for the problem described
in this thread.
Perhaps the following kb article should be updated with a step to execute
aspnet_regiis -c from the .net framework dir.
http://support.microsoft.com/?kbid=867872
"Scott Stonehouse" wrote:
> I have the same problem. This aspnet_regiis didn't solve it for me...
> any other suggestions?
> elad@.cydoor.com (Elad) wrote in message news:<2ba7f8ad.0408041410.38bd9598@.posting.google.com>...
> > Hi,
> >
> > this should be it:
> >
> > on the server run:
> > aspnet_regiis -c
> >
> > from the .Net framwork dir.
>

Cannot make a report delivery

The estatus is this of the subscription: "The delivery extension associated with this subscription is not available on this report server. Verify that the delivery extension is installed".

How do I do? Because in the rsreportserver.config they appear as extensions (Report Server FileShare and Report Server Mail). Both arent working. Do I have to install something more or configure something to appear installed?

Thanks a lot

Hi,

compare your .config file with the entries here: Perhaps you screwed up the config file ?

<Extensions>
<Delivery>
<Extension Name="Report Server FileShare" Type="Microsoft.ReportingServices.FileShareDeliveryProvider.FileShareProvider,ReportingServicesFileShareDeliveryProvider">
<MaxRetries>3</MaxRetries>
<SecondsBeforeRetry>900</SecondsBeforeRetry>
<Configuration>
<FileShareConfiguration>
<ExcludedRenderFormats>
<RenderingExtension>HTMLOWC</RenderingExtension>
<RenderingExtension>NULL</RenderingExtension>
<RenderingExtension>RGDI</RenderingExtension>
</ExcludedRenderFormats>
</FileShareConfiguration>
</Configuration>
</Extension>
<Extension Name="Report Server Email" Type="Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider,ReportingServicesEmailDeliveryProvider">
<MaxRetries>3</MaxRetries>
<SecondsBeforeRetry>900</SecondsBeforeRetry>
<Configuration>
<RSEmailDPConfiguration>
<SMTPServer></SMTPServer>
<SMTPServerPort></SMTPServerPort>
<SMTPAccountName></SMTPAccountName>
<SMTPConnectionTimeout></SMTPConnectionTimeout>
<SMTPServerPickupDirectory></SMTPServerPickupDirectory>
<SMTPUseSSL></SMTPUseSSL>
<SendUsing></SendUsing>
<SMTPAuthenticate></SMTPAuthenticate>
<From></From>
<EmbeddedRenderFormats>
<RenderingExtension>MHTML</RenderingExtension>
</EmbeddedRenderFormats>
<PrivilegedUserRenderFormats></PrivilegedUserRenderFormats>
<ExcludedRenderFormats>
<RenderingExtension>HTMLOWC</RenderingExtension>
<RenderingExtension>NULL</RenderingExtension>
<RenderingExtension>RGDI</RenderingExtension>
</ExcludedRenderFormats>
<SendEmailToUserAlias>True</SendEmailToUserAlias>
<DefaultHostName></DefaultHostName>
<PermittedHosts></PermittedHosts>
</RSEmailDPConfiguration>
</Configuration>
</Extension>
<Extension Name="NULL" Type="Microsoft.ReportingServices.NullDeliveryProvider.NullProvider,ReportingServicesNullDeliveryProvider"/>
</Delivery>
(...)

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de
-

|||

I have the same problem with HTMLOWC rendering; other formats so far no problem. Installation is RS2005 on SQL2000 upgraded in place. File 'rsreportserver.config' looks fine and has the two HTMLOWC entries as above; it has not been manually edited.

Cannot make a report delivery

The estatus is this of the subscription: "The delivery extension associated with this subscription is not available on this report server. Verify that the delivery extension is installed".

How do I do? Because in the rsreportserver.config they appear as extensions (Report Server FileShare and Report Server Mail). Both arent working. Do I have to install something more or configure something to appear installed?

Thanks a lot

Hi,

compare your .config file with the entries here: Perhaps you screwed up the config file ?

<Extensions>
<Delivery>
<Extension Name="Report Server FileShare" Type="Microsoft.ReportingServices.FileShareDeliveryProvider.FileShareProvider,ReportingServicesFileShareDeliveryProvider">
<MaxRetries>3</MaxRetries>
<SecondsBeforeRetry>900</SecondsBeforeRetry>
<Configuration>
<FileShareConfiguration>
<ExcludedRenderFormats>
<RenderingExtension>HTMLOWC</RenderingExtension>
<RenderingExtension>NULL</RenderingExtension>
<RenderingExtension>RGDI</RenderingExtension>
</ExcludedRenderFormats>
</FileShareConfiguration>
</Configuration>
</Extension>
<Extension Name="Report Server Email" Type="Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider,ReportingServicesEmailDeliveryProvider">
<MaxRetries>3</MaxRetries>
<SecondsBeforeRetry>900</SecondsBeforeRetry>
<Configuration>
<RSEmailDPConfiguration>
<SMTPServer></SMTPServer>
<SMTPServerPort></SMTPServerPort>
<SMTPAccountName></SMTPAccountName>
<SMTPConnectionTimeout></SMTPConnectionTimeout>
<SMTPServerPickupDirectory></SMTPServerPickupDirectory>
<SMTPUseSSL></SMTPUseSSL>
<SendUsing></SendUsing>
<SMTPAuthenticate></SMTPAuthenticate>
<From></From>
<EmbeddedRenderFormats>
<RenderingExtension>MHTML</RenderingExtension>
</EmbeddedRenderFormats>
<PrivilegedUserRenderFormats></PrivilegedUserRenderFormats>
<ExcludedRenderFormats>
<RenderingExtension>HTMLOWC</RenderingExtension>
<RenderingExtension>NULL</RenderingExtension>
<RenderingExtension>RGDI</RenderingExtension>
</ExcludedRenderFormats>
<SendEmailToUserAlias>True</SendEmailToUserAlias>
<DefaultHostName></DefaultHostName>
<PermittedHosts></PermittedHosts>
</RSEmailDPConfiguration>
</Configuration>
</Extension>
<Extension Name="NULL" Type="Microsoft.ReportingServices.NullDeliveryProvider.NullProvider,ReportingServicesNullDeliveryProvider"/>
</Delivery>
(...)

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de
-

|||

I have the same problem with HTMLOWC rendering; other formats so far no problem. Installation is RS2005 on SQL2000 upgraded in place. File 'rsreportserver.config' looks fine and has the two HTMLOWC entries as above; it has not been manually edited.

Cannot link from strored procedure...Error detected by DLL

Hi,

I'm using Crystal Reports Version 8.5 and SQLServer2000.
The main report is using Stored Procedure as datasource where as 2 sub reports using tables as datasource. I'm linking these subreports with some values from the main report.

When I run the main report it pops up the two error messages saying that

"Cannot link from strored procedure" followed by "Error detected by DLL".

Pls advice. Thanks in advance for your immediate attention.Is that Stored Procedure exits?
If not redesign the report|||Hi Madhi,

Yes, the stored procedure exists and works fine if i remove the sub reports. So I re-designed one of the sub-reports and its working now with out any problems.

Thanks for your reply.

Dubasi

Cannot limit results with ReportViewer

Hello,
I have been attempting to set up a report using the ReportViewer
control in VS2005. The report graphs the TOP X number of records based
on certain criteria. Naturally, I modified the report with a filter
for the TOP N results. This works, however, in the case of ties on the
last entry, all tied instances will get graphed. In my case, this may
be alot of entries causing the bar graph image to display unreadable
data since there are too many result to graph.
So, I attempted the following with no success since the server is SQL
2000 and not SQL 2005:
- Using the TOP keyword in the select query does not work with a
parameter (ie SELECT TOP @.rowcount FROM...) since I am using SQL 2000.
- I cannot use a stored procedure and use the "SET ROWCOUNT" command
with the select query.
- I cannot use the LIMIT keyword in SQL 2000.
Can anyone come up with a solution, other than upgrading to SQL 2005?
Thanks in advance,
Andrewcheck this one......
SELECT w1.CATEGORYID, w1.UNITSINSTOCK,COUNT(*) As Rank
FROM
(SELECT CATEGORYID, UNITSINSTOCK
FROM PRODUCTS
GROUP BY CATEGORYID, UNITSINSTOCK ) AS w1
INNER JOIN
(SELECT CATEGORYID, UNITSINSTOCK
FROM PRODUCTS
GROUP BY CATEGORYID, UNITSINSTOCK ) AS w2
ON w1.CATEGORYID = w2.CATEGORYID
AND w1.UNITSINSTOCK <= w2.UNITSINSTOCK
GROUP BY w1.CATEGORYID, w1.UNITSINSTOCK
HAVING COUNT(*) <=@.parameter
ORDER BY w1.CATEGORYID,w1.UNITSINSTOCK DESC
Regards
Dinesh
therealbigcoops@.gmail.com wrote:
> Hello,
> I have been attempting to set up a report using the ReportViewer
> control in VS2005. The report graphs the TOP X number of records based
> on certain criteria. Naturally, I modified the report with a filter
> for the TOP N results. This works, however, in the case of ties on the
> last entry, all tied instances will get graphed. In my case, this may
> be alot of entries causing the bar graph image to display unreadable
> data since there are too many result to graph.
> So, I attempted the following with no success since the server is SQL
> 2000 and not SQL 2005:
> - Using the TOP keyword in the select query does not work with a
> parameter (ie SELECT TOP @.rowcount FROM...) since I am using SQL 2000.
> - I cannot use a stored procedure and use the "SET ROWCOUNT" command
> with the select query.
> - I cannot use the LIMIT keyword in SQL 2000.
> Can anyone come up with a solution, other than upgrading to SQL 2005?
> Thanks in advance,
> Andrew

Cannot install Workstation components, fails on report server upgrade

I have hard time installing July CTP as it is failing on workstation component and fails on report server upgrade.

Any ideas for ther resolution.

Property(S): AdministratorsGroup = BUILTIN\Administrators
Property(S): PerformanceMontiorUsersGroup = BUILTIN\Performance Monitor Users
Property(S): PerformanceLogUsersGroup = BUILTIN\Performance Log Users
Property(S): UsersGroup = BUILTIN\Users
Property(S): SCMNetworkServiceAccount = NT AUTHORITY\NetworkService
Property(S): SCMLocalServiceAccount = NT AUTHORITY\LocalService
Property(S): IISCHECKED = 1
Property(S): SqlIISInstalled = 1
Property(S): SqlASPNETInstalled = 1
Property(S): SqlCOMPlusInstalled = 1
Property(S): RSPREREQUISITECHECKED = 1
Property(S): RSSqlPoolLimit = 100
Property(S): RSGUIDVALUE = {ec3b61d7-2813-485b-a55d-e0c931740946}
Property(S): RemoveFeatureList = Client_Components,Connectivity,SQL_Tools,SQL_WarehouseDevWorkbench,SDK,SQLXML,Tools_Legacy,TOOLS_BC_DEP,SQL_Documentation,SQL_Samples,SQL_BooksOnline,SQL_DatabaseSamples
Property(S): SqlOriginalMachineName = TAHITI
Property(S): Namechecksumcommon_32 = Developer Edition
Property(S): SqlSubDir = \MSSQL
Property(S): EditionTypechecksumcommon_32 = Developer Edition
Property(S): Namechecksumtools = Developer Edition
Property(S): EditionTypechecksumtools = Developer Edition
Property(S): ValidMOFInstanceName = 1
Property(S): ROOTDRIVE = C:\
Property(S): CostingComplete = 1
Property(S): OutOfDiskSpace = 0
Property(S): OutOfNoRbDiskSpace = 0
Property(S): PrimaryVolumeSpaceAvailable = 0
Property(S): PrimaryVolumeSpaceRequired = 0
Property(S): PrimaryVolumeSpaceRemaining = 0
Property(S): RSVirtualDirectoryServer = ReportServer
Property(S): RSVirtualDirectoryManager = Reports
Property(S): SQLStatusBeforeInstall = 3
Property(S): SOURCEDIR = Z:\Tools\Setup\
Property(S): SourcedirProduct = {D6251ACA-3FD4-49D1-8FCF-182B980B19E3}
Property(S): HxDs_Tmp_3643236F_FC70_11D3_A536_0090278A1BB8 = C:\DOCUME~1\abahl\LOCALS~1\Temp\HxEA.tmp
Property(S): HxDs_Tmp_Hash_3643236F_FC70_11D3_A536_0090278A1BB8 = B40B0DC6C3C19C68E0101E0E2A647F0C3A18F6
Property(S): InstallNgenTicks = 1750000
Property(S): ProductToBeRegistered = 1
MSI (s) (38:20) [17:31:47:165]: Note: 1: 1708
MSI (s) (38:20) [17:31:47:165]: Product: Microsoft SQL Server 2008 Tools -- Installation failed.

You shouldn't be able to upgrade your report server. We don't support upgrade in the July CTP. Can you install a new instance?|||

No I am not trying to upgrade, but trying to install a clean install on windows 2003 box and I cannot.

Any thoughts, ideas.

Atul

|||What if you don't install the workstation tools? Just install the Report Server and see if you can configure it. Can you install the relational database by itself?|||

I am able to install the report server as well as the db from the looks of it.

But since management studio does not gets installed, I cannot verify or do anything with the DB.

I need to evaluate reporting services so it is very crucial to get this up and running.

Atul

|||You don't need Management Studio to use Reporting Services. But if you really need it on this machine, I would recommend you post the question over in the Katmai setup forum.

Cannot install Workstation components, fails on report server upgrade

I have hard time installing July CTP as it is failing on workstation component and fails on report server upgrade.

Any ideas for ther resolution.

Property(S): AdministratorsGroup = BUILTIN\Administrators
Property(S): PerformanceMontiorUsersGroup = BUILTIN\Performance Monitor Users
Property(S): PerformanceLogUsersGroup = BUILTIN\Performance Log Users
Property(S): UsersGroup = BUILTIN\Users
Property(S): SCMNetworkServiceAccount = NT AUTHORITY\NetworkService
Property(S): SCMLocalServiceAccount = NT AUTHORITY\LocalService
Property(S): IISCHECKED = 1
Property(S): SqlIISInstalled = 1
Property(S): SqlASPNETInstalled = 1
Property(S): SqlCOMPlusInstalled = 1
Property(S): RSPREREQUISITECHECKED = 1
Property(S): RSSqlPoolLimit = 100
Property(S): RSGUIDVALUE = {ec3b61d7-2813-485b-a55d-e0c931740946}
Property(S): RemoveFeatureList = Client_Components,Connectivity,SQL_Tools,SQL_WarehouseDevWorkbench,SDK,SQLXML,Tools_Legacy,TOOLS_BC_DEP,SQL_Documentation,SQL_Samples,SQL_BooksOnline,SQL_DatabaseSamples
Property(S): SqlOriginalMachineName = TAHITI
Property(S): Namechecksumcommon_32 = Developer Edition
Property(S): SqlSubDir = \MSSQL
Property(S): EditionTypechecksumcommon_32 = Developer Edition
Property(S): Namechecksumtools = Developer Edition
Property(S): EditionTypechecksumtools = Developer Edition
Property(S): ValidMOFInstanceName = 1
Property(S): ROOTDRIVE = C:\
Property(S): CostingComplete = 1
Property(S): OutOfDiskSpace = 0
Property(S): OutOfNoRbDiskSpace = 0
Property(S): PrimaryVolumeSpaceAvailable = 0
Property(S): PrimaryVolumeSpaceRequired = 0
Property(S): PrimaryVolumeSpaceRemaining = 0
Property(S): RSVirtualDirectoryServer = ReportServer
Property(S): RSVirtualDirectoryManager = Reports
Property(S): SQLStatusBeforeInstall = 3
Property(S): SOURCEDIR = Z:\Tools\Setup\
Property(S): SourcedirProduct = {D6251ACA-3FD4-49D1-8FCF-182B980B19E3}
Property(S): HxDs_Tmp_3643236F_FC70_11D3_A536_0090278A1BB8 = C:\DOCUME~1\abahl\LOCALS~1\Temp\HxEA.tmp
Property(S): HxDs_Tmp_Hash_3643236F_FC70_11D3_A536_0090278A1BB8 = B40B0DC6C3C19C68E0101E0E2A647F0C3A18F6
Property(S): InstallNgenTicks = 1750000
Property(S): ProductToBeRegistered = 1
MSI (s) (38:20) [17:31:47:165]: Note: 1: 1708
MSI (s) (38:20) [17:31:47:165]: Product: Microsoft SQL Server 2008 Tools -- Installation failed.

You shouldn't be able to upgrade your report server. We don't support upgrade in the July CTP. Can you install a new instance?|||

No I am not trying to upgrade, but trying to install a clean install on windows 2003 box and I cannot.

Any thoughts, ideas.

Atul

|||What if you don't install the workstation tools? Just install the Report Server and see if you can configure it. Can you install the relational database by itself?|||

I am able to install the report server as well as the db from the looks of it.

But since management studio does not gets installed, I cannot verify or do anything with the DB.

I need to evaluate reporting services so it is very crucial to get this up and running.

Atul

|||You don't need Management Studio to use Reporting Services. But if you really need it on this machine, I would recommend you post the question over in the Katmai setup forum.

Cannot install Workstation components, fails on report server upgrade

I have hard time installing July CTP as it is failing on workstation component and fails on report server upgrade.

Any ideas for ther resolution.

Property(S): AdministratorsGroup = BUILTIN\Administrators
Property(S): PerformanceMontiorUsersGroup = BUILTIN\Performance Monitor Users
Property(S): PerformanceLogUsersGroup = BUILTIN\Performance Log Users
Property(S): UsersGroup = BUILTIN\Users
Property(S): SCMNetworkServiceAccount = NT AUTHORITY\NetworkService
Property(S): SCMLocalServiceAccount = NT AUTHORITY\LocalService
Property(S): IISCHECKED = 1
Property(S): SqlIISInstalled = 1
Property(S): SqlASPNETInstalled = 1
Property(S): SqlCOMPlusInstalled = 1
Property(S): RSPREREQUISITECHECKED = 1
Property(S): RSSqlPoolLimit = 100
Property(S): RSGUIDVALUE = {ec3b61d7-2813-485b-a55d-e0c931740946}
Property(S): RemoveFeatureList = Client_Components,Connectivity,SQL_Tools,SQL_WarehouseDevWorkbench,SDK,SQLXML,Tools_Legacy,TOOLS_BC_DEP,SQL_Documentation,SQL_Samples,SQL_BooksOnline,SQL_DatabaseSamples
Property(S): SqlOriginalMachineName = TAHITI
Property(S): Namechecksumcommon_32 = Developer Edition
Property(S): SqlSubDir = \MSSQL
Property(S): EditionTypechecksumcommon_32 = Developer Edition
Property(S): Namechecksumtools = Developer Edition
Property(S): EditionTypechecksumtools = Developer Edition
Property(S): ValidMOFInstanceName = 1
Property(S): ROOTDRIVE = C:\
Property(S): CostingComplete = 1
Property(S): OutOfDiskSpace = 0
Property(S): OutOfNoRbDiskSpace = 0
Property(S): PrimaryVolumeSpaceAvailable = 0
Property(S): PrimaryVolumeSpaceRequired = 0
Property(S): PrimaryVolumeSpaceRemaining = 0
Property(S): RSVirtualDirectoryServer = ReportServer
Property(S): RSVirtualDirectoryManager = Reports
Property(S): SQLStatusBeforeInstall = 3
Property(S): SOURCEDIR = Z:\Tools\Setup\
Property(S): SourcedirProduct = {D6251ACA-3FD4-49D1-8FCF-182B980B19E3}
Property(S): HxDs_Tmp_3643236F_FC70_11D3_A536_0090278A1BB8 = C:\DOCUME~1\abahl\LOCALS~1\Temp\HxEA.tmp
Property(S): HxDs_Tmp_Hash_3643236F_FC70_11D3_A536_0090278A1BB8 = B40B0DC6C3C19C68E0101E0E2A647F0C3A18F6
Property(S): InstallNgenTicks = 1750000
Property(S): ProductToBeRegistered = 1
MSI (s) (38:20) [17:31:47:165]: Note: 1: 1708
MSI (s) (38:20) [17:31:47:165]: Product: Microsoft SQL Server 2008 Tools -- Installation failed.

You shouldn't be able to upgrade your report server. We don't support upgrade in the July CTP. Can you install a new instance?|||

No I am not trying to upgrade, but trying to install a clean install on windows 2003 box and I cannot.

Any thoughts, ideas.

Atul

|||What if you don't install the workstation tools? Just install the Report Server and see if you can configure it. Can you install the relational database by itself?|||

I am able to install the report server as well as the db from the looks of it.

But since management studio does not gets installed, I cannot verify or do anything with the DB.

I need to evaluate reporting services so it is very crucial to get this up and running.

Atul

|||You don't need Management Studio to use Reporting Services. But if you really need it on this machine, I would recommend you post the question over in the Katmai setup forum.

Cannot install Workstation components, fails on report server upgrade

I have hard time installing July CTP as it is failing on workstation component and fails on report server upgrade.

Any ideas for ther resolution.

Property(S): AdministratorsGroup = BUILTIN\Administrators
Property(S): PerformanceMontiorUsersGroup = BUILTIN\Performance Monitor Users
Property(S): PerformanceLogUsersGroup = BUILTIN\Performance Log Users
Property(S): UsersGroup = BUILTIN\Users
Property(S): SCMNetworkServiceAccount = NT AUTHORITY\NetworkService
Property(S): SCMLocalServiceAccount = NT AUTHORITY\LocalService
Property(S): IISCHECKED = 1
Property(S): SqlIISInstalled = 1
Property(S): SqlASPNETInstalled = 1
Property(S): SqlCOMPlusInstalled = 1
Property(S): RSPREREQUISITECHECKED = 1
Property(S): RSSqlPoolLimit = 100
Property(S): RSGUIDVALUE = {ec3b61d7-2813-485b-a55d-e0c931740946}
Property(S): RemoveFeatureList = Client_Components,Connectivity,SQL_Tools,SQL_WarehouseDevWorkbench,SDK,SQLXML,Tools_Legacy,TOOLS_BC_DEP,SQL_Documentation,SQL_Samples,SQL_BooksOnline,SQL_DatabaseSamples
Property(S): SqlOriginalMachineName = TAHITI
Property(S): Namechecksumcommon_32 = Developer Edition
Property(S): SqlSubDir = \MSSQL
Property(S): EditionTypechecksumcommon_32 = Developer Edition
Property(S): Namechecksumtools = Developer Edition
Property(S): EditionTypechecksumtools = Developer Edition
Property(S): ValidMOFInstanceName = 1
Property(S): ROOTDRIVE = C:\
Property(S): CostingComplete = 1
Property(S): OutOfDiskSpace = 0
Property(S): OutOfNoRbDiskSpace = 0
Property(S): PrimaryVolumeSpaceAvailable = 0
Property(S): PrimaryVolumeSpaceRequired = 0
Property(S): PrimaryVolumeSpaceRemaining = 0
Property(S): RSVirtualDirectoryServer = ReportServer
Property(S): RSVirtualDirectoryManager = Reports
Property(S): SQLStatusBeforeInstall = 3
Property(S): SOURCEDIR = Z:\Tools\Setup\
Property(S): SourcedirProduct = {D6251ACA-3FD4-49D1-8FCF-182B980B19E3}
Property(S): HxDs_Tmp_3643236F_FC70_11D3_A536_0090278A1BB8 = C:\DOCUME~1\abahl\LOCALS~1\Temp\HxEA.tmp
Property(S): HxDs_Tmp_Hash_3643236F_FC70_11D3_A536_0090278A1BB8 = B40B0DC6C3C19C68E0101E0E2A647F0C3A18F6
Property(S): InstallNgenTicks = 1750000
Property(S): ProductToBeRegistered = 1
MSI (s) (38:20) [17:31:47:165]: Note: 1: 1708
MSI (s) (38:20) [17:31:47:165]: Product: Microsoft SQL Server 2008 Tools -- Installation failed.

You shouldn't be able to upgrade your report server. We don't support upgrade in the July CTP. Can you install a new instance?|||

No I am not trying to upgrade, but trying to install a clean install on windows 2003 box and I cannot.

Any thoughts, ideas.

Atul

|||

What if you don't install the workstation tools? Just install the Report Server and see if you can configure it. Can you install the relational database by itself?|||

I am able to install the report server as well as the db from the looks of it.

But since management studio does not gets installed, I cannot verify or do anything with the DB.

I need to evaluate reporting services so it is very crucial to get this up and running.

Atul

|||

You don't need Management Studio to use Reporting Services. But if you really need it on this machine, I would recommend you post the question over in the Katmai setup forum.