MSDTC on Clustered server

• Jeff Trusty

  SSC Journeyman

  Points: 78

  More actions

  October 20, 2005 at 1:20 pm

  #89795

  I am having a problem on a clustered SQL server. We have installed security patch ms05-51 to all our servers. Since then, in our application, we are receiving an error when we run a query and then immediately execute a remote stored procedure on a linked server.

  The error is: "MSDTC on server '' is unavailable."

  If we connect to our dev server, which is not clustered the application runs fine.

  I can reproduce the error in QA by setting implicit_transactions on and then running the 2 statements. However, if I then re-execute the remote stored procedure, it runs fine. If I turn implicit_transactions off, both statements run fine. Unfortunately, our application needs to run with connections set to implicit_transactions on.

  The commands I execute are:

  SELECT RemoteServer FROM

  (nolock) WHERE module = ‘AddressVerifyServer’

  exec [].[AddressVerify].[dbo].[csp_Verify] '123 Anystreet', 'Anytown', 'UT', '84118'

  The version of SQL Server on the clustered Windows 2003 server is “Microsoft SQL Server 2000 - 8.00.760“. The linked server is running Windows 2000 Server with “Microsoft SQL Server 2000 - 8.00.534”

  Any help would be appreciated

• October 24, 2005 at 8:00 am

  This was removed by the editor as SPAM

• Mark Hickin

  Say Hey Kid

  Points: 693

  More actions

  October 26, 2005 at 6:49 am

  #600104

  I've had this problem on 2003, not necessarily on a cluster.

  Check out this article:

  http://support.microsoft.com/default.aspx?scid=kb;en-us;817064

  If you haven't, also take a look at this:

  http://support.microsoft.com/default.aspx?scid=kb;en-us;301600

  and this:

  http://support.microsoft.com/default.aspx?scid=kb;en-us;889706

  Is the MSDTC service started? and can you issue the following:

  Begin Distributed Transaction

  do some work on remote server

  Commit Distributed Transaction

  Mark