Service account cannot see mapped network drives.

N

NicePeople

Hello:
We have a scheduler that we are going to implement called AUTOSYS. This
scheduler runs on it's own server and installs a client stub on the copmputer
that you want the tasks to be scheduled for a run.
The account used for running is an ADMIN domain account. We have mapped
approx 4 drives that have been mapped to allow applications to run.
When we login into the server interactively we see our mapped drives but
when the scheduler runs under the same account, the programs do NOT see the
mapped drives. The Scheduler runs under the ADMIN account but as a service.
So My question is, is this behaviour known? that an account, if used to
login as a service, does NOT have the same rights??
 
P

pietlinden

Hello:
We have a scheduler that we are going to implement called AUTOSYS. This
scheduler runs on it's own server and installs a client stub on the copmputer
that you want the tasks to be scheduled for a run.
The account used for running is an ADMIN domain account. We have mapped
approx 4 drives that have been mapped to allow applications to run.
When we login into the server interactively we see our mapped drives but
when the scheduler runs under the same account, the programs do NOT see the
mapped drives. The Scheduler runs under the ADMIN account but as a service.
So My question is, is this behaviour known? that an account, if used to
login as a service, does NOT have the same rights??

what if you convert the mapped drive path to an absolute path... \
\servername\directory\subdirectory\file.extension?
 
N

NicePeople

I can convert the mapped drive to an absolute path in a batch file and
everything is fine. But the programs are all written to make use of specific
drives. Example the system uses G for data files and P for apps and programs
etc.
If I have to use absolute paths then I have to change all programs (1000+)
but that does not seem right. Why would a "Service" account not see mapped
drives? I think maybe we are missing something here.
 
L

Larry Linson

This does not appear to be a question about Microsoft Access database
software. Am I missing something? The newsgroup microsoft.public.access is
for discussion of and questions and answers about Microsoft Access. The
online interface that you used can be misleading. I'm reasonably certain
there are other newsgroups, about operating systems, for example, where you
could expect more and better answers.

You were fortunate that Piet happened to have more knowledge about the topic
than you could count on finding in an Access newsgroup.

Larry Linson
Microsoft Office Access MVP
 
A

a a r o n . k e m p f

SQL Server comes with a better scheduler-- than _ANYTHING_ you could
buy with _ANY_ amount of money.. and it's free with MSDE 1.0 or MSDE
2.0


why recreate the wheel?
why pay someone else to recreate the wheel?
 
S

So Sorry For Poor Aaron

a a r o n . k e m p f @ g m a i l . c o said:
SQL Server comes with a better scheduler--
than _ANYTHING_ you could buy with _ANY_
amount of money.. and it's free with MSDE
1.0 or MSDE 2.0

why recreate the wheel?
why pay someone else to recreate the wheel?

Isn't it truly sad that poor aaron has to demonstrate his lack of
comprehension time after time, in public? He can't even recognize when a
question has simply been posted in the wrong newsgroup, and isn't a database
question at all. He is so sad. Perhaps he ought to be institutionalized so
he won't be a danger to himself or others.

Revoking his probation, for his own protection, would let Big Bruce, Big
Bubba, and Big Barney keep a close eye on him... they wouldn't want him to
harm himself because they think he's such enjoyable company. Their pet name
for aaron is "sweetcheeks".

So Sorry For Poor Aaron
 
A

a a r o n . k e m p f

of course, what you don't understand is that 'parole' gets revoked..
not probation

stop following me around stalker
 
P

posted_by_anonymous

a a r o n . k e m p f @ g m a i l . c o said:
of course, what you don't understand is that
'parole' gets revoked not probation

What do they call it when someone violates the terms of their probation and
has to serve their sentence?
stop following me around stalker

It is not stalking when someone responds to disagree with you, even if being
shown to be wrong or biased or obsessed "does not make you comfortable". I'd
bet that your errors, deliberate misrepresentations, and unwarranted advice
to "move to SQL Server" makes them uncomfortable (because they are concerned
that someone will follow your advice, to their own detriment), so
uncomfortable that they feel obligated to refute your misrepresentations and
point out the flaws in your advice. I'd bet, if you stopped cluttering up the
Access newsgroups, you just would not have similar problems anywhere that you
posted truthful, helpful answers.

But, I'd bet that if you keep posting erroneous statments as though they
were fact, keep on deliberately misrepresenting a useful software product
that is the incentive for people participating here, and keep suggesting the
poster move to SQL Server unless the situation requires it, that someonel is
likely to take exception
 
