{"id":741,"date":"2012-01-26T11:39:44","date_gmt":"2012-01-26T11:39:44","guid":{"rendered":"http:\/\/www.autoitconsulting.com\/site\/?p=741"},"modified":"2025-07-26T12:53:07","modified_gmt":"2025-07-26T11:53:07","slug":"configmgr-2012-sql-database-collation","status":"publish","type":"post","link":"https:\/\/www.autoitconsulting.com\/site\/deployment\/configmgr-2012-sql-database-collation\/","title":{"rendered":"ConfigMgr 2012 SQL Database Collation"},"content":{"rendered":"\n<h2 class=\"wp-block-heading\">Overview<\/h2>\n\n\n\n<p>I just tried to update my &#8216;default&#8217; installation of System Center Configuration Manager (SCCM \/ ConfigMgr) 2012 RC1 to RC2. I got a failure at the pre-req check stage stating that my SQL 2008 R2 database was using the wrong collation type and that installation couldn&#8217;t continue. It turns out that the default collation that I had used when I installed SQL 2008 R2 (a next&#8230;next&#8230;next&#8230;finish install) was no good. I&#8217;m not sure why ConfigMgr 2012 RC1 was happy with that configuration but RC2 certainly wasn&#8217;t!<\/p>\n\n\n\n<p>This article states the supported database configuration for ConfigMgr 2012 &#8211; it doesn&#8217;t appear to mention collation type but apparently this will be updated in the future:&nbsp;<a href=\"http:\/\/technet.microsoft.com\/en-us\/library\/gg682077.aspx#BKMK_SupConfigSQLDBconfig\">http:\/\/technet.microsoft.com\/en-us\/library\/gg682077.aspx#BKMK_SupConfigSQLDBconfig<\/a><\/p>\n\n\n\n<p>The supported collation type is: <strong>SQL_Latin1_General_CP1_CI_AS<\/strong><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Example<\/h2>\n\n\n\n<p>For reference, here are some screenshots on how to set this collation type during the installation of SQL Server 2008 R2.<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter\"><a href=\"\/site\/wp-content\/uploads\/2012\/01\/collation_1.png\"><img loading=\"lazy\" decoding=\"async\" width=\"820\" height=\"271\" src=\"\/site\/wp-content\/uploads\/2012\/01\/collation_1.png\" alt=\"Collation 1\" class=\"wp-image-756\" title=\"Collation 1\" srcset=\"https:\/\/www.autoitconsulting.com\/site\/wp-content\/uploads\/2012\/01\/collation_1.png 820w, https:\/\/www.autoitconsulting.com\/site\/wp-content\/uploads\/2012\/01\/collation_1-768x254.png 768w, https:\/\/www.autoitconsulting.com\/site\/wp-content\/uploads\/2012\/01\/collation_1-300x99.png 300w\" sizes=\"auto, (max-width: 820px) 100vw, 820px\" \/><\/a><\/figure>\n\n\n\n<p class=\"has-text-align-center\">&nbsp;<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter\"><a href=\"\/site\/wp-content\/uploads\/2012\/01\/collation_2.png\"><img loading=\"lazy\" decoding=\"async\" width=\"820\" height=\"272\" src=\"\/site\/wp-content\/uploads\/2012\/01\/collation_2.png\" alt=\"Collation 2\" class=\"wp-image-758\" title=\"Collation 2\" srcset=\"https:\/\/www.autoitconsulting.com\/site\/wp-content\/uploads\/2012\/01\/collation_2.png 820w, https:\/\/www.autoitconsulting.com\/site\/wp-content\/uploads\/2012\/01\/collation_2-300x100.png 300w, https:\/\/www.autoitconsulting.com\/site\/wp-content\/uploads\/2012\/01\/collation_2-768x255.png 768w\" sizes=\"auto, (max-width: 820px) 100vw, 820px\" \/><\/a><\/figure>\n\n\n\n<p class=\"has-text-align-center\"><\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter\"><a href=\"\/site\/wp-content\/uploads\/2012\/01\/collation_3.png\"><img loading=\"lazy\" decoding=\"async\" width=\"520\" height=\"410\" src=\"\/site\/wp-content\/uploads\/2012\/01\/collation_3.png\" alt=\"Collation 3\" class=\"wp-image-759\" title=\"Collation 3\" srcset=\"https:\/\/www.autoitconsulting.com\/site\/wp-content\/uploads\/2012\/01\/collation_3.png 520w, https:\/\/www.autoitconsulting.com\/site\/wp-content\/uploads\/2012\/01\/collation_3-300x237.png 300w\" sizes=\"auto, (max-width: 520px) 100vw, 520px\" \/><\/a><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>Overview I just tried to update my &#8216;default&#8217; installation of System Center Configuration Manager (SCCM \/ ConfigMgr) 2012 RC1 to RC2. I got a failure at the pre-req check stage stating that my SQL 2008 R2 database was using the wrong collation type and that installation couldn&#8217;t continue. It turns out that the default collation [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":746,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[20],"tags":[59,62,91,68,35],"class_list":["post-741","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-deployment","tag-configmgr","tag-deployment","tag-mecm","tag-sccm","tag-sql-2008-r2"],"_links":{"self":[{"href":"https:\/\/www.autoitconsulting.com\/site\/wp-json\/wp\/v2\/posts\/741","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.autoitconsulting.com\/site\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.autoitconsulting.com\/site\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.autoitconsulting.com\/site\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.autoitconsulting.com\/site\/wp-json\/wp\/v2\/comments?post=741"}],"version-history":[{"count":5,"href":"https:\/\/www.autoitconsulting.com\/site\/wp-json\/wp\/v2\/posts\/741\/revisions"}],"predecessor-version":[{"id":100129,"href":"https:\/\/www.autoitconsulting.com\/site\/wp-json\/wp\/v2\/posts\/741\/revisions\/100129"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.autoitconsulting.com\/site\/wp-json\/wp\/v2\/media\/746"}],"wp:attachment":[{"href":"https:\/\/www.autoitconsulting.com\/site\/wp-json\/wp\/v2\/media?parent=741"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.autoitconsulting.com\/site\/wp-json\/wp\/v2\/categories?post=741"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.autoitconsulting.com\/site\/wp-json\/wp\/v2\/tags?post=741"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}