Friday, March 30, 2012
help!...sp1 or sp2
error:
The version of the report server database is either in a format that is
not
valid, or it cannot be read. The found version is 'C.0.6.54'. The
expected
version is 'C.0.6.43'. To continue, update the version of the report
server
database and verify access rights. (rsInvalidReportServerDatabase)
I am currently running RS enteprise edition with SQL server 2000
Standard edition.
When I used to have RS std. edition with SQL server 2000 std.edition,
I've applied both service packs and didn't get the error.
Can you help me with this problem?
Thanks,If you already installed SP2, you can not install SP1 afterwards and
you do not need to.
Service Packs are cumulative - they contain everything from prior
service packs.
bevarg wrote:
> After I install SP1 of SP2 for reporting services, I get the following
> error:
> The version of the report server database is either in a format that is
> not
> valid, or it cannot be read. The found version is 'C.0.6.54'. The
> expected
> version is 'C.0.6.43'. To continue, update the version of the report
> server
> database and verify access rights. (rsInvalidReportServerDatabase)
> I am currently running RS enteprise edition with SQL server 2000
> Standard edition.
> When I used to have RS std. edition with SQL server 2000 std.edition,
> I've applied both service packs and didn't get the error.
> Can you help me with this problem?
> Thanks,
Help!. Images not Displaying
i have made a report and inserted some company logo in the report header ,,,
from the image wizard i selected Embeded type ,, But when i run the port in
asp.net by calling its webservice ,,,images are not shown.
Plz help me to solve this problem
ThanksHi Malik,
Please look at following link. "_" in the machine name may be the
culprit. Use the IP instead of machine name. Also replace machine name in
report server and report manager config files with machine IP address.
http://groups.google.com.pk/group/microsoft.public.sqlserver.reportingsvcs/browse_thread/thread/dc1fcfec0c41ec70/23425c9cbdabb2a1?q=%22reporting+services%22+%2B+%22images%22&rnum=1&hl=en#23425c9cbdabb2a1
"Malik Asif Joyia" wrote:
> Hello
> i have made a report and inserted some company logo in the report header ,,,
> from the image wizard i selected Embeded type ,, But when i run the port in
> asp.net by calling its webservice ,,,images are not shown.
> Plz help me to solve this problem
> Thanks
>
>sql
Help!!!SOS!!!
Help!!!SOS!!!
Help!!!!--Problems about the multi column report!
I have a 2 coulmns report ,one group ,when I print the report,it does not paging correctly.For example,suppose every column can display 20 rows, if every group has 20-40 rows ,the print is ok,it can paging correctly,but if one group has 10 rows or more than 40 and less than 60,the two groups will print on one paper,how can I print the every group on different paper?
Any advice would be much appreciated.
Thanks.
No one can answer me?|||Garlic,
You can edit your group properties, On your group, right click, select edit group, on General tab, select "Page break at start" this should give you a new page for each group change.
HELP!!!! - Report parameter "Read Only"
I'm stuck with a report not being able to use the URL parameter.
I get the error:
The report parameter is read-only and cannot be modified.
I do have a prompting text for the report, and I've checked the XML and there are <PROMPT></PROMPT> tags!
Most likely, you've modified the parameter definition in Report Manager to make it read-only. If you are using SQL 2005, this can happen when you mark it in the designer as 'Internal'.|||I just dealt with a similar problem (working in RS2000) and no matter what I tried, I couldn't get the error to go away. I tried removing the parameter and re-adding it manually. I tried removing the procedure that required the parameter, re-deploying, and then adding the procedure (and thus the parameter) back in. That still didn't work. This is what I finally did:
1) Removed the parameter from the procedure (commented out the param and any references to it in the sp)
2) Refresh the dataset (to remove the parameter). Ensured the parameter was removed from the report.
3) Re-deployed the report (without the offending parameter). It worked.
4) Went back to the sp and uncommented out the parameter and all references to it
5) Refreshed the dataset (to add the parameter back into the report).
6) Re-deployed. It worked and now accepted the parameter.
I can only surmise that RS had some former reference to the parameter that indicated it was read only, and any re-deployment that I did didn't overwrite that reference. Only by completely removing the parameter, re-deploying, and adding the parameter back in did this issue go away.
I hope this helps someone out there.
|||I got the same problem with VS2005. One time paremeter was checked as "Not Prompt user". After that I changed, deleted and recreated parameter, redeploys report to report server but recived the same error "Report parameter Read Only". Its helped a manualy chnage property of report parameter direct on report server using Report Manager( check on "Propmpt User" property of required parameter). Redeploy of report from VS don't cause changes of report properties on server.HELP!!!! - Report parameter "Read Only"
I'm stuck with a report not being able to use the URL parameter.
I get the error:
The report parameter is read-only and cannot be modified.
I do have a prompting text for the report, and I've checked the XML and there are <PROMPT></PROMPT> tags!
Most likely, you've modified the parameter definition in Report Manager to make it read-only. If you are using SQL 2005, this can happen when you mark it in the designer as 'Internal'.|||I just dealt with a similar problem (working in RS2000) and no matter what I tried, I couldn't get the error to go away. I tried removing the parameter and re-adding it manually. I tried removing the procedure that required the parameter, re-deploying, and then adding the procedure (and thus the parameter) back in. That still didn't work. This is what I finally did:
1) Removed the parameter from the procedure (commented out the param and any references to it in the sp)
2) Refresh the dataset (to remove the parameter). Ensured the parameter was removed from the report.
3) Re-deployed the report (without the offending parameter). It worked.
4) Went back to the sp and uncommented out the parameter and all references to it
5) Refreshed the dataset (to add the parameter back into the report).
6) Re-deployed. It worked and now accepted the parameter.
I can only surmise that RS had some former reference to the parameter that indicated it was read only, and any re-deployment that I did didn't overwrite that reference. Only by completely removing the parameter, re-deploying, and adding the parameter back in did this issue go away.
I hope this helps someone out there.
|||I got the same problem with VS2005. One time paremeter was checked as "Not Prompt user". After that I changed, deleted and recreated parameter, redeploys report to report server but recived the same error "Report parameter Read Only". Its helped a manualy chnage property of report parameter direct on report server using Report Manager( check on "Propmpt User" property of required parameter). Redeploy of report from VS don't cause changes of report properties on server.HELP!!!! - Report parameter "Read Only"
I'm stuck with a report not being able to use the URL parameter.
I get the error:
The report parameter is read-only and cannot be modified.
I do have a prompting text for the report, and I've checked the XML and there are <PROMPT></PROMPT> tags!
Most likely, you've modified the parameter definition in Report Manager to make it read-only. If you are using SQL 2005, this can happen when you mark it in the designer as 'Internal'.|||I just dealt with a similar problem (working in RS2000) and no matter what I tried, I couldn't get the error to go away. I tried removing the parameter and re-adding it manually. I tried removing the procedure that required the parameter, re-deploying, and then adding the procedure (and thus the parameter) back in. That still didn't work. This is what I finally did:
1) Removed the parameter from the procedure (commented out the param and any references to it in the sp)
2) Refresh the dataset (to remove the parameter). Ensured the parameter was removed from the report.
3) Re-deployed the report (without the offending parameter). It worked.
4) Went back to the sp and uncommented out the parameter and all references to it
5) Refreshed the dataset (to add the parameter back into the report).
6) Re-deployed. It worked and now accepted the parameter.
I can only surmise that RS had some former reference to the parameter that indicated it was read only, and any re-deployment that I did didn't overwrite that reference. Only by completely removing the parameter, re-deploying, and adding the parameter back in did this issue go away.
I hope this helps someone out there.
|||I got the same problem with VS2005. One time paremeter was checked as "Not Prompt user". After that I changed, deleted and recreated parameter, redeploys report to report server but recived the same error "Report parameter Read Only". Its helped a manualy chnage property of report parameter direct on report server using Report Manager( check on "Propmpt User" property of required parameter). Redeploy of report from VS don't cause changes of report properties on server.HELP!!!! - Report parameter "Read Only"
I'm stuck with a report not being able to use the URL parameter.
I get the error:
The report parameter is read-only and cannot be modified.
I do have a prompting text for the report, and I've checked the XML and there are <PROMPT></PROMPT> tags!
Most likely, you've modified the parameter definition in Report Manager to make it read-only. If you are using SQL 2005, this can happen when you mark it in the designer as 'Internal'.|||I just dealt with a similar problem (working in RS2000) and no matter what I tried, I couldn't get the error to go away. I tried removing the parameter and re-adding it manually. I tried removing the procedure that required the parameter, re-deploying, and then adding the procedure (and thus the parameter) back in. That still didn't work. This is what I finally did:
1) Removed the parameter from the procedure (commented out the param and any references to it in the sp)
2) Refresh the dataset (to remove the parameter). Ensured the parameter was removed from the report.
3) Re-deployed the report (without the offending parameter). It worked.
4) Went back to the sp and uncommented out the parameter and all references to it
5) Refreshed the dataset (to add the parameter back into the report).
6) Re-deployed. It worked and now accepted the parameter.
I can only surmise that RS had some former reference to the parameter that indicated it was read only, and any re-deployment that I did didn't overwrite that reference. Only by completely removing the parameter, re-deploying, and adding the parameter back in did this issue go away.
I hope this helps someone out there.
|||I got the same problem with VS2005. One time paremeter was checked as "Not Prompt user". After that I changed, deleted and recreated parameter, redeploys report to report server but recived the same error "Report parameter Read Only". Its helped a manualy chnage property of report parameter direct on report server using Report Manager( check on "Propmpt User" property of required parameter). Redeploy of report from VS don't cause changes of report properties on server.Help!!! launching report builder from url is adding .rdl to name when saving.
Hi,
When I launch a report using the following url, and then make changes to the report and save it, Reportbuilder is creating another report with the same name but also including the .rdl within the name itself.. therfore I now have two reports now displayed within the report manager
http://localhost/reportserver/reportbuilder/reportbuilder.application?/Report1
Can someone please help...
Hi,
this issue was resolved by applying SP2
thanks.
|||or:
the same rdl has been uploaded directly using Report Manager and Published in Visual Studio at the same time...
Help!!! launching report builder from url is adding .rdl to name when saving.
Hi,
When I launch a report using the following url, and then make changes to the report and save it, Reportbuilder is creating another report with the same name but also including the .rdl within the name itself.. therfore I now have two reports now displayed within the report manager
http://localhost/reportserver/reportbuilder/reportbuilder.application?/Report1
Can someone please help...
Hi,
this issue was resolved by applying SP2
thanks.
|||or:
the same rdl has been uploaded directly using Report Manager and Published in Visual Studio at the same time...
Help!! "The report server has encountered a configuration error........"
I have installed Sql Server 2005 on my machine. I've managed to created report, but when i try to deploy e same, I'm getting e following error...am i missing something here?
The report server has encountered a configuration error. See the report server log files for more information. (rsServerConfigurationError) Access to the path 'C:\Program Files\Microsoft SQL Server\MSSQL.4\Reporting Services\ReportServer\RSReportServer.config' is denied.
when i checked in msdn..there it says
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSerrors/htm/Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings.resources.Strings_rsServerConfigurationError.asp
Other info:
I have followed the Tutorial Project in SQL Books online. And for TargetURL, i have given --> http://localhost/reportserver
Report server is located in my local only
rsreportserver.config : I dint touch this file and mine is fresh installation.
Help please :)
Can you access Report Manager via Internet Explorer (http://server/reports) at all? Or does it throw the same/similar error?
It sounds to me like the account that SSRS is running under doesn't have the proper NTFS perms on the 'C:\Program Files\Microsoft SQL Server\MSSQL.4\Reporting Services\ReportServer\' folder. Verify that that it does, or use the filemon tool from sysinternals.com to capture a log of what process (and which account) is getting denied...this will give you most of the info you'd need to fix the issue.
Good luck!
|||I experienced the problem described above and the filemon tool identified that the ASPNET user did not have read privileges to the .config file.
It seems strange that the server installation did not configure this correctly.. Setting privileges manually solved the problem..
Add ASPNET user to SQLServer2005Reporting ServicesWebServiceUsers$<MACHINE NAME> group, reboot your machine and it should start working properly.
|||You should be able to fix this as well by using the Report Server Configuration tool to set the web service identity.
-Lukasz
|||Web Service Identity is hard coded on the "Configure Report Server" page.|||Hi,
I am having similar issue trying to launch report services by http://localhost/reports. I got the following error
when try to launch it.
The report server is not responding. Verify that the report server is running and can be accessed from this computer.
I used the Reporting Services Configuration tool to set all my virtual directory and etc... and verified that the report server is initiated and running. I have read other thread for similar issue, but none was able to provide a clear solution on how to resolve the problem. Any help would be appriciated.
|||Look in your log files and see if there is a detailed error message there. That's your best place to start.
-Lukasz
|||Hi,
I've look at the log file and it didn't help me much. Maybe you can point me to the right direction.
By the way, I am running Vista and using the Server 2005 eval edition. I don't know if this make any differences. I still couldn't get it took work for me. Any help would be greatly appriciate. The error i get is as follow when try to launch the report service using http://localhost/reports:
The report server is not responding. Verify that the report server is running and can be accessed from this computer.
<Header>
<Product>Microsoft SQL Server Reporting Services Version 9.00.3054.00</Product>
<Locale>en-US</Locale>
<TimeZone>Central Daylight Time</TimeZone>
<Path>c:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles\ReportServer__05_08_2007_10_17_13.log</Path>
<SystemName>ATS-PC</SystemName>
<OSName>Microsoft Windows NT 6.0.6000.0</OSName>
<OSVersion>6.0.6000.0</OSVersion>
</Header>
w3wp!webserver!1!5/8/2007-10:17:30:: i INFO: Reporting Web Server started
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing ConnectionType to '0' as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing IsSchedulingService to 'True' as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing IsNotificationService to 'True' as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing IsEventService to 'True' as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing PollingInterval to '10' second(s) as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing WindowsServiceUseFileShareStorage to 'False' as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing MemoryLimit to '60' percent as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing RecycleTime to '720' minute(s) as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing MaximumMemoryLimit to '80' percent as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing MaxQueueThreads to '0' thread(s) as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing IsWebServiceEnabled to 'True' as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing MaxScheduleWait to '5' second(s) as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing DatabaseQueryTimeout to '120' second(s) as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing ProcessRecycleOptions to '0' as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing RunningRequestsScavengerCycle to '60' second(s) as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing RunningRequestsDbCycle to '60' second(s) as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing RunningRequestsAge to '30' second(s) as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing CleanupCycleMinutes to '10' minute(s) as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing DailyCleanupMinuteOfDay to default value of '120' minutes since midnight because it was not specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing WatsonFlags to '1064' as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing WatsonDumpOnExceptions to 'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException' as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing WatsonDumpExcludeIfContainsExceptions to 'System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException' as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing SecureConnectionLevel to '0' as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing DisplayErrorLink to 'True' as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing WebServiceUseFileShareStorage to 'False' as specified in Configuration file.
w3wp!resourceutilities!1!5/8/2007-10:17:30:: i INFO: Reporting Services starting SKU: Evaluation
w3wp!resourceutilities!1!5/8/2007-10:17:30:: i INFO: Evaluation copy: 175 days left
w3wp!runningjobs!1!5/8/2007-10:17:31:: i INFO: Database Cleanup (Web Service) timer enabled: Next Event: 600 seconds. Cycle: 600 seconds
w3wp!runningjobs!1!5/8/2007-10:17:31:: i INFO: Running Requests Scavenger timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
w3wp!runningjobs!1!5/8/2007-10:17:31:: i INFO: Running Requests DB timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
w3wp!runningjobs!1!5/8/2007-10:17:31:: i INFO: Memory stats update timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
w3wp!library!1!05/08/2007-10:17:31:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. > System.NullReferenceException: Object reference not set to an instance of an object.
at Microsoft.ReportingServices.Authentication.WindowsAuthentication.GetUserInfo(IIdentity& userIdentity, IntPtr& userId)
at Microsoft.ReportingServices.WebServer.WebServiceHelper.ConstructRSServiceObjectFromSecurityExtension()
at Microsoft.ReportingServices.WebServer.Global.ConstructRSServiceFromRequest(String item)
at Microsoft.ReportingServices.WebServer.Global.get_Service()
at Microsoft.ReportingServices.WebServer.Global.ShouldRejectAntiDos()
at Microsoft.ReportingServices.WebServer.Global.Application_AuthenticateRequest(Object sender, EventArgs e)
End of inner exception stack trace
w3wp!library!1!05/08/2007-10:17:33:: i INFO: Exception dumped to: c:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles flags= ReferencedMemory, AllThreads, SendToWatson
w3wp!library!1!05/08/2007-10:17:33:: i INFO: Catalog SQL Server Edition = Evaluation
w3wp!library!1!05/08/2007-10:17:36:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. > System.NullReferenceException: Object reference not set to an instance of an object.
at Microsoft.ReportingServices.Authentication.WindowsAuthentication.GetUserInfo(IIdentity& userIdentity, IntPtr& userId)
at Microsoft.ReportingServices.WebServer.WebServiceHelper.ConstructRSServiceObjectFromSecurityExtension()
at Microsoft.ReportingServices.WebServer.Global.ConstructRSServiceFromRequest(String item)
at Microsoft.ReportingServices.WebServer.Global.get_Service()
at Microsoft.ReportingServices.WebServer.Global.ShouldRejectAntiDos()
at Microsoft.ReportingServices.WebServer.Global.Application_AuthenticateRequest(Object sender, EventArgs e)
End of inner exception stack trace
w3wp!library!1!05/08/2007-10:17:38:: i INFO: Exception dumped to: c:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles flags= ReferencedMemory, AllThreads, SendToWatson
w3wp!library!5!05/08/2007-10:27:04:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. > System.NullReferenceException: Object reference not set to an instance of an object.
at Microsoft.ReportingServices.Authentication.WindowsAuthentication.GetUserInfo(IIdentity& userIdentity, IntPtr& userId)
at Microsoft.ReportingServices.WebServer.WebServiceHelper.ConstructRSServiceObjectFromSecurityExtension()
at Microsoft.ReportingServices.WebServer.Global.ConstructRSServiceFromRequest(String item)
at Microsoft.ReportingServices.WebServer.Global.get_Service()
at Microsoft.ReportingServices.WebServer.Global.ShouldRejectAntiDos()
at Microsoft.ReportingServices.WebServer.Global.Application_AuthenticateRequest(Object sender, EventArgs e)
End of inner exception stack trace
w3wp!library!7!5/8/2007-10:27:31:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!5!05/08/2007-10:27:35:: i INFO: Exception dumped to: c:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles flags= ReferencedMemory, AllThreads, SendToWatson
w3wp!library!1!05/08/2007-10:27:37:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. > System.NullReferenceException: Object reference not set to an instance of an object.
at Microsoft.ReportingServices.Authentication.WindowsAuthentication.GetUserInfo(IIdentity& userIdentity, IntPtr& userId)
at Microsoft.ReportingServices.WebServer.WebServiceHelper.ConstructRSServiceObjectFromSecurityExtension()
at Microsoft.ReportingServices.WebServer.Global.ConstructRSServiceFromRequest(String item)
at Microsoft.ReportingServices.WebServer.Global.get_Service()
at Microsoft.ReportingServices.WebServer.Global.ShouldRejectAntiDos()
at Microsoft.ReportingServices.WebServer.Global.Application_AuthenticateRequest(Object sender, EventArgs e)
End of inner exception stack trace
If you're running on Vista, you must install SQL Server SP2. Here are some KB articles that should help you out.
http://support.microsoft.com/kb/934164 (install)
http://support.microsoft.com/kb/934163 (upgrade)
-Lukasz
|||I had a similar problem. It turned out that since I had a named instance of SQL Server 2005 I had to reference that in the url. Specifically, it was http://localhost/ReportServer$NAMEOFSQLSERVERINSTANCE - CindyPsych
Help!! "The report server has encountered a configuration error........"
I have installed Sql Server 2005 on my machine. I've managed to created report, but when i try to deploy e same, I'm getting e following error...am i missing something here?
The report server has encountered a configuration error. See the report server log files for more information. (rsServerConfigurationError) Access to the path 'C:\Program Files\Microsoft SQL Server\MSSQL.4\Reporting Services\ReportServer\RSReportServer.config' is denied.
when i checked in msdn..there it says
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSerrors/htm/Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings.resources.Strings_rsServerConfigurationError.asp
Other info:
I have followed the Tutorial Project in SQL Books online. And for TargetURL, i have given --> http://localhost/reportserver
Report server is located in my local only
rsreportserver.config : I dint touch this file and mine is fresh installation.
Help please :)
Can you access Report Manager via Internet Explorer (http://server/reports) at all? Or does it throw the same/similar error?
It sounds to me like the account that SSRS is running under doesn't have the proper NTFS perms on the 'C:\Program Files\Microsoft SQL Server\MSSQL.4\Reporting Services\ReportServer\' folder. Verify that that it does, or use the filemon tool from sysinternals.com to capture a log of what process (and which account) is getting denied...this will give you most of the info you'd need to fix the issue.
Good luck!
|||I experienced the problem described above and the filemon tool identified that the ASPNET user did not have read privileges to the .config file.
It seems strange that the server installation did not configure this correctly.. Setting privileges manually solved the problem..
Add ASPNET user to SQLServer2005Reporting ServicesWebServiceUsers$<MACHINE NAME> group, reboot your machine and it should start working properly.
|||You should be able to fix this as well by using the Report Server Configuration tool to set the web service identity.
-Lukasz
|||Web Service Identity is hard coded on the "Configure Report Server" page.|||Hi,
I am having similar issue trying to launch report services by http://localhost/reports. I got the following error
when try to launch it.
The report server is not responding. Verify that the report server is running and can be accessed from this computer.
I used the Reporting Services Configuration tool to set all my virtual directory and etc... and verified that the report server is initiated and running. I have read other thread for similar issue, but none was able to provide a clear solution on how to resolve the problem. Any help would be appriciated.
|||Look in your log files and see if there is a detailed error message there. That's your best place to start.
-Lukasz
|||Hi,
I've look at the log file and it didn't help me much. Maybe you can point me to the right direction.
By the way, I am running Vista and using the Server 2005 eval edition. I don't know if this make any differences. I still couldn't get it took work for me. Any help would be greatly appriciate. The error i get is as follow when try to launch the report service using http://localhost/reports:
The report server is not responding. Verify that the report server is running and can be accessed from this computer.
<Header>
<Product>Microsoft SQL Server Reporting Services Version 9.00.3054.00</Product>
<Locale>en-US</Locale>
<TimeZone>Central Daylight Time</TimeZone>
<Path>c:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles\ReportServer__05_08_2007_10_17_13.log</Path>
<SystemName>ATS-PC</SystemName>
<OSName>Microsoft Windows NT 6.0.6000.0</OSName>
<OSVersion>6.0.6000.0</OSVersion>
</Header>
w3wp!webserver!1!5/8/2007-10:17:30:: i INFO: Reporting Web Server started
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing ConnectionType to '0' as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing IsSchedulingService to 'True' as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing IsNotificationService to 'True' as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing IsEventService to 'True' as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing PollingInterval to '10' second(s) as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing WindowsServiceUseFileShareStorage to 'False' as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing MemoryLimit to '60' percent as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing RecycleTime to '720' minute(s) as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing MaximumMemoryLimit to '80' percent as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing MaxQueueThreads to '0' thread(s) as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing IsWebServiceEnabled to 'True' as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing MaxScheduleWait to '5' second(s) as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing DatabaseQueryTimeout to '120' second(s) as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing ProcessRecycleOptions to '0' as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing RunningRequestsScavengerCycle to '60' second(s) as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing RunningRequestsDbCycle to '60' second(s) as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing RunningRequestsAge to '30' second(s) as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing CleanupCycleMinutes to '10' minute(s) as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing DailyCleanupMinuteOfDay to default value of '120' minutes since midnight because it was not specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing WatsonFlags to '1064' as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing WatsonDumpOnExceptions to 'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException' as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing WatsonDumpExcludeIfContainsExceptions to 'System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException' as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing SecureConnectionLevel to '0' as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing DisplayErrorLink to 'True' as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing WebServiceUseFileShareStorage to 'False' as specified in Configuration file.
w3wp!resourceutilities!1!5/8/2007-10:17:30:: i INFO: Reporting Services starting SKU: Evaluation
w3wp!resourceutilities!1!5/8/2007-10:17:30:: i INFO: Evaluation copy: 175 days left
w3wp!runningjobs!1!5/8/2007-10:17:31:: i INFO: Database Cleanup (Web Service) timer enabled: Next Event: 600 seconds. Cycle: 600 seconds
w3wp!runningjobs!1!5/8/2007-10:17:31:: i INFO: Running Requests Scavenger timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
w3wp!runningjobs!1!5/8/2007-10:17:31:: i INFO: Running Requests DB timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
w3wp!runningjobs!1!5/8/2007-10:17:31:: i INFO: Memory stats update timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
w3wp!library!1!05/08/2007-10:17:31:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. > System.NullReferenceException: Object reference not set to an instance of an object.
at Microsoft.ReportingServices.Authentication.WindowsAuthentication.GetUserInfo(IIdentity& userIdentity, IntPtr& userId)
at Microsoft.ReportingServices.WebServer.WebServiceHelper.ConstructRSServiceObjectFromSecurityExtension()
at Microsoft.ReportingServices.WebServer.Global.ConstructRSServiceFromRequest(String item)
at Microsoft.ReportingServices.WebServer.Global.get_Service()
at Microsoft.ReportingServices.WebServer.Global.ShouldRejectAntiDos()
at Microsoft.ReportingServices.WebServer.Global.Application_AuthenticateRequest(Object sender, EventArgs e)
End of inner exception stack trace
w3wp!library!1!05/08/2007-10:17:33:: i INFO: Exception dumped to: c:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles flags= ReferencedMemory, AllThreads, SendToWatson
w3wp!library!1!05/08/2007-10:17:33:: i INFO: Catalog SQL Server Edition = Evaluation
w3wp!library!1!05/08/2007-10:17:36:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. > System.NullReferenceException: Object reference not set to an instance of an object.
at Microsoft.ReportingServices.Authentication.WindowsAuthentication.GetUserInfo(IIdentity& userIdentity, IntPtr& userId)
at Microsoft.ReportingServices.WebServer.WebServiceHelper.ConstructRSServiceObjectFromSecurityExtension()
at Microsoft.ReportingServices.WebServer.Global.ConstructRSServiceFromRequest(String item)
at Microsoft.ReportingServices.WebServer.Global.get_Service()
at Microsoft.ReportingServices.WebServer.Global.ShouldRejectAntiDos()
at Microsoft.ReportingServices.WebServer.Global.Application_AuthenticateRequest(Object sender, EventArgs e)
End of inner exception stack trace
w3wp!library!1!05/08/2007-10:17:38:: i INFO: Exception dumped to: c:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles flags= ReferencedMemory, AllThreads, SendToWatson
w3wp!library!5!05/08/2007-10:27:04:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. > System.NullReferenceException: Object reference not set to an instance of an object.
at Microsoft.ReportingServices.Authentication.WindowsAuthentication.GetUserInfo(IIdentity& userIdentity, IntPtr& userId)
at Microsoft.ReportingServices.WebServer.WebServiceHelper.ConstructRSServiceObjectFromSecurityExtension()
at Microsoft.ReportingServices.WebServer.Global.ConstructRSServiceFromRequest(String item)
at Microsoft.ReportingServices.WebServer.Global.get_Service()
at Microsoft.ReportingServices.WebServer.Global.ShouldRejectAntiDos()
at Microsoft.ReportingServices.WebServer.Global.Application_AuthenticateRequest(Object sender, EventArgs e)
End of inner exception stack trace
w3wp!library!7!5/8/2007-10:27:31:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!5!05/08/2007-10:27:35:: i INFO: Exception dumped to: c:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles flags= ReferencedMemory, AllThreads, SendToWatson
w3wp!library!1!05/08/2007-10:27:37:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. > System.NullReferenceException: Object reference not set to an instance of an object.
at Microsoft.ReportingServices.Authentication.WindowsAuthentication.GetUserInfo(IIdentity& userIdentity, IntPtr& userId)
at Microsoft.ReportingServices.WebServer.WebServiceHelper.ConstructRSServiceObjectFromSecurityExtension()
at Microsoft.ReportingServices.WebServer.Global.ConstructRSServiceFromRequest(String item)
at Microsoft.ReportingServices.WebServer.Global.get_Service()
at Microsoft.ReportingServices.WebServer.Global.ShouldRejectAntiDos()
at Microsoft.ReportingServices.WebServer.Global.Application_AuthenticateRequest(Object sender, EventArgs e)
End of inner exception stack trace
If you're running on Vista, you must install SQL Server SP2. Here are some KB articles that should help you out.
http://support.microsoft.com/kb/934164 (install)
http://support.microsoft.com/kb/934163 (upgrade)
-Lukasz
|||I had a similar problem. It turned out that since I had a named instance of SQL Server 2005 I had to reference that in the url. Specifically, it was http://localhost/ReportServer$NAMEOFSQLSERVERINSTANCE- CindyPsych
Help!! "The report server has encountered a configuration error........"
I have installed Sql Server 2005 on my machine. I've managed to created report, but when i try to deploy e same, I'm getting e following error...am i missing something here?
The report server has encountered a configuration error. See the report server log files for more information. (rsServerConfigurationError) Access to the path 'C:\Program Files\Microsoft SQL Server\MSSQL.4\Reporting Services\ReportServer\RSReportServer.config' is denied.
when i checked in msdn..there it says
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSerrors/htm/Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings.resources.Strings_rsServerConfigurationError.asp
Other info:
I have followed the Tutorial Project in SQL Books online. And for TargetURL, i have given --> http://localhost/reportserver
Report server is located in my local only
rsreportserver.config : I dint touch this file and mine is fresh installation.
Help please :)
Can you access Report Manager via Internet Explorer (http://server/reports) at all? Or does it throw the same/similar error?
It sounds to me like the account that SSRS is running under doesn't have the proper NTFS perms on the 'C:\Program Files\Microsoft SQL Server\MSSQL.4\Reporting Services\ReportServer\' folder. Verify that that it does, or use the filemon tool from sysinternals.com to capture a log of what process (and which account) is getting denied...this will give you most of the info you'd need to fix the issue.
Good luck!
|||I experienced the problem described above and the filemon tool identified that the ASPNET user did not have read privileges to the .config file.
It seems strange that the server installation did not configure this correctly.. Setting privileges manually solved the problem..
Add ASPNET user to SQLServer2005Reporting ServicesWebServiceUsers$<MACHINE NAME> group, reboot your machine and it should start working properly.
|||You should be able to fix this as well by using the Report Server Configuration tool to set the web service identity.
-Lukasz
|||Web Service Identity is hard coded on the "Configure Report Server" page.|||Hi,
I am having similar issue trying to launch report services by http://localhost/reports. I got the following error
when try to launch it.
The report server is not responding. Verify that the report server is running and can be accessed from this computer.
I used the Reporting Services Configuration tool to set all my virtual directory and etc... and verified that the report server is initiated and running. I have read other thread for similar issue, but none was able to provide a clear solution on how to resolve the problem. Any help would be appriciated.
|||Look in your log files and see if there is a detailed error message there. That's your best place to start.
-Lukasz
|||Hi,
I've look at the log file and it didn't help me much. Maybe you can point me to the right direction.
By the way, I am running Vista and using the Server 2005 eval edition. I don't know if this make any differences. I still couldn't get it took work for me. Any help would be greatly appriciate. The error i get is as follow when try to launch the report service using http://localhost/reports:
The report server is not responding. Verify that the report server is running and can be accessed from this computer.
<Header>
<Product>Microsoft SQL Server Reporting Services Version 9.00.3054.00</Product>
<Locale>en-US</Locale>
<TimeZone>Central Daylight Time</TimeZone>
<Path>c:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles\ReportServer__05_08_2007_10_17_13.log</Path>
<SystemName>ATS-PC</SystemName>
<OSName>Microsoft Windows NT 6.0.6000.0</OSName>
<OSVersion>6.0.6000.0</OSVersion>
</Header>
w3wp!webserver!1!5/8/2007-10:17:30:: i INFO: Reporting Web Server started
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing ConnectionType to '0' as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing IsSchedulingService to 'True' as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing IsNotificationService to 'True' as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing IsEventService to 'True' as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing PollingInterval to '10' second(s) as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing WindowsServiceUseFileShareStorage to 'False' as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing MemoryLimit to '60' percent as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing RecycleTime to '720' minute(s) as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing MaximumMemoryLimit to '80' percent as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing MaxQueueThreads to '0' thread(s) as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing IsWebServiceEnabled to 'True' as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing MaxScheduleWait to '5' second(s) as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing DatabaseQueryTimeout to '120' second(s) as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing ProcessRecycleOptions to '0' as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing RunningRequestsScavengerCycle to '60' second(s) as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing RunningRequestsDbCycle to '60' second(s) as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing RunningRequestsAge to '30' second(s) as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing CleanupCycleMinutes to '10' minute(s) as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing DailyCleanupMinuteOfDay to default value of '120' minutes since midnight because it was not specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing WatsonFlags to '1064' as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing WatsonDumpOnExceptions to 'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException' as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing WatsonDumpExcludeIfContainsExceptions to 'System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException' as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing SecureConnectionLevel to '0' as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing DisplayErrorLink to 'True' as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing WebServiceUseFileShareStorage to 'False' as specified in Configuration file.
w3wp!resourceutilities!1!5/8/2007-10:17:30:: i INFO: Reporting Services starting SKU: Evaluation
w3wp!resourceutilities!1!5/8/2007-10:17:30:: i INFO: Evaluation copy: 175 days left
w3wp!runningjobs!1!5/8/2007-10:17:31:: i INFO: Database Cleanup (Web Service) timer enabled: Next Event: 600 seconds. Cycle: 600 seconds
w3wp!runningjobs!1!5/8/2007-10:17:31:: i INFO: Running Requests Scavenger timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
w3wp!runningjobs!1!5/8/2007-10:17:31:: i INFO: Running Requests DB timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
w3wp!runningjobs!1!5/8/2007-10:17:31:: i INFO: Memory stats update timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
w3wp!library!1!05/08/2007-10:17:31:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. > System.NullReferenceException: Object reference not set to an instance of an object.
at Microsoft.ReportingServices.Authentication.WindowsAuthentication.GetUserInfo(IIdentity& userIdentity, IntPtr& userId)
at Microsoft.ReportingServices.WebServer.WebServiceHelper.ConstructRSServiceObjectFromSecurityExtension()
at Microsoft.ReportingServices.WebServer.Global.ConstructRSServiceFromRequest(String item)
at Microsoft.ReportingServices.WebServer.Global.get_Service()
at Microsoft.ReportingServices.WebServer.Global.ShouldRejectAntiDos()
at Microsoft.ReportingServices.WebServer.Global.Application_AuthenticateRequest(Object sender, EventArgs e)
End of inner exception stack trace
w3wp!library!1!05/08/2007-10:17:33:: i INFO: Exception dumped to: c:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles flags= ReferencedMemory, AllThreads, SendToWatson
w3wp!library!1!05/08/2007-10:17:33:: i INFO: Catalog SQL Server Edition = Evaluation
w3wp!library!1!05/08/2007-10:17:36:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. > System.NullReferenceException: Object reference not set to an instance of an object.
at Microsoft.ReportingServices.Authentication.WindowsAuthentication.GetUserInfo(IIdentity& userIdentity, IntPtr& userId)
at Microsoft.ReportingServices.WebServer.WebServiceHelper.ConstructRSServiceObjectFromSecurityExtension()
at Microsoft.ReportingServices.WebServer.Global.ConstructRSServiceFromRequest(String item)
at Microsoft.ReportingServices.WebServer.Global.get_Service()
at Microsoft.ReportingServices.WebServer.Global.ShouldRejectAntiDos()
at Microsoft.ReportingServices.WebServer.Global.Application_AuthenticateRequest(Object sender, EventArgs e)
End of inner exception stack trace
w3wp!library!1!05/08/2007-10:17:38:: i INFO: Exception dumped to: c:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles flags= ReferencedMemory, AllThreads, SendToWatson
w3wp!library!5!05/08/2007-10:27:04:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. > System.NullReferenceException: Object reference not set to an instance of an object.
at Microsoft.ReportingServices.Authentication.WindowsAuthentication.GetUserInfo(IIdentity& userIdentity, IntPtr& userId)
at Microsoft.ReportingServices.WebServer.WebServiceHelper.ConstructRSServiceObjectFromSecurityExtension()
at Microsoft.ReportingServices.WebServer.Global.ConstructRSServiceFromRequest(String item)
at Microsoft.ReportingServices.WebServer.Global.get_Service()
at Microsoft.ReportingServices.WebServer.Global.ShouldRejectAntiDos()
at Microsoft.ReportingServices.WebServer.Global.Application_AuthenticateRequest(Object sender, EventArgs e)
End of inner exception stack trace
w3wp!library!7!5/8/2007-10:27:31:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!5!05/08/2007-10:27:35:: i INFO: Exception dumped to: c:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles flags= ReferencedMemory, AllThreads, SendToWatson
w3wp!library!1!05/08/2007-10:27:37:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. > System.NullReferenceException: Object reference not set to an instance of an object.
at Microsoft.ReportingServices.Authentication.WindowsAuthentication.GetUserInfo(IIdentity& userIdentity, IntPtr& userId)
at Microsoft.ReportingServices.WebServer.WebServiceHelper.ConstructRSServiceObjectFromSecurityExtension()
at Microsoft.ReportingServices.WebServer.Global.ConstructRSServiceFromRequest(String item)
at Microsoft.ReportingServices.WebServer.Global.get_Service()
at Microsoft.ReportingServices.WebServer.Global.ShouldRejectAntiDos()
at Microsoft.ReportingServices.WebServer.Global.Application_AuthenticateRequest(Object sender, EventArgs e)
End of inner exception stack trace
If you're running on Vista, you must install SQL Server SP2. Here are some KB articles that should help you out.
http://support.microsoft.com/kb/934164 (install)
http://support.microsoft.com/kb/934163 (upgrade)
-Lukasz
|||I had a similar problem. It turned out that since I had a named instance of SQL Server 2005 I had to reference that in the url. Specifically, it was http://localhost/ReportServer$NAMEOFSQLSERVERINSTANCE - CindyPsych
Help!! "The report server has encountered a configuration error........"
I have installed Sql Server 2005 on my machine. I've managed to created report, but when i try to deploy e same, I'm getting e following error...am i missing something here?
The report server has encountered a configuration error. See the report server log files for more information. (rsServerConfigurationError) Access to the path 'C:\Program Files\Microsoft SQL Server\MSSQL.4\Reporting Services\ReportServer\RSReportServer.config' is denied.
when i checked in msdn..there it says
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSerrors/htm/Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings.resources.Strings_rsServerConfigurationError.asp
Other info:
I have followed the Tutorial Project in SQL Books online. And for TargetURL, i have given --> http://localhost/reportserver
Report server is located in my local only
rsreportserver.config : I dint touch this file and mine is fresh installation.
Help please :)
Can you access Report Manager via Internet Explorer (http://server/reports) at all? Or does it throw the same/similar error?
It sounds to me like the account that SSRS is running under doesn't have the proper NTFS perms on the 'C:\Program Files\Microsoft SQL Server\MSSQL.4\Reporting Services\ReportServer\' folder. Verify that that it does, or use the filemon tool from sysinternals.com to capture a log of what process (and which account) is getting denied...this will give you most of the info you'd need to fix the issue.
Good luck!
|||I experienced the problem described above and the filemon tool identified that the ASPNET user did not have read privileges to the .config file.
It seems strange that the server installation did not configure this correctly.. Setting privileges manually solved the problem..
Add ASPNET user to SQLServer2005Reporting ServicesWebServiceUsers$<MACHINE NAME> group, reboot your machine and it should start working properly.
|||You should be able to fix this as well by using the Report Server Configuration tool to set the web service identity.
-Lukasz
|||Web Service Identity is hard coded on the "Configure Report Server" page.|||Hi,
I am having similar issue trying to launch report services by http://localhost/reports. I got the following error
when try to launch it.
The report server is not responding. Verify that the report server is running and can be accessed from this computer.
I used the Reporting Services Configuration tool to set all my virtual directory and etc... and verified that the report server is initiated and running. I have read other thread for similar issue, but none was able to provide a clear solution on how to resolve the problem. Any help would be appriciated.
|||Look in your log files and see if there is a detailed error message there. That's your best place to start.
-Lukasz
|||Hi,
I've look at the log file and it didn't help me much. Maybe you can point me to the right direction.
By the way, I am running Vista and using the Server 2005 eval edition. I don't know if this make any differences. I still couldn't get it took work for me. Any help would be greatly appriciate. The error i get is as follow when try to launch the report service using http://localhost/reports:
The report server is not responding. Verify that the report server is running and can be accessed from this computer.
<Header>
<Product>Microsoft SQL Server Reporting Services Version 9.00.3054.00</Product>
<Locale>en-US</Locale>
<TimeZone>Central Daylight Time</TimeZone>
<Path>c:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles\ReportServer__05_08_2007_10_17_13.log</Path>
<SystemName>ATS-PC</SystemName>
<OSName>Microsoft Windows NT 6.0.6000.0</OSName>
<OSVersion>6.0.6000.0</OSVersion>
</Header>
w3wp!webserver!1!5/8/2007-10:17:30:: i INFO: Reporting Web Server started
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing ConnectionType to '0' as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing IsSchedulingService to 'True' as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing IsNotificationService to 'True' as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing IsEventService to 'True' as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing PollingInterval to '10' second(s) as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing WindowsServiceUseFileShareStorage to 'False' as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing MemoryLimit to '60' percent as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing RecycleTime to '720' minute(s) as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing MaximumMemoryLimit to '80' percent as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing MaxQueueThreads to '0' thread(s) as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing IsWebServiceEnabled to 'True' as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing MaxScheduleWait to '5' second(s) as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing DatabaseQueryTimeout to '120' second(s) as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing ProcessRecycleOptions to '0' as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing RunningRequestsScavengerCycle to '60' second(s) as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing RunningRequestsDbCycle to '60' second(s) as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing RunningRequestsAge to '30' second(s) as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing CleanupCycleMinutes to '10' minute(s) as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing DailyCleanupMinuteOfDay to default value of '120' minutes since midnight because it was not specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing WatsonFlags to '1064' as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing WatsonDumpOnExceptions to 'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException' as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing WatsonDumpExcludeIfContainsExceptions to 'System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException' as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing SecureConnectionLevel to '0' as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing DisplayErrorLink to 'True' as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing WebServiceUseFileShareStorage to 'False' as specified in Configuration file.
w3wp!resourceutilities!1!5/8/2007-10:17:30:: i INFO: Reporting Services starting SKU: Evaluation
w3wp!resourceutilities!1!5/8/2007-10:17:30:: i INFO: Evaluation copy: 175 days left
w3wp!runningjobs!1!5/8/2007-10:17:31:: i INFO: Database Cleanup (Web Service) timer enabled: Next Event: 600 seconds. Cycle: 600 seconds
w3wp!runningjobs!1!5/8/2007-10:17:31:: i INFO: Running Requests Scavenger timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
w3wp!runningjobs!1!5/8/2007-10:17:31:: i INFO: Running Requests DB timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
w3wp!runningjobs!1!5/8/2007-10:17:31:: i INFO: Memory stats update timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
w3wp!library!1!05/08/2007-10:17:31:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. > System.NullReferenceException: Object reference not set to an instance of an object.
at Microsoft.ReportingServices.Authentication.WindowsAuthentication.GetUserInfo(IIdentity& userIdentity, IntPtr& userId)
at Microsoft.ReportingServices.WebServer.WebServiceHelper.ConstructRSServiceObjectFromSecurityExtension()
at Microsoft.ReportingServices.WebServer.Global.ConstructRSServiceFromRequest(String item)
at Microsoft.ReportingServices.WebServer.Global.get_Service()
at Microsoft.ReportingServices.WebServer.Global.ShouldRejectAntiDos()
at Microsoft.ReportingServices.WebServer.Global.Application_AuthenticateRequest(Object sender, EventArgs e)
End of inner exception stack trace
w3wp!library!1!05/08/2007-10:17:33:: i INFO: Exception dumped to: c:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles flags= ReferencedMemory, AllThreads, SendToWatson
w3wp!library!1!05/08/2007-10:17:33:: i INFO: Catalog SQL Server Edition = Evaluation
w3wp!library!1!05/08/2007-10:17:36:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. > System.NullReferenceException: Object reference not set to an instance of an object.
at Microsoft.ReportingServices.Authentication.WindowsAuthentication.GetUserInfo(IIdentity& userIdentity, IntPtr& userId)
at Microsoft.ReportingServices.WebServer.WebServiceHelper.ConstructRSServiceObjectFromSecurityExtension()
at Microsoft.ReportingServices.WebServer.Global.ConstructRSServiceFromRequest(String item)
at Microsoft.ReportingServices.WebServer.Global.get_Service()
at Microsoft.ReportingServices.WebServer.Global.ShouldRejectAntiDos()
at Microsoft.ReportingServices.WebServer.Global.Application_AuthenticateRequest(Object sender, EventArgs e)
End of inner exception stack trace
w3wp!library!1!05/08/2007-10:17:38:: i INFO: Exception dumped to: c:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles flags= ReferencedMemory, AllThreads, SendToWatson
w3wp!library!5!05/08/2007-10:27:04:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. > System.NullReferenceException: Object reference not set to an instance of an object.
at Microsoft.ReportingServices.Authentication.WindowsAuthentication.GetUserInfo(IIdentity& userIdentity, IntPtr& userId)
at Microsoft.ReportingServices.WebServer.WebServiceHelper.ConstructRSServiceObjectFromSecurityExtension()
at Microsoft.ReportingServices.WebServer.Global.ConstructRSServiceFromRequest(String item)
at Microsoft.ReportingServices.WebServer.Global.get_Service()
at Microsoft.ReportingServices.WebServer.Global.ShouldRejectAntiDos()
at Microsoft.ReportingServices.WebServer.Global.Application_AuthenticateRequest(Object sender, EventArgs e)
End of inner exception stack trace
w3wp!library!7!5/8/2007-10:27:31:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!5!05/08/2007-10:27:35:: i INFO: Exception dumped to: c:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles flags= ReferencedMemory, AllThreads, SendToWatson
w3wp!library!1!05/08/2007-10:27:37:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. > System.NullReferenceException: Object reference not set to an instance of an object.
at Microsoft.ReportingServices.Authentication.WindowsAuthentication.GetUserInfo(IIdentity& userIdentity, IntPtr& userId)
at Microsoft.ReportingServices.WebServer.WebServiceHelper.ConstructRSServiceObjectFromSecurityExtension()
at Microsoft.ReportingServices.WebServer.Global.ConstructRSServiceFromRequest(String item)
at Microsoft.ReportingServices.WebServer.Global.get_Service()
at Microsoft.ReportingServices.WebServer.Global.ShouldRejectAntiDos()
at Microsoft.ReportingServices.WebServer.Global.Application_AuthenticateRequest(Object sender, EventArgs e)
End of inner exception stack trace
If you're running on Vista, you must install SQL Server SP2. Here are some KB articles that should help you out.
http://support.microsoft.com/kb/934164 (install)
http://support.microsoft.com/kb/934163 (upgrade)
-Lukasz
|||I had a similar problem. It turned out that since I had a named instance of SQL Server 2005 I had to reference that in the url. Specifically, it was http://localhost/ReportServer$NAMEOFSQLSERVERINSTANCE- CindyPsych
Help!! "The report server has encountered a configuration error........"
I have installed Sql Server 2005 on my machine. I've managed to created report, but when i try to deploy e same, I'm getting e following error...am i missing something here?
The report server has encountered a configuration error. See the report server log files for more information. (rsServerConfigurationError) Access to the path 'C:\Program Files\Microsoft SQL Server\MSSQL.4\Reporting Services\ReportServer\RSReportServer.config' is denied.
when i checked in msdn..there it says
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSerrors/htm/Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings.resources.Strings_rsServerConfigurationError.asp
Other info:
I have followed the Tutorial Project in SQL Books online. And for TargetURL, i have given --> http://localhost/reportserver
Report server is located in my local only
rsreportserver.config : I dint touch this file and mine is fresh installation.
Help please :)
Can you access Report Manager via Internet Explorer (http://server/reports) at all? Or does it throw the same/similar error?
It sounds to me like the account that SSRS is running under doesn't have the proper NTFS perms on the 'C:\Program Files\Microsoft SQL Server\MSSQL.4\Reporting Services\ReportServer\' folder. Verify that that it does, or use the filemon tool from sysinternals.com to capture a log of what process (and which account) is getting denied...this will give you most of the info you'd need to fix the issue.
Good luck!
|||I experienced the problem described above and the filemon tool identified that the ASPNET user did not have read privileges to the .config file.
It seems strange that the server installation did not configure this correctly.. Setting privileges manually solved the problem..
Add ASPNET user to SQLServer2005Reporting ServicesWebServiceUsers$<MACHINE NAME> group, reboot your machine and it should start working properly.
|||You should be able to fix this as well by using the Report Server Configuration tool to set the web service identity.
-Lukasz
|||Web Service Identity is hard coded on the "Configure Report Server" page.|||Hi,
I am having similar issue trying to launch report services by http://localhost/reports. I got the following error
when try to launch it.
The report server is not responding. Verify that the report server is running and can be accessed from this computer.
I used the Reporting Services Configuration tool to set all my virtual directory and etc... and verified that the report server is initiated and running. I have read other thread for similar issue, but none was able to provide a clear solution on how to resolve the problem. Any help would be appriciated.
|||Look in your log files and see if there is a detailed error message there. That's your best place to start.
-Lukasz
|||Hi,
I've look at the log file and it didn't help me much. Maybe you can point me to the right direction.
By the way, I am running Vista and using the Server 2005 eval edition. I don't know if this make any differences. I still couldn't get it took work for me. Any help would be greatly appriciate. The error i get is as follow when try to launch the report service using http://localhost/reports:
The report server is not responding. Verify that the report server is running and can be accessed from this computer.
<Header>
<Product>Microsoft SQL Server Reporting Services Version 9.00.3054.00</Product>
<Locale>en-US</Locale>
<TimeZone>Central Daylight Time</TimeZone>
<Path>c:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles\ReportServer__05_08_2007_10_17_13.log</Path>
<SystemName>ATS-PC</SystemName>
<OSName>Microsoft Windows NT 6.0.6000.0</OSName>
<OSVersion>6.0.6000.0</OSVersion>
</Header>
w3wp!webserver!1!5/8/2007-10:17:30:: i INFO: Reporting Web Server started
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing ConnectionType to '0' as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing IsSchedulingService to 'True' as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing IsNotificationService to 'True' as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing IsEventService to 'True' as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing PollingInterval to '10' second(s) as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing WindowsServiceUseFileShareStorage to 'False' as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing MemoryLimit to '60' percent as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing RecycleTime to '720' minute(s) as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing MaximumMemoryLimit to '80' percent as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing MaxQueueThreads to '0' thread(s) as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing IsWebServiceEnabled to 'True' as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing MaxScheduleWait to '5' second(s) as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing DatabaseQueryTimeout to '120' second(s) as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing ProcessRecycleOptions to '0' as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing RunningRequestsScavengerCycle to '60' second(s) as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing RunningRequestsDbCycle to '60' second(s) as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing RunningRequestsAge to '30' second(s) as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing CleanupCycleMinutes to '10' minute(s) as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing DailyCleanupMinuteOfDay to default value of '120' minutes since midnight because it was not specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing WatsonFlags to '1064' as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing WatsonDumpOnExceptions to 'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException' as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing WatsonDumpExcludeIfContainsExceptions to 'System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException' as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing SecureConnectionLevel to '0' as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing DisplayErrorLink to 'True' as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing WebServiceUseFileShareStorage to 'False' as specified in Configuration file.
w3wp!resourceutilities!1!5/8/2007-10:17:30:: i INFO: Reporting Services starting SKU: Evaluation
w3wp!resourceutilities!1!5/8/2007-10:17:30:: i INFO: Evaluation copy: 175 days left
w3wp!runningjobs!1!5/8/2007-10:17:31:: i INFO: Database Cleanup (Web Service) timer enabled: Next Event: 600 seconds. Cycle: 600 seconds
w3wp!runningjobs!1!5/8/2007-10:17:31:: i INFO: Running Requests Scavenger timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
w3wp!runningjobs!1!5/8/2007-10:17:31:: i INFO: Running Requests DB timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
w3wp!runningjobs!1!5/8/2007-10:17:31:: i INFO: Memory stats update timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
w3wp!library!1!05/08/2007-10:17:31:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. > System.NullReferenceException: Object reference not set to an instance of an object.
at Microsoft.ReportingServices.Authentication.WindowsAuthentication.GetUserInfo(IIdentity& userIdentity, IntPtr& userId)
at Microsoft.ReportingServices.WebServer.WebServiceHelper.ConstructRSServiceObjectFromSecurityExtension()
at Microsoft.ReportingServices.WebServer.Global.ConstructRSServiceFromRequest(String item)
at Microsoft.ReportingServices.WebServer.Global.get_Service()
at Microsoft.ReportingServices.WebServer.Global.ShouldRejectAntiDos()
at Microsoft.ReportingServices.WebServer.Global.Application_AuthenticateRequest(Object sender, EventArgs e)
End of inner exception stack trace
w3wp!library!1!05/08/2007-10:17:33:: i INFO: Exception dumped to: c:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles flags= ReferencedMemory, AllThreads, SendToWatson
w3wp!library!1!05/08/2007-10:17:33:: i INFO: Catalog SQL Server Edition = Evaluation
w3wp!library!1!05/08/2007-10:17:36:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. > System.NullReferenceException: Object reference not set to an instance of an object.
at Microsoft.ReportingServices.Authentication.WindowsAuthentication.GetUserInfo(IIdentity& userIdentity, IntPtr& userId)
at Microsoft.ReportingServices.WebServer.WebServiceHelper.ConstructRSServiceObjectFromSecurityExtension()
at Microsoft.ReportingServices.WebServer.Global.ConstructRSServiceFromRequest(String item)
at Microsoft.ReportingServices.WebServer.Global.get_Service()
at Microsoft.ReportingServices.WebServer.Global.ShouldRejectAntiDos()
at Microsoft.ReportingServices.WebServer.Global.Application_AuthenticateRequest(Object sender, EventArgs e)
End of inner exception stack trace
w3wp!library!1!05/08/2007-10:17:38:: i INFO: Exception dumped to: c:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles flags= ReferencedMemory, AllThreads, SendToWatson
w3wp!library!5!05/08/2007-10:27:04:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. > System.NullReferenceException: Object reference not set to an instance of an object.
at Microsoft.ReportingServices.Authentication.WindowsAuthentication.GetUserInfo(IIdentity& userIdentity, IntPtr& userId)
at Microsoft.ReportingServices.WebServer.WebServiceHelper.ConstructRSServiceObjectFromSecurityExtension()
at Microsoft.ReportingServices.WebServer.Global.ConstructRSServiceFromRequest(String item)
at Microsoft.ReportingServices.WebServer.Global.get_Service()
at Microsoft.ReportingServices.WebServer.Global.ShouldRejectAntiDos()
at Microsoft.ReportingServices.WebServer.Global.Application_AuthenticateRequest(Object sender, EventArgs e)
End of inner exception stack trace
w3wp!library!7!5/8/2007-10:27:31:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!5!05/08/2007-10:27:35:: i INFO: Exception dumped to: c:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles flags= ReferencedMemory, AllThreads, SendToWatson
w3wp!library!1!05/08/2007-10:27:37:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. > System.NullReferenceException: Object reference not set to an instance of an object.
at Microsoft.ReportingServices.Authentication.WindowsAuthentication.GetUserInfo(IIdentity& userIdentity, IntPtr& userId)
at Microsoft.ReportingServices.WebServer.WebServiceHelper.ConstructRSServiceObjectFromSecurityExtension()
at Microsoft.ReportingServices.WebServer.Global.ConstructRSServiceFromRequest(String item)
at Microsoft.ReportingServices.WebServer.Global.get_Service()
at Microsoft.ReportingServices.WebServer.Global.ShouldRejectAntiDos()
at Microsoft.ReportingServices.WebServer.Global.Application_AuthenticateRequest(Object sender, EventArgs e)
End of inner exception stack trace
If you're running on Vista, you must install SQL Server SP2. Here are some KB articles that should help you out.
http://support.microsoft.com/kb/934164 (install)
http://support.microsoft.com/kb/934163 (upgrade)
-Lukasz
|||I had a similar problem. It turned out that since I had a named instance of SQL Server 2005 I had to reference that in the url. Specifically, it was http://localhost/ReportServer$NAMEOFSQLSERVERINSTANCE - CindyPsych
Help!! "The report server has encountered a configuration error........"
I have installed Sql Server 2005 on my machine. I've managed to created report, but when i try to deploy e same, I'm getting e following error...am i missing something here?
The report server has encountered a configuration error. See the report server log files for more information. (rsServerConfigurationError) Access to the path 'C:\Program Files\Microsoft SQL Server\MSSQL.4\Reporting Services\ReportServer\RSReportServer.config' is denied.
when i checked in msdn..there it says
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSerrors/htm/Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings.resources.Strings_rsServerConfigurationError.asp
Other info:
I have followed the Tutorial Project in SQL Books online. And for TargetURL, i have given --> http://localhost/reportserver
Report server is located in my local only
rsreportserver.config : I dint touch this file and mine is fresh installation.
Help please :)
Can you access Report Manager via Internet Explorer (http://server/reports) at all? Or does it throw the same/similar error?
It sounds to me like the account that SSRS is running under doesn't have the proper NTFS perms on the 'C:\Program Files\Microsoft SQL Server\MSSQL.4\Reporting Services\ReportServer\' folder. Verify that that it does, or use the filemon tool from sysinternals.com to capture a log of what process (and which account) is getting denied...this will give you most of the info you'd need to fix the issue.
Good luck!
|||I experienced the problem described above and the filemon tool identified that the ASPNET user did not have read privileges to the .config file.
It seems strange that the server installation did not configure this correctly.. Setting privileges manually solved the problem..
Add ASPNET user to SQLServer2005Reporting ServicesWebServiceUsers$<MACHINE NAME> group, reboot your machine and it should start working properly.
|||You should be able to fix this as well by using the Report Server Configuration tool to set the web service identity.
-Lukasz
|||Web Service Identity is hard coded on the "Configure Report Server" page.|||Hi,
I am having similar issue trying to launch report services by http://localhost/reports. I got the following error
when try to launch it.
The report server is not responding. Verify that the report server is running and can be accessed from this computer.
I used the Reporting Services Configuration tool to set all my virtual directory and etc... and verified that the report server is initiated and running. I have read other thread for similar issue, but none was able to provide a clear solution on how to resolve the problem. Any help would be appriciated.
|||Look in your log files and see if there is a detailed error message there. That's your best place to start.
-Lukasz
|||Hi,
I've look at the log file and it didn't help me much. Maybe you can point me to the right direction.
By the way, I am running Vista and using the Server 2005 eval edition. I don't know if this make any differences. I still couldn't get it took work for me. Any help would be greatly appriciate. The error i get is as follow when try to launch the report service using http://localhost/reports:
The report server is not responding. Verify that the report server is running and can be accessed from this computer.
<Header>
<Product>Microsoft SQL Server Reporting Services Version 9.00.3054.00</Product>
<Locale>en-US</Locale>
<TimeZone>Central Daylight Time</TimeZone>
<Path>c:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles\ReportServer__05_08_2007_10_17_13.log</Path>
<SystemName>ATS-PC</SystemName>
<OSName>Microsoft Windows NT 6.0.6000.0</OSName>
<OSVersion>6.0.6000.0</OSVersion>
</Header>
w3wp!webserver!1!5/8/2007-10:17:30:: i INFO: Reporting Web Server started
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing ConnectionType to '0' as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing IsSchedulingService to 'True' as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing IsNotificationService to 'True' as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing IsEventService to 'True' as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing PollingInterval to '10' second(s) as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing WindowsServiceUseFileShareStorage to 'False' as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing MemoryLimit to '60' percent as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing RecycleTime to '720' minute(s) as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing MaximumMemoryLimit to '80' percent as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing MaxQueueThreads to '0' thread(s) as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing IsWebServiceEnabled to 'True' as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing MaxScheduleWait to '5' second(s) as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing DatabaseQueryTimeout to '120' second(s) as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing ProcessRecycleOptions to '0' as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing RunningRequestsScavengerCycle to '60' second(s) as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing RunningRequestsDbCycle to '60' second(s) as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing RunningRequestsAge to '30' second(s) as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing CleanupCycleMinutes to '10' minute(s) as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing DailyCleanupMinuteOfDay to default value of '120' minutes since midnight because it was not specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing WatsonFlags to '1064' as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing WatsonDumpOnExceptions to 'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException' as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing WatsonDumpExcludeIfContainsExceptions to 'System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException' as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing SecureConnectionLevel to '0' as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing DisplayErrorLink to 'True' as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing WebServiceUseFileShareStorage to 'False' as specified in Configuration file.
w3wp!resourceutilities!1!5/8/2007-10:17:30:: i INFO: Reporting Services starting SKU: Evaluation
w3wp!resourceutilities!1!5/8/2007-10:17:30:: i INFO: Evaluation copy: 175 days left
w3wp!runningjobs!1!5/8/2007-10:17:31:: i INFO: Database Cleanup (Web Service) timer enabled: Next Event: 600 seconds. Cycle: 600 seconds
w3wp!runningjobs!1!5/8/2007-10:17:31:: i INFO: Running Requests Scavenger timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
w3wp!runningjobs!1!5/8/2007-10:17:31:: i INFO: Running Requests DB timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
w3wp!runningjobs!1!5/8/2007-10:17:31:: i INFO: Memory stats update timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
w3wp!library!1!05/08/2007-10:17:31:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. > System.NullReferenceException: Object reference not set to an instance of an object.
at Microsoft.ReportingServices.Authentication.WindowsAuthentication.GetUserInfo(IIdentity& userIdentity, IntPtr& userId)
at Microsoft.ReportingServices.WebServer.WebServiceHelper.ConstructRSServiceObjectFromSecurityExtension()
at Microsoft.ReportingServices.WebServer.Global.ConstructRSServiceFromRequest(String item)
at Microsoft.ReportingServices.WebServer.Global.get_Service()
at Microsoft.ReportingServices.WebServer.Global.ShouldRejectAntiDos()
at Microsoft.ReportingServices.WebServer.Global.Application_AuthenticateRequest(Object sender, EventArgs e)
End of inner exception stack trace
w3wp!library!1!05/08/2007-10:17:33:: i INFO: Exception dumped to: c:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles flags= ReferencedMemory, AllThreads, SendToWatson
w3wp!library!1!05/08/2007-10:17:33:: i INFO: Catalog SQL Server Edition = Evaluation
w3wp!library!1!05/08/2007-10:17:36:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. > System.NullReferenceException: Object reference not set to an instance of an object.
at Microsoft.ReportingServices.Authentication.WindowsAuthentication.GetUserInfo(IIdentity& userIdentity, IntPtr& userId)
at Microsoft.ReportingServices.WebServer.WebServiceHelper.ConstructRSServiceObjectFromSecurityExtension()
at Microsoft.ReportingServices.WebServer.Global.ConstructRSServiceFromRequest(String item)
at Microsoft.ReportingServices.WebServer.Global.get_Service()
at Microsoft.ReportingServices.WebServer.Global.ShouldRejectAntiDos()
at Microsoft.ReportingServices.WebServer.Global.Application_AuthenticateRequest(Object sender, EventArgs e)
End of inner exception stack trace
w3wp!library!1!05/08/2007-10:17:38:: i INFO: Exception dumped to: c:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles flags= ReferencedMemory, AllThreads, SendToWatson
w3wp!library!5!05/08/2007-10:27:04:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. > System.NullReferenceException: Object reference not set to an instance of an object.
at Microsoft.ReportingServices.Authentication.WindowsAuthentication.GetUserInfo(IIdentity& userIdentity, IntPtr& userId)
at Microsoft.ReportingServices.WebServer.WebServiceHelper.ConstructRSServiceObjectFromSecurityExtension()
at Microsoft.ReportingServices.WebServer.Global.ConstructRSServiceFromRequest(String item)
at Microsoft.ReportingServices.WebServer.Global.get_Service()
at Microsoft.ReportingServices.WebServer.Global.ShouldRejectAntiDos()
at Microsoft.ReportingServices.WebServer.Global.Application_AuthenticateRequest(Object sender, EventArgs e)
End of inner exception stack trace
w3wp!library!7!5/8/2007-10:27:31:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!5!05/08/2007-10:27:35:: i INFO: Exception dumped to: c:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles flags= ReferencedMemory, AllThreads, SendToWatson
w3wp!library!1!05/08/2007-10:27:37:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. > System.NullReferenceException: Object reference not set to an instance of an object.
at Microsoft.ReportingServices.Authentication.WindowsAuthentication.GetUserInfo(IIdentity& userIdentity, IntPtr& userId)
at Microsoft.ReportingServices.WebServer.WebServiceHelper.ConstructRSServiceObjectFromSecurityExtension()
at Microsoft.ReportingServices.WebServer.Global.ConstructRSServiceFromRequest(String item)
at Microsoft.ReportingServices.WebServer.Global.get_Service()
at Microsoft.ReportingServices.WebServer.Global.ShouldRejectAntiDos()
at Microsoft.ReportingServices.WebServer.Global.Application_AuthenticateRequest(Object sender, EventArgs e)
End of inner exception stack trace
If you're running on Vista, you must install SQL Server SP2. Here are some KB articles that should help you out.
http://support.microsoft.com/kb/934164 (install)
http://support.microsoft.com/kb/934163 (upgrade)
-Lukasz
|||I had a similar problem. It turned out that since I had a named instance of SQL Server 2005 I had to reference that in the url. Specifically, it was http://localhost/ReportServer$NAMEOFSQLSERVERINSTANCE - CindyPsych