Monday, March 26, 2012
rsAccessDenied when accessing Report 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
>
Friday, March 23, 2012
RS2005 web reference produces "C2234: Array of References illegal"
I'm new to RS2005 and have begun going through the Tutorials in SQLServer 2005 Books Online. I'm currently attempting to add "reportingservices2005.asmx" as a web reference to my VS2003 C#.NET project and I keep getting this compile time error:
error C2234: 'Warnings' : arrays of references are illegal
How do I get rid of this compile time error? This error appears in the generated file representing the RS2005.wsdl. Aside from the generated web reference files the other files of the VS2003 C#.NET project are the default project files by the wizard.
Thanks in advance for the help
ZeroVerticalUpgrading to VS2005 C#.NET got rid of the error. I must have overlooked this requirement. I just upgraded to VS2005 C#.NET and everything works fine now.|||It shouldn't really be a requirement. Not sure why it is happening. You should file a bug on the feedback center.
Friday, March 9, 2012
Rs setup problem with version La versión encontrada es 'C.0.8.54'. La versión esperada es 'C.
Hello I got this error when installing rs 2005.
The thing is that sqlserver database is on another server, that server must have sp2 I think but the rs machine doesnt have sp2, that may be the problem?
La versión de la base de datos del servidor de informes no tiene un formato válido o no se puede leer. La versión encontrada es 'C.0.8.54'. La versión esperada es 'C.0.8.40'. Para continuar, actualice la versión de la base de datos del servidor de informes y compruebe los derechos de acceso. (rsInvalidReportServerDatabase) Obtener ayuda en pantalla
"La versión de la base de datos del servidor de informes no tiene un formato válido o no se puede leer. La versión encontrada es 'Unknown'. La versión esperada es 'C.0.8.40'. Para continuar, actualice la versión de la base de datos del servidor de informes y compruebe los derechos de acceso. (rsInvalidReportServerDatabase) Obtener ayuda en pantalla "
if you solved it, would you mind to help me ? thanks...