Re: Permission denied

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Responses:

1. I receive the same permission denied error if I manually run the
script manually and not as a scheduled task.

2. We have a two server production environment: a web server and a
database server, both of which are on the same network unseparated by
firewalls or anything like that. I want the script to actually run
from the web server. If I run the script from my local development
machine I don't have any problems. If I run it from the web server I
receive the permission error.

When I attempt to run the script manually, it executes under the
account of the currently logged in user, correct? I'm logged in with
an admin account, so I wouldn't think that permissions would be an
issue in that scenario. I can't figure this thing out.

Thanks again for any advice.

Rich


Richard Mueller wrote:
Hi,

If the script runs fine for you, but not as a scheduled task, the problem is
likely permissions, especially since the error is raised when it attempts to
insert. Unless you are saying the database cannot be updated remotely. Is
the database on the machine you call the local machine? Can you run the
script as yourself on the server successfully? For most DBMS's it doesn't
matter which machine the script is run from as long as you have permission
and connectivity (and are not blocked by something like a firewall).

--
Richard
Microsoft MVP Scripting and ADSI
Hilltop Lab - http://www.rlmueller.net

"Rich" <rsbaier@xxxxxxxxx> wrote in message
news:1150734311.734646.243880@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
I have a VBScript file that I am trying to execute on a scheduled basis
via a Scheduled Task. This script is a little different that others
I've written in that it inserts records into a database table. The
script works fine until it hits the code to execute the insert, at
which point I receive the following error:

800A0046
Permission Denied

This script runs fine if executed on my local machine. I only receive
the error above when I execute it on a server. I have the task running
under a user account which should have more than sufficient
permissions. I guess my questions are:

1. Any ideas what directions I might go to resolve this error?
2. Is there another/better way I should be doing such a task?

Thanks in advance for any assistance.


.

Relevant Pages

  • Re: Grant TS User "Manage Printer" Permission
    ... You can change the permission for all domain users, ... > My Server is Windows 2000, Running in Terminal Server Application Mode ... > I have written a script which uses prnadmin.dll COM for VBscript. ... > User permission settings. ...
    (microsoft.public.windows.server.security)
  • Re: Writing or copying file to another directory
    ... The Open Source movement says the same thing. ... Just to let you know I have fixed the perl script so that it no longer shows errors using strict and warnings. ... I am concerned about security especially now that I have FTP access to the Sierra Club server. ... Does an executable script, accessed by anyone through a link in the web page, have write permission to files with permission set at, for example, 700? ...
    (comp.lang.perl.misc)
  • Re: php on the command line
    ... Essentially the script ... get's a file from a remote ftp server and coies it to the server. ... you first have to isolate where the permission problem is. ...
    (comp.lang.php)
  • Re: output to a file
    ... Or would it be better running a different scheduled task on each server ... For example if the script is called FindPst.vbs: ... ElseIf FileSizeMB>= 1 Then ...
    (microsoft.public.windows.server.scripting)
  • Scheduled VBScript cant launch network program via wShell.Run
    ... I have a Windows 2003 member server in a W2k Domain. ... script that demonstrates the problem. ... up a scheduled task to run a script which uses wShell.Run to launch a ... see wscript.exe launch, but then it just sits there forever. ...
    (microsoft.public.windows.server.scripting)