Yes, I was a little unsure of which drives to use as the dependencies (should
all shared drives be there, we have several, I just picked one, E drive), and
the registry set up, in step 9, I just put what is in the document, then in
step 14 I put the shared drive where I copied the MsDtsSrvr.ini.xml file (I
used E drive).
Could someone talk me through what should be set in each step? Thanks!
[quoted text, click to view] "Edwin vMierlo" wrote:
> Denise,
>
> this you follow this
http://msdn2.microsoft.com/en-us/library/ms345193.aspx > ?
>
> HTH,
> _Edwin.
>
>
>
>
> "denise" <denise@discussions.microsoft.com> wrote in message
> news:92A9C846-69CA-4B46-87FE-75E567904FD9@microsoft.com...
> > We have SQL Server 2005 cluster setup, active/passive, 2 nodes, on Windows
> > 2003. If I try to add a maintenance task using sql management studio on
> my
> > pc I get error: "apply to target server failed for job". If I try it
> using
> > management studio while on the active node of the cluster I get error:
> > "failed to create the task, exception from hresult: 0xC0010014
> > Microsoft.SqlServer.DTSRuntimeWrap".
> > I installed Integration Services on both nodes and followed instructions
> in
> > document ms345193 to configure IS on the cluster, but I must have
> something
> > wrong.
> > Any ideas what I should look at to get this to work? Thanks!
>
>
[quoted text, click to view] > Yes, I was a little unsure of which drives to use as the dependencies
(should
> all shared drives be there, we have several, I just picked one, E drive),
and
If the E drive is the only drive you use for the packages and file, than
that is OK, however if not sure you can add all drives.
[quoted text, click to view] > the registry set up, in step 9, I just put what is in the document, then
in
In step 9 you fill in the registry location (not the disk);
"SOFTWARE\Microsoft\MSDTS\ServiceConfigFile"
[quoted text, click to view] > step 14 I put the shared drive where I copied the MsDtsSrvr.ini.xml file
(I
> used E drive).
In step 14 you put in the fulname and directory path in the registry,
Example
E:\dir\subdir\MsDtsSrvr.ini.xml
[quoted text, click to view] > Could someone talk me through what should be set in each step? Thanks!
HTH,
_Edwin.
I have all this set up correctly. Any other ideas of what could be wrong?
Would it be affected by the MSDTS configuration set up on the cluster?
Thanks so much for your help.
[quoted text, click to view] "Edwin vMierlo" wrote:
>
> > Yes, I was a little unsure of which drives to use as the dependencies
> (should
> > all shared drives be there, we have several, I just picked one, E drive),
> and
>
> If the E drive is the only drive you use for the packages and file, than
> that is OK, however if not sure you can add all drives.
>
> > the registry set up, in step 9, I just put what is in the document, then
> in
>
> In step 9 you fill in the registry location (not the disk);
> "SOFTWARE\Microsoft\MSDTS\ServiceConfigFile"
>
> > step 14 I put the shared drive where I copied the MsDtsSrvr.ini.xml file
> (I
> > used E drive).
>
> In step 14 you put in the fulname and directory path in the registry,
> Example
> E:\dir\subdir\MsDtsSrvr.ini.xml
>
> > Could someone talk me through what should be set in each step? Thanks!
>
> HTH,
> _Edwin.
>
>
Don't see what you're looking for? Try a search.
