infogate85
asked on
SQL 2000 Jobs, seem not to work on my Windows Server 2003 SQL Failover Cluster
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\SOFTWAR E\Microsof t\MSDTC\Tu rnOffRpcSe 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: experts-exchange1@lesoho.c om
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.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 GATE.dbo.d PRG_REPL_T BL_LOG_MAX AP') [SQLSTATE 01000] (Message 0) MSDTC on server 'ED1VDBCP1\COOP_VIRGINIA' is unavailable. [SQLSTATE 42000] (Error 8501). The step failed.
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
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.c
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.INFOGA
ASKER
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
there is a different settings for clustering Windows Server 2003:
http://support.microsoft.com/default.aspx?scid=kb;en-us;301600
How did you set up replication?
Do any jobs that don't depend on DTC work?
Do any jobs that don't depend on DTC work?
ASKER
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\SOFTWAR E\Microsof t\MSDTC\Tu rnOffRpcSe curity with value "1"
everything works fine.
Should I enable run some command such as comclust.exe for windows2003EE ?
Thanks
Gil D
it does not work.
If I use regular SQL2000 edition( not cluster) and put HKEY_LOCAL_MACHINE\SOFTWAR
everything works fine.
Should I enable run some command such as comclust.exe for windows2003EE ?
Thanks
Gil D
ASKER
Hi
Solved
Go to Component Services and click properties on "My Computer"
Go to MSDTC
go to Security
Check all check box
Enjoy
NirE
Solved
Go to Component Services and click properties on "My Computer"
Go to MSDTC
go to Security
Check all check box
Enjoy
NirE
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
Cheers, JD
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
How did you set up replication?