rsInvalidPolicyDefinition - migration to another domain .....

Hi friends,

We have a problem with our RS2005 after migration into another domain.

The problem is that we have got duplicate access rights for the same AD usergroup.
When trying to remove or add a new AD group we get the error msg - "... role assignment is not valid. The role assignment is either empty or it specifies a user or group name that is already used in an existing role assignment for the current item. (rsInvalidPolicyDefinition)"

Books online gives no answers and neither does other serach engines .....

Anyone having a hint or solution .......

We have the same problem. Cannot remove some roles. I'm worried about if we need to make changes later, will we have to destroy the entire folder structure & re-create it in order to get rid of these roles/permissions?

rsInvalidPolicyDefinition - migration to another domain .....

Hi friends,

We have a problem with our RS2005 after migration into another domain.

The problem is that we have got duplicate access rights for the same AD usergroup.
When trying to remove or add a new AD group we get the error msg - "... role assignment is not valid. The role assignment is either empty or it specifies a user or group name that is already used in an existing role assignment for the current item. (rsInvalidPolicyDefinition)"

Books online gives no answers and neither does other serach engines .....

Anyone having a hint or solution .......

We have the same problem. Cannot remove some roles. I'm worried about if we need to make changes later, will we have to destroy the entire folder structure & re-create it in order to get rid of these roles/permissions?sql

RSClientPrint Download

I have an asp.net application which is launched from our B2B site. The primary purpose of the application is to allow our external clients access to reports, along with the ability to export and print. The RS2005 report viewer component was used within the application to render the reports. The problem is when the our client users click on the print button on the report viewer's tool bar, many of them are receiving a window asking them if they want to install "SQL Server". In reality, the ActiveX viewer, RSClientPrint, is what is trying to install. Our technical support staff is being flooded with calls due to this pop up. The users are very confused and concerned about installing "SQL Server." In addition, some users do not have the ability to install the ActiveX viewer, so they are not going to be able to print. We've experienced this in the past with ActiveX for Crystal. Finally, some users receive no message or feedback when they click on the print button for several minutes. We've determined the ActiveX is being installed during this time. We've had users wait as long as 7 minutes for the Print Dialog to come up.

1. We would like to place a message along with the link on the page where the report is rendered. Is there a way for us to provide a link to a self extracting file containing RSClientPrint?

2. Also is there any way to get around the issue where the client user does not have the ability to install the ActiveX? I've seen references on the forum to using SMS, but this is not possible since the users are external?

3. Is there any setting we can turn on so the users don't think the application has gone "out to lunch" while the ActiveX viewer is installed?

Thanks

Anything that Report Manager or the ActiveX control does, you can code yourself using the Reporting Services Web Services. You don't and never did need the ActiveX to view reports. It was added to allow new developers an easy way to add reporting features to applications without needing to know about the Web Services.

What you will find is that at some point, you will need to access Reporting Services in a way that the ActiveX does not support/make easy and you will have to go via the Web Services... now it that time

Regards

Paul

|||

Paul,

Thank you for your quick response. Unfortunately, we avoided this approach on purpose for a number of reasons, one of which was to avoid passing sensitive client customer information on the query string and then having to encrypt it.

We have actually used the RS web service with a RS2000 report for our price lists. However, we liked the ease of use in VS2005 with the report viewer component and the ability to pass parameters internally from the ASP.Net application to the report viewer component which hid sensitive information from potential hackers.

I assume based on your response there is no way for us to provide a link to a self extracting RSClientPrint file or any way to speed up the download and installation time?

Thanks

Carol

|||

Not really. This is one of the 'joys' of working with ActiveX controls.

You only pass details across the query string when you are using URL access to reporting services. The web services use SOAP (XML). You could create a soap extension in .NET to encrypt the data or simply run the web services over SSL.

Cheers

Paul

|||

Paul,

You say "You don't and never did need the ActiveX to view reports".... Are you talking about RSClientPrint? If so...is there any way to print reports (other than browser, or exported) without this ActiveX?

|||

Hi to everyone, actually i have an application to external clients and they will need to be able to print some reports.

After reading some forums, blogs, MSDN KB articles, we discover a way to print automatically theese reports, but it only work if we have thath activex installed.

If you (Paul) say thah we can perform the activity to print reports on Iexplorer using the Reporting Services Web Service, could you give us some orientatio about the methods to use for this activity...

I used this Web Service form rendering reports and show it to the client, but now thath i need to print, the only way i discovered is using the activex.

Greetings !

|||From what I understand, in order to use that print button on the report toolbar, the RSClientPrint ActiveX is required. The only other options for printing are:
1. Using the browser's print functionality (file->print) - but then you get the rest of the web page, and only the part of the report that is currently visible (nothing you have to scroll to see or other pages for multipage reports)
2. Export the report and use another application to print - for instance, export to PDF and print from Adobe Reader.
Basically, the browser knows how to print web pages, Adobe knows how to print PDFs, and RSClientPrint knows how to print SQL 2005 Reports.
MSDN - SQL Server 2005 Books Online - Printing Reports from a Browser:
http://msdn2.microsoft.com/en-us/library/ms159237.aspx
MSDN - SQL Server 2005 Books Online - How to: Configure a Browser for Client-Side Printing (Report Manager)
http://msdn2.microsoft.com/en-us/library/ms159190.aspx
This was enough proof for our marketing department...
-
Mike

RSClientPrint Download

I have an asp.net application which is launched from our B2B site. The primary purpose of the application is to allow our external clients access to reports, along with the ability to export and print. The RS2005 report viewer component was used within the application to render the reports. The problem is when the our client users click on the print button on the report viewer's tool bar, many of them are receiving a window asking them if they want to install "SQL Server". In reality, the ActiveX viewer, RSClientPrint, is what is trying to install. Our technical support staff is being flooded with calls due to this pop up. The users are very confused and concerned about installing "SQL Server." In addition, some users do not have the ability to install the ActiveX viewer, so they are not going to be able to print. We've experienced this in the past with ActiveX for Crystal. Finally, some users receive no message or feedback when they click on the print button for several minutes. We've determined the ActiveX is being installed during this time. We've had users wait as long as 7 minutes for the Print Dialog to come up.

1. We would like to place a message along with the link on the page where the report is rendered. Is there a way for us to provide a link to a self extracting file containing RSClientPrint?

2. Also is there any way to get around the issue where the client user does not have the ability to install the ActiveX? I've seen references on the forum to using SMS, but this is not possible since the users are external?

3. Is there any setting we can turn on so the users don't think the application has gone "out to lunch" while the ActiveX viewer is installed?

Thanks

Anything that Report Manager or the ActiveX control does, you can code yourself using the Reporting Services Web Services. You don't and never did need the ActiveX to view reports. It was added to allow new developers an easy way to add reporting features to applications without needing to know about the Web Services.

What you will find is that at some point, you will need to access Reporting Services in a way that the ActiveX does not support/make easy and you will have to go via the Web Services... now it that time

Regards

Paul

|||

Paul,

Thank you for your quick response. Unfortunately, we avoided this approach on purpose for a number of reasons, one of which was to avoid passing sensitive client customer information on the query string and then having to encrypt it.

