January 30, 2007 at 8:31 am
I have a SQL Server 2005 cluster set up, Windows 2003. I created plans to backup the databases and transaction logs with no problems. But when I try to create a maintenance plan to run the cleanup task I get this error:
"Apply to target server failed for job"
This works on a regular SQL Server 2005 server, is the problem something to do with the cluster set up?
Any ideas where to start looking for the problem?
Thanks, I appreciate any help.
January 30, 2007 at 9:16 am
Actually, I set up the backup plans using the Maintenance Plan Wizard. I can't create any kind of jobs using New Maintenance Plan which is what I need for cleanup task.
This is only on our cluster set up.
Could it have anything to do with MSDTC? This service doesn't start on the cluster. Maybe I don't have it set up correctly. Get error "Could not start Distributed Transaction Coordinator service on local computer. Error: 1067:The process terminated unexpectedly."
Thanks for any ideas!
January 31, 2007 at 6:27 am
Hi Denise
create a cluster resources as DTC. Resources dependicies should be the network name and the drive where the DTC log will be stored.
Do you have an active/passive cluster ? If yes I suggest you to install SSIS on both node and to create a resource for it. In case of failover the jobs will still run.
Regards,
Moreno
January 31, 2007 at 7:07 am
So I should create a cluster resource as DTC, type Distributed Transaction Coordinator, with the dependencies you mentioned?
It is active/passive cluster. I have already installed SSIS on both node servers. So do I also create another cluster resource for it? What resource type should it be and what dependencies if any?
This is the first time I set up a cluster environment so thank you, I really appreciate the help.
January 31, 2007 at 7:14 am
Yes for the DTC. Create the resource as generic service for SSIS. We do so in our company because we encountered problem after a failover. The dependencies are the drive on which datas are stored and the sql network name.
I hope it works in your environment.
Regards,
Moreno
February 1, 2007 at 9:28 am
I've added cluster group resources for DTC and SSIS, but I still am receiving "Apply to target server failed for job" error. Any other ideas? Thanks!
February 1, 2007 at 11:47 pm
Hi
hhmm..check the permissions on folder for the user you are using to execute the plans.
You tarteg the local server ?
February 7, 2007 at 3:41 pm
I think maybe I haven't configured Integration Services on the Cluster correctly. I was trying to follow this document: http://msdn2.microsoft.com/en-us/library/ms345193.aspx.
I didn't understand the registry replication part. What should be in #9. the registry replication page? And then in #14, what do I do here exactly?
I looked in the hkey_local_macjine\software\microsoft\msdts\serviceconfigfile, but there is nothing there.
Thanks again for any help.
February 8, 2007 at 6:13 am
#9 It means the registry application tab of the cluster resources. You should add the registry path
#14 you store the xml config file under a cluster resource. You should change the registry keep to target the path you have choosen
Regards,
Moreno
February 12, 2007 at 10:24 am
We changed the registry to the target path, but I still get the "apply to target server failed for job" message.
Could I still have something set up wrong? I could create jobs before I installed Integration Services.
any other ideas would be greatly appreciated!
February 19, 2007 at 5:37 am
Can you start the msdtc service now ? Is SSIS installed on both nodes and if yes, is the service starting correctly then you move the group ?
If I understand right you cannot create jobs anymore.
Viewing 11 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply