DTC in multiple instance cluster

WE have a 2 node win 2k3 x64 cluster (also x86 clusters with same problem)
with 2 instanses of SQL 2005 x64 and the MSDTC resource in the admin.
cluster group (quorum group).
This is a active/passive cluster, all 3 groups/vir. servers on same node.
The problem appears when one of the SQL servers fail over to the other node.
Then the MSDTC transactions fail on this sql server.
Result = we have to manually fail over the MSDTC resource/group also.
I have read about a DTC proxy but how do I get this to work ?
Bj?rn
Some say that this shouldn't happen, but we experienced this often as well.
The fix is to place the MS DTC in its own cluster resource group, which will
require another set of dedicated IP Addresses, physical disk, and network
name resources.
http://support.microsoft.com/kb/301600/en-us
Sincerely,
Anthony Thomas

"Bjrn" <Bjrn@.discussions.microsoft.com> wrote in message
news:251D1C52-C076-40A0-BE2B-2B5EF4031146@.microsoft.com...
> WE have a 2 node win 2k3 x64 cluster (also x86 clusters with same problem)
> with 2 instanses of SQL 2005 x64 and the MSDTC resource in the admin.
> cluster group (quorum group).
> This is a active/passive cluster, all 3 groups/vir. servers on same node.
> The problem appears when one of the SQL servers fail over to the other
node.
> Then the MSDTC transactions fail on this sql server.
> Result = we have to manually fail over the MSDTC resource/group also.
> I have read about a DTC proxy but how do I get this to work ?
> Bjrn
>

DTA (Database Tuning Advisor) Malfunction, no error message

Hello, I am having an extremely odd problem with the Database Engine Tuning Advisor, on SQL Server 2005 Enterprise x64. It was working fine, and I was tuning the queries for a bunch of database views we have created. About 2/3 of the way through the list DTA began getting stuck on "Submitting Configuration Information" every time it was run.

I get no error messages, it just sits and spins on Submitting Configuration Information for days and days at a time. When other users view my session, its status says ready as though it had never started, but I am unable to start nor stop it until I close out of it and simply delete it out of the Session Monitor on the left. Other users are able to run sessions without issue, and nothing has changed on the server. I get the same behavior whether I am tuning a query or a workload file. **Edit** A workload file eventually died on the first step with the nebulous "Tuning process exited unexpectedly." There are no entries in dbo.DTA_tuninglog. In dbo.DTA_progress, only TuningStage 0 is present for that SessionID.

I have tried using a different SQL user, rebooting, uninstalling all SQL Server components from my PC then re-installing them, and deleting out all previous DTA session data with no luck. We have also recently installed SP2 for SQL Server 2005 on the server, and I updated my local installation with Microsoft Update. The problem persists. I would appreciate any input you could provide!

Thanks,
Konrad Willmert
Indiana Wesleyan University

I am having the Same Problem, I have no Idea what to do to fix it.

I get this error even after a complete Uninstall (Per the Book) and ReInstallation (Per the Book).

I have tried 3 times.

|||I am having a similar problem. I can get it to start consuming the workload, but it errors out every time. My SQL version is 9.0.3042 so I don't think KB 917131 applies. Was there ever a resolution?|||Shelly,

I have neither found nor received any resolution to this problem--other than asking my co-workers to tune things for me.
|||I gave up as well. I am just using other systems to do the testing.

DTA (Database Tuning Advisor) Malfunction, no error message

Hello, I am having an extremely odd problem with the Database Engine Tuning Advisor, on SQL Server 2005 Enterprise x64. It was working fine, and I was tuning the queries for a bunch of database views we have created. About 2/3 of the way through the list DTA began getting stuck on "Submitting Configuration Information" every time it was run.

I get no error messages, it just sits and spins on Submitting Configuration Information for days and days at a time. When other users view my session, its status says ready as though it had never started, but I am unable to start nor stop it until I close out of it and simply delete it out of the Session Monitor on the left. Other users are able to run sessions without issue, and nothing has changed on the server. I get the same behavior whether I am tuning a query or a workload file. **Edit** A workload file eventually died on the first step with the nebulous "Tuning process exited unexpectedly." There are no entries in dbo.DTA_tuninglog. In dbo.DTA_progress, only TuningStage 0 is present for that SessionID.

I have tried using a different SQL user, rebooting, uninstalling all SQL Server components from my PC then re-installing them, and deleting out all previous DTA session data with no luck. We have also recently installed SP2 for SQL Server 2005 on the server, and I updated my local installation with Microsoft Update. The problem persists. I would appreciate any input you could provide!

Thanks,
Konrad Willmert
Indiana Wesleyan University

I am having the Same Problem, I have no Idea what to do to fix it.

I get this error even after a complete Uninstall (Per the Book) and ReInstallation (Per the Book).

I have tried 3 times.

|||I am having a similar problem. I can get it to start consuming the workload, but it errors out every time. My SQL version is 9.0.3042 so I don't think KB 917131 applies. Was there ever a resolution?|||Shelly,

I have neither found nor received any resolution to this problem--other than asking my co-workers to tune things for me.
|||I gave up as well. I am just using other systems to do the testing.

DTA (Database Tuning Advisor) Malfunction, no error message

Hello, I am having an extremely odd problem with the Database Engine Tuning Advisor, on SQL Server 2005 Enterprise x64. It was working fine, and I was tuning the queries for a bunch of database views we have created. About 2/3 of the way through the list DTA began getting stuck on "Submitting Configuration Information" every time it was run.

I get no error messages, it just sits and spins on Submitting Configuration Information for days and days at a time. When other users view my session, its status says ready as though it had never started, but I am unable to start nor stop it until I close out of it and simply delete it out of the Session Monitor on the left. Other users are able to run sessions without issue, and nothing has changed on the server. I get the same behavior whether I am tuning a query or a workload file. **Edit** A workload file eventually died on the first step with the nebulous "Tuning process exited unexpectedly." There are no entries in dbo.DTA_tuninglog. In dbo.DTA_progress, only TuningStage 0 is present for that SessionID.

I have tried using a different SQL user, rebooting, uninstalling all SQL Server components from my PC then re-installing them, and deleting out all previous DTA session data with no luck. We have also recently installed SP2 for SQL Server 2005 on the server, and I updated my local installation with Microsoft Update. The problem persists. I would appreciate any input you could provide!

Thanks,
Konrad Willmert
Indiana Wesleyan University

I am having the Same Problem, I have no Idea what to do to fix it.

I get this error even after a complete Uninstall (Per the Book) and ReInstallation (Per the Book).

I have tried 3 times.

|||I am having a similar problem. I can get it to start consuming the workload, but it errors out every time. My SQL version is 9.0.3042 so I don't think KB 917131 applies. Was there ever a resolution?|||Shelly,

I have neither found nor received any resolution to this problem--other than asking my co-workers to tune things for me.
|||I gave up as well. I am just using other systems to do the testing.