We have actually used the RS web service with a RS2000 report for our price lists. However, we liked the ease of use in VS2005 with the report viewer component and the ability to pass parameters internally from the ASP.Net application to the report viewer component which hid sensitive information from potential hackers.

I assume based on your response there is no way for us to provide a link to a self extracting RSClientPrint file or any way to speed up the download and installation time?

Thanks

Carol

|||

Not really. This is one of the 'joys' of working with ActiveX controls.

You only pass details across the query string when you are using URL access to reporting services. The web services use SOAP (XML). You could create a soap extension in .NET to encrypt the data or simply run the web services over SSL.

Cheers

Paul

|||

Paul,

You say "You don't and never did need the ActiveX to view reports".... Are you talking about RSClientPrint? If so...is there any way to print reports (other than browser, or exported) without this ActiveX?

|||

Hi to everyone, actually i have an application to external clients and they will need to be able to print some reports.

After reading some forums, blogs, MSDN KB articles, we discover a way to print automatically theese reports, but it only work if we have thath activex installed.

If you (Paul) say thah we can perform the activity to print reports on Iexplorer using the Reporting Services Web Service, could you give us some orientatio about the methods to use for this activity...

I used this Web Service form rendering reports and show it to the client, but now thath i need to print, the only way i discovered is using the activex.

Greetings !

|||From what I understand, in order to use that print button on the report toolbar, the RSClientPrint ActiveX is required. The only other options for printing are:
1. Using the browser's print functionality (file->print) - but then you get the rest of the web page, and only the part of the report that is currently visible (nothing you have to scroll to see or other pages for multipage reports)
2. Export the report and use another application to print - for instance, export to PDF and print from Adobe Reader.
Basically, the browser knows how to print web pages, Adobe knows how to print PDFs, and RSClientPrint knows how to print SQL 2005 Reports.
MSDN - SQL Server 2005 Books Online - Printing Reports from a Browser:
http://msdn2.microsoft.com/en-us/library/ms159237.aspx
MSDN - SQL Server 2005 Books Online - How to: Configure a Browser for Client-Side Printing (Report Manager)
http://msdn2.microsoft.com/en-us/library/ms159190.aspx
This was enough proof for our marketing department...
-
Mike

RSClientPrint Download

I have an asp.net application which is launched from our B2B site. The primary purpose of the application is to allow our external clients access to reports, along with the ability to export and print. The RS2005 report viewer component was used within the application to render the reports. The problem is when the our client users click on the print button on the report viewer's tool bar, many of them are receiving a window asking them if they want to install "SQL Server". In reality, the ActiveX viewer, RSClientPrint, is what is trying to install. Our technical support staff is being flooded with calls due to this pop up. The users are very confused and concerned about installing "SQL Server." In addition, some users do not have the ability to install the ActiveX viewer, so they are not going to be able to print. We've experienced this in the past with ActiveX for Crystal. Finally, some users receive no message or feedback when they click on the print button for several minutes. We've determined the ActiveX is being installed during this time. We've had users wait as long as 7 minutes for the Print Dialog to come up.

1. We would like to place a message along with the link on the page where the report is rendered. Is there a way for us to provide a link to a self extracting file containing RSClientPrint?

2. Also is there any way to get around the issue where the client user does not have the ability to install the ActiveX? I've seen references on the forum to using SMS, but this is not possible since the users are external?

3. Is there any setting we can turn on so the users don't think the application has gone "out to lunch" while the ActiveX viewer is installed?

Thanks

Anything that Report Manager or the ActiveX control does, you can code yourself using the Reporting Services Web Services. You don't and never did need the ActiveX to view reports. It was added to allow new developers an easy way to add reporting features to applications without needing to know about the Web Services.

What you will find is that at some point, you will need to access Reporting Services in a way that the ActiveX does not support/make easy and you will have to go via the Web Services... now it that time

Regards

Paul

|||

Paul,

Thank you for your quick response. Unfortunately, we avoided this approach on purpose for a number of reasons, one of which was to avoid passing sensitive client customer information on the query string and then having to encrypt it.

We have actually used the RS web service with a RS2000 report for our price lists. However, we liked the ease of use in VS2005 with the report viewer component and the ability to pass parameters internally from the ASP.Net application to the report viewer component which hid sensitive information from potential hackers.

I assume based on your response there is no way for us to provide a link to a self extracting RSClientPrint file or any way to speed up the download and installation time?

Thanks

Carol

|||

Not really. This is one of the 'joys' of working with ActiveX controls.

You only pass details across the query string when you are using URL access to reporting services. The web services use SOAP (XML). You could create a soap extension in .NET to encrypt the data or simply run the web services over SSL.

Cheers

Paul

|||

Paul,

You say "You don't and never did need the ActiveX to view reports".... Are you talking about RSClientPrint? If so...is there any way to print reports (other than browser, or exported) without this ActiveX?

|||

Hi to everyone, actually i have an application to external clients and they will need to be able to print some reports.

After reading some forums, blogs, MSDN KB articles, we discover a way to print automatically theese reports, but it only work if we have thath activex installed.

If you (Paul) say thah we can perform the activity to print reports on Iexplorer using the Reporting Services Web Service, could you give us some orientatio about the methods to use for this activity...

I used this Web Service form rendering reports and show it to the client, but now thath i need to print, the only way i discovered is using the activex.

Greetings !

|||From what I understand, in order to use that print button on the report toolbar, the RSClientPrint ActiveX is required. The only other options for printing are:
1. Using the browser's print functionality (file->print) - but then you get the rest of the web page, and only the part of the report that is currently visible (nothing you have to scroll to see or other pages for multipage reports)
2. Export the report and use another application to print - for instance, export to PDF and print from Adobe Reader.
Basically, the browser knows how to print web pages, Adobe knows how to print PDFs, and RSClientPrint knows how to print SQL 2005 Reports.
MSDN - SQL Server 2005 Books Online - Printing Reports from a Browser:
http://msdn2.microsoft.com/en-us/library/ms159237.aspx
MSDN - SQL Server 2005 Books Online - How to: Configure a Browser for Client-Side Printing (Report Manager)
http://msdn2.microsoft.com/en-us/library/ms159190.aspx
This was enough proof for our marketing department...
-
Mike

rsAccessDenied when accessing Report Server

I have SQLServer 2005 with reporting services running on win 2003 server.
I'm trying to configure SSRS with Anonymous access configured on
ReportServer Web Site and verified NTFS security on ReportServer folder
include Iusr and Iwam with read/execute permmisions
Does ReportServer stand on its own or does the ReportManager Web Site also
need Anonymous access?
Are there any config files that need to be updated?
What am I missing?
IE Message when accessing http://<Server>/ReportServer
The permissions granted to user 'VWIN2003SERVER\IUSR_VWIN2003SERVER' are
insufficient for performing this operation. (rsAccessDenied)
ReportServer Log File
w3wp!library!1!02/15/2006-11:54:17:: i INFO: Catalog SQL Server Edition = Developer
w3wp!library!1!02/15/2006-11:54:17:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException: The
permissions granted to user 'VWIN2003SERVER\IUSR_VWIN2003SERVER' are
insufficient for performing this operation., ;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException: The
permissions granted to user 'VWIN2003SERVER\IUSR_VWIN2003SERVER' are
insufficient for performing this operation.
ReportServerService_Main Log File
ReportingServicesService!library!4!2/15/2006-08:54:25:: i INFO: Initializing
ConnectionType to '0' as specified in Configuration file.
ReportingServicesService!library!4!2/15/2006-08:54:25:: i INFO: Initializing
IsSchedulingService to 'True' as specified in Configuration file.
ReportingServicesService!library!4!2/15/2006-08:54:25:: i INFO: Initializing
IsNotificationService to 'True' as specified in Configuration file.
ReportingServicesService!library!4!2/15/2006-08:54:25:: i INFO: Initializing
IsEventService to 'True' as specified in Configuration file.
ReportingServicesService!library!4!2/15/2006-08:54:25:: i INFO: Initializing
PollingInterval to '10' second(s) as specified in Configuration file.
ReportingServicesService!library!4!2/15/2006-08:54:25:: i INFO: Initializing
WindowsServiceUseFileShareStorage to 'False' as specified in Configuration
file.
ReportingServicesService!library!4!2/15/2006-08:54:25:: i INFO: Initializing
MemoryLimit to '60' percent as specified in Configuration file.
ReportingServicesService!library!4!2/15/2006-08:54:25:: i INFO: Initializing
RecycleTime to '720' minute(s) as specified in Configuration file.
ReportingServicesService!library!4!2/15/2006-08:54:25:: i INFO: Initializing
MaximumMemoryLimit to '80' percent as specified in Configuration file.
ReportingServicesService!library!4!2/15/2006-08:54:25:: i INFO: Initializing
MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration file.
ReportingServicesService!library!4!2/15/2006-08:54:25:: i INFO: Initializing
MaxQueueThreads to '0' thread(s) as specified in Configuration file.
ReportingServicesService!library!4!2/15/2006-08:54:25:: i INFO: Initializing
IsWebServiceEnabled to 'True' as specified in Configuration file.
ReportingServicesService!library!4!2/15/2006-08:54:25:: i INFO: Initializing
MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration
file.
ReportingServicesService!library!4!2/15/2006-08:54:25:: i INFO: Initializing
MaxScheduleWait to '5' second(s) as specified in Configuration file.
ReportingServicesService!library!4!2/15/2006-08:54:25:: i INFO: Initializing
DatabaseQueryTimeout to '120' second(s) as specified in Configuration file.
ReportingServicesService!library!4!2/15/2006-08:54:25:: i INFO: Initializing
ProcessRecycleOptions to '0' as specified in Configuration file.
ReportingServicesService!library!4!2/15/2006-08:54:25:: i INFO: Initializing
RunningRequestsScavengerCycle to '60' second(s) as specified in
Configuration file.
ReportingServicesService!library!4!2/15/2006-08:54:25:: i INFO: Initializing
RunningRequestsDbCycle to '60' second(s) as specified in Configuration file.
ReportingServicesService!library!4!2/15/2006-08:54:25:: i INFO: Initializing
RunningRequestsAge to '30' second(s) as specified in Configuration file.
ReportingServicesService!library!4!2/15/2006-08:54:25:: i INFO: Initializing
CleanupCycleMinutes to '10' minute(s) as specified in Configuration file.
ReportingServicesService!library!4!2/15/2006-08:54:25:: i INFO: Initializing
DailyCleanupMinuteOfDay to default value of '120' minutes since midnight
because it was not specified in Configuration file.
ReportingServicesService!library!4!2/15/2006-08:54:25:: i INFO: Initializing
WatsonFlags to '1064' as specified in Configuration file.
ReportingServicesService!library!4!2/15/2006-08:54:25:: i INFO: Initializing
WatsonDumpOnExceptions to
'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException'
as specified in Configuration file.
ReportingServicesService!library!4!2/15/2006-08:54:25:: i INFO: Initializing
WatsonDumpExcludeIfContainsExceptions to
'System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException'
as specified in Configuration file.
ReportingServicesService!library!4!2/15/2006-08:54:25:: i INFO: Initializing
SecureConnectionLevel to '0' as specified in Configuration file.
ReportingServicesService!library!4!2/15/2006-08:54:25:: i INFO: Initializing
DisplayErrorLink to 'True' as specified in Configuration file.
ReportingServicesService!library!4!2/15/2006-08:54:25:: i INFO: Initializing
WebServiceUseFileShareStorage to 'False' as specified in Configuration
file.
ReportingServicesService!servicecontroller!9!2/15/2006-08:54:31:: Total
Physical memory: 685219840
ReportingServicesService!servicecontroller!4!2/15/2006-08:54:31:: i INFO:
RPC Server started. Endpoint name ='ReportingServices$MSSQL.3'
ReportingServicesService!library!d!2/15/2006-08:57:45:: i INFO: Catalog SQL
Server Edition = Developer
ReportingServicesService!resourceutilities!d!2/15/2006-08:57:45:: i INFO:
Reporting Services starting SKU: Developer
ReportingServicesService!resourceutilities!d!2/15/2006-08:57:45:: i INFO:
Evaluation copy: 0 days left
ReportingServicesService!library!e!2/15/2006-08:57:45:: i INFO: Catalog SQL
Server Edition = Developer
ReportingServicesService!library!f!2/15/2006-08:57:45:: i INFO: Catalog SQL
Server Edition = Developer
ReportingServicesService!crypto!d!2/15/2006-08:57:45:: i INFO: Initializing
crypto as user: NT AUTHORITY\SYSTEM
ReportingServicesService!crypto!d!2/15/2006-08:57:46:: i INFO: Exporting
public key
ReportingServicesService!crypto!d!2/15/2006-08:57:46:: i INFO: Performing
sku validation
ReportingServicesService!crypto!d!2/15/2006-08:57:46:: i INFO: Importing
existing encryption key
Thanks
Marc BumgarnerNo a good idea (anonymous access). As soon as you do this you will find out
that you have lost all admin rights even when you are an administrator on
the box. Why? Because it is anonymous, RS does not know who you are.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Marc Bumgarner" <mbumgarner@.ecomponentstech.com> wrote in message
news:8P6dnaUqm6P1Gm7enZ2dnUVZ_sidnZ2d@.mt.net...
>I have SQLServer 2005 with reporting services running on win 2003 server.
> I'm trying to configure SSRS with Anonymous access configured on
> ReportServer Web Site and verified NTFS security on ReportServer folder
> include Iusr and Iwam with read/execute permmisions
> Does ReportServer stand on its own or does the ReportManager Web Site also
> need Anonymous access?
> Are there any config files that need to be updated?
> What am I missing?
>
> IE Message when accessing http://<Server>/ReportServer
> The permissions granted to user 'VWIN2003SERVER\IUSR_VWIN2003SERVER' are
> insufficient for performing this operation. (rsAccessDenied)
>
> ReportServer Log File
> w3wp!library!1!02/15/2006-11:54:17:: i INFO: Catalog SQL Server Edition => Developer
> w3wp!library!1!02/15/2006-11:54:17:: e ERROR: Throwing
> Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException:
> The permissions granted to user 'VWIN2003SERVER\IUSR_VWIN2003SERVER' are
> insufficient for performing this operation., ;
> Info:
> Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException:
> The permissions granted to user 'VWIN2003SERVER\IUSR_VWIN2003SERVER' are
> insufficient for performing this operation.
>
> ReportServerService_Main Log File
>
> ReportingServicesService!library!4!2/15/2006-08:54:25:: i INFO:
> Initializing ConnectionType to '0' as specified in Configuration file.
> ReportingServicesService!library!4!2/15/2006-08:54:25:: i INFO:
> Initializing IsSchedulingService to 'True' as specified in Configuration
> file.
> ReportingServicesService!library!4!2/15/2006-08:54:25:: i INFO:
> Initializing IsNotificationService to 'True' as specified in
> Configuration file.
> ReportingServicesService!library!4!2/15/2006-08:54:25:: i INFO:
> Initializing IsEventService to 'True' as specified in Configuration file.
> ReportingServicesService!library!4!2/15/2006-08:54:25:: i INFO:
> Initializing PollingInterval to '10' second(s) as specified in
> Configuration file.
> ReportingServicesService!library!4!2/15/2006-08:54:25:: i INFO:
> Initializing WindowsServiceUseFileShareStorage to 'False' as specified in
> Configuration file.
> ReportingServicesService!library!4!2/15/2006-08:54:25:: i INFO:
> Initializing MemoryLimit to '60' percent as specified in Configuration
> file.
> ReportingServicesService!library!4!2/15/2006-08:54:25:: i INFO:
> Initializing RecycleTime to '720' minute(s) as specified in Configuration
> file.
> ReportingServicesService!library!4!2/15/2006-08:54:25:: i INFO:
> Initializing MaximumMemoryLimit to '80' percent as specified in
> Configuration file.
> ReportingServicesService!library!4!2/15/2006-08:54:25:: i INFO:
> Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in
> Configuration file.
> ReportingServicesService!library!4!2/15/2006-08:54:25:: i INFO:
> Initializing MaxQueueThreads to '0' thread(s) as specified in
> Configuration file.
> ReportingServicesService!library!4!2/15/2006-08:54:25:: i INFO:
> Initializing IsWebServiceEnabled to 'True' as specified in Configuration
> file.
> ReportingServicesService!library!4!2/15/2006-08:54:25:: i INFO:
> Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in
> Configuration file.
> ReportingServicesService!library!4!2/15/2006-08:54:25:: i INFO:
> Initializing MaxScheduleWait to '5' second(s) as specified in
> Configuration file.
> ReportingServicesService!library!4!2/15/2006-08:54:25:: i INFO:
> Initializing DatabaseQueryTimeout to '120' second(s) as specified in
> Configuration file.
> ReportingServicesService!library!4!2/15/2006-08:54:25:: i INFO:
> Initializing ProcessRecycleOptions to '0' as specified in Configuration
> file.
> ReportingServicesService!library!4!2/15/2006-08:54:25:: i INFO:
> Initializing RunningRequestsScavengerCycle to '60' second(s) as specified
> in Configuration file.
> ReportingServicesService!library!4!2/15/2006-08:54:25:: i INFO:
> Initializing RunningRequestsDbCycle to '60' second(s) as specified in
> Configuration file.
> ReportingServicesService!library!4!2/15/2006-08:54:25:: i INFO:
> Initializing RunningRequestsAge to '30' second(s) as specified in
> Configuration file.
> ReportingServicesService!library!4!2/15/2006-08:54:25:: i INFO:
> Initializing CleanupCycleMinutes to '10' minute(s) as specified in
> Configuration file.
> ReportingServicesService!library!4!2/15/2006-08:54:25:: i INFO:
> Initializing DailyCleanupMinuteOfDay to default value of '120' minutes
> since midnight because it was not specified in Configuration file.
> ReportingServicesService!library!4!2/15/2006-08:54:25:: i INFO:
> Initializing WatsonFlags to '1064' as specified in Configuration file.
> ReportingServicesService!library!4!2/15/2006-08:54:25:: i INFO:
> Initializing WatsonDumpOnExceptions to
> 'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException'
> as specified in Configuration file.
> ReportingServicesService!library!4!2/15/2006-08:54:25:: i INFO:
> Initializing WatsonDumpExcludeIfContainsExceptions to
> 'System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException'
> as specified in Configuration file.
> ReportingServicesService!library!4!2/15/2006-08:54:25:: i INFO:
> Initializing SecureConnectionLevel to '0' as specified in Configuration
> file.
> ReportingServicesService!library!4!2/15/2006-08:54:25:: i INFO:
> Initializing DisplayErrorLink to 'True' as specified in Configuration
> file.
> ReportingServicesService!library!4!2/15/2006-08:54:25:: i INFO:
> Initializing WebServiceUseFileShareStorage to 'False' as specified in
> Configuration file.
> ReportingServicesService!servicecontroller!9!2/15/2006-08:54:31:: Total
> Physical memory: 685219840
> ReportingServicesService!servicecontroller!4!2/15/2006-08:54:31:: i INFO:
> RPC Server started. Endpoint name ='ReportingServices$MSSQL.3'
> ReportingServicesService!library!d!2/15/2006-08:57:45:: i INFO: Catalog
> SQL Server Edition = Developer
> ReportingServicesService!resourceutilities!d!2/15/2006-08:57:45:: i INFO:
> Reporting Services starting SKU: Developer
> ReportingServicesService!resourceutilities!d!2/15/2006-08:57:45:: i INFO:
> Evaluation copy: 0 days left
> ReportingServicesService!library!e!2/15/2006-08:57:45:: i INFO: Catalog
> SQL Server Edition = Developer
> ReportingServicesService!library!f!2/15/2006-08:57:45:: i INFO: Catalog
> SQL Server Edition = Developer
> ReportingServicesService!crypto!d!2/15/2006-08:57:45:: i INFO:
> Initializing crypto as user: NT AUTHORITY\SYSTEM
> ReportingServicesService!crypto!d!2/15/2006-08:57:46:: i INFO: Exporting
> public key
> ReportingServicesService!crypto!d!2/15/2006-08:57:46:: i INFO: Performing
> sku validation
> ReportingServicesService!crypto!d!2/15/2006-08:57:46:: i INFO: Importing
> existing encryption key
>
> Thanks
> Marc Bumgarner
>

rsAccessDenied for authorised user.

Hi, as many people in this group, I have the problem that some users
cannot access the report we designed. They receive the message:
The permissions granted to user '{domain}\{userID}' are insufficient
for performing
this operation. (rsAccessDenied)
The strange thing here is that I granted access to a group (Domain
Users) which holds all the users of this domain. I tested with 3 users
who all could access the report. Of course I thought that if these
users could access the report, other users should be able to access the
report too. But, when I tested with a fourth user I got the error as
stated above. I checked the rights for the group on the folders and
reports, but they are ok. So what am I misssing here?
I also tried to sign individual rights to the userId, but no luck
either. Then I tried to use an other userId too (fith userid for the
test) , same result, no access. So in my group "Domain Users" , which
holds all the users of the domain. Three users can access the report
and so far two can not. I didn't test with other accounts except for
these 5, that should be enough, don't you think?
We do not use "Anonymous Access" anywhere.
The server is Standard 2003
MS SQL 2000
Reporting Services 2000
Any help would be appriciatedOk, found out what the problem was. I didn't set the right permissions
on the top-level. So, first I had to set de security permissions in RS
on te "root"-folder, then on the subfolders and so on to the reports.
This solved my problemsql

RS2005 access over internet?

Hi,

is it possible to make the RS2005 available over Internet?

