{"id":2801,"date":"2018-01-25T15:41:56","date_gmt":"2018-01-25T14:41:56","guid":{"rendered":"http:\/\/lestfrexgn.cluster020.hosting.ovh.net\/?p=2801"},"modified":"2018-01-25T15:41:56","modified_gmt":"2018-01-25T14:41:56","slug":"sccm-patch-sql-et-probleme-clr","status":"publish","type":"post","link":"https:\/\/les2t.fr\/en_us\/sccm-patch-sql-et-probleme-clr\/","title":{"rendered":"SCCM \u2013 Patch SQL et probl\u00e8me CLR"},"content":{"rendered":"

\"\"<\/a><\/p>\n

Avec les failles d\u00e9couvertes sur les processeurs, Microsoft d\u00e9ploie un arsenal de patch sur ces syst\u00e8mes. Mais certain peuvent poser des probl\u00e8mes pour des applications comme SCCM. C\u2019est d\u2019ailleurs le cas pour le KB4073225.<\/p>\n

<\/p>\n

Celui-ci d\u00e9sactive entre autre CLR qui fait partie du fonctionnement de SCCM. Il faudra donc r\u00e9activer CRL apr\u00e8s l\u2019application du patch. Pour ce faire, dans SQL Management Studio ex\u00e9cutez\u00a0:<\/p>\n

sp_configure \u2018show advanced options\u2019, 1;<\/em>
\n GO<\/em>
\n RECONFIGURE;<\/em>
\n GO<\/em>
\n sp_configure \u2018clr enabled\u2019, 1;<\/em>
\n GO<\/em>
\n RECONFIGURE;<\/em>
\n GO<\/em><\/p>","protected":false},"excerpt":{"rendered":"

Avec les failles d\u00e9couvertes sur les processeurs, Microsoft d\u00e9ploie un arsenal de patch sur ces syst\u00e8mes. Mais certain peuvent poser des probl\u00e8mes pour des applications comme SCCM. C\u2019est d\u2019ailleurs le cas pour le KB4073225.<\/p>","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"","_et_pb_old_content":"","_et_gb_content_width":"","_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[198],"tags":[113,36,27,114,22],"class_list":["post-2801","post","type-post","status-publish","format-standard","hentry","category-sccm","tag-configmgr","tag-microsoft","tag-mises-a-jour","tag-sccm","tag-system-center-configuration-manager"],"yoast_head":"\nSCCM \u2013 Patch SQL et probl\u00e8me CLR - Les2T<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/les2t.fr\/en_us\/sccm-patch-sql-et-probleme-clr\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SCCM \u2013 Patch SQL et probl\u00e8me CLR - Les2T\" \/>\n<meta property=\"og:description\" content=\"Avec les failles d\u00e9couvertes sur les processeurs, Microsoft d\u00e9ploie un arsenal de patch sur ces syst\u00e8mes. Mais certain peuvent poser des probl\u00e8mes pour des applications comme SCCM. C\u2019est d\u2019ailleurs le cas pour le KB4073225.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/les2t.fr\/en_us\/sccm-patch-sql-et-probleme-clr\/\" \/>\n<meta property=\"og:site_name\" content=\"Les2T\" \/>\n<meta property=\"article:published_time\" content=\"2018-01-25T14:41:56+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/les2t.fr\/wp-content\/uploads\/2017\/02\/BANSCCM.png\" \/>\n<meta name=\"author\" content=\"TRARBACH Jean-Yves\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"TRARBACH Jean-Yves\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/les2t.fr\/sccm-patch-sql-et-probleme-clr\/\",\"url\":\"https:\/\/les2t.fr\/sccm-patch-sql-et-probleme-clr\/\",\"name\":\"SCCM \u2013 Patch SQL et probl\u00e8me CLR - Les2T\",\"isPartOf\":{\"@id\":\"https:\/\/les2t.fr\/fr_fr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/les2t.fr\/sccm-patch-sql-et-probleme-clr\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/les2t.fr\/sccm-patch-sql-et-probleme-clr\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/les2t.fr\/wp-content\/uploads\/2017\/02\/BANSCCM.png\",\"datePublished\":\"2018-01-25T14:41:56+00:00\",\"author\":{\"@id\":\"https:\/\/les2t.fr\/fr_fr\/#\/schema\/person\/d96bb4f512f9aeb12dc923def245768e\"},\"breadcrumb\":{\"@id\":\"https:\/\/les2t.fr\/sccm-patch-sql-et-probleme-clr\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/les2t.fr\/sccm-patch-sql-et-probleme-clr\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/les2t.fr\/sccm-patch-sql-et-probleme-clr\/#primaryimage\",\"url\":\"https:\/\/les2t.fr\/wp-content\/uploads\/2017\/02\/BANSCCM.png\",\"contentUrl\":\"https:\/\/les2t.fr\/wp-content\/uploads\/2017\/02\/BANSCCM.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/les2t.fr\/sccm-patch-sql-et-probleme-clr\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/les2t.fr\/fr_fr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SCCM \u2013 Patch SQL et probl\u00e8me CLR\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/les2t.fr\/fr_fr\/#website\",\"url\":\"https:\/\/les2t.fr\/fr_fr\/\",\"name\":\"Les2T\",\"description\":\"| BLOG IT |\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/les2t.fr\/fr_fr\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/les2t.fr\/fr_fr\/#\/schema\/person\/d96bb4f512f9aeb12dc923def245768e\",\"name\":\"TRARBACH Jean-Yves\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/les2t.fr\/fr_fr\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/les2t.fr\/wp-content\/uploads\/2023\/02\/JeanYvestrarbach-96x96.jpg\",\"contentUrl\":\"https:\/\/les2t.fr\/wp-content\/uploads\/2023\/02\/JeanYvestrarbach-96x96.jpg\",\"caption\":\"TRARBACH Jean-Yves\"},\"description\":\"Head Of Modern Workplace Metsys MVP Windows & devices For IT\",\"sameAs\":[\"https:\/\/les2t.fr\/jean-yves-trarbach\/\"],\"url\":\"https:\/\/les2t.fr\/en_us\/author\/kounac\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SCCM \u2013 Patch SQL et probl\u00e8me CLR - Les2T","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/les2t.fr\/en_us\/sccm-patch-sql-et-probleme-clr\/","og_locale":"en_US","og_type":"article","og_title":"SCCM \u2013 Patch SQL et probl\u00e8me CLR - Les2T","og_description":"Avec les failles d\u00e9couvertes sur les processeurs, Microsoft d\u00e9ploie un arsenal de patch sur ces syst\u00e8mes. Mais certain peuvent poser des probl\u00e8mes pour des applications comme SCCM. C\u2019est d\u2019ailleurs le cas pour le KB4073225.","og_url":"https:\/\/les2t.fr\/en_us\/sccm-patch-sql-et-probleme-clr\/","og_site_name":"Les2T","article_published_time":"2018-01-25T14:41:56+00:00","og_image":[{"url":"https:\/\/les2t.fr\/wp-content\/uploads\/2017\/02\/BANSCCM.png","type":"","width":"","height":""}],"author":"TRARBACH Jean-Yves","twitter_card":"summary_large_image","twitter_misc":{"Written by":"TRARBACH Jean-Yves"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/les2t.fr\/sccm-patch-sql-et-probleme-clr\/","url":"https:\/\/les2t.fr\/sccm-patch-sql-et-probleme-clr\/","name":"SCCM \u2013 Patch SQL et probl\u00e8me CLR - Les2T","isPartOf":{"@id":"https:\/\/les2t.fr\/fr_fr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/les2t.fr\/sccm-patch-sql-et-probleme-clr\/#primaryimage"},"image":{"@id":"https:\/\/les2t.fr\/sccm-patch-sql-et-probleme-clr\/#primaryimage"},"thumbnailUrl":"https:\/\/les2t.fr\/wp-content\/uploads\/2017\/02\/BANSCCM.png","datePublished":"2018-01-25T14:41:56+00:00","author":{"@id":"https:\/\/les2t.fr\/fr_fr\/#\/schema\/person\/d96bb4f512f9aeb12dc923def245768e"},"breadcrumb":{"@id":"https:\/\/les2t.fr\/sccm-patch-sql-et-probleme-clr\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/les2t.fr\/sccm-patch-sql-et-probleme-clr\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/les2t.fr\/sccm-patch-sql-et-probleme-clr\/#primaryimage","url":"https:\/\/les2t.fr\/wp-content\/uploads\/2017\/02\/BANSCCM.png","contentUrl":"https:\/\/les2t.fr\/wp-content\/uploads\/2017\/02\/BANSCCM.png"},{"@type":"BreadcrumbList","@id":"https:\/\/les2t.fr\/sccm-patch-sql-et-probleme-clr\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/les2t.fr\/fr_fr\/"},{"@type":"ListItem","position":2,"name":"SCCM \u2013 Patch SQL et probl\u00e8me CLR"}]},{"@type":"WebSite","@id":"https:\/\/les2t.fr\/fr_fr\/#website","url":"https:\/\/les2t.fr\/fr_fr\/","name":"Les2T","description":"| BLOG IT |","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/les2t.fr\/fr_fr\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/les2t.fr\/fr_fr\/#\/schema\/person\/d96bb4f512f9aeb12dc923def245768e","name":"TRARBACH Jean-Yves","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/les2t.fr\/fr_fr\/#\/schema\/person\/image\/","url":"https:\/\/les2t.fr\/wp-content\/uploads\/2023\/02\/JeanYvestrarbach-96x96.jpg","contentUrl":"https:\/\/les2t.fr\/wp-content\/uploads\/2023\/02\/JeanYvestrarbach-96x96.jpg","caption":"TRARBACH Jean-Yves"},"description":"Head Of Modern Workplace Metsys MVP Windows & devices For IT","sameAs":["https:\/\/les2t.fr\/jean-yves-trarbach\/"],"url":"https:\/\/les2t.fr\/en_us\/author\/kounac\/"}]}},"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/les2t.fr\/en_us\/wp-json\/wp\/v2\/posts\/2801","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/les2t.fr\/en_us\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/les2t.fr\/en_us\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/les2t.fr\/en_us\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/les2t.fr\/en_us\/wp-json\/wp\/v2\/comments?post=2801"}],"version-history":[{"count":0,"href":"https:\/\/les2t.fr\/en_us\/wp-json\/wp\/v2\/posts\/2801\/revisions"}],"wp:attachment":[{"href":"https:\/\/les2t.fr\/en_us\/wp-json\/wp\/v2\/media?parent=2801"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/les2t.fr\/en_us\/wp-json\/wp\/v2\/categories?post=2801"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/les2t.fr\/en_us\/wp-json\/wp\/v2\/tags?post=2801"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}