Submit My Question - Recent Questions - Recent Answer
Msdn Tech >> SQL Server >> Getting started with SQL Server

MSDTC

Hi,

I am running SQl 7.0 (SP4) on Windows XP Professional (SP2). Whenever I try an insert/update type of activity, the System returns the following message :

Server: Msg 8501, Level 16, State 3, Line 2
MSDTC on server 'SERVER' is unavailable.

However, all the required services including MSDTC are running on the System.

Please help ASAP.

Thanks & Regards - Rajesh Pathak

[449 byte] By [RajeshPathak] at [2007-12-25]
«« Server Error :Exception of type System.OutOfMemoryException was thrown
»» Custom Query Notifications
# 1

It sounds like DTC is turned off on the other machine. Can you confirm that it is on and try again?

Thanks,
Sam Lester (MSFT)

SamuelLester-MSFT at 2007-8-31 > top of Msdn Tech,SQL Server,Getting started with SQL Server...
# 2
Hello Sam,

Thanks for the prompt reply. As a matter of fact, trying any operation on the Server System which itself runs SQL 7.0 returns the MSDTC not running message. If it works on the Server System then I can try debugging problems on other Client Systems.

Kindly let me have probable resolution to this.

Thanks & Regards - Rajesh Pathak

RajeshPathak at 2007-8-31 > top of Msdn Tech,SQL Server,Getting started with SQL Server...
SQL Server
Getting started with SQL Server

SQL Server Hot Topic

SQL Server New Topic

SQL Server

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech

Site Classified