Report Server not showing - error http 500 on SSRS 2008 SP1 installation on 64-bit Vista Business edition
I am unable to view the Report Server on I installed SSRS 2008 SP1 on my 64-bit Vista PC. I understand it uses IIS 7 and have read the differences on MSDNhttp://msdn.microsoft.com/en-us/library/cc646023.aspxbut setting the Windows Firewall TCP setting has not solved the issue.When I go into IIS Manager I don't see the virtual directories for reports and reportserver so I'm not sure if that is an issue.When I installed on my works Windows XP 2 I did not have any of these problems.In the Reporting Services Configuration Manager, the Web Services URL is set to http://<myPCname:80>ReportServer but the webpage open with a http 500 error, also asks for my userid and password which I have inputted correctly.The Report Builder works fine but it is also unable to view the Report ServerI am a newbie to SSRS and trying to learn Reporting Services from my home PC but am stumped as to solve this problem.Please help/advise. Very much appreciated.SP in Scotland.
July 5th, 2009 3:57pm

Hi,Report server architecture is fundamentally changed in SQL Server 2008 by the removal of IIS dependencies. The new architecture embeds HTTP server capabilities into the report server itself. The HTTP 500 error indicates there are conflicting authentication setting in the report server Web.config file and RSReportServer.config file. In RSReportServer.config file, make sure the AuthenticationTypes setting as follows:<AuthenticationTypes><RSWindows*/></AuthenticationTypes>In the report server Web.config file, please also check the authentication type:Authentication=WindowsIf you have any more questions, please let me know.Thanks.***Xiao Min Tan***Microsoft Online Community***
Free Windows Admin Tool Kit Click here and download it now
July 7th, 2009 8:43am

