September 27, 2010 at 7:23 am
This error just started popping up out of the blue and the few questions I found on Google had no answers. I'm hoping one of the peeps here has an idea.
An error occurred attempting to read properties for the 'MSDTC' resource.
Cannot create a duplicate resource of type Distributed Transaction Coordintor
Error ID: -2146367743 (80110701).
Any ideas on what this means and how I can fix it? There's only one resource on the cluster and it was working fine until this morning.
September 27, 2010 at 8:54 am
try dropping the msdtc resource and disk and recreate it. This should solve your issue.
September 27, 2010 at 8:58 am
I appreciate the advice. I do want to know what happened, though, so we can prevent it from occurring again.
The last time we "lost" a resource on the cluster--the Agent service mysteriously disappeared from one of our instances--we had trouble getting it back on. Still haven't been able to re-add it, in fact. So I'm leery of the drop & recreate approach at the moment.
September 27, 2010 at 9:04 am
AhHA! A coworker figured it out. The System log had a whole bunch of "Side by Side" errors, referring to access denied on several different .dlls and other files. Turns out the Log Monitor and Log User local accounts lost permissions on some SQL Instance folders.
Here's a link with more details:
http://www.eventid.net/display.asp?eventid=59&eventno=4228&source=SideBySide&phase=1
We're good now, and we didn't even have to touch the resource itself to fix the problem.
September 27, 2010 at 4:27 pm
Hi I was wondering if you have a trusted domain I have seen an issue like this where a user made a change with a trusted domain login and when another user logged in with a different domain account this killed the permissions on the folder
September 28, 2010 at 4:09 am
It's not a domain issue. This was entirely local to the server. See my last post.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply