Stored procedure from one server to a linked server

[StevenK]

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

 

[JayKusch]

Go to your linked server and then open the SQL Server Service Manager from your system tray or from the Start Menu..Program Files..SQL Server ( or whatever your path is from the Start menu). Inside the Service Manager you have a drop down to stop/start SQL Server, SQL Server Agent, OLAP Services(if installed) AND ... Distibuted Transaction Coordionator. Make sure that is started. Also check this on your source server too.

Thanks

J. Kusch

 

[StevenK]

Thanks.
We're up and running this now.
I think we've been sent to the same area via a different means - through SQL Server Enterprise Manager.
The SQL commands now run as required.
Steve

 

[JayKusch]

That is correct. Both ways can accomplish the needed settings. Glad its up and running for you!

Thanks

J. Kusch