unable to configure reporting service(SQL 2005)

  • Hi All,

    I have SQL Server 2005 standard edition with service pack 2.I have configure the reporting service but when i browse the url http://localhost/Reports/ it gives me following error.

    And also while configuring reporting service initialization option is not highlighted.

    Any kind of help will be appreciated.

    Thanks in advance.

    Akshay G.

    Server Error in '/Reports' Application.

    --------------------------------------------------------------------------------

    Could not load file or assembly 'Microsoft.ReportingServices.Diagnostics' or one of its dependencies. Access is denied.

    Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

    Exception Details: System.IO.FileLoadException: Could not load file or assembly 'Microsoft.ReportingServices.Diagnostics' or one of its dependencies. Access is denied.

    Source Error:

    An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

    Assembly Load Trace: The following information can be helpful to determine why the assembly 'Microsoft.ReportingServices.Diagnostics' could not be loaded.

    WRN: Assembly binding logging is turned OFF.

    To enable assembly bind failure logging, set the registry value [HKLM\Software\Microsoft\Fusion!EnableLog] (DWORD) to 1.

    Note: There is some performance penalty associated with assembly bind failure logging.

    To turn this feature off, remove the registry value [HKLM\Software\Microsoft\Fusion!EnableLog].

    Stack Trace:

    [FileLoadException: Could not load file or assembly 'Microsoft.ReportingServices.Diagnostics' or one of its dependencies. Access is denied.]

    [FileLoadException: Could not load file or assembly 'Microsoft.ReportingServices.Diagnostics, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. Access is denied.]

    System.Reflection.Assembly._nLoad(AssemblyName fileName, String codeBase, Evidence assemblySecurity, Assembly locationHint, StackCrawlMark& stackMark, Boolean throwOnFileNotFound, Boolean forIntrospection) +0

    System.Reflection.Assembly.nLoad(AssemblyName fileName, String codeBase, Evidence assemblySecurity, Assembly locationHint, StackCrawlMark& stackMark, Boolean throwOnFileNotFound, Boolean forIntrospection) +43

    System.Reflection.Assembly.InternalLoad(AssemblyName assemblyRef, Evidence assemblySecurity, StackCrawlMark& stackMark, Boolean forIntrospection) +127

    System.Reflection.Assembly.InternalLoad(String assemblyString, Evidence assemblySecurity, StackCrawlMark& stackMark, Boolean forIntrospection) +142

    System.Reflection.Assembly.Load(String assemblyString) +28

    System.Web.Configuration.CompilationSection.LoadAssemblyHelper(String assemblyName, Boolean starDirective) +46

    [ConfigurationErrorsException: Could not load file or assembly 'Microsoft.ReportingServices.Diagnostics, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. Access is denied.]

    System.Web.Configuration.CompilationSection.LoadAssemblyHelper(String assemblyName, Boolean starDirective) +613

    System.Web.Configuration.CompilationSection.LoadAllAssembliesFromAppDomainBinDirectory() +203

    System.Web.Configuration.CompilationSection.LoadAssembly(AssemblyInfo ai) +105

    System.Web.Compilation.BuildManager.GetReferencedAssemblies(CompilationSection compConfig) +178

    System.Web.Compilation.BuildProvidersCompiler..ctor(VirtualPath configPath, Boolean supportLocalization, String outputAssemblyName) +54

    System.Web.Compilation.ApplicationBuildProvider.GetGlobalAsaxBuildResult(Boolean isPrecompiledApp) +227

    System.Web.Compilation.BuildManager.CompileGlobalAsax() +52

    System.Web.Compilation.BuildManager.EnsureTopLevelFilesCompiled() +337

    [HttpException (0x80004005): Could not load file or assembly 'Microsoft.ReportingServices.Diagnostics, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. Access is denied.]

    System.Web.Compilation.BuildManager.ReportTopLevelCompilationException() +58

    System.Web.Compilation.BuildManager.EnsureTopLevelFilesCompiled() +512

    System.Web.Hosting.HostingEnvironment.Initialize(ApplicationManager appManager, IApplicationHost appHost, IConfigMapPathFactory configMapPathFactory, HostingEnvironmentParameters hostingParameters) +729

    [HttpException (0x80004005): Could not load file or assembly 'Microsoft.ReportingServices.Diagnostics, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. Access is denied.]

    System.Web.HttpRuntime.FirstRequestInit(HttpContext context) +8890815

    System.Web.HttpRuntime.EnsureFirstRequestInit(HttpContext context) +85

    System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr) +259

  • duplicate post. please continue here.



    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply