Tips for finding Knowledge Articles

  • - Enter just a few key words related to your question or problem
  • - Add Key words to refine your search as necessary
  • - Do not use punctuation
  • - Search is not case sensitive
  • - Avoid non-descriptive filler words like "how", "the", "what", etc.
  • - If you do not find what you are looking for the first time,reduce the number of key words you enter and try searching again.
  • - Minimum supported Internet Explorer version is IE9
Home  >
article

KB-3406: MS Patch KB 2840628 Causing DirectAudit Connection Loss to SQL

Centrify DirectAudit ,  

12 April,16 at 11:13 AM

Applies to: All versions of Centrify DirectAudit
 
Problem:
 
Immediately upon installation of the update from Microsoft Security Bulletin MS13-052 (KB2840628) on the SQL server hosting the DirectAudit database; All Collectors, Centrify Audit Manager and Centrify Audit Manager sessions are no longer able to connect to the SQL server.  
 
An error similar to the one below may be seen in the Collector Control Panel when trying to re-establish connection:
 
Warnings: A failure occurred while checking the database version of the Audit Store database '<AuditStoreName>' because: A database operation error occurred. Please contact your administrator to make sure the remote database is accessible and working properly. Although Audit Store '<AuditStoreName>' is serving the current site, we failed to verify whether the Collector has sufficient permissions to access the active Audit Store database. A database operation error occurred. Please contact your administrator to make sure the remote database is accessible and working properly. Please make sure the Collector has permissions on the active Audit Store database. You can use DirectManage Audit Manager to grant the permissions. 
 
The following errors may be seen in the Collector Log:
 
Error: ExceptionHandler.GetException: Sql error occurs - Number: 6522
Error: ExceptionHandler.GetException: Message: A .NET Framework error occurred during execution of user-defined routine or aggregate "DatabaseVersionGet": 
Error: ExceptionHandler.GetException: System.Security.SecurityException: 
Error: ExceptionHandler.GetException: System.MethodAccessException: 
 
(or)
 

Msg 6522, Level 16, State 1, Procedure DatabaseVersionGet, Line 0
A .NET Framework error occurred during execution of user-defined routine or aggregate "DatabaseVersionGet":
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.R
...
System.TypeInitializationException:
at System.Data.SqlClient.SqlConnection..ctor()
at System.Data.SqlClient.SqlConnection..ctor(String connectionString)
at Microsoft.SqlServer.Server.SqlPipe.ExecuteAndSend(SqlComm...

 
 
Cause:
 
Microsoft has acknowledged an issue with the patch to KB 2872041:
 
http://support.microsoft.com/kb/2872041
 
Link to actual patch:
 
http://support.microsoft.com/kb/2840628
 
If the patch was applied on SQL before August 13 2013, the connection issues may be immediately encountered. 
This issue has been observed on SQL Server 2012 (11.0.3000)
 
Resolution:
 
As of August 13 2013, Microsoft has re-released an update to MS13-052 (KB2840628) and recommends that those who installed the first update prior to this new update immediately reapply the patch. 
 
This should correct the issue.  
 
(All external links are provided as a courtesy)
 
 
Keywords: Windows update fix SQL Server audit agent MS13-052 KB2840628

Still have questions? Click here to log a technical support case, or collaborate with your peers in Centrify's Online Community.