A

a a r o n . k e m p f

a) I'm not breaking anything nor do i intend to
b) it's not misleading information. JET FUCKING SUCKS DICK
c) if you're uncomfortable then stop following me around, STALKER
d) detriment? are you fucking kidding me? SQL Server makes things
BETTER no connection strings, no linked table manager.. and no SQL
Passthrough.
SQL Passthrough is just about the worst piece of Jet, it's
completely unmaintainable
 
A

a a r o n . k e m p f

and I'm not clutting up shit

I'm reccomending- as an experience enterprise level developer / dba--
that the people around here should be disregarded because they are not
partial

it's like going to a suzuki dealership and asking the salesman 'uh
what brand of car should I buy'

Jet is obsolete, it has been for a decade.
Stop trying to justify your STALKING of me by blaming things on me
 
N

NicePeople

Thanks for your response aaron. The other scheduler is the enterprise
standard. Supporting several similar products is less efficient than
standardising on one, even if less than perfect, product. So that is why
AUTOSYS.
 
L

Larry Linson

Mr. Kempf,

I suggest you think before you post. You have, in fact, posted much
egregious misinformation here, and made the same recommendation many times
for situations where it would be inappropriate as a solution, and you have
attracted many who not only disagreed, but provided proof.

Their disagreeing with you is not stalking. Whether your misrepresenting
the facts and making the same recommendation, often in strong, vulgar, and
insulting language, is stalking is a matter for someone else, not me, to
decide.

If it makes you uncomfortable for people to disagree, then you need to be
careful what and how you post -- I think you would be pleasantly surprised
at how few people disagreed with you if you provided helpful posts for the
question that original posters asked, and took into account that this is a
"general questions" newsgroup where many people do not have the option of
changing their software, development tools, or platform. I've worked on
database applications, as a contractor or subcontractor, in many shops that
had corporate standard database software and changing it was simply not a
possibility -- sometimes that was SQL Server (which, BTW, worked very nicely
indeed with Access MDB, Jet, and ODBC) and sometimes were other databases
(which ADPs do not support -- my observation about the work I did with ADPs
was that ADP was not as onerous a burden as some seem to think, but that it
provided little, if any, advantage in the client environment where I was
enhancing the applications). YMMV, of course, and from your extolling the
virtues of ADP, your observations do seem to vary from the observations of
most of us here who have used both MDB and ADP.

Rather few of the posters here, I suspect, are asking questions about the
enterprise-level environment. Also, there are many experienced
enterprise-level environment developers who are effective advocates for the
databases they use, not nearly all of which use Microsoft SQL Server. If
you wish to engage them, microsoft.public.access is not the newsgroup.
Enterprise-level applications aren't normally going to be done in Access,
Jet, or ACCDB but in DotNet, J2EE, Unix and similar environments.

Thus, if your goal is to promote the use of MS SQL Server as an enterprise
development tool, your time might be more efficaciously spent reading and
posting those groups. If, however, your goals are to interfere, irritate,
disrupt, and argue the unarguable, you appear to have chosen a newsgroup
where your views will in fact further your goals.

I think also, you might be pleasantly surprised at the mild tone of
responses to you if you were less strident, vulgar, obscene, and insulting
in your posts.

Larry Linson
Microsoft Office Access MVP


message
and I'm not clutting up shit

I'm reccomending- as an experience enterprise level developer / dba--
that the people around here should be disregarded because they are not
partial

it's like going to a suzuki dealership and asking the salesman 'uh
what brand of car should I buy'

Jet is obsolete, it has been for a decade.
Stop trying to justify your STALKING of me by blaming things on me
 
A

a a r o n . k e m p f

there _IS_ no such thing as a situation where Jet is beneficial

it is a dead database
yes, I'll admit-- MS finally killed FoxPro.. Maybe they did something
right for once.

But Jet has _NO_ benefit over SQL Server.
But Jet has _NO_ benefit over SQL Server.
But Jet has _NO_ benefit over SQL Server.
But Jet has _NO_ benefit over SQL Server.
But Jet has _NO_ benefit over SQL Server.


It is less stable, slower, and harder to develop with.
 
A

a a r o n . k e m p f

Enterprise Sized Companies get there-- because they make the right
LONG TERM decisions.
they don't like havnig to call in a programer every time that they
move a database application

FILE, CONNECTION

is all it takes 'in the real world'
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top