Thank you Xiao-Min-tan for your support.I did try the various RSWindows* combinations but I still get the same HTTP 500 errorfor both ReportsServer and Reports from theReportingServices Configuration Manager.<Authentication><AuthenticationTypes> <RSWindowsNTLM /></AuthenticationTypes><EnableAuthPersistence>true</EnableAuthPersistence></Authentication> I also read the notes on this issue:http://msdn.microsoft.com/en-us/library/cc281253.aspxThe problem persists.I also enclose the error section of my SQL Reporting log file for your perusal.<Header>......appdomainmanager!DefaultDomain!1048!07/07/2009-20:31:16:: i INFO: Appdomain:2 WindowsService_0 started.resourceutilities!WindowsService_0!1048!07/07/2009-20:31:16:: i INFO: Reporting Services starting SKU: Developerresourceutilities!WindowsService_0!1048!07/07/2009-20:31:16:: i INFO: Evaluation copy: 0 days leftresourceutilities!WindowsService_0!1048!07/07/2009-20:31:16:: i INFO: Running on 4 physical processors, 4 logical processorsrshost!rshost!12fc!07/07/2009-20:31:16:: i INFO: Registered url=http://+:80/ReportServer/, vdir=/ReportServer, pdir=C:\Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER\Reporting Services\ReportServer.rshost!rshost!12fc!07/07/2009-20:31:16:: i INFO: Currently registered url http://+:80/ReportServer/ on endpoint 2rshost!rshost!2ec!07/07/2009-20:31:16:: i INFO: Registered url=http://+:80/Reports/, vdir=/Reports, pdir=C:\Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER\Reporting Services\ReportManager.rshost!rshost!2ec!07/07/2009-20:31:16:: i INFO: Currently registered url http://+:80/Reports/ on endpoint 3rshost!rshost!1280!07/07/2009-20:31:16:: i INFO: Endpoint 4 is disabled and no url is registered vdir=/ReportServer/ReportBuilder, pdir=C:\Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER\Reporting Services\ReportServer\ReportBuilder.resourceutilities!DefaultDomain!1048!07/07/2009-20:31:16:: i INFO: Reporting Services starting SKU: Developerresourceutilities!DefaultDomain!1048!07/07/2009-20:31:16:: i INFO: Evaluation copy: 0 days leftrshost!rshost!1048!07/07/2009-20:31:16:: i INFO: Derived memory configuration based on physical memory as 4125728 KBrpcserver!DefaultDomain!1280!07/07/2009-20:31:16:: i INFO: Process monitoring started.servicecontroller!DefaultDomain!12fc!07/07/2009-20:31:16:: i INFO: Total Physical memory: 4224745472library!WindowsService_0!e08!07/07/2009-20:31:16:: i INFO: Catalog SQL Server Edition = Developercrypto!WindowsService_0!e08!07/07/2009-20:31:16:: i INFO: Initializing crypto as user: NT AUTHORITY\NETWORK SERVICEcrypto!WindowsService_0!e08!07/07/2009-20:31:16:: i INFO: Exporting public keycrypto!WindowsService_0!e08!07/07/2009-20:31:16:: i INFO: Performing sku validationcrypto!WindowsService_0!e08!07/07/2009-20:31:16:: i INFO: Importing existing encryption keydbpolling!WindowsService_0!e08!07/07/2009-20:31:16:: i INFO: EventPolling polling service starteddbpolling!WindowsService_0!e08!07/07/2009-20:31:16:: i INFO: NotificationPolling polling service starteddbpolling!WindowsService_0!e08!07/07/2009-20:31:16:: i INFO: SchedulePolling polling service starteddbpolling!WindowsService_0!e08!07/07/2009-20:31:16:: i INFO: UpgradePolling polling service starteddbpolling!WindowsService_0!172c!07/07/2009-20:31:16:: i INFO: HeartbeatThread(EventPolling): heartbeat thread started.dbpolling!WindowsService_0!2ec!07/07/2009-20:31:16:: i INFO: HeartbeatThread(NotificationPolling): heartbeat thread started.dbpolling!WindowsService_0!a10!07/07/2009-20:31:16:: i INFO: PollingMaintenance: Polling startedrunningjobs!WindowsService_0!e08!07/07/2009-20:31:16:: i INFO: Database Cleanup (NT Service) timer enabled: Next Event: 600 seconds. Cycle: 600 secondsrunningjobs!WindowsService_0!e08!07/07/2009-20:31:16:: i INFO: Running Requests Scavenger timer enabled: Next Event: 60 seconds. Cycle: 60 secondsrunningjobs!WindowsService_0!e08!07/07/2009-20:31:16:: i INFO: Running Requests DB timer enabled: Next Event: 60 seconds. Cycle: 60 secondsrunningjobs!WindowsService_0!e08!07/07/2009-20:31:16:: i INFO: Execution Log Entry Expiration timer enabled: Next Event: 19723 seconds. Cycle: 86400 secondsrunningjobs!WindowsService_0!e08!07/07/2009-20:31:16:: i INFO: SQM timer timer enabled: Next Event: 23323 seconds. Cycle: 86400 secondsrpcserver!DefaultDomain!e08!07/07/2009-20:31:16:: i INFO: RPC Server started.servicecontroller!DefaultDomain!e08!07/07/2009-20:31:16:: i INFO: RPC Server started. Endpoint name ='ReportingServices$MSRS10.MSSQLSERVER'appdomainmanager!WindowsService_0!e08!07/07/2009-20:31:16:: i INFO: Appdomain:2 WindowsService_0 initialized.library!DefaultDomain!fc8!07/07/2009-20:31:17:: i INFO: Catalog SQL Server Edition = Developerappdomainmanager!DefaultDomain!ba4!07/07/2009-20:32:05:: i INFO: Appdomain:3 ReportServer_MSSQLSERVER_0-1-128914687253338110 started.appdomainmanager!DefaultDomain!ba4!07/07/2009-20:32:05:: e ERROR: AppDomain ReportServer_MSSQLSERVER_0 failed to start. Error: (0): error CS0016: Could not write to output file 'c:\Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER\Reporting Services\rstempfiles\reportserver\13de8c64\97d4cdf9\App_global.asax.z-casw9x.dll' -- 'The directory name is invalid. 'library!DefaultDomain!ba4!07/07/2009-20:32:05:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerHttpRuntimeInternalException: An internal or system error occurred in the HTTP Runtime object for application domain ReportServer_MSSQLSERVER_0. , Failed to create HTTP Runtime;Info: Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerHttpRuntimeInternalException: An internal or system error occurred in the HTTP Runtime object for application domain ReportServer_MSSQLSERVER_0. ---> System.Web.HttpCompileException: (0): error CS0016: Could not write to output file 'c:\Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER\Reporting Services\rstempfiles\reportserver\13de8c64\97d4cdf9\App_global.asax.z-casw9x.dll' -- 'The directory name is invalid. ' at System.Web.Compilation.AssemblyBuilder.Compile() at System.Web.Compilation.BuildProvidersCompiler.PerformBuild() at System.Web.Compilation.ApplicationBuildProvider.GetGlobalAsaxBuildResult(Boolean isPrecompiledApp) at System.Web.Compilation.BuildManager.CompileGlobalAsax() at System.Web.Compilation.BuildManager.EnsureTopLevelFilesCompiled() at System.Web.Hosting.HostingEnvironment.Initialize(ApplicationManager appManager, IApplicationHost appHost, IConfigMapPathFactory configMapPathFactory, HostingEnvironmentParameters hostingParameters) at System.Web.Hosting.HostingEnvironment.Initialize(ApplicationManager appManager, IApplicationHost appHost, IConfigMapPathFactory configMapPathFactory, HostingEnvironmentParameters hostingParameters) at System.Web.Hosting.ApplicationManager.CreateAppDomainWithHostingEnvironment(String appId, IApplicationHost appHost, HostingEnvironmentParameters hostingParameters) at System.Web.Hosting.ApplicationManager.CreateAppDomainWithHostingEnvironmentAndReportErrors(String appId, IApplicationHost appHost, HostingEnvironmentParameters hostingParameters) at System.Web.Hosting.ApplicationManager.GetAppDomainWithHostingEnvironment(String appId, IApplicationHost appHost, HostingEnvironmentParameters hostingParameters) at System.Web.Hosting.ApplicationManager.CreateObjectInternal(String appId, Type type, IApplicationHost appHost, Boolean failIfExists, HostingEnvironmentParameters hostingParameters) at System.Web.Hosting.ApplicationManager.CreateObject(String appId, Type type, String virtualPath, String physicalPath, Boolean failIfExists, Boolean throwOnError) at ReportingServicesHttpRuntime.RsHttpRuntime.Create(RsAppDomainType type, String vdir, String pdir, Int32& domainId) --- End of inner exception stack trace ---appdomainmanager!ReportServer_0-1!ba4!07/07/2009-20:32:05:: i INFO: Appdomain:3 ReportServer_MSSQLSERVER_0-1-128914687253338110 unloadinglibrary!DefaultDomain!ba4!07/07/2009-20:32:05:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerAppDomainManagerException: An error occurred when attempting to start the application domain ReportServer within the Report Server service., Failed to create Report Server HTTP Runtime;Info: Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerAppDomainManagerException: An error occurred when attempting to start the application domain ReportServer within the Report Server service. ---> Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerHttpRuntimeInternalException: An internal or system error occurred in the HTTP Runtime object for application domain ReportServer_MSSQLSERVER_0. ---> System.Web.HttpCompileException: (0): error CS0016: Could not write to output file 'c:\Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER\Reporting Services\rstempfiles\reportserver\13de8c64\97d4cdf9\App_global.asax.z-casw9x.dll' -- 'The directory name is invalid. ' at System.Web.Compilation.AssemblyBuilder.Compile() at System.Web.Compilation.BuildProvidersCompiler.PerformBuild() at System.Web.Compilation.ApplicationBuildProvider.GetGlobalAsaxBuildResult(Boolean isPrecompiledApp) at System.Web.Compilation.BuildManager.CompileGlobalAsax() at System.Web.Compilation.BuildManager.EnsureTopLevelFilesCompiled() at System.Web.Hosting.HostingEnvironment.Initialize(ApplicationManager appManager, IApplicationHost appHost, IConfigMapPathFactory configMapPathFactory, HostingEnvironmentParameters hostingParameters) at System.Web.Hosting.HostingEnvironment.Initialize(ApplicationManager appManager, IApplicationHost appHost, IConfigMapPathFactory configMapPathFactory, HostingEnvironmentParameters hostingParameters) at System.Web.Hosting.ApplicationManager.CreateAppDomainWithHostingEnvironment(String appId, IApplicationHost appHost, HostingEnvironmentParameters hostingParameters) at System.Web.Hosting.ApplicationManager.CreateAppDomainWithHostingEnvironmentAndReportErrors(String appId, IApplicationHost appHost, HostingEnvironmentParameters hostingParameters) at System.Web.Hosting.ApplicationManager.GetAppDomainWithHostingEnvironment(String appId, IApplicationHost appHost, HostingEnvironmentParameters hostingParameters) at System.Web.Hosting.ApplicationManager.CreateObjectInternal(String appId, Type type, IApplicationHost appHost, Boolean failIfExists, HostingEnvironmentParameters hostingParameters) at System.Web.Hosting.ApplicationManager.CreateObject(String appId, Type type, String virtualPath, String physicalPath, Boolean failIfExists, Boolean throwOnError) at ReportingServicesHttpRuntime.RsHttpRuntime.Create(RsAppDomainType type, String vdir, String pdir, Int32& domainId) --- End of inner exception stack trace --- at ReportingServicesHttpRuntime.RsHttpRuntime.Create(RsAppDomainType type, String vdir, String pdir, Int32& domainId) at Microsoft.ReportingServices.AppDomainManager.RsAppDomainManager.CreateHttpRuntime(RsAppDomainType appDomainType, String vdir, String pdir, Int32& domainId) --- End of inner exception stack trace ---rshost!rshost!ba4!07/07/2009-20:32:05:: e ERROR: Failed to create HttpRuntime 80131500.rshost!rshost!ba4!07/07/2009-20:32:05:: e ERROR: Failed to get appdomain 80131500, pipeline=0x00000000003EFD30.rshost!rshost!ba4!07/07/2009-20:32:05:: e ERROR: Error state. Internal abort for pipeline=0x00000000003EFD30 ...appdomainmanager!DefaultDomain!1760!07/07/2009-20:32:10:: i INFO: Appdomain:3 ReportServer_MSSQLSERVER_0-1-128914687253338110 unregistered.rshost!rshost!1760!07/07/2009-20:32:10:: i INFO: Application domain type ReportServer statistics: created: 1, unloaded: 1, failed: 0, timed out: 0.rpcserver!DefaultDomain!1280!07/07/2009-20:37:00:: i INFO: Process monitoring stopped.rpcserver!DefaultDomain!1430!07/07/2009-20:37:00:: i INFO: RPC Server stopped.servicecontroller!DefaultDomain!1430!07/07/2009-20:37:00:: i INFO: RPC Server stopped. dbpolling!WindowsService_0!d3c!07/07/2009-20:37:00:: i INFO: EventPolling polling service stoppedservicecontroller!WindowsService_0!1430!07/07/2009-20:37:00:: i INFO: Service controller exiting.dbpolling!WindowsService_0!172c!07/07/2009-20:37:00:: i INFO: HeartbeatThread(EventPolling): Exited.dbpolling!WindowsService_0!d3c!07/07/2009-20:37:00:: i INFO: NotificationPolling polling service stoppeddbpolling!WindowsService_0!2ec!07/07/2009-20:37:00:: i INFO: HeartbeatThread(NotificationPolling): Exited.dbpolling!WindowsService_0!d3c!07/07/2009-20:37:00:: i INFO: SchedulePolling polling service stoppeddbpolling!WindowsService_0!d3c!07/07/2009-20:37:00:: i INFO: UpgradePolling polling service stoppedappdomainmanager!DefaultDomain!1430!07/07/2009-20:37:00:: i INFO: Appdomain:2 WindowsService_0 unregistered.appdomainmanager!DefaultDomain!1430!07/07/2009-20:37:00:: i INFO: Appdomain:2 WindowsService_0 unloading.appdomainmanager!DefaultDomain!2ec!07/07/2009-20:37:00:: i INFO: AppDomain:2 0 pending unload(s)appdomainmanager!DefaultDomain!1760!07/07/2009-20:37:00:: i INFO: Appdomain:2 unregistered.rshost!rshost!1760!07/07/2009-20:37:00:: i INFO: Application domain type WindowsService statistics: created: 1, unloaded: 1, failed: 0, timed out: 0.servicecontroller!DefaultDomain!1430!07/07/2009-20:37:00:: i INFO: Service shutting down.--Please advise what else I can do to solve this problem.Many thanks.
July 7th, 2009 10:48pm

