SSRS 2008 not working after configuration on Windows Server 2008
I am doing a new installation of SSRS 2008 R2 on my server. When I installed the product, I chose to configure SSRS later. I when through the configuration tool. When I completed the configuration, the /reports url gives me an error 500, and the /reportserver gives me the following. The report server encountered an unhandled exception in HttpApplication. (rsUnhandledHttpApplicationError) Get Online Help Could not load file or assembly 'CrystalDecisions.Web, Version=10.2.3600.0, Culture=neutral, PublicKeyToken=692fbea5521e1304' or one of its dependencies. The system cannot find the file specified. (C:\Windows\Microsoft.NET\Framework\v2.0.50727\Config\web.config line 239) Could not load file or assembly 'CrystalDecisions.Web, Version=10.2.3600.0, Culture=neutral, PublicKeyToken=692fbea5521e1304' or one of its dependencies. The system cannot find the file specified. -------------------------------------------------------------------------------- I did go pull that line out of the web config, and got the following: testsql/ReportServer - / Microsoft SQL Server Reporting Services Version 10.50.1600.1 This is a clean windows 2008 installation. We have all the frameworks up to 3.5 SP 1 installed. What could be causing this behavior?
July 23rd, 2010 8:10pm

Hi RoadRunnerSam, First of all, from your description, the reporting services works fine. This problem might be related to windows issue(vs crystal report). Please go to \Program Files\Microsoft SDKs\Windows\v6.0A\Bootstrapper\Packages\CrystalReports10_5 and install the crystal runtime package, or repair the SQL Server Business Intelligence Management Studio. Related topic: http://social.msdn.microsoft.com/forums/en/vscrystalreports/thread/b0fc930f-5fc8-4475-bfe7-ad56616e838d/ please let us know if you have more question. thanks, Jerry
Free Windows Admin Tool Kit Click here and download it now
July 26th, 2010 1:32pm

I went through a repair of the entire R2 installation the other day. That didn't help. The CrystalReports10_5 directory doesn't exist. Must be the one that comes with Studio. I have never installed anything Cystal on this server. Will try the repair again. I went to the now SAP site to find what I might be missing, but I would only be guessing as to what I need. (I am assuming Crystal 10.5) I know what you are trying to say by saying RS is fine, but it is not working. Frustrated. Next steps for me would be to completely un-install, and try again. FYI.. I am on Developer Edition
July 26th, 2010 4:26pm

Second Repair is complete. No change.
Free Windows Admin Tool Kit Click here and download it now
July 26th, 2010 5:26pm

