SC Configuration Manager

Cannot insert duplicate key error while upgrading SCCM 2012 to SP1

Posted by on Feb 5, 2013 in SC Configuration Manager, SQL Server, Transact-SQL | 1 comment

Cannot insert duplicate key error while upgrading SCCM 2012 to SP1

The following error occurred during SP1 update of Microsoft System Center 2012 Configuration Manager: ERROR: SQL Server error: [23000][2627][Microsoft][SQL Server Native Client 11.0][SQL Server]Violation of PRIMARY KEY constraint ‘CollectionQueryRuleTables_PK’. Cannot insert duplicate key in object ‘dbo.CollectionQueryRuleTables’. The duplicate key value is (16777228, 1, vSMS_R_System). Configuration Manager Setup 05.02.2013 09:12:18 4084 (0x0FF4) The easiest way would be to delete the corresponding rows from CollectionQueryRuleTables table in your SCCM database. This...

Read More

Various issues after installing Windows Management Framework 3.0 (KB2506143) on computer running SCCM 2012 agent

Posted by on Dec 19, 2012 in Exchange Server, Group Policies, Hyper-V, SC Configuration Manager, Sharepoint Server, Virtual Machine Manager, WMI | 1 comment

Various issues after installing Windows Management Framework 3.0 (KB2506143) on computer running SCCM 2012 agent

Last week I experienced some issues after installing Windows Management Framework 3.0 (KB2506143). I could not manage my Hyper-V Servers (the console kept saying there was no Hyper-V role installed on that server), group policies were not applied and WMI did not work. Group Policy Error in System eventlog (id 1065): The processing of Group Policy failed. Windows could not evaluate the Windows Management Instrumentation (WMI) filter for the Group Policy object CN={AD443F1C-C1B4-201A-B38E-CF596AB23FE6},CN=Policies,CN=System,DC=normanbauer,DC=com. This could be caused by RSOP being disabled or...

Read More

How to avoid Windows 7 language choice dialog in multilanguage image deployment with SCCM 2007?

Posted by on Nov 9, 2012 in SC Configuration Manager | 1 comment

How to avoid Windows 7 language choice dialog in multilanguage image deployment with SCCM 2007?

This is just a quick review of a forum post at Microsoft System Center Forums because of a question that a reader of my website had (see the comments). The initial problem was as following: I’m using an english win7 ent wim with german language pack intergrated. Everytime i install a client the language choice dialog pops up (after the first reboot). I tried to use an xml answer file that did change the language of setup and of the client itself. But the dialog keeps popping up… The solution to the problem was to use a local source path for the unattend package instead of a unc...

Read More

SCCM failes to login at SQL database

Posted by on Jan 31, 2011 in SC Configuration Manager, SQL Server | 2 comments

Sometimes it happened to me, that our Microsoft System Center Configuration Manager 2007 R2 (sccmsrv01) failed to login at our dedicated MS SQL 2005 2 nodes cluster (cluster: sqlclu, node 1: sqlclu01 and node 2: sqlclu02). Everything you could find in the sql logs was: Error: 18456, Severity: 14, State: 11. Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. [CLIENT: 192.168.1.10] Since I knew that SCCM wouldn’t try to logon anonymously at the dedicated sql server but with its machine account the error seemed to be related on kerberos and service principal names (SPN). I checked this...

Read More