RS 2008 does not use IIS. That is a major architectural change so you will not see it in IIS. Is everything a green light in the configuration manager? If so then my guess is that Vista access control has hit you. From a post by Jin Chen Microsoft:>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> To avoid prompting login dialog, please add the URL of the Reporting Service to trusted site zone as the tutorial mentioned. And then configure the Internet Explorer to automatic login with current username and password for the trusted site zone. To configure the Internet Explorer to automatic login with current username and password for the trusted site zone, please follow these steps: 1. Click Tools Interenet Options in Internet Explorer 2. Switch to the "Security" tab 3. Select " Trusted sites" 4. Disable Protected mode by un-checking the "Enable Protected mode" checkbox. 5. In the same dialog, click the "Custom Level" button. 6. In the "Security settings Trusted sites zone" dialog, select "Automatic login with current use name and password". >>>>>>>>>>>>>>>>>>>>>>>>>>>>> Bruce Loehle-Conger SQL Server Reporting Services MVP
Free Windows Admin Tool Kit Click here and download it now
July 7th, 2009 10:58pm

Bruce,Thanks for your suggestion.I have now done that (site in in my list of trusted sites0 and set the settings as advised above, but still the pesky HTTP 500 error persists.http://localhost/ - shows me the blue IIS 7 welcome screenhttp://localhost/report- just testing no such folder - 404.0 error shown - sounds righthttp://localhost/reports- expecting this to work - HTTP 500 error !!!http://localhost/ReportsServer- just testing no such folder - 404.0 error - sounds righthttp://localhost/ReportServer- expecting this to work - HTTP 500 error !!!I am willing to try any other suggestions out there.Many thanks.SP in Scotland
July 7th, 2009 11:56pm

Can you make sure that RS Service account has permissions on RSTempFiles folder?
Free Windows Admin Tool Kit Click here and download it now
July 8th, 2009 12:52am

1. Go to Reporting Services configuration manager. 2. click on Databases. Make sure you already have on report database. I f not create new. 3. Go to WEbservice URL , there is link below called as Report Server Webservice URL Click on that Link and you should be able to see it. Thanks, Sandeep~~ Mark it as Answer if you find it correct~~
July 8th, 2009 1:41am

Hello SmitaPlease can you tell me how to check RS Service account permissions on RS TempFiles folder?Thanks.Siva
Free Windows Admin Tool Kit Click here and download it now
July 8th, 2009 2:12am

Hello Sandeep,Thank you for your suggestion.I have set the database name as ReportServer using the Database option in the RS Configuration Manager but to no sucess.The link in the Web Service URL option still gives me a HTTP 500 error.Your help is much appreciated.Siva
July 8th, 2009 2:15am

Hi Siva,Do you check the authentication type option in the report server Web.config file? By default, the Web.config file is located in <driver>:\Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER\Reporting Services\ReportServer (<driver>:\Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER\Reporting Services\RerpotManager). The setting should be as follows:<authentication mode="Windows" />If you have any more questions, please let me know.Thanks.***Xiao Min Tan***Microsoft Online Community***
Free Windows Admin Tool Kit Click here and download it now
July 8th, 2009 12:44pm

The error message in the log file says:"Could not write to output file 'c:\Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER\Reporting Services\rstempfiles\reportserver\13de8c64\97d4cdf9\App_global.asax.z-casw9x.dll' -- 'The directory name is invalid. '"This is where you should start since it appears to be the root cause of the problem. As Smita suggests, look at the security permissions settings for each folder starting with rstempfiles and determine if RS service account or a group it is a member of has enough permission to use the folder. Hope that helps,-LukaszThis posting is provided "AS IS" with no warranties, and confers no rights.
July 9th, 2009 7:30pm

Hello Min TanThank you for your advice about the <authentication mode="Windows" /> but this was already set up as is from the time of installation.So here in this case, this was not the culprit.Thanks very much for the suggestion.
Free Windows Admin Tool Kit Click here and download it now
July 9th, 2009 10:32pm

Hello Lukasz,Thank you very much for the suggestion.I did go in the Tempfolders directory and released the read-only option on the folders but it keep coming back. I am not sure why.I have also given the Network Service account full rights but still get the http 500 error.I am surprised at how much work and time this system installation takes and yet no positive results.I have a 4MB Vista 64-bit home pc, with UAC turned off.I am the only user with Administrator rights.I installed SQL 2008 w Reporting Services and never had any joy at all.The software installed with no errors and all the other parts of the SQL including Configuration Manager and Management Studio all work!But the Reporting Services just doesn't.I have tried all the suggestions made and I thank you very much for them but between that and all my time online looking for suggestions to solve this problem has just killed my enthusiasism for this project.I thought things would be faster better and easier with 64-bit and all that jazz.How come SQL 2008 installs beautifully and easily on Windows XP and Windows Server with no problemsand not on Vista 64-bit. I thought MS was improving its system not getting worse.I am now using a VPC running Windows 2003 and SQL 2008 to learn for my project.I am so disappointed with this SQL 2008/Vista 64-bit installation - words fail me! What I would like to know is, is there anyone out there who actually got SQL 2008 working on 64-bit Vista? Roll on Windows 7, I can't wait to dump Vista.However I would like to thank everyone for their suggestions. Great forum for support!SP in Scotland.
July 9th, 2009 10:46pm

Hello LukaszI have now checked and can confirm that the RS service account has permissions to use the folder but still no joy. http 500 error still persists.Thanks though.SP
Free Windows Admin Tool Kit Click here and download it now
July 10th, 2009 12:30am

Are there any error messages in the RS Trace logs? I would try creating a new instance and then using the SSRS configuration utility to configure it. I have not seen this kind of problem before that is specific to Vista x64. If there are no more problems listed in the log files, then probably opening a customer support case would be appropriate to work through why you are seeing this issue.Hope that helps,-LukaszThis posting is provided "AS IS" with no warranties, and confers no rights.
July 15th, 2009 11:48pm

A little gotcha for folks struggling with this kind of issue: if permissions for the RSTempFiles folder are missing for your RS Service account (like in my case), then be sure to restart the RS service after you add the perms. I was certain the service will pick the perms right away, so I ended up wasting time to solve a solved issue ;) Cheers, Michal
Free Windows Admin Tool Kit Click here and download it now
January 26th, 2011 11:13am

try this http://otkfounder.blogspot.com/2007/11/solving-reportviewer-rendering-issue-on.htmlGeorge Mathew
March 15th, 2011 5:06am

I was having this problem also. I tried all the suggestions in the other replies, but nothing worked. Finally I went and checked the account that was running Reporting Services, and saw that it was "Local System" instead of "Network Services". I had been setting permissions on all the temp folders for the "Network Services" account, to no effect. So this is something you might want to double check. Go to Reporting Services Configuration Manager, and choose Service Account. If "Use bult-in acount" is selected, make sure it says "Network Service". If "Use another account" is selected, then that is the account that will need privileges on the temp folders. If you change the account, you will get a warning about resetting the encryption key. You can make this warning go away by choosing "Encryption Keys" and then "Delete Encrypted Content" - but do so at your own risk.
Free Windows Admin Tool Kit Click here and download it now
March 29th, 2011 4:25am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics