Monday, March 12, 2012

Reporting Service will not start

SQL Server 2005 SP1 (Express) will not start
Reporting Services Configuration Manager reports:
System.ServiceProcess.TimeoutException: Time out has expired and the
operation has not been completed.
at
System.ServiceProcess.ServiceController.WaitForStatus(ServiceControllerStatus
desiredStatus, TimeSpan timeout)
at
ReportServicesConfigUI.Panels.ServerInformationPanel.StartStopServiceTask(Boolean start)
Windows Event Application log contains:
Service cannot be started. System.TypeInitializationException: The type
initializer for 'Microsoft.ReportingServices.Library.Global' threw an
exception. --> System.Configuration.ConfigurationErrorsException: An error
occurred creating the configuration section handler for RStrace: That
assembly does not allow partially trusted callers. (c:\Program
Files\Microsoft SQL Server\MSSQL.3\Reporting
Services\ReportServer\bin\ReportingServicesService.exe.config line 3) -->
System.Security.SecurityException: That assembly does not allow partially
trusted callers.
at
System.Security.CodeAccessSecurityEngine.ThrowSecurityException(Assembly asm,
PermissionSet granted, PermissionSet refused, RuntimeMethodHandle rmh,
SecurityAction action, Object demand, IPermission permThatFailed)
at System.RuntimeTypeHandle.CreateInstance(RuntimeType type, Boolean
publicOnly, Boolean noCheck, Boolean& canBeCached, RuntimeMethodHandle& ctor,
Boolean& bNeedSecurityCheck)
at System.RuntimeType.CreateInstanceSlow(Boolean publicOnly, Boolean
fillCache)
...
Thanks for the helpI have the exact same problem on my machine - did you ever find a solution to
this?
"Automate" wrote:
> SQL Server 2005 SP1 (Express) will not start
> Reporting Services Configuration Manager reports:
> System.ServiceProcess.TimeoutException: Time out has expired and the
> operation has not been completed.
> at
> System.ServiceProcess.ServiceController.WaitForStatus(ServiceControllerStatus
> desiredStatus, TimeSpan timeout)
> at
> ReportServicesConfigUI.Panels.ServerInformationPanel.StartStopServiceTask(Boolean start)
>
> Windows Event Application log contains:
> Service cannot be started. System.TypeInitializationException: The type
> initializer for 'Microsoft.ReportingServices.Library.Global' threw an
> exception. --> System.Configuration.ConfigurationErrorsException: An error
> occurred creating the configuration section handler for RStrace: That
> assembly does not allow partially trusted callers. (c:\Program
> Files\Microsoft SQL Server\MSSQL.3\Reporting
> Services\ReportServer\bin\ReportingServicesService.exe.config line 3) -->
> System.Security.SecurityException: That assembly does not allow partially
> trusted callers.
> at
> System.Security.CodeAccessSecurityEngine.ThrowSecurityException(Assembly asm,
> PermissionSet granted, PermissionSet refused, RuntimeMethodHandle rmh,
> SecurityAction action, Object demand, IPermission permThatFailed)
> at System.RuntimeTypeHandle.CreateInstance(RuntimeType type, Boolean
> publicOnly, Boolean noCheck, Boolean& canBeCached, RuntimeMethodHandle& ctor,
> Boolean& bNeedSecurityCheck)
> at System.RuntimeType.CreateInstanceSlow(Boolean publicOnly, Boolean
> fillCache)
> ...
>
> Thanks for the help|||The problem was occuring on a large companies computers that used their own
standardized secure Windows install images. They told me they had to open up
the security of DCOM but I don't know exactly what they changed.
"Flayto" wrote:
> I have the exact same problem on my machine - did you ever find a solution to
> this?
> "Automate" wrote:
> > SQL Server 2005 SP1 (Express) will not start
> >
> > Reporting Services Configuration Manager reports:
> >
> > System.ServiceProcess.TimeoutException: Time out has expired and the
> > operation has not been completed.
> > at
> > System.ServiceProcess.ServiceController.WaitForStatus(ServiceControllerStatus
> > desiredStatus, TimeSpan timeout)
> > at
> > ReportServicesConfigUI.Panels.ServerInformationPanel.StartStopServiceTask(Boolean start)
> >
> >
> > Windows Event Application log contains:
> >
> > Service cannot be started. System.TypeInitializationException: The type
> > initializer for 'Microsoft.ReportingServices.Library.Global' threw an
> > exception. --> System.Configuration.ConfigurationErrorsException: An error
> > occurred creating the configuration section handler for RStrace: That
> > assembly does not allow partially trusted callers. (c:\Program
> > Files\Microsoft SQL Server\MSSQL.3\Reporting
> > Services\ReportServer\bin\ReportingServicesService.exe.config line 3) -->
> > System.Security.SecurityException: That assembly does not allow partially
> > trusted callers.
> > at
> > System.Security.CodeAccessSecurityEngine.ThrowSecurityException(Assembly asm,
> > PermissionSet granted, PermissionSet refused, RuntimeMethodHandle rmh,
> > SecurityAction action, Object demand, IPermission permThatFailed)
> > at System.RuntimeTypeHandle.CreateInstance(RuntimeType type, Boolean
> > publicOnly, Boolean noCheck, Boolean& canBeCached, RuntimeMethodHandle& ctor,
> > Boolean& bNeedSecurityCheck)
> > at System.RuntimeType.CreateInstanceSlow(Boolean publicOnly, Boolean
> > fillCache)
> > ...
> >
> >
> > Thanks for the help|||Well, I managed to fix the problem after a bit of research. In the end, all I
needed to do was re-install .Net 2.0 framework. I'm not sure if it got
damaged because of the order I installed applications on my computer, but
repairing Framework 2.0 seems to have done the trick.
"Automate" wrote:
> The problem was occuring on a large companies computers that used their own
> standardized secure Windows install images. They told me they had to open up
> the security of DCOM but I don't know exactly what they changed.
> "Flayto" wrote:
> > I have the exact same problem on my machine - did you ever find a solution to
> > this?
> >
> > "Automate" wrote:
> >
> > > SQL Server 2005 SP1 (Express) will not start
> > >
> > > Reporting Services Configuration Manager reports:
> > >
> > > System.ServiceProcess.TimeoutException: Time out has expired and the
> > > operation has not been completed.
> > > at
> > > System.ServiceProcess.ServiceController.WaitForStatus(ServiceControllerStatus
> > > desiredStatus, TimeSpan timeout)
> > > at
> > > ReportServicesConfigUI.Panels.ServerInformationPanel.StartStopServiceTask(Boolean start)
> > >
> > >
> > > Windows Event Application log contains:
> > >
> > > Service cannot be started. System.TypeInitializationException: The type
> > > initializer for 'Microsoft.ReportingServices.Library.Global' threw an
> > > exception. --> System.Configuration.ConfigurationErrorsException: An error
> > > occurred creating the configuration section handler for RStrace: That
> > > assembly does not allow partially trusted callers. (c:\Program
> > > Files\Microsoft SQL Server\MSSQL.3\Reporting
> > > Services\ReportServer\bin\ReportingServicesService.exe.config line 3) -->
> > > System.Security.SecurityException: That assembly does not allow partially
> > > trusted callers.
> > > at
> > > System.Security.CodeAccessSecurityEngine.ThrowSecurityException(Assembly asm,
> > > PermissionSet granted, PermissionSet refused, RuntimeMethodHandle rmh,
> > > SecurityAction action, Object demand, IPermission permThatFailed)
> > > at System.RuntimeTypeHandle.CreateInstance(RuntimeType type, Boolean
> > > publicOnly, Boolean noCheck, Boolean& canBeCached, RuntimeMethodHandle& ctor,
> > > Boolean& bNeedSecurityCheck)
> > > at System.RuntimeType.CreateInstanceSlow(Boolean publicOnly, Boolean
> > > fillCache)
> > > ...
> > >
> > >
> > > Thanks for the help

No comments:

Post a Comment