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.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 MSDTC in SQL2K5

Author  Topic 

ravilobo
Master Smack Fu Yak Hacker

1184 Posts

Posted - 2008-08-15 : 09:59:13
Do I need MSDTC service in SQL2K5. I am getting a MSDTC error, thinking of completely removing it.

------------------------
I think, therefore I am - Rene Descartes

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-08-15 : 10:53:25
quote:
Originally posted by ravilobo

Do I need MSDTC service in SQL2K5. I am getting a MSDTC error, thinking of completely removing it.

------------------------
I think, therefore I am - Rene Descartes




They are needed for Distributed transactions/Heterogeneous transactions. What error are you getting?
Go to Top of Page

ravilobo
Master Smack Fu Yak Hacker

1184 Posts

Posted - 2008-08-15 : 11:16:26
The error (in the event log) is ,

Failed to initialize the needed name objects. Error Specifics: d:\nt\com\complus\dtc\dtc\msdtcprx\src\dtcinit.cpp:457, Pid: 1172

No Callstack,
CmdLine: "C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\sqlservr.exe" -sMSSQLSERVER





------------------------
I think, therefore I am - Rene Descartes
Go to Top of Page

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-08-15 : 11:22:16

Find your associated error over here:

http://technet.microsoft.com/en-us/library/cc726318.aspx
Go to Top of Page
   

- Advertisement -