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\SOFTWAR
curity 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: email@example.com
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.INFOGA
TE [SQLSTATE 01000] (Message 0) @iSYS_LEVEL_ID : 3 [SQLSTATE 01000] (Message 0) @nvINSTANCE_FROM_NAME : MAWEB_COOP_VIRGINIA.INFOGA
TE [SQLSTATE 01000] (Message 0) insert into #LOG_MAX execute ('MAWEB_COOP_VIRGINIA.INFO
AP') [SQLSTATE 01000] (Message 0) MSDTC on server 'ED1VDBCP1\COOP_VIRGINIA' is unavailable. [SQLSTATE 42000] (Error 8501). The step failed.