Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
smithygreg
Starting Member
37 Posts |
 Posted - 2009-11-25 : 14:44:23
|
| Hi there..I am using SQL Server 2008 Standard on Windows Server 2008. I am looking for the option in MSDTC to "Enable TIP Transactions" and I can't seem to find it anywhere. I've located all the other DTC security options in dcomcnfg, but Enable TIP Transactions seems to be missing.Are there any command line arguments available to change that value?Thanks for any help!-Greg |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
|
|
smithygreg
Starting Member
37 Posts |
Posted - 2009-11-30 : 11:23:32
|
| Thanks Fred.Unfortunately it doesn't help. The first website lists instructions that aren't for Server 2008 and the 2nd one doesn't address Enabling TIP.Any other ideas? |
 |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2009-11-30 : 12:24:33
|
| it is removed on purpose. you'll need to manually edit the registry to enable TIP on server 2k8. see here: http://blogs.msdn.com/chrisforster/archive/2008/02/19/msdtc-in-windows-vista-and-windows-server-2008-removal-of-the-tip-checkbox.aspx |
|
|
|
smithygreg
Starting Member
37 Posts |
Posted - 2009-11-30 : 12:57:38
|
| Thanks Russell!Thats exactly what I was looking for. -Greg |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2009-11-30 : 13:34:34
|
You're welcome. Glad to help  |
|
|
|
|
|
|
MSDTC Enable TIP transactions