From: "Robert G Lewis" 


"Ellen K."  wrote in message
news:q38gf1poed7oii5l1p7den4om0ifoe28tm{at}4ax.com...
> This happened to me with Novell but might apply in other mixed
> environments:
>
> I have an application I wrote that is run weekly by Windows
> TaskScheduler as me.  It resides on a desktop that lives in the server
> room so as to have a UPS, and talks to two Windows servers (one of which
> has one of my SQL Server databases) and a Novell server.
>
> Being that I was finally given part of someone's time so that they could
> take over the function of reviewing the mission-critical reports this
> app generates (which is necessary because they are created from our
> legacy data which, um, leaves a lot to be desired), I set him up as a
> user on the box (although not an admin), and figured I could be logged
> off and the program would still run because TaskScheduler is running it
> as me.
>
> Last week my error log reported that the app could not find the server
> associated with the given drive letter.   (Referring to the Novell box,
> it had no problem finding the Windows ones.)  I thought, duh, that's
> because with no logged-on user there are no mapped drives, OK fine, I'll
> change the connection string for the legacy database to use the UNC
> name.
>
> This week it ALSO didn't run, reporting the same error message.  Finally
> the new admin manager explained that the only way a non-Novell box can
> talk to a Novell box is by having a logged-in Novell client on the
> non-Novell box.
>
> (I wonder if it would have worked if the desktop had the Microsoft
> Windows client for Novell instead of the Novell one...)
>
> So anyway, next thing I plan to try is to let the other guy log on
> Sunday nights.  I don't want to leave the machine with me logged on
> because as me he could trash all our SQL databases -- not that he would
> do so maliciously but accidents happen.  Any bets as to whether it will
> work with him logged on but the app running as me?   He has the same
> permissions as me to the Novell box.

Why not use a script file to make the appropriate logins and run the job ?

From a security standpoint even create a new ID strictly for that job to use
?

Bob Lewis

--- BBBS/NT v4.01 Flag-5