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
