MSDTC on server 'VirtualServername\Instance' is unavailable.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a problem when trying to execute this query:

BEGIN TRAN Test
SELECT * FROM [Server].Database.dbo.table
COMMIT TRAN Test

OR

BEGIN DITRIBUTED TRAN Test
SELECT * FROM [Server].Database.dbo.table
COMMIT TRAN Test


Result: Server: Msg 8501, Level 16, State 3, Line 2
MSDTC on server 'VirtualServername\Instance' is unavailable.

In SQL Server Log: Failed to obtain TransactionDispenserInterface: Result
Code = 0x80070005

I am using SQL Server on Cluster enviroment:

MSDTC service is running.

Any help is greatly appreciated !

Thanks....

Rodrigo Fernandes
(e-mail address removed)
 
Better to ask them in sqlserver.server

--
Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect

:
|I have a problem when trying to execute this query:
|
| BEGIN TRAN Test
| SELECT * FROM [Server].Database.dbo.table
| COMMIT TRAN Test
|
| OR
|
| BEGIN DITRIBUTED TRAN Test
| SELECT * FROM [Server].Database.dbo.table
| COMMIT TRAN Test
|
|
| Result: Server: Msg 8501, Level 16, State 3, Line 2
| MSDTC on server 'VirtualServername\Instance' is unavailable.
|
| In SQL Server Log: Failed to obtain TransactionDispenserInterface: Result
| Code = 0x80070005
|
| I am using SQL Server on Cluster enviroment:
|
| MSDTC service is running.
|
| Any help is greatly appreciated !
|
| Thanks....
|
| Rodrigo Fernandes
| (e-mail address removed)
|
|
 
Back
Top