{"id":35,"date":"2018-05-25T06:42:05","date_gmt":"2018-05-25T06:42:05","guid":{"rendered":"http:\/\/dbtut.com\/?p=35"},"modified":"2020-10-13T20:26:58","modified_gmt":"2020-10-13T20:26:58","slug":"how-to-configure-msdtc-for-sql-server","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2018\/05\/25\/how-to-configure-msdtc-for-sql-server\/","title":{"rendered":"How To Configure MSDTC For SQL Server"},"content":{"rendered":"<p>In this article, we will explain what is MSDTC and configure MSDTC(Microsoft Distributed Transaction Coordinator) for an application that will connect to SQL Server with MSDTC.<\/p>\n<h2>What is MSDTC?<\/h2>\n<p>SQL Server DTC is used to manage a single transaction in instances on different servers. If you need to manage a single transaction on different instances on same server, you dont need MSDTC.<\/p>\n<p>For example you started a transaction on machine1 and then you want to execute some statements on machine2 in same transaction.<\/p>\n<p>So if the statements executed on machine2 has failed, whole transaction will be rolled back. SQL DTC provide this functionality.<\/p>\n<h3>What is Msdtc used for?<\/h3>\n<p>We talked about what is MSDTC? But why do I need MSDTC?<\/p>\n<p>You may need MSDTC if you want to use one of belows.<\/p>\n<ul>\n<li>Linked Servers<\/li>\n<li>OPENROWSET<\/li>\n<li>OPENQUERY<\/li>\n<li>OPENDATASOURCE<\/li>\n<li>RPC (Remote Procedure Calls)<\/li>\n<\/ul>\n<h3>Check MSDTC Service is Running<\/h3>\n<p>Many people wonders to check that msdtc is installed and running on the database server.<\/p>\n<p>To check the msdtc is configured on the database server, you should check below steps on your system.<\/p>\n<p>To check msdtc service is running or not running on your server first write service.msc to open services as follows.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-16957 aligncenter\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/05\/Adsiz.jpg\" alt=\"\" width=\"278\" height=\"178\" \/><\/p>\n<p>Then go to the Distributed Transaction Coordinator and look at the service.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-16958 aligncenter\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/05\/Adsiz-1.jpg\" alt=\"\" width=\"544\" height=\"298\" \/><\/p>\n<h3>Start, Stop or Restart MSDTC Service<\/h3>\n<p>To start or stop MSDTC Service, you should check the msdtc service is running at first as I mentioned above. Then right click the DTC service and click stop or start.<\/p>\n<h2>Enable MSDTC<\/h2>\n<p>To enable distributed transaction cordinator in sql server,first we should open component services.<\/p>\n<p>Click Start-&gt;Run and type dcomcnfg to open component services or\u00a0 go to Server Manager-&gt;Tools-&gt;Component Services.<\/p>\n<h3>Configure MSDTC<\/h3>\n<p>Msdtc configuration can be local or cluster based. If the server on which SQL Server is located is not Windows cluster, and SQL Cluster DTC is not available, you should configure Local DTC.<\/p>\n<p>Go to the following tab and right click on &#8220;Local DTC&#8221; anc click Properties.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/dbtut.com\/wp-content\/uploads\/2018\/05\/443.png\" \/><\/p>\n<p>You can see msdtc settings in below screenshot. Configure Local DTC as follows.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/dbtut.com\/wp-content\/uploads\/2018\/05\/411.png\" \/><\/p>\n<p>It will not be very safe to open Allow Remote Administration.<\/p>\n<h3>Configure MSDTC in Cluster<\/h3>\n<p>If the server where SQL Server is located is windows cluster, you should configure Cluster DTC.<\/p>\n<p>To configure MSDTC SQL cluster,Right-click the Cluster DTC that appears as deleted from the following screenshot and click Properties. Then configure Cluster DTC as follows.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/dbtut.com\/wp-content\/uploads\/2018\/05\/186.png\" \/><\/p>\n<p>It will not be very safe to open Allow Remote Administration.<\/p>\n<h3>MSDTC Ports<\/h3>\n<p>MSDTC does not use the default ports of SQL. This section contains information about msdtc firewall settings.<\/p>\n<p>There are special msdtc firewall ports that it uses.<\/p>\n<p>You can find a list of these ports on the link below.<\/p>\n<p><a href=\"https:\/\/msdn.microsoft.com\/en-us\/library\/ee784913(v=cs.20).aspx\">https:\/\/msdn.microsoft.com\/en-us\/library\/ee784913(v=cs.20).aspx<\/a><\/p>\n<p>It may also use ports other than these ports.<\/p>\n<p>Therefore, it is necessary to check whether there is a closed port between the application servers that will use ms DTC and the database servers.<\/p>\n<p>You must grant the necessary access privilege from the firewall.<\/p>\n<p>If you do not do this, the transactions that come with ms dtc will abort as follows.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/dbtut.com\/wp-content\/uploads\/2018\/05\/648.png\" \/><\/p>\n<p>You may want to read other article related with MSDTC<\/p>\n<p><a href=\"https:\/\/dbtut.com\/index.php\/2019\/01\/31\/how-to-move-msdtc-disk-to-another-storage\/\" target=\"_blank\" rel=\"noopener noreferrer\">How To Move Msdtc Disk To Another Storage<\/a>,<\/p>\n<p><a href=\"https:\/\/dbtut.com\/index.php\/2018\/10\/26\/how-to-add-ms-dtc-to-the-cluster\/\" target=\"_blank\" rel=\"noopener noreferrer\">How To Add MS DTC To The Cluster<\/a><\/p>\n\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_35\" class=\"pvc_stats all  \" data-element-id=\"35\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"excerpt":{"rendered":"<p>In this article, we will explain what is MSDTC and configure MSDTC(Microsoft Distributed Transaction Coordinator) for an application that will connect to SQL Server with MSDTC. What is MSDTC? SQL Server DTC is used to manage a single transaction in instances on different servers. If you need to manage a single transaction on different instances &hellip;<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_35\" class=\"pvc_stats all  \" data-element-id=\"35\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"author":1,"featured_media":10608,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[3],"tags":[9966,9967,9984,2690,2691,10198,9964,9965,10199,10197,2693,12,11,10195,10191,10190,2695,2642,10192,2696,2694,9970,2810,9968,9979,9972,9978,9981,9980,2689,2692,10,9,10193,10194,10196,2688,9983,9977,10189,10188,9973,9975,9971,9976,9974,9963,9962,9969,9982],"class_list":["post-35","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-mssql","tag-check-msdtc-is-running","tag-check-msdtc-service-is-running","tag-check-msdtc-status","tag-cluster-dtc","tag-component-services","tag-configure-cluster-dtc","tag-configure-msdtc","tag-configure-msdtc-in-cluster","tag-configure-msdtc-sql-cluster","tag-configure-the-cluster-dtc","tag-distributed-transaction-coordinator","tag-distributed-transaction-cordiator","tag-dtc","tag-enable-distributed-transaction-cordinator","tag-enable-dtc-in-sql-server","tag-enable-dtc-sql-server","tag-enable-ms-dtc","tag-enable-msdtc","tag-enable-msdtc-in-sql-server","tag-enabling-ms-dtc","tag-enabling-msdtc","tag-how-do-i-access-my-msdtc-settings","tag-how-do-i-enable-msdtc","tag-how-do-i-know-if-msdtc-is-enabled","tag-how-do-i-restart-msdtc-service","tag-how-do-i-start-msdtc-service","tag-how-do-i-stop-msdtc-service","tag-install-dtc","tag-is-dtc-enabled-on-the-server","tag-local-dtc","tag-microsoft-distributed-transaction-coordinator","tag-ms-dtc","tag-msdtc","tag-msdtc-configuration","tag-msdtc-firewall-ports","tag-msdtc-firewall-settings","tag-msdtc-ports","tag-msdtc-service-is-not-running","tag-restart-msdtc-service","tag-sql-dtc","tag-sql-server-dtc","tag-start","tag-start-msdtc-service","tag-start-or-stop-msdtc-service","tag-stop-msdtc-service","tag-stop-or-restart-msdtc-service","tag-what-is-msdtc-used-for","tag-what-is-msdtc","tag-what-is-the-msdtc-service","tag-what-port-does-dtc-use"],"aioseo_notices":[],"a3_pvc":{"activated":true,"total_views":9872,"today_views":0},"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How To Configure MSDTC For SQL Server - Database Tutorials<\/title>\n<meta name=\"description\" content=\"In this article you will find information about What is MSDTC, What is MDTC Used For, Enable MSDTC, Configure MSDTC, Start and Stop MSDTC\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/dbtut.com\/index.php\/2018\/05\/25\/how-to-configure-msdtc-for-sql-server\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How To Configure MSDTC For SQL Server - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"In this article you will find information about What is MSDTC, What is MDTC Used For, Enable MSDTC, Configure MSDTC, Start and Stop MSDTC\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2018\/05\/25\/how-to-configure-msdtc-for-sql-server\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2018-05-25T06:42:05+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-10-13T20:26:58+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/05\/1-1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"478\" \/>\n\t<meta property=\"og:image:height\" content=\"228\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"dbtut\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"dbtut\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\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:\/\/dbtut.com\/index.php\/2018\/05\/25\/how-to-configure-msdtc-for-sql-server\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/05\/25\/how-to-configure-msdtc-for-sql-server\/\"},\"author\":{\"name\":\"dbtut\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\"},\"headline\":\"How To Configure MSDTC For SQL Server\",\"datePublished\":\"2018-05-25T06:42:05+00:00\",\"dateModified\":\"2020-10-13T20:26:58+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/05\/25\/how-to-configure-msdtc-for-sql-server\/\"},\"wordCount\":564,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/05\/25\/how-to-configure-msdtc-for-sql-server\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/05\/1-1.png\",\"keywords\":[\"Check MSDTC is Running\",\"Check MSDTC Service is Running\",\"check msdtc status\",\"Cluster DTC\",\"Component Services\",\"configure Cluster DTC\",\"Configure MSDTC\",\"Configure MSDTC in Cluster\",\"Configure MSDTC SQL cluster\",\"configure the Cluster DTC\",\"Distributed Transaction Coordinator\",\"Distributed Transaction Cordiator\",\"DTC\",\"enable distributed transaction cordinator\",\"enable dtc in sql server\",\"enable dtc sql server\",\"enable ms dtc\",\"enable msdtc\",\"enable msdtc in sql server\",\"enabling ms dtc\",\"enabling msdtc\",\"How do I access my Msdtc settings?\",\"How do I enable Msdtc\",\"How do I know if Msdtc is enabled?\",\"How do I restart Msdtc service?\",\"How do I start Msdtc service?\",\"How do I stop Msdtc service?\",\"install dtc\",\"Is DTC enabled on the server?\",\"Local DTC\",\"Microsoft Distributed Transaction Coordinator\",\"ms dtc\",\"MSDTC\",\"msdtc configuration\",\"msdtc firewall ports\",\"msdtc firewall settings\",\"msdtc ports\",\"msdtc service is not running\",\"restart msdtc service\",\"sql dtc\",\"sql server dtc\",\"Start\",\"Start msdtc service\",\"Start or Stop MSDTC Service\",\"stop msdtc service\",\"Stop or Restart MSDTC Service\",\"What is Msdtc used for?\",\"What is MSDTC?\",\"What is the Msdtc service?\",\"What port does DTC use?\"],\"articleSection\":[\"MSSQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2018\/05\/25\/how-to-configure-msdtc-for-sql-server\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/05\/25\/how-to-configure-msdtc-for-sql-server\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2018\/05\/25\/how-to-configure-msdtc-for-sql-server\/\",\"name\":\"How To Configure MSDTC For SQL Server - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/05\/25\/how-to-configure-msdtc-for-sql-server\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/05\/25\/how-to-configure-msdtc-for-sql-server\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/05\/1-1.png\",\"datePublished\":\"2018-05-25T06:42:05+00:00\",\"dateModified\":\"2020-10-13T20:26:58+00:00\",\"description\":\"In this article you will find information about What is MSDTC, What is MDTC Used For, Enable MSDTC, Configure MSDTC, Start and Stop MSDTC\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/05\/25\/how-to-configure-msdtc-for-sql-server\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2018\/05\/25\/how-to-configure-msdtc-for-sql-server\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/05\/25\/how-to-configure-msdtc-for-sql-server\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/05\/1-1.png\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/05\/1-1.png\",\"width\":478,\"height\":228},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/05\/25\/how-to-configure-msdtc-for-sql-server\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How To Configure MSDTC For SQL Server\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/dbtut.com\/#website\",\"url\":\"https:\/\/dbtut.com\/\",\"name\":\"Database Tutorials\",\"description\":\"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux\",\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/dbtut.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/dbtut.com\/#organization\",\"name\":\"dbtut\",\"url\":\"https:\/\/dbtut.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"width\":223,\"height\":36,\"caption\":\"dbtut\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\",\"name\":\"dbtut\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g\",\"caption\":\"dbtut\"},\"description\":\"We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.\",\"sameAs\":[\"http:\/\/NurullahCAKIR\"],\"url\":\"https:\/\/dbtut.com\/index.php\/author\/dbtut\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How To Configure MSDTC For SQL Server - Database Tutorials","description":"In this article you will find information about What is MSDTC, What is MDTC Used For, Enable MSDTC, Configure MSDTC, Start and Stop MSDTC","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:\/\/dbtut.com\/index.php\/2018\/05\/25\/how-to-configure-msdtc-for-sql-server\/","og_locale":"en_US","og_type":"article","og_title":"How To Configure MSDTC For SQL Server - Database Tutorials","og_description":"In this article you will find information about What is MSDTC, What is MDTC Used For, Enable MSDTC, Configure MSDTC, Start and Stop MSDTC","og_url":"https:\/\/dbtut.com\/index.php\/2018\/05\/25\/how-to-configure-msdtc-for-sql-server\/","og_site_name":"Database Tutorials","article_published_time":"2018-05-25T06:42:05+00:00","article_modified_time":"2020-10-13T20:26:58+00:00","og_image":[{"width":478,"height":228,"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/05\/1-1.png","type":"image\/png"}],"author":"dbtut","twitter_card":"summary_large_image","twitter_misc":{"Written by":"dbtut","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2018\/05\/25\/how-to-configure-msdtc-for-sql-server\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/05\/25\/how-to-configure-msdtc-for-sql-server\/"},"author":{"name":"dbtut","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408"},"headline":"How To Configure MSDTC For SQL Server","datePublished":"2018-05-25T06:42:05+00:00","dateModified":"2020-10-13T20:26:58+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/05\/25\/how-to-configure-msdtc-for-sql-server\/"},"wordCount":564,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/05\/25\/how-to-configure-msdtc-for-sql-server\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/05\/1-1.png","keywords":["Check MSDTC is Running","Check MSDTC Service is Running","check msdtc status","Cluster DTC","Component Services","configure Cluster DTC","Configure MSDTC","Configure MSDTC in Cluster","Configure MSDTC SQL cluster","configure the Cluster DTC","Distributed Transaction Coordinator","Distributed Transaction Cordiator","DTC","enable distributed transaction cordinator","enable dtc in sql server","enable dtc sql server","enable ms dtc","enable msdtc","enable msdtc in sql server","enabling ms dtc","enabling msdtc","How do I access my Msdtc settings?","How do I enable Msdtc","How do I know if Msdtc is enabled?","How do I restart Msdtc service?","How do I start Msdtc service?","How do I stop Msdtc service?","install dtc","Is DTC enabled on the server?","Local DTC","Microsoft Distributed Transaction Coordinator","ms dtc","MSDTC","msdtc configuration","msdtc firewall ports","msdtc firewall settings","msdtc ports","msdtc service is not running","restart msdtc service","sql dtc","sql server dtc","Start","Start msdtc service","Start or Stop MSDTC Service","stop msdtc service","Stop or Restart MSDTC Service","What is Msdtc used for?","What is MSDTC?","What is the Msdtc service?","What port does DTC use?"],"articleSection":["MSSQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2018\/05\/25\/how-to-configure-msdtc-for-sql-server\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2018\/05\/25\/how-to-configure-msdtc-for-sql-server\/","url":"https:\/\/dbtut.com\/index.php\/2018\/05\/25\/how-to-configure-msdtc-for-sql-server\/","name":"How To Configure MSDTC For SQL Server - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/05\/25\/how-to-configure-msdtc-for-sql-server\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/05\/25\/how-to-configure-msdtc-for-sql-server\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/05\/1-1.png","datePublished":"2018-05-25T06:42:05+00:00","dateModified":"2020-10-13T20:26:58+00:00","description":"In this article you will find information about What is MSDTC, What is MDTC Used For, Enable MSDTC, Configure MSDTC, Start and Stop MSDTC","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/05\/25\/how-to-configure-msdtc-for-sql-server\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2018\/05\/25\/how-to-configure-msdtc-for-sql-server\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2018\/05\/25\/how-to-configure-msdtc-for-sql-server\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/05\/1-1.png","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/05\/1-1.png","width":478,"height":228},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2018\/05\/25\/how-to-configure-msdtc-for-sql-server\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"How To Configure MSDTC For SQL Server"}]},{"@type":"WebSite","@id":"https:\/\/dbtut.com\/#website","url":"https:\/\/dbtut.com\/","name":"Database Tutorials","description":"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux","publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dbtut.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/dbtut.com\/#organization","name":"dbtut","url":"https:\/\/dbtut.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","width":223,"height":36,"caption":"dbtut"},"image":{"@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408","name":"dbtut","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g","caption":"dbtut"},"description":"We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.","sameAs":["http:\/\/NurullahCAKIR"],"url":"https:\/\/dbtut.com\/index.php\/author\/dbtut\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/35","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/comments?post=35"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/35\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media\/10608"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=35"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=35"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=35"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}