{"id":6625,"date":"2018-10-11T14:55:32","date_gmt":"2018-10-11T13:55:32","guid":{"rendered":"http:\/\/blog.capdata.fr\/?p=6625"},"modified":"2022-11-21T16:57:18","modified_gmt":"2022-11-21T15:57:18","slug":"groupe-de-disponibilite-alwayson-multisubnet-et-probleme-de-connectivite-sous-windows-2008-r2-7","status":"publish","type":"post","link":"https:\/\/blog.capdata.fr\/index.php\/groupe-de-disponibilite-alwayson-multisubnet-et-probleme-de-connectivite-sous-windows-2008-r2-7\/","title":{"rendered":"Groupe de disponibilit\u00e9 AlwaysOn multisubnet et probl\u00e8me de connectivit\u00e9 sous Windows 2008 R2 \/ 7"},"content":{"rendered":"<a class=\"synved-social-button synved-social-button-share synved-social-size-24 synved-social-resolution-single synved-social-provider-twitter nolightbox\" data-provider=\"twitter\" target=\"_blank\" rel=\"nofollow\" title=\"Share on Twitter\" href=\"https:\/\/twitter.com\/intent\/tweet?url=https%3A%2F%2Fblog.capdata.fr%2Findex.php%2Fwp-json%2Fwp%2Fv2%2Fposts%2F6625&#038;text=Article%20sur%20le%20blog%20de%20la%20Capdata%20Tech%20Team%20%3A%20\" style=\"font-size: 0px;width:24px;height:24px;margin:0;margin-bottom:5px;margin-right:5px\"><img loading=\"lazy\" decoding=\"async\" alt=\"twitter\" title=\"Share on Twitter\" class=\"synved-share-image synved-social-image synved-social-image-share\" width=\"24\" height=\"24\" style=\"display: inline;width:24px;height:24px;margin: 0;padding: 0;border: none;box-shadow: none\" src=\"https:\/\/blog.capdata.fr\/wp-content\/plugins\/social-media-feather\/synved-social\/image\/social\/regular\/48x48\/twitter.png\" \/><\/a><a class=\"synved-social-button synved-social-button-share synved-social-size-24 synved-social-resolution-single synved-social-provider-linkedin nolightbox\" data-provider=\"linkedin\" target=\"_blank\" rel=\"nofollow\" title=\"Share on Linkedin\" href=\"https:\/\/www.linkedin.com\/shareArticle?mini=true&#038;url=https%3A%2F%2Fblog.capdata.fr%2Findex.php%2Fwp-json%2Fwp%2Fv2%2Fposts%2F6625&#038;title=Groupe%20de%20disponibilit%C3%A9%20AlwaysOn%20multisubnet%20et%20probl%C3%A8me%20de%20connectivit%C3%A9%20sous%20Windows%202008%20R2%20%2F%207\" style=\"font-size: 0px;width:24px;height:24px;margin:0;margin-bottom:5px;margin-right:5px\"><img loading=\"lazy\" decoding=\"async\" alt=\"linkedin\" title=\"Share on Linkedin\" class=\"synved-share-image synved-social-image synved-social-image-share\" width=\"24\" height=\"24\" style=\"display: inline;width:24px;height:24px;margin: 0;padding: 0;border: none;box-shadow: none\" src=\"https:\/\/blog.capdata.fr\/wp-content\/plugins\/social-media-feather\/synved-social\/image\/social\/regular\/48x48\/linkedin.png\" \/><\/a><a class=\"synved-social-button synved-social-button-share synved-social-size-24 synved-social-resolution-single synved-social-provider-mail nolightbox\" data-provider=\"mail\" rel=\"nofollow\" title=\"Share by email\" href=\"mailto:?subject=Groupe%20de%20disponibilit%C3%A9%20AlwaysOn%20multisubnet%20et%20probl%C3%A8me%20de%20connectivit%C3%A9%20sous%20Windows%202008%20R2%20%2F%207&#038;body=Article%20sur%20le%20blog%20de%20la%20Capdata%20Tech%20Team%20%3A%20:%20https%3A%2F%2Fblog.capdata.fr%2Findex.php%2Fwp-json%2Fwp%2Fv2%2Fposts%2F6625\" style=\"font-size: 0px;width:24px;height:24px;margin:0;margin-bottom:5px\"><img loading=\"lazy\" decoding=\"async\" alt=\"mail\" title=\"Share by email\" class=\"synved-share-image synved-social-image synved-social-image-share\" width=\"24\" height=\"24\" style=\"display: inline;width:24px;height:24px;margin: 0;padding: 0;border: none;box-shadow: none\" src=\"https:\/\/blog.capdata.fr\/wp-content\/plugins\/social-media-feather\/synved-social\/image\/social\/regular\/48x48\/mail.png\" \/><\/a><p>Cet article d\u00e9crit un probl\u00e8me rencontr\u00e9 il y a peu et qui nous a fait nous creuser la t\u00eate. Il s&#8217;agit une connexion \u00e0 un AlwaysOn 2016 en multi-subnet, mais \u00e7a aurait tr\u00e8s bien pu \u00eatre une configuration cluster classique (FCI) en multi-subnet.<\/p>\n<p>Les sympt\u00f4mes pr\u00e9sent\u00e9s \u00e9taient les suivants : dans un groupe de disponibilit\u00e9 AlwaysOn SQL Server 2016 + Windows Server 2016 en multi-subnet, certains clients n&#8217;arrivent pas \u00e0 se connecter en ODBC.<\/p>\n<p>Le premier r\u00e9flexe a \u00e9t\u00e9 de sous-estimer le probl\u00e8me : il suffit juste de cocher &#8220;multisubnet failover&#8221; dans le driver !<\/p>\n<p>Sauf que <em>non<\/em>. C&#8217;\u00e9tait coch\u00e9.<\/p>\n<p>Deuxi\u00e8me r\u00e9flexe : \u00e7a doit \u00eatre surement \u00eatre un probl\u00e8me de DNS : les 2 IP ne sont pas enregistr\u00e9es par le cluster !<\/p>\n<p>Sauf que <em>non<\/em> : un nslookup sur le nom du listener AlwaysOn renvoie bien les 2 IP.<\/p>\n<p>Donc l\u00e0, \u00e7a y est, on est dans la <em>twilight zone.<\/em><\/p>\n<p>Pour comprendre le probl\u00e8me, il faut d\u00e9j\u00e0 bien saisir le fonctionnement du cluster en multi-subnet.<\/p>\n<p>Un cluster, ou un AlwaysOn peu importe, en multi-subnet, implique l&#8217;utilisation d&#8217;au moins 2 adresses IP dans des subnets diff\u00e9rents. La solution &#8220;moderne&#8221; implique que les 2 IP sont enregistr\u00e9es dans le DNS. Quand un client demandera donc \u00e0 r\u00e9soudre le nom du listener ou le nom de l&#8217;instance clusteris\u00e9e, il va interroger le DNS et r\u00e9cup\u00e9rer les 2 IP. Avec les m\u00e9canismes de <a href=\"https:\/\/fr.wikipedia.org\/wiki\/DNS_round-robin\">Round-Robin<\/a>&nbsp; le client va donc avoir du mal \u00e0 se connecter ! En th\u00e9orie, il se connectera une fois sur deux sur la bonne IP. Pour \u00e9viter ce probl\u00e8me, les drivers de connexion modernes disposent d&#8217;une option &#8220;multisubnet failover&#8221; et m\u00eame encore plus r\u00e9cemment &#8220;Transparent Network IP resolution&#8221;. Leur combinaison change un peu la mani\u00e8re dont se comporte le driver : <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/connect\/odbc\/using-transparent-network-ip-resolution?view=sql-server-2017\">https:\/\/docs.microsoft.com\/en-us\/sql\/connect\/odbc\/using-transparent-network-ip-resolution?view=sql-server-2017<\/a><\/p>\n<p>Dans le doute, pour v\u00e9rifier que les comportements attendus et obtenus \u00e9taient bien identiques, nous avons utilis\u00e9 un <a href=\"https:\/\/www.wireshark.org\/\">Wireshark<\/a>. Pour ceux qui ne connaissent pas, c&#8217;est un outil capture les trames r\u00e9seaux \u00e9chang\u00e9es. Et l\u00e0, nous avons bien vu que nous avions, comme attendu, deux connexions effectu\u00e9es simultan\u00e9ment sur les deux IP enregistr\u00e9es dans le DNS.<\/p>\n<p>Sur la premi\u00e8re IP (celle active), nous voyons bien le <a href=\"https:\/\/fr.wikipedia.org\/wiki\/Three-way_handshake\">3-way handshake<\/a>&nbsp; s&#8217;effectuer normalement : la connexion s\u2019\u00e9tablit bien (pas de souci r\u00e9seau). Sur la deuxi\u00e8me IP : pas de r\u00e9ponse (normal : l&#8217;IP est inactive dans le cluster). Sauf que le driver ODBC refuse de consid\u00e9rer la r\u00e9ponse :<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-6630\" src=\"https:\/\/blog.capdata.fr\/wp-content\/uploads\/2018\/10\/wireshark_small.png\" alt=\"\" width=\"1214\" height=\"298\" srcset=\"https:\/\/blog.capdata.fr\/wp-content\/uploads\/2018\/10\/wireshark_small.png 1214w, https:\/\/blog.capdata.fr\/wp-content\/uploads\/2018\/10\/wireshark_small-300x74.png 300w, https:\/\/blog.capdata.fr\/wp-content\/uploads\/2018\/10\/wireshark_small-768x189.png 768w, https:\/\/blog.capdata.fr\/wp-content\/uploads\/2018\/10\/wireshark_small-1024x251.png 1024w\" sizes=\"auto, (max-width: 1214px) 100vw, 1214px\" \/><\/p>\n<p><em>[Microsoft][ODBC Driver 13 for SQL Server]Unable to complete login process due to delay in opening server connection :<\/em><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-6626\" src=\"https:\/\/blog.capdata.fr\/wp-content\/uploads\/2018\/10\/odbc_error.jpg\" alt=\"\" width=\"889\" height=\"528\" srcset=\"https:\/\/blog.capdata.fr\/wp-content\/uploads\/2018\/10\/odbc_error.jpg 889w, https:\/\/blog.capdata.fr\/wp-content\/uploads\/2018\/10\/odbc_error-300x178.jpg 300w, https:\/\/blog.capdata.fr\/wp-content\/uploads\/2018\/10\/odbc_error-768x456.jpg 768w\" sizes=\"auto, (max-width: 889px) 100vw, 889px\" \/><\/p>\n<p>De l\u00e0, apr\u00e8s avoir test\u00e9 diff\u00e9rentes combinaisons de drivers, des tests de bascules, r\u00e9seau DNS et j&#8217;en passe : toujours pas l&#8217;ombre d&#8217;une solution&#8230;<\/p>\n<p>Jusqu&#8217;\u00e0 tomber sur ce bug r\u00e9f\u00e9renc\u00e9 chez Microsoft (KB2870437) :<\/p>\n<p><a href=\"https:\/\/support.microsoft.com\/en-us\/help\/2870437\/connection-times-out-when-you-use-alwayson-availability-group-listener\">https:\/\/support.microsoft.com\/en-us\/help\/2870437\/connection-times-out-when-you-use-alwayson-availability-group-listener<\/a><\/p>\n<p>Il est bien propos\u00e9 un hotfix, mais il n&#8217;est plus t\u00e9l\u00e9chargeable chez Microsoft directement. Quelques recherches dans votre moteur de recherche favoris permettent de le retrouver quand m\u00eame sans trop de difficult\u00e9s. Ou sinon <a href=\"https:\/\/blog.capdata.fr\/media\/Windows6.1-KB2870437-x64.msu\">ici chez nous<\/a>.<\/p>\n<p>M\u00eame si j&#8217;avais un Windows Update \u00e0 jour sur ce serveur, ce fix ne semble pas passer syst\u00e9matiquement. Donc : \u00e0 installer \u00e0 la main.<\/p>\n<p>Une fois le patch install\u00e9, machine red\u00e9marr\u00e9e : tout est rentr\u00e9 dans l&#8217;ordre !<\/p>\n<a class=\"synved-social-button synved-social-button-share synved-social-size-24 synved-social-resolution-single synved-social-provider-twitter nolightbox\" data-provider=\"twitter\" target=\"_blank\" rel=\"nofollow\" title=\"Share on Twitter\" href=\"https:\/\/twitter.com\/intent\/tweet?url=https%3A%2F%2Fblog.capdata.fr%2Findex.php%2Fwp-json%2Fwp%2Fv2%2Fposts%2F6625&#038;text=Article%20sur%20le%20blog%20de%20la%20Capdata%20Tech%20Team%20%3A%20\" style=\"font-size: 0px;width:24px;height:24px;margin:0;margin-bottom:5px;margin-right:5px\"><img loading=\"lazy\" decoding=\"async\" alt=\"twitter\" title=\"Share on Twitter\" class=\"synved-share-image synved-social-image synved-social-image-share\" width=\"24\" height=\"24\" style=\"display: inline;width:24px;height:24px;margin: 0;padding: 0;border: none;box-shadow: none\" src=\"https:\/\/blog.capdata.fr\/wp-content\/plugins\/social-media-feather\/synved-social\/image\/social\/regular\/48x48\/twitter.png\" \/><\/a><a class=\"synved-social-button synved-social-button-share synved-social-size-24 synved-social-resolution-single synved-social-provider-linkedin nolightbox\" data-provider=\"linkedin\" target=\"_blank\" rel=\"nofollow\" title=\"Share on Linkedin\" href=\"https:\/\/www.linkedin.com\/shareArticle?mini=true&#038;url=https%3A%2F%2Fblog.capdata.fr%2Findex.php%2Fwp-json%2Fwp%2Fv2%2Fposts%2F6625&#038;title=Groupe%20de%20disponibilit%C3%A9%20AlwaysOn%20multisubnet%20et%20probl%C3%A8me%20de%20connectivit%C3%A9%20sous%20Windows%202008%20R2%20%2F%207\" style=\"font-size: 0px;width:24px;height:24px;margin:0;margin-bottom:5px;margin-right:5px\"><img loading=\"lazy\" decoding=\"async\" alt=\"linkedin\" title=\"Share on Linkedin\" class=\"synved-share-image synved-social-image synved-social-image-share\" width=\"24\" height=\"24\" style=\"display: inline;width:24px;height:24px;margin: 0;padding: 0;border: none;box-shadow: none\" src=\"https:\/\/blog.capdata.fr\/wp-content\/plugins\/social-media-feather\/synved-social\/image\/social\/regular\/48x48\/linkedin.png\" \/><\/a><a class=\"synved-social-button synved-social-button-share synved-social-size-24 synved-social-resolution-single synved-social-provider-mail nolightbox\" data-provider=\"mail\" rel=\"nofollow\" title=\"Share by email\" href=\"mailto:?subject=Groupe%20de%20disponibilit%C3%A9%20AlwaysOn%20multisubnet%20et%20probl%C3%A8me%20de%20connectivit%C3%A9%20sous%20Windows%202008%20R2%20%2F%207&#038;body=Article%20sur%20le%20blog%20de%20la%20Capdata%20Tech%20Team%20%3A%20:%20https%3A%2F%2Fblog.capdata.fr%2Findex.php%2Fwp-json%2Fwp%2Fv2%2Fposts%2F6625\" style=\"font-size: 0px;width:24px;height:24px;margin:0;margin-bottom:5px\"><img loading=\"lazy\" decoding=\"async\" alt=\"mail\" title=\"Share by email\" class=\"synved-share-image synved-social-image synved-social-image-share\" width=\"24\" height=\"24\" style=\"display: inline;width:24px;height:24px;margin: 0;padding: 0;border: none;box-shadow: none\" src=\"https:\/\/blog.capdata.fr\/wp-content\/plugins\/social-media-feather\/synved-social\/image\/social\/regular\/48x48\/mail.png\" \/><\/a>","protected":false},"excerpt":{"rendered":"<p>Cet article d\u00e9crit un probl\u00e8me rencontr\u00e9 il y a peu et qui nous a fait nous creuser la t\u00eate. Il s&#8217;agit une connexion \u00e0 un AlwaysOn 2016 en multi-subnet, mais \u00e7a aurait tr\u00e8s bien pu \u00eatre une configuration cluster classique&hellip; <a href=\"https:\/\/blog.capdata.fr\/index.php\/groupe-de-disponibilite-alwayson-multisubnet-et-probleme-de-connectivite-sous-windows-2008-r2-7\/\" class=\"more-link\">Continuer la lecture <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":6630,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[173,5],"tags":[291,21,290,292,293,294],"class_list":["post-6625","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-operating-system","category-sqlserver","tag-alwayson","tag-cluster","tag-kb2870437","tag-multi-subnet","tag-multisubnet","tag-unable-to-complete-login-process"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v20.8 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Groupe de disponibilit\u00e9 AlwaysOn multisubnet et probl\u00e8me de connectivit\u00e9 sous Windows 2008 R2 \/ 7 - Capdata TECH BLOG<\/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:\/\/blog.capdata.fr\/index.php\/groupe-de-disponibilite-alwayson-multisubnet-et-probleme-de-connectivite-sous-windows-2008-r2-7\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Groupe de disponibilit\u00e9 AlwaysOn multisubnet et probl\u00e8me de connectivit\u00e9 sous Windows 2008 R2 \/ 7 - Capdata TECH BLOG\" \/>\n<meta property=\"og:description\" content=\"Cet article d\u00e9crit un probl\u00e8me rencontr\u00e9 il y a peu et qui nous a fait nous creuser la t\u00eate. Il s&#8217;agit une connexion \u00e0 un AlwaysOn 2016 en multi-subnet, mais \u00e7a aurait tr\u00e8s bien pu \u00eatre une configuration cluster classique&hellip; Continuer la lecture &rarr;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/blog.capdata.fr\/index.php\/groupe-de-disponibilite-alwayson-multisubnet-et-probleme-de-connectivite-sous-windows-2008-r2-7\/\" \/>\n<meta property=\"og:site_name\" content=\"Capdata TECH BLOG\" \/>\n<meta property=\"article:published_time\" content=\"2018-10-11T13:55:32+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-11-21T15:57:18+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/blog.capdata.fr\/wp-content\/uploads\/2018\/10\/wireshark_small.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1214\" \/>\n\t<meta property=\"og:image:height\" content=\"298\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Capdata team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u00c9crit par\" \/>\n\t<meta name=\"twitter:data1\" content=\"Capdata team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Dur\u00e9e de lecture estim\u00e9e\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/blog.capdata.fr\/index.php\/groupe-de-disponibilite-alwayson-multisubnet-et-probleme-de-connectivite-sous-windows-2008-r2-7\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/blog.capdata.fr\/index.php\/groupe-de-disponibilite-alwayson-multisubnet-et-probleme-de-connectivite-sous-windows-2008-r2-7\/\"},\"author\":{\"name\":\"Capdata team\",\"@id\":\"https:\/\/blog.capdata.fr\/#\/schema\/person\/bfd9395c8ba4fa125792a543377035e9\"},\"headline\":\"Groupe de disponibilit\u00e9 AlwaysOn multisubnet et probl\u00e8me de connectivit\u00e9 sous Windows 2008 R2 \/ 7\",\"datePublished\":\"2018-10-11T13:55:32+00:00\",\"dateModified\":\"2022-11-21T15:57:18+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/blog.capdata.fr\/index.php\/groupe-de-disponibilite-alwayson-multisubnet-et-probleme-de-connectivite-sous-windows-2008-r2-7\/\"},\"wordCount\":579,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/blog.capdata.fr\/#organization\"},\"keywords\":[\"AlwaysOn\",\"cluster\",\"KB2870437\",\"multi-subnet\",\"multisubnet\",\"unable to complete login process\"],\"articleSection\":[\"Operating System\",\"SQL Server\"],\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/blog.capdata.fr\/index.php\/groupe-de-disponibilite-alwayson-multisubnet-et-probleme-de-connectivite-sous-windows-2008-r2-7\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/blog.capdata.fr\/index.php\/groupe-de-disponibilite-alwayson-multisubnet-et-probleme-de-connectivite-sous-windows-2008-r2-7\/\",\"url\":\"https:\/\/blog.capdata.fr\/index.php\/groupe-de-disponibilite-alwayson-multisubnet-et-probleme-de-connectivite-sous-windows-2008-r2-7\/\",\"name\":\"Groupe de disponibilit\u00e9 AlwaysOn multisubnet et probl\u00e8me de connectivit\u00e9 sous Windows 2008 R2 \/ 7 - Capdata TECH BLOG\",\"isPartOf\":{\"@id\":\"https:\/\/blog.capdata.fr\/#website\"},\"datePublished\":\"2018-10-11T13:55:32+00:00\",\"dateModified\":\"2022-11-21T15:57:18+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/blog.capdata.fr\/index.php\/groupe-de-disponibilite-alwayson-multisubnet-et-probleme-de-connectivite-sous-windows-2008-r2-7\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/blog.capdata.fr\/index.php\/groupe-de-disponibilite-alwayson-multisubnet-et-probleme-de-connectivite-sous-windows-2008-r2-7\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/blog.capdata.fr\/index.php\/groupe-de-disponibilite-alwayson-multisubnet-et-probleme-de-connectivite-sous-windows-2008-r2-7\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/blog.capdata.fr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Groupe de disponibilit\u00e9 AlwaysOn multisubnet et probl\u00e8me de connectivit\u00e9 sous Windows 2008 R2 \/ 7\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/blog.capdata.fr\/#website\",\"url\":\"https:\/\/blog.capdata.fr\/\",\"name\":\"Capdata TECH BLOG\",\"description\":\"Le blog technique sur les bases de donn\u00e9es de CAP DATA Consulting\",\"publisher\":{\"@id\":\"https:\/\/blog.capdata.fr\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/blog.capdata.fr\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"fr-FR\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/blog.capdata.fr\/#organization\",\"name\":\"Capdata TECH BLOG\",\"url\":\"https:\/\/blog.capdata.fr\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/blog.capdata.fr\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/blog.capdata.fr\/wp-content\/uploads\/2023\/01\/logo_capdata.webp\",\"contentUrl\":\"https:\/\/blog.capdata.fr\/wp-content\/uploads\/2023\/01\/logo_capdata.webp\",\"width\":800,\"height\":254,\"caption\":\"Capdata TECH BLOG\"},\"image\":{\"@id\":\"https:\/\/blog.capdata.fr\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.linkedin.com\/company\/cap-data-consulting\/mycompany\/\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/blog.capdata.fr\/#\/schema\/person\/bfd9395c8ba4fa125792a543377035e9\",\"name\":\"Capdata team\",\"sameAs\":[\"https:\/\/www.capdata.fr\"],\"url\":\"https:\/\/blog.capdata.fr\/index.php\/author\/admin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Groupe de disponibilit\u00e9 AlwaysOn multisubnet et probl\u00e8me de connectivit\u00e9 sous Windows 2008 R2 \/ 7 - Capdata TECH BLOG","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:\/\/blog.capdata.fr\/index.php\/groupe-de-disponibilite-alwayson-multisubnet-et-probleme-de-connectivite-sous-windows-2008-r2-7\/","og_locale":"fr_FR","og_type":"article","og_title":"Groupe de disponibilit\u00e9 AlwaysOn multisubnet et probl\u00e8me de connectivit\u00e9 sous Windows 2008 R2 \/ 7 - Capdata TECH BLOG","og_description":"Cet article d\u00e9crit un probl\u00e8me rencontr\u00e9 il y a peu et qui nous a fait nous creuser la t\u00eate. Il s&#8217;agit une connexion \u00e0 un AlwaysOn 2016 en multi-subnet, mais \u00e7a aurait tr\u00e8s bien pu \u00eatre une configuration cluster classique&hellip; Continuer la lecture &rarr;","og_url":"https:\/\/blog.capdata.fr\/index.php\/groupe-de-disponibilite-alwayson-multisubnet-et-probleme-de-connectivite-sous-windows-2008-r2-7\/","og_site_name":"Capdata TECH BLOG","article_published_time":"2018-10-11T13:55:32+00:00","article_modified_time":"2022-11-21T15:57:18+00:00","og_image":[{"width":1214,"height":298,"url":"https:\/\/blog.capdata.fr\/wp-content\/uploads\/2018\/10\/wireshark_small.png","type":"image\/png"}],"author":"Capdata team","twitter_card":"summary_large_image","twitter_misc":{"\u00c9crit par":"Capdata team","Dur\u00e9e de lecture estim\u00e9e":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/blog.capdata.fr\/index.php\/groupe-de-disponibilite-alwayson-multisubnet-et-probleme-de-connectivite-sous-windows-2008-r2-7\/#article","isPartOf":{"@id":"https:\/\/blog.capdata.fr\/index.php\/groupe-de-disponibilite-alwayson-multisubnet-et-probleme-de-connectivite-sous-windows-2008-r2-7\/"},"author":{"name":"Capdata team","@id":"https:\/\/blog.capdata.fr\/#\/schema\/person\/bfd9395c8ba4fa125792a543377035e9"},"headline":"Groupe de disponibilit\u00e9 AlwaysOn multisubnet et probl\u00e8me de connectivit\u00e9 sous Windows 2008 R2 \/ 7","datePublished":"2018-10-11T13:55:32+00:00","dateModified":"2022-11-21T15:57:18+00:00","mainEntityOfPage":{"@id":"https:\/\/blog.capdata.fr\/index.php\/groupe-de-disponibilite-alwayson-multisubnet-et-probleme-de-connectivite-sous-windows-2008-r2-7\/"},"wordCount":579,"commentCount":0,"publisher":{"@id":"https:\/\/blog.capdata.fr\/#organization"},"keywords":["AlwaysOn","cluster","KB2870437","multi-subnet","multisubnet","unable to complete login process"],"articleSection":["Operating System","SQL Server"],"inLanguage":"fr-FR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/blog.capdata.fr\/index.php\/groupe-de-disponibilite-alwayson-multisubnet-et-probleme-de-connectivite-sous-windows-2008-r2-7\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/blog.capdata.fr\/index.php\/groupe-de-disponibilite-alwayson-multisubnet-et-probleme-de-connectivite-sous-windows-2008-r2-7\/","url":"https:\/\/blog.capdata.fr\/index.php\/groupe-de-disponibilite-alwayson-multisubnet-et-probleme-de-connectivite-sous-windows-2008-r2-7\/","name":"Groupe de disponibilit\u00e9 AlwaysOn multisubnet et probl\u00e8me de connectivit\u00e9 sous Windows 2008 R2 \/ 7 - Capdata TECH BLOG","isPartOf":{"@id":"https:\/\/blog.capdata.fr\/#website"},"datePublished":"2018-10-11T13:55:32+00:00","dateModified":"2022-11-21T15:57:18+00:00","breadcrumb":{"@id":"https:\/\/blog.capdata.fr\/index.php\/groupe-de-disponibilite-alwayson-multisubnet-et-probleme-de-connectivite-sous-windows-2008-r2-7\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/blog.capdata.fr\/index.php\/groupe-de-disponibilite-alwayson-multisubnet-et-probleme-de-connectivite-sous-windows-2008-r2-7\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/blog.capdata.fr\/index.php\/groupe-de-disponibilite-alwayson-multisubnet-et-probleme-de-connectivite-sous-windows-2008-r2-7\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/blog.capdata.fr\/"},{"@type":"ListItem","position":2,"name":"Groupe de disponibilit\u00e9 AlwaysOn multisubnet et probl\u00e8me de connectivit\u00e9 sous Windows 2008 R2 \/ 7"}]},{"@type":"WebSite","@id":"https:\/\/blog.capdata.fr\/#website","url":"https:\/\/blog.capdata.fr\/","name":"Capdata TECH BLOG","description":"Le blog technique sur les bases de donn\u00e9es de CAP DATA Consulting","publisher":{"@id":"https:\/\/blog.capdata.fr\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/blog.capdata.fr\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"fr-FR"},{"@type":"Organization","@id":"https:\/\/blog.capdata.fr\/#organization","name":"Capdata TECH BLOG","url":"https:\/\/blog.capdata.fr\/","logo":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/blog.capdata.fr\/#\/schema\/logo\/image\/","url":"https:\/\/blog.capdata.fr\/wp-content\/uploads\/2023\/01\/logo_capdata.webp","contentUrl":"https:\/\/blog.capdata.fr\/wp-content\/uploads\/2023\/01\/logo_capdata.webp","width":800,"height":254,"caption":"Capdata TECH BLOG"},"image":{"@id":"https:\/\/blog.capdata.fr\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.linkedin.com\/company\/cap-data-consulting\/mycompany\/"]},{"@type":"Person","@id":"https:\/\/blog.capdata.fr\/#\/schema\/person\/bfd9395c8ba4fa125792a543377035e9","name":"Capdata team","sameAs":["https:\/\/www.capdata.fr"],"url":"https:\/\/blog.capdata.fr\/index.php\/author\/admin\/"}]}},"_links":{"self":[{"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/posts\/6625","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/comments?post=6625"}],"version-history":[{"count":8,"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/posts\/6625\/revisions"}],"predecessor-version":[{"id":9515,"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/posts\/6625\/revisions\/9515"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/media\/6630"}],"wp:attachment":[{"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/media?parent=6625"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/categories?post=6625"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/tags?post=6625"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}