SQL Server – Reporting Services ( v2005 ) on Windows 2008 – Application Pool Settings

Background

A quick and very brief catalog of possible problems one might encounter when configuring SQL Server Reporting Services (v2005) on MS Windows 2008/MS Windows 2008-R2.

Reporting Services COnfiguration on IIS is a broad topic and for the sake of brevity, we restrict our lenses mostly on the Application Pool.

Configuration

Application Pool

  1. .Net Framework version
    • .Net Framework v2.0.50727
  2. Managed pipeline mode
    • Use
      • Classic
    • Do not use
      • Integrated

Screen Shot

EditApplicationPool

 

Error

HTTP Error 500.23 – Internal Server Error – An ASP.NET setting has been detected that does not apply in Integrated managed pipeline mode.

 

Screen Shot

HTTP Error 500DOT23

Tabulated

Item Value
 Module ConfigurationValidationModule
 Handler  AboMapperCustom-7284591
 Error Code  0x80070032
 Logon Method  Not yet determined
 Logon User  Not yet determined

 

Remedy

Alternatively, switch the application to a Classic mode application pool – for example, appcmd set app “Default Web Site/” /applicationPool:”Classic .NET AppPool”. Only do this if you are unable to migrate your application.

 

Application Pool – View Settings

Sample


set "_appPool=AppPoolDomainServiceAccount"
%systemroot%\system32\inetsrv\APPCMD list apppool "%_appPool%" /text:*

Output

Apppool-configuration-view

 

Application Pool – Change Setting – Managed Pipeline Mode

Change Managed Pipeline Mode from Integrated to Classic.

Sample


set "_appPool=AppPoolDomainServiceAccount"
%systemroot%\system32\inetsrv\APPCMD set apppool "%_appPool%" /managedPipelineMode:Classic

Output

Apppool-configuration-set

 

 

Error – Could not find permission set named ‘ASP.Net’.

Screen Shot

CouldNotFindPermissionSetNamedASPNet

 

Textual

[ConfigurationErrorsException: Could not find permission set named 'ASP.Net'.]
   System.Web.HttpRuntime.HostingInit(HostingEnvironmentFlags hostingFlags, PolicyLevel policyLevel, Exception appDomainCreationException) +361

[HttpException (0x80004005): Could not find permission set named 'ASP.Net'.]
   System.Web.HttpRuntime.FirstRequestInit(HttpContext context) +579
   System.Web.HttpRuntime.EnsureFirstRequestInit(HttpContext context) +112
   System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr) +1083

Tabulated

Item Value
ConfigurationErrorsException [ConfigurationErrorsException: Could not find permission set named ‘ASP.Net’.]
HTTP Exception HttpException (0x80004005): Could not find permission set named ‘ASP.Net’.]

 

Code

Application Pool – Change Setting – Managed Runtime Version

Change Managed Runtime Version to 2.0

Sample

set "_appPool=AppPoolDomainServiceAccount"
%systemroot%\system32\inetsrv\APPCMD set apppool "%_appPool%" /managedRuntimeVersion:v2.0
Output

managedRuntimeVersionChangeCommandOutput

Error – Server unavailable

Screen Shot

ServerUnavailable

Textual

Service Unavailable

Service Unavailable

 

HTTP Error 503. The service is unavailable.

Application Pool – Start

Start application pool

Sample
set "_appPool=AppPoolDomainServiceAccount"
%systemroot%\system32\inetsrv\APPCMD start apppool /apppool.name:"%_appPool%"

Output
appPoolStartOutput

Error – Illegal operation attempted on a registry key that has been marked for deletion. (0x800703fa)

Screen Shot

 

Textual

Remediation

The recommended remediation step is to launch Group Policy and

Computer Configuration->Administrative Templates->System-> UserProfiles -> Do not forcefully unload the user registry at user logoff.

Application Pool – Load User Profile – Current Setting

What is the Application Pools – Load User Profile – Current setting?

Sample
set "_appPool=AppPoolDomainServiceAccount"
%systemroot%\system32\inetsrv\APPCMD list apppool "%_appPool%" /text:* | find "loadUserProfile"

Output

viewCurrentSetting-LoadUserProfile

Application Pool – Load User Profile – Set to true

Set Application Pools – Load User Profile to True

 

Sample
set "_appPool=AppPoolDomainServiceAccount"
%systemroot%\system32\inetsrv\APPCMD set apppool "%_appPool%" /processModel.loadUserProfile:true

Output

setLoadUserProfile

Win OS – Desktop

Access Control Panel \ User Accounts and review the list of users that have current profiles.

UserProfiles

 

Error – System.UnauthorizedAccessException.Access to the path … RSReportServer.config is denied

ScreenShot

eventViewer-WindowsLog-Application

 

Textual

 


Service cannot be started. Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error. See the report server log files for more information. ---> System.UnauthorizedAccessException: Access to the path 'D:\Program Files\Microsoft SQL Server\v2005Mirror\MSSQL.4\Reporting Services\ReportServer\RSReportServer.config' is denied. at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath) at System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy) at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access, FileShare share, Int32 bufferSize, FileOptions options, String msgPath, Boolean bFromProxy) at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access, FileShare share) at Microsoft.ReportingServices.Diagnostics.Globals.Safe...

 

System.UnauthorizedAccessException: Access to the path ‘D:\Program Files\Microsoft SQL Server\v2005Mirror\MSSQL.4\Reporting Services\ReportServer\RSReportServer.config’ is denied

Remedy

Launch “Reporting Services Configuration Manager” and set\reset Windows Service Identity to your designated Service Account.

WindowsServerIdentity (Cropped)

 

References

IIS

Appcmd

  1. Getting Started with AppCmd.exe – By Mike VolodarskyNovember 16, 2007
    Link
  2. Start or Stop an Application Pool (IIS 7)
    Link

 

Application Pool – Error – “ILLEGAL OPERATION ATTEMPTED ON A REGISTRY KEY THAT HAS BEEN MARKED FOR DELETION”

  1. A COM+ application may stop working on Windows Server 2008 when the identity user logs off
    Link
  2. Ned Pyle (MSFT)User Profile Policies in Windows Server 2008 and Windows Vista
    Link
  3. RESOLVING ERROR “ILLEGAL OPERATION ATTEMPTED ON A REGISTRY KEY THAT HAS BEEN MARKED FOR DELETION.”
    Link
  4. Veritas – Events 6287, 45569, 3280, 3263, 6979, 7082 – Illegal operation attempted on a registry key that has been marked for deletion. (0x800703fa)
    Link
  5. thycotic – RESOLVING ERROR “ILLEGAL OPERATION ATTEMPTED ON A REGISTRY KEY THAT HAS BEEN MARKED FOR DELETION.”
    Link

 

Application Pool – Load User Profile

  1. IIS 7 Tip # 3 You can now load the user profile of the application pool identity
    Link

 

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