reportbuilder.application Authentication Error

This is the strangest thing. Whenever I try to access report builder from 90% of machines, I get the following error:

PLATFORM VERSION INFO
Windows : 5.1.2600.131072 (Win32NT)
Common Language Runtime : 2.0.50727.42
System.Deployment.dll : 2.0.50727.42 (RTM.050727-4200)
mscorwks.dll : 2.0.50727.42 (RTM.050727-4200)
dfdll.dll : 2.0.50727.42 (RTM.050727-4200)
dfshim.dll : 2.0.50727.42 (RTM.050727-4200)

SOURCES
Deployment url : https://reports.mysite.com/ReportServer/ReportBuilder/ReportBuilder.application

ERROR SUMMARY
Below is a summary of the errors, details of these errors are listed later in the log.
* Activation of https://reports.mysite.com/ReportServer/ReportBuilder/ReportBuilder.application resulted in exception. Following failure messages were detected:
+ Downloading https://reports.mysite.com/ReportServer/ReportBuilder/ReportBuilder.application did not succeed.
+ The remote server returned an error: (401) Unauthorized.

COMPONENT STORE TRANSACTION FAILURE SUMMARY
No transaction error was detected.

WARNINGS
There were no warnings during this operation.

OPERATION PROGRESS STATUS
* [5/10/2006 8:48:02 AM] : Activation of https://reports.mysite.com/ReportServer/ReportBuilder/ReportBuilder.application has started.

ERROR DETAILS
Following errors were detected during this operation.
* [5/10/2006 8:48:11 AM] System.Deployment.Application.DeploymentDownloadException (Unknown subtype)
- Downloading https://reports.mysite.com/ReportServer/ReportBuilder/ReportBuilder.application did not succeed.
- Source: System.Deployment
- Stack trace:
at System.Deployment.Application.SystemNetDownloader.DownloadSingleFile(DownloadQueueItem next)
at System.Deployment.Application.SystemNetDownloader.DownloadAllFiles()
at System.Deployment.Application.FileDownloader.Download(SubscriptionState subState)
at System.Deployment.Application.DownloadManager.DownloadManifestAsRawFile(Uri& sourceUri, String targetPath, IDownloadNotification notification, DownloadOptions options, ServerInformation& serverInformation)
at System.Deployment.Application.DownloadManager.DownloadDeploymentManifestDirectBypass(SubscriptionStore subStore, Uri& sourceUri, TempFile& tempFile, SubscriptionState& subState, IDownloadNotification notification, DownloadOptions options, ServerInformation& serverInformation)
at System.Deployment.Application.DownloadManager.DownloadDeploymentManifestBypass(SubscriptionStore subStore, Uri& sourceUri, TempFile& tempFile, SubscriptionState& subState, IDownloadNotification notification, DownloadOptions options)
at System.Deployment.Application.ApplicationActivator.PerformDeploymentActivation(Uri activationUri, Boolean isShortcut)
at System.Deployment.Application.ApplicationActivator.ActivateDeploymentWorker(Object state)
Inner Exception
System.Net.WebException
- The remote server returned an error: (401) Unauthorized.
- Source: System
- Stack trace:
at System.Net.HttpWebRequest.GetResponse()
at System.Deployment.Application.SystemNetDownloader.DownloadSingleFile(DownloadQueueItem next)

COMPONENT STORE TRANSACTION DETAILS
No transaction informtion is available.
-

Ok, so here's the catch. It works one 1 machine, a co-workers machine. I can login as any user and it'll work fine. But when I try it on any other machine, including my laptop, my desktop, my server, etc. I get that error. I've tried adjusting the IE Security settings, firewall settings, even tried different browsers. Here's some of the stuff installed on my machines:

Laptop
-Windows XP Pro
-ASP.NET Validation Tool
-Visual Basic Express w/ SQL Server Express
-.NET 1.1/2.0 Framework

Desktop
-Windows XP Home
-Visual Studio 2005 Professional
-.NET 1.1/2.0 Framework

Server
-Windows Server 2003 Enterprise
-SQL Server 2005
-.NET 1.1/2.0 Framework

Any help on this would be greatly appreciated. Even our lead developer has no clue, it won't work on his machine either!

I found a solution here.

reportbuilder.application Authentication Error

This is the strangest thing. Whenever I try to access report builder from 90% of machines, I get the following error:

PLATFORM VERSION INFO
Windows : 5.1.2600.131072 (Win32NT)
Common Language Runtime : 2.0.50727.42
System.Deployment.dll : 2.0.50727.42 (RTM.050727-4200)
mscorwks.dll : 2.0.50727.42 (RTM.050727-4200)
dfdll.dll : 2.0.50727.42 (RTM.050727-4200)
dfshim.dll : 2.0.50727.42 (RTM.050727-4200)

SOURCES
Deployment url : https://reports.mysite.com/ReportServer/ReportBuilder/ReportBuilder.application

ERROR SUMMARY
Below is a summary of the errors, details of these errors are listed later in the log.
* Activation of https://reports.mysite.com/ReportServer/ReportBuilder/ReportBuilder.application resulted in exception. Following failure messages were detected:
+ Downloading https://reports.mysite.com/ReportServer/ReportBuilder/ReportBuilder.application did not succeed.
+ The remote server returned an error: (401) Unauthorized.

COMPONENT STORE TRANSACTION FAILURE SUMMARY
No transaction error was detected.

WARNINGS
There were no warnings during this operation.

OPERATION PROGRESS STATUS
* [5/10/2006 8:48:02 AM] : Activation of https://reports.mysite.com/ReportServer/ReportBuilder/ReportBuilder.application has started.

