Desired Configuration Management - Clients fail to successfully download Configuration Items
I came across a mis-configuration issue with Management Points using a replica database. My own fault of course, but took a long time for me to spot where I messed up. So just in case someone else hits the same issue...
Issue: Server 2008, x64. Configuration Manager 07 Sp1. Management Points behind an NLB. Clients could not successfully download Configuration Items for a Configuration Baseline. (The NLB aspect is not as relevant as the MPs using a replica database)
Symptoms:
Symptom #1: During enabling CLR Integration (via SQL 2005 Surface Area Configuration for Features, CLR Integration), the following error would occur:
"could not load file or assembly 'Microsoft.sqlserver.batchparser, version-9.0.242.0, culture-neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified. (MIcrosoft.SqlServer.ConnectionInfo)"
Symptom #2: when interactively requesting a client “Evaluate” a Specific baseline listed on the Configuration Management applet, the DCMAgent.log would indicate:
“AddCIAssignmentFromWmiPolicy - Adding baseline with ID:ScopeId_<yourScopeID>/Baseline_<yourBaselineID> Version:<yourversion>.00 to scheduled job”
“State – Downloading”
Then… nothing for 6 hours. After 6 hours a State – Failed would be recorded in DCMAgent.log
Resolution: On the Management Point Servers hosting the SQL Database Replicas for the NLB-defined Management Point, CLR Integration needs to be enabled (without errors). On an SQL 2005 x64, "Microsoft SQL Server 2005 Management Objects Collection" from the SQL 2005 Feature Pack (http://www.microsoft.com/downloads/details.aspx?FamilyId=D09C1D60-A13C-4479-9B91-9E8B9D835CDC&displaylang=en), specifically the x64 version, aka SQLServer2005_XMO_x64.msi, needs to be installed. Then run the Surface Area Configuration for Features, and enable CLR Integration.