First - we are working in a Novell network. Have a SQL 2000 server. We are starting to have W2KServer boxes, but only as necessary - no [MS] domains or PDC. A lot of this is due to the app suite we run (as a manufacturer).
I have a DTS package built that must get to an ACCESS db across the net on another W2KServer box. I can run the package via MMC on my system and on the server(s), but a job to do the package will not run - error says (SIC) the filename string is invalid - SQL can't find the remote dataset. Yet that same package, untouched, will run manually as stated above.
Is this a NOVELL issue? It is as if the SQLAgent can't validate security (since there isn't a PDC or domain to resolve user ids and rights).
Anybody know how to get around this? I need to get this job to run (and, of course don't want to depend on a human to do such a task). After all - we have this great facility to use...
I have a DTS package built that must get to an ACCESS db across the net on another W2KServer box. I can run the package via MMC on my system and on the server(s), but a job to do the package will not run - error says (SIC) the filename string is invalid - SQL can't find the remote dataset. Yet that same package, untouched, will run manually as stated above.
Is this a NOVELL issue? It is as if the SQLAgent can't validate security (since there isn't a PDC or domain to resolve user ids and rights).
Anybody know how to get around this? I need to get this job to run (and, of course don't want to depend on a human to do such a task). After all - we have this great facility to use...