Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

SQL 2000 Jobs, seem not to work on my Windows Server 2003 SQL Failover Cluster

Posted on 2004-10-03
9
Medium Priority
?
387 Views
Last Modified: 2013-11-15
Hi all

I have a problem with SQL 2000 Jobs
They seem not to work only on my Windows Server 2003 SQL Failover Cluster
The Jobs (replications) exit with error code 8501 which is related to the MSDTC resource.
My MSDTC is set up fine in my event viewer I have no error message about the MSDTC and also when I run on the active Node "Net Start MSDTC" it will state that the MSDTC is already running

On my other none-cluster Windows Server 2003 SQL I fixed the problem by turning off the RPC security (set the Registry value HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSDTC\TurnOffRpcSecurity to 1)

I followed all Microsoft guidelines in how to set the SQL 2000 failover cluster including the MSDTC settings: http://support.microsoft.com/default.aspx?scid=kb;en-us;301600

but it doesn't seems to work, I also tried to add the TurnOffRpcSecurity registry key on both nodes (and restarted the servers) but it didn't help...

I will be happy to here some of your suggestions on my email: experts-exchange1@lesoho.com

Thanks

Gil Davidman

PS

Here is a full error message from the  SQL Job

Executed as user: sarepl. @LAST_ID : 0 [SQLSTATE 01000] (Message 0)  @MYNAME : 3 [SQLSTATE 01000] (Message 0)  @FATHER_NAME : MAWEB_COOP_VIRGINIA.INFOGATE [SQLSTATE 01000] (Message 0)  @iSYS_LEVEL_ID : 3 [SQLSTATE 01000] (Message 0)  @nvINSTANCE_FROM_NAME : MAWEB_COOP_VIRGINIA.INFOGATE [SQLSTATE 01000] (Message 0)  insert into #LOG_MAX execute ('MAWEB_COOP_VIRGINIA.INFOGATE.dbo.dPRG_REPL_TBL_LOG_MAX AP') [SQLSTATE 01000] (Message 0)  MSDTC on server 'ED1VDBCP1\COOP_VIRGINIA' is unavailable. [SQLSTATE 42000] (Error 8501).  The step failed.
0
Comment
Question by:infogate85
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
9 Comments
 
LVL 15

Expert Comment

by:jdlambert1
ID: 12212784
Did you run comclust.exe to configure DTC for clustering?

How did you set up replication?
0
 

Author Comment

by:infogate85
ID: 12212835
comclust.exe is for Windows 2000 Server
there is a different settings for clustering Windows Server 2003:
http://support.microsoft.com/default.aspx?scid=kb;en-us;301600


0
 
LVL 15

Expert Comment

by:jdlambert1
ID: 12212860
How did you set up replication?

Do any jobs that don't depend on DTC work?
0
Survive A High-Traffic Event with Percona

Your application or website rely on your database to deliver information about products and services to your customers. You can’t afford to have your database lose performance, lose availability or become unresponsive – even for just a few minutes.

 

Author Comment

by:infogate85
ID: 12213126
All my jobs works with DTC ,from the cluster machine to other machines all works but from other machines to the cluster
it does not work.
If I use regular SQL2000 edition( not cluster) and put HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSDTC\TurnOffRpcSecurity with value "1"
everything works fine.
Should I enable run some command such as comclust.exe for windows2003EE ?

Thanks

Gil D
0
 

Author Comment

by:infogate85
ID: 12332897
Hi

Solved

Go to Component Services and click properties on "My Computer"

Go to MSDTC

go to Security

Check all check box

Enjoy

NirE

0
 
LVL 15

Expert Comment

by:jdlambert1
ID: 12334229
Hey, infogate85, sorry I lost track of this question, and glad you found a solution. Since you answered it yourself, post a question in the Community Support topic area and ask that the question be PAQ'd with a refund of your points. I think they can do that, rather than deleting your question, and then your solution can remain available to others searching EE.

Cheers, JD
0
 

Accepted Solution

by:
modulo earned 0 total points
ID: 12612828
PAQed with no points refunded (of 500)

modulo
Community Support Moderator
0

Featured Post

Survive A High-Traffic Event with Percona

Your application or website rely on your database to deliver information about products and services to your customers. You can’t afford to have your database lose performance, lose availability or become unresponsive – even for just a few minutes.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Your data is at risk. Probably more today that at any other time in history. There are simply more people with more access to the Web with bad intentions.
This article shows how to use a free utility called 'Parkdale' to easily test the performance and benchmark any Hard Drive(s) installed in your computer. We also look at RAM Disks and their speed comparisons.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

670 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question