none
Msg 6522, Level 16, State 1, Procedure sp_printstatement, Line 0 RRS feed

  • Question

  • Hello. we got a problem after patching our Windows server 2008R2 on which SQL 2012 cluster is built. when we run sp_browsereplcmds it gives following message. when SQL server sits on unpatched node, there is no such problem. Can somebody provide a solution? Here are patches:

    Windows server 2008R2 Enterprise:

    KB2850851, KB2846071, KB2840631, KB2835361, KB2834886, KB2833946, KB2844286, KB2832414.

    .NET Framework 4 client profile:

    KB2840628, KB2836939, KB2835393, KB2804576, KB2789642, KB2742595, KB2737019, KB2736428, KB2729449, KB2656351, KB2604121, KB2600217, KB2544514, KB2533523, KB2468871.

    Message: 

    Msg 6522, Level 16, State 1, Procedure sp_printstatement, Line 0

    A .NET Framework error occurred during execution of user-defined routine or aggregate "sp_printstatement":

    System.TypeInitializationException: The type initializer for 'System.Data.SqlClient.SqlConnection' threw an exception. ---> System.TypeInitializationException: The type initializer for 'System.Data.SqlClient.SqlConnectionFactory' threw an exception. ---> System.TypeInitializationException: The type initializer for 'System.Data.SqlClient.SqlPerformanceCounters' threw an exception. ---> System.MethodAccessException: Attempt by method 'System.Configuration.TypeUtil.CreateInstanceRestricted(System.Type, System.Type)' to access method 'System.Diagnostics.SwitchElementsCollection..ctor()' failed. ---> System.Security.SecurityException: Request failed.

    System.Security.SecurityException:

      at System.Security.CodeAccessSecurityEngine.ThrowSecurityException(RuntimeAssembly asm, PermissionSet granted, PermissionSet refused, RuntimeMethodHandleInternal rmh, SecurityAction action, Object demand, IPermission permThatFailed)

      at System.Security.CodeAccessSecurityEngine.CheckSetHelper(PermissionSet grants, PermissionSet refused, PermissionSet demands, RuntimeMethodHandleInternal rmh, Object assemblyOrString, SecurityAction action, Boolean throwException)

      at System.Security.PermissionListSet.CheckSetDemandWithModification(PermissionSet pset, PermissionSet& alteredDemandSet, RuntimeMethodHandleInternal rmh)

      at System.Security.PermissionListSet.CheckSetDemand(PermissionSet pset, RuntimeMethodHandleInternal rmh)

      at System.Security.PermissionListSet.DemandFlagsOrGrantSet(Int32 flags, PermissionSet grantSet)

      at System.Security.CodeAccessSecurityEngine.ReflectionTargetDemandHelper(Int32 permission, PermissionSet targetGrant)

    System.MethodAccessException:

      at System.RuntimeTypeHandle.CreateInstance(RuntimeType type, Boolean publicOnly, Boolean noCheck, B

           ...

    System.TypeInitializationException:

      at System.Data.SqlClient.SqlConnection..ctor()

      at System.Data.SqlClient.SqlConnection..ctor(St...


    Monday, July 29, 2013 5:57 PM