This SqlTransaction has completed it is no longer usable configuration error

0 votes
I've been working on this for about a day and a half, and I've looked through a lot of blogs and online how-to guides. On SO, I came across a number of queries pertaining to this mistake, but I didn't think they were exactly applicable to my circumstances (or, sadly, in some cases, I couldn't grasp them clearly enough to implement:P). I'm not sure if I can explain this clearly enough to be of assistance, but I'll try:

To track our resources, we have a.NET application. A stored procedure that connects to the time and billing databases is accessed by the export function, which copies a resource to the time tracking system and the billing system.

The billing system database was just transferred to a new server by me (original server: Server 2003 SP2, SQL 2005; new server: Server 2008 R2, SQL 2008 R2). I've set up a Linked Server that directs traffic to the 2008 databases. A message concerning MSDTC and RPC appeared after I altered the stored procedure to refer to the 2008 server (http://www.safnet.com/writing/tech/archives/2007/06/server myserver.html). I set MSDTC to allow Network Access and enabled "rpc/rpc out" on the Linked Server (similar to this: http://www.sqlwebpedia.com/content/msdtc-troubleshooting).

When I try to use the export function, I now get the following message: "This SqlTransaction has completed; it is no longer useable." What puzzles me is that when I simply run the stored procedure (via SSMS), it reports a successful completion.

Has anyone ever witnessed this? Has the configuration been configured incorrectly? The only thing I discovered after repeatedly reading the same pages is that I didn't reboot after making the MSDTC adjustments (discussed here: http://social.msdn.microsoft.com/forums/en-US/adodotnetdataproviders/thread/7172223f-acbe-4472-8cdf-feec80fd2e64/).

If posting the entire stored method will be helpful, please let me know.
Aug 19 in Database by Kithuzzz
• 12,440 points
118 views

No answer to this question. Be the first to respond.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.

Related Questions In Database

0 votes
0 answers

'NoneType' object has no attribute 'name'

in the models.py: name = models.CharField(max_length=50, db_index=True) gender = ...READ MORE

Jun 18, 2020 in Database by prince
• 120 points

edited Jun 18, 2020 by Gitika 2,307 views
0 votes
1 answer
0 votes
0 answers

No process is on the other end of the pipe (SQL Server 2012)

I've got this error: A connection was successfully ...READ MORE

Aug 18 in Database by Kithuzzz
• 12,440 points
26 views
0 votes
0 answers

SQL Server database restore error: specified cast is not valid. (SqlManagerUI)

For my production website, SQL Server 2008 ...READ MORE

Aug 20 in Database by Kithuzzz
• 12,440 points
67 views
0 votes
1 answer

What does recursive stored procedure?

Recursive stored procedure refers to a stored ...READ MORE

answered Sep 27, 2018 in Database by Sahiti
• 6,380 points
10,923 views
0 votes
1 answer

What is a stored procedure?

A stored procedure is a set of ...READ MORE

answered Feb 4 in Database by Neha
• 8,920 points
220 views
0 votes
1 answer

Function vs. Stored Procedure in SQL Server

Functions are calculated values that cannot make ...READ MORE

answered Feb 17 in Database by Neha
• 8,920 points

edited Feb 17 by Neha 477 views
0 votes
0 answers

What is a stored procedure?

119 What is a "stored procedure" , how do they work? What ...READ MORE

May 27 in Others by avinash
• 1,840 points
37 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP