How to enable MSDTC on SQL Server 2014? -
i have installed sql server enterprise version on local windows server, , have need enable msdtc services.
i have contacted microsoft help, taking long time respond.
use windows server 2008 r2
click start, click run, type dcomcnfg , click ok open component services.
in console tree, click expand component services, click expand computers, click expand my computer, click expand distributed transaction coordinator , click local dtc.
right click local dtc , click properties display local dtc properties dialog box.
click security tab.
check mark "network dtc access" checkbox.
finally check mark "allow inbound" , "allow outbound" checkboxes.
click apply, ok.
a message pop restarting service.
click ok , that's all.
Comments
Post a Comment