Someone knows a guidance or tutorial in the Internet?

Thanks Stefan

What exactly do you want in RS2005 to be available over the Internet?

You can always access the reports by visiting:

http://serverName/ReportServer?/FolderName/ReportName&rs:Command=render

|||

See Tudor's blog:

http://blogs.msdn.com/tudortr/archive/2005/11/03/488731.aspx

RS2005 Access Error Using Report Manager Via DNS

PROBLEM:
Created a DNS entry (reportsdev) to access reporting services.
I can NOT ACCESS the report manager and receive an error
http://reportsdev/Reports$SQLServer2005/Pages/Folder.aspx
I CAN ACCESS the report server with out a problem via IE and VS2005.
http://reportsdev/ReportServer$SQLServer2005
ERROR:
â'The attempt to connect to the report server failed. Check your connection
information and that the report server is a compatible version.â'
This is a reporting services error with the reporting services UI wrapped
around the error and the link to Home. Clicking the link to Home generates
the same error.
NOTES & Tentative Solution:
I CAN ACCESS the report manager by configuring the report site with a port
rather then host header.
http://dc13:900/Reports$SQLServer2005/Pages/Folder.aspx
If I restart IIS and then access the report manager using the DNS an error
is logged in the Application Log â'Report Manager cannot connect to the
ReportServer service.â'
Configuration:
Windows 2000, Side by side install of SQL 2000 and SQL 2005 (New clean
install of 2005). RS2000 was on the machine until a restore but after the
restore was not reinstalled the RS2000 databases have been removed from
SQL2000 after the restore.
Any help is appreciated,
TedTed,
Did you update the entry in RSWebApplication.config to match your
report server DNS entry?
Andy Potter|||the same problem persists to me although i have modified the entry in
RSWebApplication.config
when I first installed the reporting services 2005, I wanted to use as
server the older one (sql + reporting 2000). I couldn't figure out what's the
problem and I thought that may be an incompatibility beteen sql 200 and
RS2005 and RS 2000 all toghther on the same server. After this I have
installed a new instance of SQL 2005 and the RS 2005...but I had the same
error (The attempt to connect to the report server failed. Check your
connection
information and that the report server is a compatible version)
...until I droped the ideea of using host header (right now I use a simple
asp page to redirect...but this is not the final solution that I want).
still, I want to use a host header...anyone figure it out how to?
"Potter" wrote:
> Ted,
> Did you update the entry in RSWebApplication.config to match your
> report server DNS entry?
> Andy Potter
>|||I am havin the same problem!
I am having problems trying to deploy a report from VS2005 to SSRS 2005. We
are using Windows Server 2003 SP1. I get the following error:
Microsoft Report Designer
A connection could not be made to the report server
Check your connection information and that the report server is a compatible
version.
nickpup
"tbarton" wrote:
> PROBLEM:
> Created a DNS entry (reportsdev) to access reporting services.
> I can NOT ACCESS the report manager and receive an error
> http://reportsdev/Reports$SQLServer2005/Pages/Folder.aspx
> I CAN ACCESS the report server with out a problem via IE and VS2005.
> http://reportsdev/ReportServer$SQLServer2005
>
> ERROR:
> â'The attempt to connect to the report server failed. Check your connection
> information and that the report server is a compatible version.â'
> This is a reporting services error with the reporting services UI wrapped
> around the error and the link to Home. Clicking the link to Home generates
> the same error.
>
> NOTES & Tentative Solution:
> I CAN ACCESS the report manager by configuring the report site with a port
> rather then host header.
> http://dc13:900/Reports$SQLServer2005/Pages/Folder.aspx
> If I restart IIS and then access the report manager using the DNS an error
> is logged in the Application Log â'Report Manager cannot connect to the
> ReportServer service.â'
>
> Configuration:
> Windows 2000, Side by side install of SQL 2000 and SQL 2005 (New clean
> install of 2005). RS2000 was on the machine until a restore but after the
> restore was not reinstalled the RS2000 databases have been removed from
> SQL2000 after the restore.
> Any help is appreciated,
> Ted
>|||I finally managed to solve this problem
open SQl Books Online at this page:
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/rptsrvr9/html/a0134ef0-086c-443e-93b9-7213a3d76393.htm
and check the explanations about ReportServerVirtualDirectory and
ReportServerUrl
"ReportServerUrl and ReportServerVirtualDirectory are mutually exclusive. If
you specify ReportServerUrl, you must delete the entry for
ReportServerVirtualDirectory"
"nickpup" wrote:
> I am havin the same problem!
> I am having problems trying to deploy a report from VS2005 to SSRS 2005. We
> are using Windows Server 2003 SP1. I get the following error:
> Microsoft Report Designer
> A connection could not be made to the report server
> Check your connection information and that the report server is a compatible
> version.
> nickpup
>
> "tbarton" wrote:
> > PROBLEM:
> > Created a DNS entry (reportsdev) to access reporting services.
> > I can NOT ACCESS the report manager and receive an error
> > http://reportsdev/Reports$SQLServer2005/Pages/Folder.aspx
> >
> > I CAN ACCESS the report server with out a problem via IE and VS2005.
> > http://reportsdev/ReportServer$SQLServer2005
> >
> >
> > ERROR:
> > â'The attempt to connect to the report server failed. Check your connection
> > information and that the report server is a compatible version.â'
> >
> > This is a reporting services error with the reporting services UI wrapped
> > around the error and the link to Home. Clicking the link to Home generates
> > the same error.
> >
> >
> > NOTES & Tentative Solution:
> > I CAN ACCESS the report manager by configuring the report site with a port
> > rather then host header.
> > http://dc13:900/Reports$SQLServer2005/Pages/Folder.aspx
> >
> > If I restart IIS and then access the report manager using the DNS an error
> > is logged in the Application Log â'Report Manager cannot connect to the
> > ReportServer service.â'
> >
> >
> > Configuration:
> > Windows 2000, Side by side install of SQL 2000 and SQL 2005 (New clean
> > install of 2005). RS2000 was on the machine until a restore but after the
> > restore was not reinstalled the RS2000 databases have been removed from
> > SQL2000 after the restore.
> >
> > Any help is appreciated,
> >
> > Ted
> >|||also check this page:
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/rptsrvr9/html/1571c3fb-53a1-4bdd-bde6-0b8d490bf823.htm
"dragoon" wrote:
> I finally managed to solve this problem
> open SQl Books Online at this page:
> ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/rptsrvr9/html/a0134ef0-086c-443e-93b9-7213a3d76393.htm
> and check the explanations about ReportServerVirtualDirectory and
> ReportServerUrl
> "ReportServerUrl and ReportServerVirtualDirectory are mutually exclusive. If
> you specify ReportServerUrl, you must delete the entry for
> ReportServerVirtualDirectory"
> "nickpup" wrote:
> > I am havin the same problem!
> >
> > I am having problems trying to deploy a report from VS2005 to SSRS 2005. We
> > are using Windows Server 2003 SP1. I get the following error:
> >
> > Microsoft Report Designer
> >
> > A connection could not be made to the report server
> >
> > Check your connection information and that the report server is a compatible
> > version.
> >
> > nickpup
> >
> >
> > "tbarton" wrote:
> >
> > > PROBLEM:
> > > Created a DNS entry (reportsdev) to access reporting services.
> > > I can NOT ACCESS the report manager and receive an error
> > > http://reportsdev/Reports$SQLServer2005/Pages/Folder.aspx
> > >
> > > I CAN ACCESS the report server with out a problem via IE and VS2005.
> > > http://reportsdev/ReportServer$SQLServer2005
> > >
> > >
> > > ERROR:
> > > â'The attempt to connect to the report server failed. Check your connection
> > > information and that the report server is a compatible version.â'
> > >
> > > This is a reporting services error with the reporting services UI wrapped
> > > around the error and the link to Home. Clicking the link to Home generates
> > > the same error.
> > >
> > >
> > > NOTES & Tentative Solution:
> > > I CAN ACCESS the report manager by configuring the report site with a port
> > > rather then host header.
> > > http://dc13:900/Reports$SQLServer2005/Pages/Folder.aspx
> > >
> > > If I restart IIS and then access the report manager using the DNS an error
> > > is logged in the Application Log â'Report Manager cannot connect to the
> > > ReportServer service.â'
> > >
> > >
> > > Configuration:
> > > Windows 2000, Side by side install of SQL 2000 and SQL 2005 (New clean
> > > install of 2005). RS2000 was on the machine until a restore but after the
> > > restore was not reinstalled the RS2000 databases have been removed from
> > > SQL2000 after the restore.
> > >
> > > Any help is appreciated,
> > >
> > > Ted
> > >

