{"id":4111,"date":"2017-08-21T14:33:09","date_gmt":"2017-08-21T14:33:09","guid":{"rendered":"https:\/\/answers.gurussolutions.com\/answers\/comment-configurer-les-chaines-de-connexion-pour-azure-sql-database-ssl-tls\/"},"modified":"2026-07-28T18:26:25","modified_gmt":"2026-07-28T18:26:25","slug":"comment-configurer-les-chaines-de-connexion-pour-azure-sql-database-ssl-tls","status":"publish","type":"qa_entry","link":"https:\/\/answers.gurussolutions.com\/fr\/answers\/comment-configurer-les-chaines-de-connexion-pour-azure-sql-database-ssl-tls\/","title":{"rendered":"Comment configurer les cha\u00eenes de connexion pour Azure SQL Database SSL\/TLS"},"content":{"rendered":"","protected":false},"template":"","meta":{"_kad_blocks_custom_css":"","_kad_blocks_head_custom_js":"","_kad_blocks_body_custom_js":"","_kad_blocks_footer_custom_js":"","_kadence_starter_templates_imported_post":false,"_kad_post_transparent":"","_kad_post_title":"","_kad_post_layout":"","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false,"_kad_post_classname":"","ga_subtitle":"Assurez-vous que les connexions \u00e0 Azure SQL Database sont s\u00e9curis\u00e9es en configurant correctement les param\u00e8tres de chiffrement SSL\/TLS dans votre cha\u00eene de connexion.","ga_short_answer":"Pour \u00e9tablir une connexion s\u00e9curis\u00e9e \u00e0 Azure SQL Database, assurez-vous que votre cha\u00eene de connexion inclut le param\u00e8tre `Encrypt=True`. Ce param\u00e8tre impose le chiffrement SSL\/TLS, qui constitue une exigence de s\u00e9curit\u00e9 obligatoire pour toutes les connexions \u00e0 Azure SQL Database, garantissant ainsi la protection des donn\u00e9es en transit.","ga_scenario":"Les utilisateurs qui tentent de se connecter \u00e0 une base de donn\u00e9es Azure SQL peuvent rencontrer des \u00e9checs de connexion ou des avertissements li\u00e9s aux protocoles de s\u00e9curit\u00e9. Cela se produit souvent lorsque la cha\u00eene de connexion ne sp\u00e9cifie pas explicitement les param\u00e8tres n\u00e9cessaires \u00e0 l\u2019application du chiffrement SSL\/TLS, qui constitue une exigence de s\u00e9curit\u00e9 fondamentale pour la base de donn\u00e9es Azure SQL.","ga_solution":"Pour garantir une connexion r\u00e9ussie et s\u00e9curis\u00e9e \u00e0 Azure SQL Database, la cha\u00eene de connexion doit inclure des param\u00e8tres imposant le chiffrement SSL\/TLS. Azure SQL Database impose l\u2019utilisation de SSL\/TLS pour toutes les connexions. Le param\u00e8tre recommand\u00e9 \u00e0 ajouter \u00e0 la cha\u00eene de connexion est :\n\n```\nEncrypt=True\n```\n\nVous pouvez \u00e9galement inclure `TrustServerCertificate=False` afin de garantir la validation du certificat du serveur, ce qui renforce la s\u00e9curit\u00e9. Cette configuration garantit que toutes les donn\u00e9es transmises entre le client et la base de donn\u00e9es sont chiffr\u00e9es.","ga_source_author":"","ga_source_author_email":"","ga_date_original":"2017-08-21T10:33:09-04:00","ga_date_verified":"2026-07-05","ga_source_subject":"Connecting to a SQL Azure Database","ga_ans_id":"ANS-0452","ga_publish_decision":"publish_with_edits","ga_staleness_risk":"high","ga_review_priority":"verify_soon","ga_tier2_verdict":"partially_outdated","ga_tier2_concerns":"The connection string parameter ';sslrequire' is not the current standard or recommended parameter for enforcing SSL\/TLS connections to Azure SQL Database.","ga_final_category":"Web Services & Integrations","footnotes":""},"ga_category":[102,28,102],"ga_audience":[30],"ga_difficulty":[92],"class_list":["post-4111","qa_entry","type-qa_entry","status-publish","hentry","ga_category-services-web-et-integrations","ga_category-web-services-integrations","ga_audience-it-integration-team","ga_difficulty-niveau-intermediaire"],"taxonomy_info":{"ga_category":[{"value":102,"label":"Services Web et int\u00e9grations"},{"value":28,"label":"Web Services & Integrations"},{"value":102,"label":"Services Web et int\u00e9grations"}],"ga_audience":[{"value":30,"label":"IT\/integration team"}],"ga_difficulty":[{"value":92,"label":"Niveau interm\u00e9diaire"}]},"featured_image_src_large":[],"author_info":[],"comment_info":"","_links":{"self":[{"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/qa_entry\/4111","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/qa_entry"}],"about":[{"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/types\/qa_entry"}],"version-history":[{"count":1,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/qa_entry\/4111\/revisions"}],"predecessor-version":[{"id":6032,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/qa_entry\/4111\/revisions\/6032"}],"wp:attachment":[{"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/media?parent=4111"}],"wp:term":[{"taxonomy":"ga_category","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_category?post=4111"},{"taxonomy":"ga_audience","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_audience?post=4111"},{"taxonomy":"ga_difficulty","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_difficulty?post=4111"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}