ERROR DETAILS
Following errors were detected during this operation.
* [5/10/2006 8:48:11 AM] System.Deployment.Application.DeploymentDownloadException (Unknown subtype)
- Downloading https://reports.mysite.com/ReportServer/ReportBuilder/ReportBuilder.application did not succeed.
- Source: System.Deployment
- Stack trace:
at System.Deployment.Application.SystemNetDownloader.DownloadSingleFile(DownloadQueueItem next)
at System.Deployment.Application.SystemNetDownloader.DownloadAllFiles()
at System.Deployment.Application.FileDownloader.Download(SubscriptionState subState)
at System.Deployment.Application.DownloadManager.DownloadManifestAsRawFile(Uri& sourceUri, String targetPath, IDownloadNotification notification, DownloadOptions options, ServerInformation& serverInformation)
at System.Deployment.Application.DownloadManager.DownloadDeploymentManifestDirectBypass(SubscriptionStore subStore, Uri& sourceUri, TempFile& tempFile, SubscriptionState& subState, IDownloadNotification notification, DownloadOptions options, ServerInformation& serverInformation)
at System.Deployment.Application.DownloadManager.DownloadDeploymentManifestBypass(SubscriptionStore subStore, Uri& sourceUri, TempFile& tempFile, SubscriptionState& subState, IDownloadNotification notification, DownloadOptions options)
at System.Deployment.Application.ApplicationActivator.PerformDeploymentActivation(Uri activationUri, Boolean isShortcut)
at System.Deployment.Application.ApplicationActivator.ActivateDeploymentWorker(Object state)
Inner Exception
System.Net.WebException
- The remote server returned an error: (401) Unauthorized.
- Source: System
- Stack trace:
at System.Net.HttpWebRequest.GetResponse()
at System.Deployment.Application.SystemNetDownloader.DownloadSingleFile(DownloadQueueItem next)

COMPONENT STORE TRANSACTION DETAILS
No transaction informtion is available.
-

Ok, so here's the catch. It works one 1 machine, a co-workers machine. I can login as any user and it'll work fine. But when I try it on any other machine, including my laptop, my desktop, my server, etc. I get that error. I've tried adjusting the IE Security settings, firewall settings, even tried different browsers. Here's some of the stuff installed on my machines:

Laptop
-Windows XP Pro
-ASP.NET Validation Tool
-Visual Basic Express w/ SQL Server Express
-.NET 1.1/2.0 Framework

Desktop
-Windows XP Home
-Visual Studio 2005 Professional
-.NET 1.1/2.0 Framework

Server
-Windows Server 2003 Enterprise
-SQL Server 2005
-.NET 1.1/2.0 Framework

Any help on this would be greatly appreciated. Even our lead developer has no clue, it won't work on his machine either!

I found a solution here.sql

Report Viewer Parameter Dropdown width

Does anyone know how to control the width of the parameter dropdownlist? If you select "Multi-value" for the parameter (non-sp1 version) the parameter list is in a dropdownlist that is manageable in size. If you do not use the multi-value parameter, it looks like the width of the dropdownlist is determined by the width of the longest text of the returned parameters.

Is there any way to control the width of the dropdown?

Thanks

Rob

pretty sure there is no way to do this|||

I spent some time "fighting" with this problem. The only way this might be achieved is to play with the customizable style sheets for the Report Manager.

I solved my problem by making the text in the multi-value dropdown smaller.

|||

Hi

Where can I find this style sheet?
I've had this problem since I started using
SSRS 4 months ago.

Thanks

G

|||

here you can find all the info you need: http://msdn2.microsoft.com/en-us/library/ms345247.aspx.

Also, maybe you'll find this post useful: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1084925&SiteID=1

|||

Thanks alot!

I only now saw your other post...
Marked as hepfull

G

sql

Report Viewer Parameter Dropdown width

Does anyone know how to control the width of the parameter dropdownlist? If you select "Multi-value" for the parameter (non-sp1 version) the parameter list is in a dropdownlist that is manageable in size. If you do not use the multi-value parameter, it looks like the width of the dropdownlist is determined by the width of the longest text of the returned parameters.

Is there any way to control the width of the dropdown?

Thanks

Rob

pretty sure there is no way to do this|||

I spent some time "fighting" with this problem. The only way this might be achieved is to play with the customizable style sheets for the Report Manager.

I solved my problem by making the text in the multi-value dropdown smaller.

|||

Hi

Where can I find this style sheet?
I've had this problem since I started using
SSRS 4 months ago.

Thanks

G

|||

here you can find all the info you need: http://msdn2.microsoft.com/en-us/library/ms345247.aspx.

Also, maybe you'll find this post useful: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1084925&SiteID=1

|||

Thanks alot!

I only now saw your other post...
Marked as hepfull

G

Report Versioning

Is there a way to add a version number to an rdl file? If so can someone give me pointers on how to do it.

Thanks

-JW

You can add custom properties to RDL under the CustomProperties element. We met a similar requirement by adding a Version property. However, custom properties are not surfaced to the UI (neither Report Manager nor SSMS) so you have to parse the RDL to get to them. Implementing a standard Version property could be a welcome addition to a future release.

|||

You can also add hidden (internal) "Version" parameter with default value, and use it within your report.

Maciej

Report Syntax help !!

Hi,

I restored a wrong copy of a db, since then I that restored the correct
version. during the execution of the reports in report services I get an
error that read *** 'reportServerTempdb.dbo.persitedstream' ** this message
is sparatic, at time the reports are displayed other time I get that error,
the db backup was done an 2005, after I restored the latest version of the db
I reapplied RP services sp2 and I still get the error. Please if this is a
setting that I am missing or what I screwed up.