RS2000: Failure sending mail: Cannot access a closed file...

SQL Server 2000, RS2000...
I have 2 timed subscriptions to the same report. One of the
subscriptions delivers the report via Report Server Email, the other
via File share.
If I choose PDF orWeb Archive as the deliverable then then both
reports work. If I choose Excel, I get the following error message
posted on the Report Server next to Status when I look at both
subscriptions to the report.
Any idea what is happening?
Thanks,
KeithOn Feb 1, 5:29 pm, 1300...@.gmail.com wrote:
> SQL Server 2000, RS2000...
> I have 2 timed subscriptions to the same report. One of the
> subscriptions delivers the report via Report Server Email, the other
> via File share.
> If I choose PDF orWeb Archive as the deliverable then then both
> reports work. If I choose Excel, I get the following error message
> posted on the Report Server next to Status when I look at both
> subscriptions to the report.
Guess including the error might help!
Failure sending mail: Cannot access a closed file
> Any idea what is happening?
> Thanks,
> Keith

RS2000 Cannot find server or DNS

I have installed Reporting Services 2000 SP2 and Windows Server2000 SP4.
At first access from the Client-PC (Windows XP SP2) with
http://myserver/Reports
I get always a
"Cannot find server or DNS"
error.
With Second Start Internet Explorer with http://myserver/Reports
the ReportServer works perfect.
Thanks for a tip.
ReinfriedI'm having a similar problem with RS 2000 SP2. Was there any resolution to
this?
Andrew.
"Reinfried" wrote:
> I have installed Reporting Services 2000 SP2 and Windows Server2000 SP4.
> At first access from the Client-PC (Windows XP SP2) with
> http://myserver/Reports
> I get always a
> "Cannot find server or DNS"
> error.
> With Second Start Internet Explorer with http://myserver/Reports
> the ReportServer works perfect.
> Thanks for a tip.
> Reinfried
>

rs:ParameterLanguage URL access parameter

We tried setting rs:ParameterLanguage=en-US in the URL so international
users dates would stay in the MM/DD/YYYY format but it isn't working. We
have SP1 installed. Has anyone used this parameter successfully and if so
do you have any suggestions? Please help, our customers in the UK would
like to be able to view their reports. Thanks!Hi,
You can test this online on internet:
http://128.171.208.112/ReportServer?/Product%20Line%20Sales&rs:Command=Render&rc:zoom=100&rc:Parameters=True&rs:ParameterLanguage=en-us
Just add a new end date as parameter and press View.
Regards,
Marco Groeneveld
www.gmsbv.nl - your partner for MS Analyses and Reporting Services in
Europe !
"Jessica C" <jesscobbe@.hotmail.com> wrote in message news:<#JDcgRneEHA.2560@.TK2MSFTNGP09.phx.gbl>...
> We tried setting rs:ParameterLanguage=en-US in the URL so international
> users dates would stay in the MM/DD/YYYY format but it isn't working. We
> have SP1 installed. Has anyone used this parameter successfully and if so
> do you have any suggestions? Please help, our customers in the UK would
> like to be able to view their reports. Thanks!|||I'm having the same problem. I used the URL Access Parameter
"rs:ParameterLanguage=en-us" and the dates aren't coming out right. If I
select August 24, 2004 - instead of 8/24/2004 (how it should be), it
displays as 24/8/2004 which causes an error. I have SP1 installed, using
datetime for the parameter data type, using the ParameterLanguage parameter,
and it's still showing up backwards. Have you found a solution to this?
"Jessica C" <jesscobbe@.hotmail.com> wrote in message
news:#JDcgRneEHA.2560@.TK2MSFTNGP09.phx.gbl...
> We tried setting rs:ParameterLanguage=en-US in the URL so international
> users dates would stay in the MM/DD/YYYY format but it isn't working. We
> have SP1 installed. Has anyone used this parameter successfully and if so
> do you have any suggestions? Please help, our customers in the UK would
> like to be able to view their reports. Thanks!
>

RS URL access

Is URL access possible using SQL Server Standard Edition?

Assuming you are talking about accessing Reporting Services via URL access, it is supported in all editions. If you are talking about HTTP endpoints in the database, they are supported in standard and enterprise.

See http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx for full edition differences.|||It is RS but SQL Server 2000 not 2005.|||yes. if you still have not found out. I use 2000 version too because we have not got around to getting updated.

RS on SSL losing querystring in URL

