Reporting Services ( v2012 ) – Error – System.Configuration.ConfigurationErrorsException – Trust / RosettaSrv

Background

Received an email this morning.

Here is the email snippet.

arjun-brushed-up

 

It was placed as a comment to a this post.

BTW, the post is titled “Reporting Services – Error – This configuration section cannot be used at this path. This happens when the site administrator has locked access to this section using from an inherited configuration file“.

Error

Here is more on the error.

Error – Image

rosettasrv-xml

Error – Textual


Reporting Services – Error – This configuration section cannot be used at this path. This happens when the site administrator has locked access to this section using from an inherited configuration file.
Failed to initialize the AppDomain:ReportServer_MSSQLSERVER_0
Exception: System.Configuration.ConfigurationErrorsException
Message: This configuration section cannot be used at this path. This happens when the site administrator has locked access to this section using from an inherited configuration file. 

(C:\Program Files\Microsoft SQL Server\MSRS12.MSSQLSERVER\Reporting Services\ReportServer\web.config line <strong>44</strong>)

StackTrace: at System.Web.HttpRuntime.HostingInit(HostingEnvironmentFlags hostingFlags)
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)Failed to initialize the AppDomain:ReportServer_MSSQLSERVER_0
Exception: System.Configuration.ConfigurationErrorsException
Message: This configuration section cannot be used at this path. This happens when the site administrator has locked access to this section using from an inherited configuration file. (C:\Program Files\Microsoft SQL Server\MSRS12.MSSQLSERVER\Reporting Services\ReportServer\web.config line 44)
StackTrace: at System.Web.HttpRuntime.HostingInit(HostingEnvironmentFlags hostingFlags)
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)

Explanation

  1. The Key Information is
    • This configuration section cannot be used at this path. This happens when the site administrator has locked access to this section using from an inherited configuration file
    • Failing line is 44

 

Remediation

Identify Location of RS Web.config

Checked the web.config which is here D:\Program Files\Microsoft SQL Server\MSRS12.MSSQLSERVER\Reporting Services\ReportServer

The generic location is <drive>:\Program Files\Microsoft SQL Server\MSRS<Number>.MSSQLSERVER\Reporting Services\ReportServer

 

Review & Correct File

Original Text


<securityPolicy>

    <trustLevel name="RosettaSrv" policyFile="rssrvpolicy.config" />

</securityPolicy>

<trust level="RosettaSrv" originUrl="" />

Revised Text


<!--
  commented out 2016-11-30

  <securityPolicy>

      <trustLevel name="RosettaSrv" policyFile="rssrvpolicy.config" />

  </securityPolicy>

  <trust level="RosettaSrv" originUrl="" />

-->

 

Restart SQL Server Reporting Services & Watch for Errors

Please restart SQL Server Reporting Services and watch out for errors in RS Log Folder

Syntax

<Drive>:\Program Files\Microsoft SQL Server\MSRS<RSNumber>.MSSQLSERVER\Reporting Services\LogFiles

Sample

D:\Program Files\Microsoft SQL Server\MSRS12.MSSQLSERVER\Reporting Services\LogFiles

After Burner

Please work with your OS Group and see whether there are Group Policies in place that is preventing the usage of Rosetta Mgr.

 

One thought on “Reporting Services ( v2012 ) – Error – System.Configuration.ConfigurationErrorsException – Trust / RosettaSrv

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s