Just found that it is getting this error in the Application log when you go to the /Reports URL. Log Name: Application Source: ASP.NET 2.0.50727.0 Date: 7/26/2010 10:16:58 AM Event ID: 1334 Task Category: None Level: Error Keywords: Classic User: N/A Computer: mocdevsql.murphyoilcorp.com Description: Failed to initialize the AppDomain:ReportManager_MSSQLSERVER_0 Exception: System.Web.HttpException Message: Could not load file or assembly 'System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35' or one of its dependencies. The system cannot find the file specified. StackTrace: at System.Web.Compilation.BuildManager.ReportTopLevelCompilationException() 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) InnerException: System.Configuration.ConfigurationErrorsException Message: Could not load file or assembly 'System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35' or one of its dependencies. The system cannot find the file specified. StackTrace: at System.Web.Configuration.CompilationSection.LoadAssemblyHelper(String assemblyName, Boolean starDirective) at System.Web.Configuration.CompilationSection.LoadAssembly(AssemblyInfo ai) at System.Web.Compilation.BuildManager.GetReferencedAssemblies(CompilationSection compConfig) at System.Web.Compilation.BuildProvidersCompiler..ctor(VirtualPath configPath, Boolean supportLocalization, String outputAssemblyName) at System.Web.Compilation.ApplicationBuildProvider.GetGlobalAsaxBuildResult(Boolean isPrecompiledApp) at System.Web.Compilation.BuildManager.CompileGlobalAsax() at System.Web.Compilation.BuildManager.EnsureTopLevelFilesCompiled() InnerException: System.IO.FileNotFoundException Message: Could not load file or assembly 'System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35' or one of its dependencies. The system cannot find the file specified. StackTrace: at System.Reflection.Assembly._nLoad(AssemblyName fileName, String codeBase, Evidence assemblySecurity, Assembly locationHint, StackCrawlMark& stackMark, Boolean throwOnFileNotFound, Boolean forIntrospection) at System.Reflection.Assembly.nLoad(AssemblyName fileName, String codeBase, Evidence assemblySecurity, Assembly locationHint, StackCrawlMark& stackMark, Boolean throwOnFileNotFound, Boolean forIntrospection) at System.Reflection.Assembly.InternalLoad(AssemblyName assemblyRef, Evidence assemblySecurity, StackCrawlMark& stackMark, Boolean forIntrospection) at System.Reflection.Assembly.InternalLoad(String assemblyString, Evidence assemblySecurity, StackCrawlMark& stackMark, Boolean forIntrospection) at System.Reflection.Assembly.Load(String assemblyString) at System.Web.Configuration.CompilationSection.LoadAssemblyHelper(String assemblyName, Boolean starDirective) Event Xml: <Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event"> <System> <Provider Name="ASP.NET 2.0.50727.0" /> <EventID Qualifiers="49152">1334</EventID> <Level>2</Level> <Task>0</Task> <Keywords>0x80000000000000</Keywords> <TimeCreated SystemTime="2010-07-26T15:16:58.000Z" /> <EventRecordID>7449</EventRecordID> <Channel>Application</Channel> <Computer>mocdevsql.murphyoilcorp.com</Computer> <Security /> </System> <EventData> <Data>Failed to initialize the AppDomain:ReportManager_MSSQLSERVER_0 Exception: System.Web.HttpException Message: Could not load file or assembly 'System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35' or one of its dependencies. The system cannot find the file specified. StackTrace: at System.Web.Compilation.BuildManager.ReportTopLevelCompilationException() 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) InnerException: System.Configuration.ConfigurationErrorsException Message: Could not load file or assembly 'System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35' or one of its dependencies. The system cannot find the file specified. StackTrace: at System.Web.Configuration.CompilationSection.LoadAssemblyHelper(String assemblyName, Boolean starDirective) at System.Web.Configuration.CompilationSection.LoadAssembly(AssemblyInfo ai) at System.Web.Compilation.BuildManager.GetReferencedAssemblies(CompilationSection compConfig) at System.Web.Compilation.BuildProvidersCompiler..ctor(VirtualPath configPath, Boolean supportLocalization, String outputAssemblyName) at System.Web.Compilation.ApplicationBuildProvider.GetGlobalAsaxBuildResult(Boolean isPrecompiledApp) at System.Web.Compilation.BuildManager.CompileGlobalAsax() at System.Web.Compilation.BuildManager.EnsureTopLevelFilesCompiled() InnerException: System.IO.FileNotFoundException Message: Could not load file or assembly 'System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35' or one of its dependencies. The system cannot find the file specified. StackTrace: at System.Reflection.Assembly._nLoad(AssemblyName fileName, String codeBase, Evidence assemblySecurity, Assembly locationHint, StackCrawlMark&amp; stackMark, Boolean throwOnFileNotFound, Boolean forIntrospection) at System.Reflection.Assembly.nLoad(AssemblyName fileName, String codeBase, Evidence assemblySecurity, Assembly locationHint, StackCrawlMark&amp; stackMark, Boolean throwOnFileNotFound, Boolean forIntrospection) at System.Reflection.Assembly.InternalLoad(AssemblyName assemblyRef, Evidence assemblySecurity, StackCrawlMark&amp; stackMark, Boolean forIntrospection) at System.Reflection.Assembly.InternalLoad(String assemblyString, Evidence assemblySecurity, StackCrawlMark&amp; stackMark, Boolean forIntrospection) at System.Reflection.Assembly.Load(String assemblyString) at System.Web.Configuration.CompilationSection.LoadAssemblyHelper(String assemblyName, Boolean starDirective)</Data> </EventData> </Event>
July 26th, 2010 6:18pm

I am beyond the System.Web.Extension Errors. Found invalid Web.Config entries in 2.0 Framework config file. The site will pull up now, but says: "The attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version."
Free Windows Admin Tool Kit Click here and download it now
July 26th, 2010 7:15pm

Check report service trace file. It may contain info that can help you to diagnose the problem. http://msdn.microsoft.com/en-us/library/ms156500.aspx
July 26th, 2010 7:25pm

Thanks to Andy and Jerry for the responses. The trace log was benefical, but didn't lead me to any of the findings. Here is what I found: When this server was loaded, a web config was put on the server that had more assemblies than a default installation. Removed the assemblies that were causing problems, and several of the error messages went away. My sql box is also my SSRS box. I ended up having to populate the URLRoot manually with http://<server name>/reportserver in the rsreportserver.config. I also added a <server name> as an alternate host header which got rid of some error messages I recieved in the log file. Log error message: Failed to unload app domain DefaultDomain. The following exception occurred: Error while unloading appdomain. (Exception from HRESULT: 0x80131015). Log error message: The value for UrlRoot in RSReportServer.config is not valid. The default value will be used instead. I am not sure why I am having trouble with these two pieces of configuration, but I am not getting error messages now. Did I resolve the issue correctly. I am worried that this might come back to haunt me later.
Free Windows Admin Tool Kit Click here and download it now
July 26th, 2010 10:24pm

Hi , I have same problem now. Is there any solution about this topic?
December 3rd, 2010 4:09am

My problem was solved. Here is the reason : I chechked os , av update , patch , etc.. Oracle client had setup on machine. I uninstalled it and then it worked. I noticed that on event viewer application log. Machine.config was changed by oracle client. Another installed app or configuration can be reason too. Should chechk machine.config Path : C:\Windows\Microsoft.NET\Framework64\v2.0.50727\Config\machine.config (and line XXX) -- Here is reason Event viewer application log : Failed to initialize the AppDomain:ReportServer_IDM_0 Exception: System.Web.HttpException Message: Could not load file or assembly 'Oracle.Web, Version=2.111.7.0, Culture=neutral, PublicKeyToken=89b483f429c47342' or one of its dependencies. The system cannot find the file specified. (C:\Windows\Microsoft.NET\Framework64\v2.0.50727\Config\machine.config line 176) StackTrace: at System.Web.Compilation.BuildManager.ReportTopLevelCompilationException() 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) InnerException: System.Configuration.ConfigurationErrorsException Message: Could not load file or assembly 'Oracle.Web, Version=2.111.7.0, Culture=neutral, PublicKeyToken=89b483f429c47342' or one of its dependencies. The system cannot find the file specified. (C:\Windows\Microsoft.NET\Framework64\v2.0.50727\Config\machine.config line 176) StackTrace: at System.Web.Configuration.ConfigUtil.GetType(String typeName, String propertyName, ConfigurationElement configElement, XmlNode node, Boolean checkAptcaBit, Boolean ignoreCase) at System.Web.Configuration.HealthMonitoringSectionHelper.BasicSanityCheck() at System.Web.Configuration.HealthMonitoringSectionHelper..ctor() at System.Web.Configuration.HealthMonitoringSectionHelper.GetHelper() at System.Web.Management.HealthMonitoringManager..ctor() at System.Web.Management.HealthMonitoringManager.Manager() at System.Web.Management.HealthMonitoringManager.get_Enabled() at System.Web.Management.WebBaseEvent.RaiseSystemEventInternal(String message, Object source, Int32 eventCode, Int32 eventDetailCode, Exception exception, String nameToAuthenticate) 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() InnerException: System.IO.FileNotFoundException Message: Could not load file or assembly 'Oracle.Web, Version=2.111.7.0, Culture=neutral, PublicKeyToken=89b483f429c47342' or one of its dependencies. The system cannot find the file specified. StackTrace: at System.RuntimeTypeHandle._GetTypeByName(String name, Boolean throwOnError, Boolean ignoreCase, Boolean reflectionOnly, StackCrawlMark& stackMark, Boolean loadTypeFromPartialName) at System.RuntimeTypeHandle.GetTypeByName(String name, Boolean throwOnError, Boolean ignoreCase, Boolean reflectionOnly, StackCrawlMark& stackMark) at System.RuntimeType.PrivateGetType(String typeName, Boolean throwOnError, Boolean ignoreCase, Boolean reflectionOnly, StackCrawlMark& stackMark) at System.Type.GetType(String typeName, Boolean throwOnError, Boolean ignoreCase) at System.Web.Compilation.BuildManager.GetType(String typeName, Boolean throwOnError, Boolean ignoreCase) at System.Web.Configuration.ConfigUtil.GetType(String typeName, String propertyName, ConfigurationElement configElement, XmlNode node, Boolean checkAptcaBit, Boolean ignoreCase)
Free Windows Admin Tool Kit Click here and download it now
December 3rd, 2010 8:37am

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

Other recent topics Other recent topics