Hi,
This is a live problem that Iam facing,
There is this internet application (in SSL) which I deployed at my
Client which access reports by calling something like
https://in4suite.symphonysv.com/ReportServer?/reports/ChangeInDealSizeReport&rs:Command=Render&userid=3®ionid=0
Here is the THE PROBLEM.
After I call the report (by clicking a link in the application) in the
INTERNET application, it opens well taking the default values. When I
change one value in any of the parameters, the parameter toolbar hangs
with the white blank screen. There is no postback happening or it is
hanging at the post back. So The customer cant do anything except see
the report for the default values.
I did this research. I called a report, When I right-clicked on the
report page to see the Properties window, I noticed that the parameters
in the URL which were supposed to be passed are not there. So the
Address:URL looked like this
https://in4suite.symphonysv.com/ReportServer?%2freports%
It does not carry any info on the URL except the report folder. So I
believe this is why the report is hanging. So this means the
querystring is being lost.
What is the workaround or trick to let the URL in full be available
after calling the report the first time. This will help the post back
occur Iam sure.
Help Please.
Anand Sagar
In4VelocityNo WAIT !!
I was wrong. The complete URL qureystring is still there. It does not
lose the querystring, I was not scrolling down completely.
The reason for the problem is something else.|||Here is the actual problem.
Iam passing a parameter '&userid=3' in the URL when I first call the
report. The report shows up fine. Then when I change any other
parameter value in the report parameters UI, a post back occurs and the
report hangs. I noticed that when I drag down the separator between the
parameter area and the report area, I see another report page behind
which says
"This report requires a default or user-defined value for the report
parameter 'userid'. To run or subscribe to this report, you must
provide a parameter value. (rsReportParameterValueNotSet)"
So this means when a postback occurs, the default parameter in the URL
is lost. Why does this happen. Any ideas ? The report server is in SSL.
Is this an issue ?
Thanks,
Anand Sagar

RS Lag on First Report

When I first call for a report (from URL access or called from ASP 3.0), it
takes about 10 seconds before it appears. Subsequent reports take less than
a second to appear. I'm not really sure where this lag is likely to come
from, e.g. IIS, RS, SQL Server, etc.
Where and how do I configure RS to stay "alive" longer once started (session
expiration? compile options?) and also to decrease the lag time for the
first report? Since my application is used 24x7 as far as I'm concerned it
should always be ready and quick.
Thanks.This is due to IIS.
Go to IIS Manager, under Applocation Pools node, right click
"DefaultAppPool" in which the Reporting Server work process is running,
select properties. On "Performace" tag, you will see, by default, the app
pool will shut down if > being idle for 20 min. You can extend this time to
8x60min 480min, so that the app pool will not shut down for a regular
working day. However, the first report reader of the day, will hit the
delay. You may schedule a dummy report at beginning of a work day for this.
If you have any activity at all then users should never see a delay.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Don Miller" <nospam@.nospam.com> wrote in message
news:utx6vFLHIHA.3548@.TK2MSFTNGP06.phx.gbl...
> When I first call for a report (from URL access or called from ASP 3.0),
> it takes about 10 seconds before it appears. Subsequent reports take less
> than a second to appear. I'm not really sure where this lag is likely to
> come from, e.g. IIS, RS, SQL Server, etc.
> Where and how do I configure RS to stay "alive" longer once started
> (session expiration? compile options?) and also to decrease the lag time
> for the first report? Since my application is used 24x7 as far as I'm
> concerned it should always be ready and quick.
> Thanks.
>|||Thanks.
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:eZ5PEWLHIHA.700@.TK2MSFTNGP05.phx.gbl...
> This is due to IIS.
> Go to IIS Manager, under Applocation Pools node, right click
> "DefaultAppPool" in which the Reporting Server work process is running,
> select properties. On "Performace" tag, you will see, by default, the app
> pool will shut down if > being idle for 20 min. You can extend this time
> to 8x60min 480min, so that the app pool will not shut down for a regular
> working day. However, the first report reader of the day, will hit the
> delay. You may schedule a dummy report at beginning of a work day for
> this.
> If you have any activity at all then users should never see a delay.
>
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Don Miller" <nospam@.nospam.com> wrote in message
> news:utx6vFLHIHA.3548@.TK2MSFTNGP06.phx.gbl...
>> When I first call for a report (from URL access or called from ASP 3.0),
>> it takes about 10 seconds before it appears. Subsequent reports take less
>> than a second to appear. I'm not really sure where this lag is likely to
>> come from, e.g. IIS, RS, SQL Server, etc.
>> Where and how do I configure RS to stay "alive" longer once started
>> (session expiration? compile options?) and also to decrease the lag time
>> for the first report? Since my application is used 24x7 as far as I'm
>> concerned it should always be ready and quick.
>> Thanks.
>

RS installation Problem on Win2000

Hi,
I try to install reporting services on win2000 (sp4), everything went well.
when I try to access reports folder http://servername/reports I am getting
the follwoing error.
server has VS.NET 2003 and all latest service packs. I am trying for past
one three days to resolve this problem.
T I A.,
Nemani
Server Error in '/Reports' Application.
----
--
Configuration Error
Description: An error occurred during the processing of a configuration file
required to service this request. Please review the specific error details
below and modify your configuration file appropriately.
Parser Error Message: The XML file
c:\winnt\microsoft.net\framework\v1.1.4322\Config\machine.config could not
be loaded. Attempted to access an unloaded AppDomain.
Source Error:
[No relevant source lines]
Source File:
c:\winnt\microsoft.net\framework\v1.1.4322\Config\machine.config Line: 0Can you access http://servername/reportserver? It sounds like the ASP.NET
identity does not have access to the configuration files.
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Nemani" <mnemani@.che.state.nm.us> wrote in message
news:eXNhiJEYEHA.2672@.TK2MSFTNGP09.phx.gbl...
> Hi,
> I try to install reporting services on win2000 (sp4), everything went
> well.
> when I try to access reports folder http://servername/reports I am getting
> the follwoing error.
> server has VS.NET 2003 and all latest service packs. I am trying for past
> one three days to resolve this problem.
> T I A.,
> Nemani
> Server Error in '/Reports' Application.
> ----
> --
> Configuration Error
> Description: An error occurred during the processing of a configuration
> file
> required to service this request. Please review the specific error details
> below and modify your configuration file appropriately.
> Parser Error Message: The XML file
> c:\winnt\microsoft.net\framework\v1.1.4322\Config\machine.config could not
> be loaded. Attempted to access an unloaded AppDomain.
> Source Error:
>
> [No relevant source lines]
>
> Source File:
> c:\winnt\microsoft.net\framework\v1.1.4322\Config\machine.config Line:
> 0
>|||Thank you for your response.
Yes, I can access http://servername/reportserver . I explicitly gave
permission to ASPNET account on Reports folder too. Still the error is same.
When I first installed the RS on the machine at that time it doesn't have
the Visual Studion.NET 2003, all it has is IIS, SQL 2000 (sp3a). I installed
the RS but it didn't worked. Then I installed Visual Studion.NET 2003 on the
machine but still the same problem.
Is Visual Studion.NET 2003 is madatory in order to run RS.
Thanks,
Nemani.
"Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in message
news:Ok2qp5MYEHA.2868@.TK2MSFTNGP09.phx.gbl...
> Can you access http://servername/reportserver? It sounds like the ASP.NET
> identity does not have access to the configuration files.
> --
> Brian Welcker
> Group Program Manager
> SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> "Nemani" <mnemani@.che.state.nm.us> wrote in message
> news:eXNhiJEYEHA.2672@.TK2MSFTNGP09.phx.gbl...
> > Hi,
> > I try to install reporting services on win2000 (sp4), everything went
> > well.
> > when I try to access reports folder http://servername/reports I am
getting
> > the follwoing error.
> > server has VS.NET 2003 and all latest service packs. I am trying for
past
> > one three days to resolve this problem.
> >
> > T I A.,
> > Nemani
> > Server Error in '/Reports' Application.
> ----
--
> > --
> >
> > Configuration Error
> > Description: An error occurred during the processing of a configuration
> > file
> > required to service this request. Please review the specific error
details
> > below and modify your configuration file appropriately.
> >
> > Parser Error Message: The XML file
> > c:\winnt\microsoft.net\framework\v1.1.4322\Config\machine.config could
not
> > be loaded. Attempted to access an unloaded AppDomain.
> >
> > Source Error:
> >
> >
> > [No relevant source lines]
> >
> >
> > Source File:
> > c:\winnt\microsoft.net\framework\v1.1.4322\Config\machine.config
Line:
> > 0
> >
> >
>