Thanks in advance.Smells like homework.
I would a link to a place with reports similar
to this one I have to do for ideas.Thanks in advance.Try www.ask.com.

If you post the code you have tried, we can help you debug it or recommend a different approach.|||Help.....
I restored a wrong copy of a db, since then I that restored the correct
version. during the execution of the reports in report services I get an
error that read *** 'reportServerTempdb.dbo.persitedstream' ** this message
is sparatic, at time the reports are displayed other time I get that error,
the db backup was done an 2005, after I restored the latest version of the db
I reapplied RP services sp2 and I still get the error. Please if this is a
setting that I am missing or what I screwed up.

Thanks in advance.|||error on --> sum(3 * .01)AS CommissionPercent

SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

-- -- RA 4/25/06 - Adding code to calculate base on three commission values. 6% - 5%- 3%, and Target = 5,300,000
-- If the invoice was received prior to 04/01/2006 calculate base on the 6% anything after that date is multiplied by 3%
-- unless they reach amt calculate by 5%
---------------------------------

--DROP PROCEDURE dbo.sp_Sales_Commission_for_export
ALTER PROCEDURE dbo.sp_Sales_Commission_for_export2(@.StartDate smalldatetime,
@.EndDate smalldatetime, @.SalesRepID int, @.TargetAmt int)
-- TargetAmt is 3,500,000.00
AS

---------------------------------
-- SELECT ADDED TO KEEP A TALY OF THE AMT PAID WHICH WILL BE USED TO VALIDATE IF SALESREP REACH TARGET AMT STARTING FROM 1/1/06.
SELECT sum(dbo.p21_view_ar_receipts_detail.payment_amount - (dbo.p21_view_invoice_hdr.freight * (dbo.p21_view_ar_receipts_detail.payment_amount / dbo.p21_view_invoice_hdr.total_amount))) as TotalAmount1 --totaAmount1 is the amt to check against the Targetamt.
FROM dbo.p21_view_ar_receipts_detail INNER JOIN dbo.p21_view_invoice_hdr ON dbo.p21_view_ar_receipts_detail.invoice_no = dbo.p21_view_invoice_hdr.invoice_no
WHERE dbo.p21_view_invoice_hdr.invoice_date BETWEEN '01/01/2006' AND '12/30/2006' AND dbo.p21_view_invoice_hdr.salesrep_id = '1001'

SELECT DISTINCT TOP 100 PERCENT
dbo.p21_view_ar_receipts_detail.invoice_no AS InvoiceNumber,
dbo.p21_view_invoice_hdr.customer_id AS CustomerNumber,
dbo.p21_view_invoice_hdr.bill2_name AS BillToName, dbo.p21_view_invoice_hdr.bill2_address1 AS BillToAddress,
dbo.p21_view_invoice_hdr.bill2_city AS BillToCity, dbo.p21_view_invoice_hdr.bill2_state AS BillToState,
dbo.p21_view_invoice_hdr.bill2_postal_code AS BillToZipCode,
dbo.p21_view_invoice_hdr.ship2_name AS ShipToName, dbo.p21_view_invoice_hdr.ship2_address1 AS ShipToAddress,
dbo.p21_view_invoice_hdr.ship2_city AS ShipToCity, dbo.p21_view_invoice_hdr.ship2_state AS ShipToState,
dbo.p21_view_invoice_hdr.ship2_postal_code AS ShipToZipCode,
dbo.vw_latest_payment_by_invoice.LatestPaymentDate ,
dbo.p21_view_invoice_hdr.invoice_date AS InvoiceDate,
sum(dbo.p21_view_ar_receipts_detail.payment_amount - (dbo.p21_view_invoice_hdr.freight * (dbo.p21_view_ar_receipts_detail.payment_amount / dbo.p21_view_invoice_hdr.total_amount))) as [TotalAmount]
--IF STATEMENT TO SET THE COMMISSION RATE
IF dbo.p21_view_invoice_hdr.invoice_date BETWEEN '04/01/2006' AND '12/31/2006'
BEGIN
sum(3 * .01)AS CommissionPercent
END
ELSE IF TotalAmount1 >= @.TargetAmt
BEGIN
sum(5 * .01) AS CommissionPercent
END
RETURN CommissionPercent
IF (dbo.p21_view_invoice_hdr.invoice_date < '04/01/2006')
BEGIN
dbo.CMP_Sales_CommissionPercent.CommissionPercent * .01 AS CommissionPercent
END
CAST((CommissionPercent * .01) * (dbo.p21_view_ar_receipts_detail.payment_amount - (dbo.p21_view_invoice_hdr.freight * (dbo.p21_view_ar_receipts_detail.payment_amount / dbo.p21_view_invoice_hdr.total_amount))) AS smallmoney(6, 2)) AS CommissionDollars,
dbo.p21_view_invoice_hdr.amount_paid AS TotalAmountPaid,
CAST(dbo.p21_view_invoice_hdr.amount_paid / dbo.p21_view_invoice_hdr.total_amount AS real(2, 2)) AS PercentInvoicePaid

FROM
dbo.CMP_Sales_CommissionPercent INNER JOIN
dbo.customer ON dbo.CMP_Sales_CommissionPercent.class_1id = dbo.customer.class_1id INNER JOIN
dbo.p21_view_ar_receipts INNER JOIN
dbo.p21_view_ar_receipts_detail ON dbo.p21_view_ar_receipts_detail.receipt_number = dbo.p21_view_ar_receipts.receipt_number INNER JOIN
dbo.p21_view_invoice_hdr ON dbo.p21_view_ar_receipts_detail.invoice_no = dbo.p21_view_invoice_hdr.invoice_no ON
dbo.customer.customer_id = dbo.p21_view_ar_receipts_detail.customer_id LEFT JOIN
dbo.vw_latest_payment_by_invoice ON dbo.p21_view_ar_receipts_detail.invoice_no = dbo.vw_latest_payment_by_invoice.InvoiceNumber
WHERE
(dbo.p21_view_invoice_hdr.salesrep_id LIKE @.SalesRepID ) and
(dbo.p21_view_invoice_hdr.salesrep_id <> '1048') AND
(dbo.p21_view_invoice_hdr.approved = 'Y') AND
(dbo.p21_view_invoice_hdr.invoice_class <> 'FINANCE') AND
(dbo.p21_view_invoice_hdr.invoice_adjustment_type NOT IN ('B', 'T', 'X')) AND
(dbo.p21_view_invoice_hdr.consolidated <> 'C') AND
(dbo.p21_view_invoice_hdr.total_amount <> 0) AND
(dbo.p21_view_ar_receipts.date_received >= @.StartDate) AND
(dbo.p21_view_ar_receipts.date_received <= @.EndDate) AND
(dbo.p21_view_invoice_hdr.amount_paid <> 0) AND
(dbo.p21_view_invoice_hdr.salesrep_id <> '1007')

GROUP BY dbo.p21_view_ar_receipts_detail.invoice_no, dbo.p21_view_invoice_hdr.invoice_date, dbo.p21_view_invoice_hdr.bill2_name,
dbo.p21_view_invoice_hdr.customer_id,dbo.p21_view_ invoice_hdr.bill2_address1, dbo.p21_view_invoice_hdr.bill2_city,
dbo.p21_view_invoice_hdr.bill2_state, dbo.p21_view_invoice_hdr.bill2_postal_code, dbo.p21_view_invoice_hdr.ship2_name,
dbo.p21_view_invoice_hdr.ship2_address1, dbo.p21_view_invoice_hdr.ship2_city, dbo.p21_view_invoice_hdr.ship2_state,
dbo.p21_view_invoice_hdr.ship2_postal_code, dbo.vw_latest_payment_by_invoice.LatestPaymentDate ,
dbo.CMP_Sales_CommissionPercent.CommissionPercent, dbo.p21_view_ar_receipts_detail.payment_amount,
dbo.p21_view_invoice_hdr.freight, dbo.p21_view_invoice_hdr.total_amount, dbo.p21_view_invoice_hdr.amount_paid


ORDER BY
dbo.p21_view_ar_receipts_detail.invoice_no
---------------------------------

--exec sp_Sales_Commission_for_export @.StartDate = '2/1/05', @.EndDate = '2/28/05', @.SalesRepID = '1001'

GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO

--
I also have a few syntax error.|||You should post new questions as new threads.

You need a comma after [TotalAmount]

Use CASE instead of IF within a SELECT statement:sum(dbo.p21_view_ar_receipts_detail.paym ent_amount - (dbo.p21_view_invoice_hdr.freight * (dbo.p21_view_ar_receipts_detail.payment_amount / dbo.p21_view_invoice_hdr.total_amount))) as [TotalAmount],
--CASE STATEMENT TO SET THE COMMISSION RATE
case when dbo.p21_view_invoice_hdr.invoice_date BETWEEN '04/01/2006' AND '12/31/2006'
then sum(3 * .01)
else case when TotalAmount1 >= @.TargetAmt
then sum(5 * .01)
end
end as CommisionPercent
from dbo.p21_view_invoice_hdr

Report Subscription sends wrong version

I have a report that's scheduled to run once a month on a timed subscription (using a shared schedule). The Report Delivery Options are set to include the report as a PDF embedded within the email notification. The report has also been set to record a snapshot each time it is run.

The first month, the report was embedded as planned.

The second month, the wrong report was sent. The PDF that was generated in the prior month was resent, not a new instance of a PDF based on the current data. The emailed link to the report on the server worked fine, and the history shows that the snapshot was recorded at the appropriate time?

Wa happen? Why would it embed the prior/old instance of the report?Hi there, I'm trying to recreate this problem so I can try and figure it out but I need a little bit more info.

When you say you have set it to record a snapshot every time the report is run do you mean that it records a snapshot on the same schedule as the subscription?|||Specifically, on the History Properties of the report, I have the following options selected:

Allow history to be created manually.
Store all report execution snapshots in history.
Use the following schedule to add snapshots to report history
Shared Schedule: MonthEndProcessing-At 2:00 AM on day(s) 1 of every month starting 6/3/2005.
Keep an unlimited number of snapshots in report history.

On the Execution Properties, I have the following options selected:

Render this report from an execution snapshot
Use the following schedule to create execution snapshots:
Shared Schedule: MonthEndProcessing-At 2:00 AM on day(s) 1 of every month starting 6/3/2005.
Report Execution Timeout: Use default setting

On the Subscription Processing options:
Delivered by: Report Server E-Mail
Include Report Render Format: Acrobat (PDF) file
Run the subscription:
On a shared schedule: MonthEndProcessing-At 2:00 AM on day(s) 1 of every month|||I've not had time to try and test this theory but I believe it may be somethig to do with the time it takes to process the report.

I think what may be happening is that when the schedule kicks in and starts to generate the report the subscription doesn't wait for the report to be completed because of the time it takes to generate it so it sends the last generated report.

It was probably fine for the first report because by default when you create a snapshot schedule it automatically creates a snapshot when you apply the settings but when it was run the next time it sent the first report while the second was being generated.

If this is the problem you should be able to fix it by creating a schedule that runs before the subscriptions to generate the report so it is ready when the subscription schedule kicks in.|||

This is the behavior I am experiencing with large reports, and it is getting me burned!

The "Render the report with most recent data" switch does nothing in this case, as in our environment all reports run with most recent data and snapshots are not useful.

So for all my monthly and weelky reports I have to schedule a snapshot (with a limit history of 1) a fixed time (10minutes?, 1 hour?) on the report history page before building the subscription separately to send them?

If Render most recent is on, the sub should wait for the report to finish, before sending.

THIS IS A BUG. No matter how it's sliced.

Report Subscription sends wrong version

I have a report that's scheduled to run once a month on a timed subscription (using a shared schedule). The Report Delivery Options are set to include the report as a PDF embedded within the email notification. The report has also been set to record a snapshot each time it is run.

The first month, the report was embedded as planned.

The second month, the wrong report was sent. The PDF that was generated in the prior month was resent, not a new instance of a PDF based on the current data. The emailed link to the report on the server worked fine, and the history shows that the snapshot was recorded at the appropriate time?

Wa happen? Why would it embed the prior/old instance of the report?Hi there, I'm trying to recreate this problem so I can try and figure it out but I need a little bit more info.

When you say you have set it to record a snapshot every time the report is run do you mean that it records a snapshot on the same schedule as the subscription?|||Specifically, on the History Properties of the report, I have the following options selected:

Allow history to be created manually.
Store all report execution snapshots in history.
Use the following schedule to add snapshots to report history
Shared Schedule: MonthEndProcessing-At 2:00 AM on day(s) 1 of every month starting 6/3/2005.
Keep an unlimited number of snapshots in report history.

On the Execution Properties, I have the following options selected:

Render this report from an execution snapshot
Use the following schedule to create execution snapshots:
Shared Schedule: MonthEndProcessing-At 2:00 AM on day(s) 1 of every month starting 6/3/2005.
Report Execution Timeout: Use default setting

On the Subscription Processing options:
Delivered by: Report Server E-Mail
Include Report Render Format: Acrobat (PDF) file
Run the subscription:
On a shared schedule: MonthEndProcessing-At 2:00 AM on day(s) 1 of every month|||I've not had time to try and test this theory but I believe it may be somethig to do with the time it takes to process the report.

I think what may be happening is that when the schedule kicks in and starts to generate the report the subscription doesn't wait for the report to be completed because of the time it takes to generate it so it sends the last generated report.

It was probably fine for the first report because by default when you create a snapshot schedule it automatically creates a snapshot when you apply the settings but when it was run the next time it sent the first report while the second was being generated.

If this is the problem you should be able to fix it by creating a schedule that runs before the subscriptions to generate the report so it is ready when the subscription schedule kicks in.|||

This is the behavior I am experiencing with large reports, and it is getting me burned!

The "Render the report with most recent data" switch does nothing in this case, as in our environment all reports run with most recent data and snapshots are not useful.

So for all my monthly and weelky reports I have to schedule a snapshot (with a limit history of 1) a fixed time (10minutes?, 1 hour?) on the report history page before building the subscription separately to send them?

If Render most recent is on, the sub should wait for the report to finish, before sending.

THIS IS A BUG. No matter how it's sliced.

Report subscription and Failure sending mail:

I am using Reporting Services 2005. SP1 is applied (version 9.0.2047). I configured one of the reports with subscription and sending
report via email. I used Report Manager to setup the report subscriptions,
but I get the following status message:

"Failure sending mail: The Report Server has encountered a configuration
error; more details in the log files"

The log file contains the following:

ERROR: Throwing
Microsoft.ReportingServices .Diagnostics.Utilities.ServerConfigurationErrorE-xception: The Report Server has encountered a configuration error. See the report server log files for more information., AuthzInitializeContextFromSid: Win32 error: 110;

Any ideas?

I am also getting the error on SQL Server 2005 with SP1 and am currently trying to get the email working.

The only bit of extra information I can give is that when I do

net helpmsg 110

I get: The system cannot open the device of file specified.

As yet, I have no idea what device or file report server is trying to open.

I'll update this message if I figure this out.

Report subscription and Failure sending mail:

I am using Reporting Services 2005. SP1 is applied (version 9.0.2047). I configured one of the reports with subscription and sending
report via email. I used Report Manager to setup the report subscriptions,
but I get the following status message:

"Failure sending mail: The Report Server has encountered a configuration
error; more details in the log files"

The log file contains the following:

ERROR: Throwing
Microsoft.ReportingServices

.Diagnostics.Utilities.ServerConfigurationErrorE-xception: The Report Server has encountered a configuration error. See the report server log files for more information., AuthzInitializeContextFromSid: Win32 error: 110;

Any ideas?

I am also getting the error on SQL Server 2005 with SP1 and am currently trying to get the email working.

The only bit of extra information I can give is that when I do

net helpmsg 110

I get: The system cannot open the device of file specified.

As yet, I have no idea what device or file report server is trying to open.

I'll update this message if I figure this out.

Report Source

Hi
We have different version of the same report. For example, Report 1,
Report 1a, Report 1b in the visual studio. We publish only one of them.
But, we go and change report name in browser to 1. After a while, we do not
remember which one did we publish. Is it possible to see which report is
published?
I know that you can get RDL code from browser and compare it against the
visual studio RDL. But, I have lot of such reports.typo in last post - should be "Description" property :-)
"manish" wrote:
> Hi
> We have different version of the same report. For example, Report 1,
> Report 1a, Report 1b in the visual studio. We publish only one of them.
> But, we go and change report name in browser to 1. After a while, we do not
> remember which one did we publish. Is it possible to see which report is
> published?
> I know that you can get RDL code from browser and compare it against the
> visual studio RDL. But, I have lot of such reports.
>|||Add the version number to the "Sedcription" property of the report before you
deploy it, then you will see that in the properties of the report in Report
Manager
"manish" wrote:
> Hi
> We have different version of the same report. For example, Report 1,
> Report 1a, Report 1b in the visual studio. We publish only one of them.
> But, we go and change report name in browser to 1. After a while, we do not
> remember which one did we publish. Is it possible to see which report is
> published?
> I know that you can get RDL code from browser and compare it against the
> visual studio RDL. But, I have lot of such reports.
>|||Hi Mary
Unfortunately, they are already deployed.
Thanks
Manish
"Mary Bray [SQL Server MVP]" wrote:
> typo in last post - should be "Description" property :-)
> "manish" wrote:
> > Hi
> >
> > We have different version of the same report. For example, Report 1,
> > Report 1a, Report 1b in the visual studio. We publish only one of them.
> > But, we go and change report name in browser to 1. After a while, we do not
> > remember which one did we publish. Is it possible to see which report is
> > published?
> > I know that you can get RDL code from browser and compare it against the
> > visual studio RDL. But, I have lot of such reports.
> >

Report services compatibility ??

Hi All ...
If I create a report with Microsoft SQL Server Reporting Services
Designers
Version 9.00.1399.00 ... ( Visual Studio 2005) ... Will I be able to
deploy it to SQL Server Report Services 2000 ?
*******
Error 8 An error occurred during the parsing of a resource required to
service this request. Please review the following specific parse
error details and modify your source file appropriately.
*******
I did verify my Report Server name in the "Microsoft CRM Deployment
Manager ... made some modification ...try to deploy again then I'm
getting another error message
******
A connection could not be made to the report server
http:// .........../ReportServer
ADDITIONAL INFORMATION:
The attempt to connect to the report server failed. Check your
connection information and that the report server is a compatible
version. (Microsoft.ReportingServices.Designer)
******
With this one it seems to be a version problem ... Just need an
approval from an expert
TanksNope.
You can deploy RS 2000 to RS 2005 but not RS 2005 to RS 2000.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Frank" <flefe2000@.gmail.com> wrote in message
news:1170879261.176664.43180@.j27g2000cwj.googlegroups.com...
> Hi All ...
> If I create a report with Microsoft SQL Server Reporting Services
> Designers
> Version 9.00.1399.00 ... ( Visual Studio 2005) ... Will I be able to
> deploy it to SQL Server Report Services 2000 ?
>
> *******
> Error 8 An error occurred during the parsing of a resource required to
> service this request. Please review the following specific parse
> error details and modify your source file appropriately.
> *******
>
> I did verify my Report Server name in the "Microsoft CRM Deployment
> Manager ... made some modification ...try to deploy again then I'm
> getting another error message
>
> ******
> A connection could not be made to the report server
> http:// .........../ReportServer
> ADDITIONAL INFORMATION:
> The attempt to connect to the report server failed. Check your
> connection information and that the report server is a compatible
> version. (Microsoft.ReportingServices.Designer)
> ******
> With this one it seems to be a version problem ... Just need an
> approval from an expert
> Tanks
>|||On 7 f=E9v, 15:21, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
wrote:
> Nope.
> You can deploy RS 2000 to RS 2005 but not RS 2005 to RS 2000.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Frank" <flefe2...@.gmail.com> wrote in message
> news:1170879261.176664.43180@.j27g2000cwj.googlegroups.com...
>
> > Hi All ...
> > If I create a report with Microsoft SQL Server Reporting Services
> > Designers
> > Version 9.00.1399.00 ... ( Visual Studio 2005) ... Will I be able to
> > deploy it to SQL Server Report Services 2000 ?
> > *******
> > Error 8 An error occurred during the parsing of a resource required to
> > service this request. Please review the following specific parse
> > error details and modify your source file appropriately.
> > *******
> > I did verify my Report Server name in the "Microsoft CRM Deployment
> > Manager ... made some modification ...try to deploy again then I'm
> > getting another error message
> > ******
> > A connection could not be made to the report server
> > http:// .........../ReportServer
> > ADDITIONAL INFORMATION:
> > The attempt to connect to the report server failed. Check your
> > connection information and that the report server is a compatible
> > version. (Microsoft.ReportingServices.Designer)
> > ******
> > With this one it seems to be a version problem ... Just need an
> > approval from an expert
> > Tanks- Masquer le texte des messages pr=E9c=E9dents -
> - Afficher le texte des messages pr=E9c=E9dents -
Whaow ... Quick answer ... tanks
I'm using Microsoft CRM 3.0 with SQL Server Report Services 2000 ...
is it an easy task to upgrade Report Services 2000 to 2005 '
Tanks again
Frank|||I'm not familiar with CRM.
A regular RS 2000 environment is not hard to upgrade but there might be
specific things for your environment.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Frank" <flefe2000@.gmail.com> wrote in message
news:1170880734.453903.84940@.s48g2000cws.googlegroups.com...
On 7 fév, 15:21, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
wrote:
> Nope.
> You can deploy RS 2000 to RS 2005 but not RS 2005 to RS 2000.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Frank" <flefe2...@.gmail.com> wrote in message
> news:1170879261.176664.43180@.j27g2000cwj.googlegroups.com...
>
> > Hi All ...
> > If I create a report with Microsoft SQL Server Reporting Services
> > Designers
> > Version 9.00.1399.00 ... ( Visual Studio 2005) ... Will I be able to
> > deploy it to SQL Server Report Services 2000 ?
> > *******
> > Error 8 An error occurred during the parsing of a resource required to
> > service this request. Please review the following specific parse
> > error details and modify your source file appropriately.
> > *******
> > I did verify my Report Server name in the "Microsoft CRM Deployment
> > Manager ... made some modification ...try to deploy again then I'm
> > getting another error message
> > ******
> > A connection could not be made to the report server
> > http:// .........../ReportServer
> > ADDITIONAL INFORMATION:
> > The attempt to connect to the report server failed. Check your
> > connection information and that the report server is a compatible
> > version. (Microsoft.ReportingServices.Designer)
> > ******
> > With this one it seems to be a version problem ... Just need an
> > approval from an expert
> > Tanks- Masquer le texte des messages précédents -
> - Afficher le texte des messages précédents -
Whaow ... Quick answer ... tanks
I'm using Microsoft CRM 3.0 with SQL Server Report Services 2000 ...
is it an easy task to upgrade Report Services 2000 to 2005 '
Tanks again
Frank|||On 7 f=E9v, 16:23, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
wrote:
> I'm not familiar with CRM.
> A regular RS 2000 environment is not hard to upgrade but there might be
> specific things for your environment.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Frank" <flefe2...@.gmail.com> wrote in message
> news:1170880734.453903.84940@.s48g2000cws.googlegroups.com...
> On 7 f=E9v, 15:21, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
> wrote:
>
>
> > Nope.
> > You can deploy RS 2000 to RS 2005 but not RS 2005 to RS 2000.
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> > "Frank" <flefe2...@.gmail.com> wrote in message
> >news:1170879261.176664.43180@.j27g2000cwj.googlegroups.com...
> > > Hi All ...
> > > If I create a report with Microsoft SQL Server Reporting Services
> > > Designers
> > > Version 9.00.1399.00 ... ( Visual Studio 2005) ... Will I be able to
> > > deploy it to SQL Server Report Services 2000 ?
> > > *******
> > > Error 8 An error occurred during the parsing of a resource required to
> > > service this request. Please review the following specific parse
> > > error details and modify your source file appropriately.
> > > *******
> > > I did verify my Report Server name in the "Microsoft CRM Deployment
> > > Manager ... made some modification ...try to deploy again then I'm
> > > getting another error message
> > > ******
> > > A connection could not be made to the report server
> > > http:// .........../ReportServer
> > > ADDITIONAL INFORMATION:
> > > The attempt to connect to the report server failed. Check your
> > > connection information and that the report server is a compatible
> > > version. (Microsoft.ReportingServices.Designer)
> > > ******
> > > With this one it seems to be a version problem ... Just need an
> > > approval from an expert
> > > Tanks- Masquer le texte des messages pr=E9c=E9dents -
> > - Afficher le texte des messages pr=E9c=E9dents -
> Whaow ... Quick answer ... tanks
> I'm using Microsoft CRM 3.0 with SQL Server Report Services 2000 ...
> is it an easy task to upgrade Report Services 2000 to 2005 '
> Tanks again
> Frank- Masquer le texte des messages pr=E9c=E9dents -
> - Afficher le texte des messages pr=E9c=E9dents -
I will research on the CRM issue but beside that ... is it preferable
to upgrade or start from scratch '

Report server service pack

How can I determine what version of service pack for reporting services is
installed on our servers?
I would deeply appreciate step by step instructions.
TIA...Go to http://yourserver/Reportserver
SP1 is Version 8.00.878.00
SP2 is Version 8.00.1038.00
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Trisha" <trisha@.nospam.nospam> wrote in message
news:567D207F-3AED-4D63-96C0-96B0A37C1671@.microsoft.com...
> How can I determine what version of service pack for reporting services is
> installed on our servers?
> I would deeply appreciate step by step instructions.
> TIA...|||Thank you Bruce.
What would version 8.00.743.00 refer to?
TIA...
"Bruce L-C [MVP]" wrote:
> Go to http://yourserver/Reportserver
> SP1 is Version 8.00.878.00
> SP2 is Version 8.00.1038.00
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Trisha" <trisha@.nospam.nospam> wrote in message
> news:567D207F-3AED-4D63-96C0-96B0A37C1671@.microsoft.com...
> > How can I determine what version of service pack for reporting services is
> > installed on our servers?
> >
> > I would deeply appreciate step by step instructions.
> >
> > TIA...
>
>|||That must be RTM (release to Manufacturing, i.e. the first release). That
means you have no service packs installed. Given all the fixes I strongly
recommend applying both service packs.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Trisha" <trisha@.nospam.nospam> wrote in message
news:630BE97F-B5D7-4083-87FC-714D990B90A1@.microsoft.com...
> Thank you Bruce.
> What would version 8.00.743.00 refer to?
> TIA...
> "Bruce L-C [MVP]" wrote:
> > Go to http://yourserver/Reportserver
> >
> > SP1 is Version 8.00.878.00
> > SP2 is Version 8.00.1038.00
> >
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> > "Trisha" <trisha@.nospam.nospam> wrote in message
> > news:567D207F-3AED-4D63-96C0-96B0A37C1671@.microsoft.com...
> > > How can I determine what version of service pack for reporting
services is
> > > installed on our servers?
> > >
> > > I would deeply appreciate step by step instructions.
> > >
> > > TIA...
> >
> >
> >|||Bruce,
I just googled for 8.00.743.00 and it turns out to be the installation
version.
Thanks
"Bruce L-C [MVP]" wrote:
> Go to http://yourserver/Reportserver
> SP1 is Version 8.00.878.00
> SP2 is Version 8.00.1038.00
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Trisha" <trisha@.nospam.nospam> wrote in message
> news:567D207F-3AED-4D63-96C0-96B0A37C1671@.microsoft.com...
> > How can I determine what version of service pack for reporting services is
> > installed on our servers?
> >
> > I would deeply appreciate step by step instructions.
> >
> > TIA...
>
>|||Thanks Bruce...
"Bruce L-C [MVP]" wrote:
> That must be RTM (release to Manufacturing, i.e. the first release). That
> means you have no service packs installed. Given all the fixes I strongly
> recommend applying both service packs.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Trisha" <trisha@.nospam.nospam> wrote in message
> news:630BE97F-B5D7-4083-87FC-714D990B90A1@.microsoft.com...
> > Thank you Bruce.
> >
> > What would version 8.00.743.00 refer to?
> >
> > TIA...
> >
> > "Bruce L-C [MVP]" wrote:
> >
> > > Go to http://yourserver/Reportserver
> > >
> > > SP1 is Version 8.00.878.00
> > > SP2 is Version 8.00.1038.00
> > >
> > >
> > > --
> > > Bruce Loehle-Conger
> > > MVP SQL Server Reporting Services
> > >
> > > "Trisha" <trisha@.nospam.nospam> wrote in message
> > > news:567D207F-3AED-4D63-96C0-96B0A37C1671@.microsoft.com...
> > > > How can I determine what version of service pack for reporting
> services is
> > > > installed on our servers?
> > > >
> > > > I would deeply appreciate step by step instructions.
> > > >
> > > > TIA...
> > >
> > >
> > >
>
>|||When you said "both service packs," does that mean that SP2 doesn't include
fixes from SP1?
When I read through the SP2 docs it wasn't clear to me, but it seemed like
if I ran SP2 on an RTM or SP1 installation that I'd end up with equivalent
installations.
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in
news:O9bvCaMUFHA.3244@.TK2MSFTNGP15.phx.gbl:
> That must be RTM (release to Manufacturing, i.e. the first release). That
> means you have no service packs installed. Given all the fixes I strongly
> recommend applying both service packs.
>|||SP2 includes everything that comes with SP1. So installing just SP2 is
sufficient.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Nerf Herder" <null@.notta.org> wrote in message
news:Xns964CAFD1F116Ejjjjjj@.207.46.248.16...
> When you said "both service packs," does that mean that SP2 doesn't
> include
> fixes from SP1?
> When I read through the SP2 docs it wasn't clear to me, but it seemed like
> if I ran SP2 on an RTM or SP1 installation that I'd end up with equivalent
> installations.
>
>
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in
> news:O9bvCaMUFHA.3244@.TK2MSFTNGP15.phx.gbl:
>> That must be RTM (release to Manufacturing, i.e. the first release). That
>> means you have no service packs installed. Given all the fixes I strongly
>> recommend applying both service packs.
>>
>|||I was a little sloppy with that statement. As Robert said, SP2 is all that
is needed to upgrade with.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Nerf Herder" <null@.notta.org> wrote in message
news:Xns964CAFD1F116Ejjjjjj@.207.46.248.16...
> When you said "both service packs," does that mean that SP2 doesn't
> include
> fixes from SP1?
> When I read through the SP2 docs it wasn't clear to me, but it seemed like
> if I ran SP2 on an RTM or SP1 installation that I'd end up with equivalent
> installations.
>
>
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in
> news:O9bvCaMUFHA.3244@.TK2MSFTNGP15.phx.gbl:
>> That must be RTM (release to Manufacturing, i.e. the first release). That
>> means you have no service packs installed. Given all the fixes I strongly
>> recommend applying both service packs.
>>
>|||Thanks
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in
news:#X0vnASUFHA.228@.TK2MSFTNGP12.phx.gbl:
> I was a little sloppy with that statement. As Robert said, SP2 is all
> that is needed to upgrade with.
>

