RE: Remote stored procedure

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Joseph Sack (JosephSack_at_discussions.microsoft.com)
Date: 12/21/04 

Date: Tue, 21 Dec 2004 08:23:03 -0800

Hi Nivek,

Are you running on Windows 2003? If so, the following link may apply to you:

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

"The problem occurs because Microsoft Distributed Transaction Coordinator
(MS DTC) is not configured for network access. By default, the network access
settings of MS DTC are disabled on new installations of SQL Server 2000 on
computers running Windows Server 2003, Enterprise Edition. "

Best Regards,

Joe Sack
Author of "SQL Server 2000 Fast Answers..."
http://www.JoeSack.com

"nivek" wrote:

> I am trying to run a stored procedure on a remote server and insert the
> output into a table on the local machine.
>
> The two servers are linked and I am using the code as follows
>
> BEGIN DISTRIBUTED TRAN
> insert into ServerA.Database.dbo.drv_total
> exec ServerB.master.dbo.xp_fixeddrives
>
> COMMIT TRAN
>
> The MSDTC is started on both machines.
>
> I am getting this error:
>
> Server: Msg 7391, Level 16, State 1, Line 2
> The operation could not be performed because the OLE DB provider 'SQLOLEDB'
> was unable to begin a distributed transaction.
> [OLE/DB provider returned message: New transaction cannot enlist in the
> specified transaction coordinator. ]
>
>
> Any thoughts?
>
>
> TIA,
> nivek
>
>
>

Relevant Pages

  • RE: Distributed Transaction Error
    ... First thought is to make sure that DTC is running on both machines involved. ... DTC is not started automatically for SQL Server. ... > a distributed transaction. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: UPDATE Statement Involving Tables in Different Databases
    ... 'SQLOLEDB' was unable to begin a distributed transaction. ... OLE DB error trace [OLE/DB Provider 'SQLOLEDB' ... If the databases are on the same instance of SQL Server, ...
    (comp.databases.ms-sqlserver)
  • dcomcnfg Probleme
    ... Fehlercode 8004E00F - COM+ konnte keine Daten mit dem Microsoft ... Distributed Transaction Coordinator austauschen. ... Das Ereignisprotokoll enthält möglicherweise weitere Informationen zur ...
    (microsoft.public.de.german.windowsxp.sonstiges)
  • RE: MSDTC error 4404
    ... After checking the event log information you provided, I assume that the Distributed Transaction Coordinator on your ... please reset the msdtc dtclog log and this allowed the DTC service to come up. ... Transaction Coordinator service with all the default settings, like making sure it runs under the NT AUTHORITY ...
    (microsoft.public.windows.server.sbs)
  • Re: MSDTC error 4404
    ... Select the MSDTC tab and click on Tracing Options ... allowed the DTC service to come up. ... > Distributed Transaction Coordinator service in your service console. ...
    (microsoft.public.windows.server.sbs)