SQL Stored procedure against a linked server 1

[StevenK]

Not sure if anyone will be able to help us with this one ...
We're developing an application using Visual Studio .NET (C#) and are working against a SQL Server database.
One of our stored procedures makes use of a dynamic SQL cursor.
In one instance we are working with data in one of the tables in the current database (where the connection is running) and in another we are accessing data from a linked server - i.e. SELECT -- FROM [SERVER2].Database1.dbo.Table1
When we try and execute the stored procedure through C# code we get errors indicating that 'MSDTC on server SERVER1 is not available'.
The code fails to complete.
What are we missing ? (to allow the distributed query to run).
Any help would be appreciated.
Thanks,
Steve

 

[obislavu]

I think you need to loopback the linked servers.
Loopback servers are useful when testing an application that uses distributed queries on a single server network and it is not allwed in the distributted transaction.
-obislavu-

 

[AtomicChip]

I'm pretty sure that all you need to do is start the MSDTC service.

Launch your SQL Server Service Manager, select "Distributed Transaction Coordinator" and click start. That should resolve your problem.

-----------------------------------------------

http://www.liquidfuzion.com

"The night sky over the planet Krikkit is the least interesting sight in the entire universe."
-Hitch Hiker's Guide To The Galaxy

 

[StevenK]

Thanks.
Starting the 'Distributed Transaction Coordinator' has solved the issues.
Steve