Report Server Database is an invalid version

We have been receiving these errors and are not sure why. The Reporting
Server has RS SP1 and the latest SQL Server service pack (SP3a). The webiste
is serving up reports with no problem. Thanks.
Event Type: Error
Event Source: Schedule and Delivery Processor
Event Category: Startup/Shutdown
Event ID: 117
Date: 10/19/2004
Time: 2:36:58 AM
User: N/A
Computer: ProdServer
Description:
The report server database is an invalid version.Does RS work correctly when you browse to //localhost/reportserver? What
user is the reportserver service running as?
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"troy" <troy@.discussions.microsoft.com> wrote in message
news:04512DEC-7E0E-494A-9201-739E135A2885@.microsoft.com...
> We have been receiving these errors and are not sure why. The Reporting
> Server has RS SP1 and the latest SQL Server service pack (SP3a). The
webiste
> is serving up reports with no problem. Thanks.
> Event Type: Error
> Event Source: Schedule and Delivery Processor
> Event Category: Startup/Shutdown
> Event ID: 117
> Date: 10/19/2004
> Time: 2:36:58 AM
> User: N/A
> Computer: ProdServer
> Description:
> The report server database is an invalid version.|||Hi, I used to face the same problem, until I created a Virtual Directory/Database using the SQL Server Config Wizard. Since, then, the error has stopped occuring.
From http://www.developmentnow.com/g/115_2004_10_0_0_452074/Report-Server-Database-is-an-invalid-version.ht
Posted via DevelopmentNow.com Group
http://www.developmentnow.com