RS Install fails with HRESULT: 2147942405

I previously had RS installed and working fine. Recently I tried to access
the local reporting server instance on my development machine and noticed
that it wasn't working. One thing led to another and I ended up uninstalling
RS and then found that I couldn't re-install it. The end of the "RS Setup
Bootstrap" log file shows the following:
---
WorkDir=D:\ENGLISH\SQL2000\REPORTING_SERVICES\DEV
}} {n:\rosetta\dev\src\everettsetup\sqlcu\dll\scusetupmgr.cpp:292}
ScuProgressDlg::SetupFinished()
ScuProgressDlg::DialogProc() installation done... waiting for setup mgr
SCU_SetupMgr::svc() finished. SetupMgr: state=FINISHED, cancel_state=0,
is_done=1, ActionRequired=1, NeedReboot=0, custom_props={AutoStart=true
HandleReboots=false
ModuleDir=D:\ENGLISH\SQL2000\REPORTING_SERVICES\DEV
QuietMode=false
Unattended=false
WorkDir=D:\ENGLISH\SQL2000\REPORTING_SERVICES\DEV
}} {n:\rosetta\dev\src\everettsetup\sqlcu\dll\scusetupmgr.cpp:420}
<EndFunc Name='UpdateComponents' Return='0' GetLastError='0'>
<Func Name='DwLaunchMsiExec'>
<Func Name='PerformDetections'>
0
Failed to find property in cache: InstalledInstances
Failed to perform discovery on machine: JCHORLTON4
HRESULT: 2147942405
<EndFunc Name='PerformDetections' Return='2' GetLastError='183'>
<Func Name='FSetupLogging'>
<Func Name='CreateSetupLogCabs'>
Creating Setup Logs Cab "C:\Program Files\Microsoft SQL Server\80\RS Setup
Bootstrap\LOG\RSStp_.cab"
---
I found a similar bug article
(http://support.microsoft.com/default.aspx?scid=kb;en-us;897020) but this
doesn't seem to affect my install.
I currently have SQL 2000 Developer installed and running under the system
account and there are no traces of previous RS installs that I can find on my
system but the Reporting Services install still fails right after it installs
the "Setup Support Files". Has anyone else seen this?Has anyone seen this problem? I've done everything to my machine that I can
think of and nothing seems to cure it. I talked to MS support and they have
records of similar problems but the only cure they have is to rebuild the
entire machine. This is not my preferred cure since this machine is a dev
machine and will take several days to rebuild. We've also had this happen to
another machine here so this can't be that uncommon.
The weird thing is that SQL Server 2000 and MSDE both install with no
problems it's just the Reporting Services install that craps out. I'm
thinking that this is just another one of Microsoft's poorly written installs
that corrupts Windows somehow.

RS deactivated after upgrade from Win 2000 to W2k3

Hi,
After I have upgraded my server, RS stop working .
a.. The report server cannot decrypt the symmetric key used to access
sensitive or encrypted data in a report server database. You must either
restore a backup key or delete all encrypted content and then restart the
service. Check the documentation for more information.
(rsReportServerDisabled) Get Online Help
a.. Bad Data.
I have the Key (exported using the rskeymgmt utility)
But I can't reapply the key:
an "Unable to connect to the database" error appear when I try to reapply
the key.
I have lost a document on the Microsoft web site which explain the entire
process to reactivate RS.
Anyone has the link?
or can explain the procedure?
thanks
Jerome.You may need to use rsconfig to reset that database connection if it is
having issues:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsuiref/htm/cpu_rsconfig_v1_5f1e.asp
Here is an activation doc for the rsactivate utility:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsuiref/htm/cpu_rsconfig_v1_6yqq.asp
--
Douglas McDowell douglas@.nospam.solidqualitylearning.com
"Jéjé" <willgart_A_@.hotmail_A_.com> wrote in message
news:OSWdzrDJFHA.1360@.TK2MSFTNGP10.phx.gbl...
> Hi,
> After I have upgraded my server, RS stop working .
> a.. The report server cannot decrypt the symmetric key used to access
> sensitive or encrypted data in a report server database. You must either
> restore a backup key or delete all encrypted content and then restart the
> service. Check the documentation for more information.
> (rsReportServerDisabled) Get Online Help
> a.. Bad Data.
> I have the Key (exported using the rskeymgmt utility)
> But I can't reapply the key:
> an "Unable to connect to the database" error appear when I try to reapply
> the key.
> I have lost a document on the Microsoft web site which explain the entire
> process to reactivate RS.
> Anyone has the link?
> or can explain the procedure?
> thanks
> Jerome.
>|||I think this is the key management article you are referring to...
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsadmin/htm/arp_dbadmin_v1_98xh.asp?frame=true
"Jéjé" wrote:
> Hi,
> After I have upgraded my server, RS stop working .
> a.. The report server cannot decrypt the symmetric key used to access
> sensitive or encrypted data in a report server database. You must either
> restore a backup key or delete all encrypted content and then restart the
> service. Check the documentation for more information.
> (rsReportServerDisabled) Get Online Help
> a.. Bad Data.
> I have the Key (exported using the rskeymgmt utility)
> But I can't reapply the key:
> an "Unable to connect to the database" error appear when I try to reapply
> the key.
> I have lost a document on the Microsoft web site which explain the entire
> process to reactivate RS.
> Anyone has the link?
> or can explain the procedure?
> thanks
> Jerome.
>
>|||its ok
I'have found (or re-found ) the solution.
I have replaced the oledb32.dll file on the server by the 2.8 version
(instead-of the 2.7 version which is not upgraded during the Win2003
upgrade)
"Jéjé" <willgart_A_@.hotmail_A_.com> wrote in message
news:OSWdzrDJFHA.1360@.TK2MSFTNGP10.phx.gbl...
> Hi,
> After I have upgraded my server, RS stop working .
> a.. The report server cannot decrypt the symmetric key used to access
> sensitive or encrypted data in a report server database. You must either
> restore a backup key or delete all encrypted content and then restart the
> service. Check the documentation for more information.
> (rsReportServerDisabled) Get Online Help
> a.. Bad Data.
> I have the Key (exported using the rskeymgmt utility)
> But I can't reapply the key:
> an "Unable to connect to the database" error appear when I try to reapply
> the key.
> I have lost a document on the Microsoft web site which explain the entire
> process to reactivate RS.
> Anyone has the link?
> or can explain the procedure?
> thanks
> Jerome.
>