|
|
Posted by Dan Guzman on 09/14/06 03:24
In SQL 2000, the SQL Agent Proxy account is used as the OS security context
for non-sysadmin users. This is configurable from Enterprise Manager under
SQL Agent-->Properties-->Job System. When the 'Only users with Sysadmin
privileges..' is unchecked, you can specify the Windows account to be used
as the security context for non-sysadmin users. It's best to specify a
minimally privileged account.
I see you are located in St. Louis, You might consider joining our local
SQL Server User Group (http://www.stlssug.org/index.html) if you haven't
already done so. We also have a BI special interest group.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Jim" <jdyoumans@gmail.com> wrote in message
news:1158185320.259108.169510@p79g2000cwp.googlegroups.com...
>I have command line PKZip (pkzipc.exe) installed on my SQL Server 2000.
> I want to use it to zip up some text files that I receive and process
> on a daily basis to save space. I want to schedule it to run as a job.
> The problem is that when I run the job as a standard user, it just does
> not work. No error messages or anything. If I make the job owned by
> SA, it is fine.
>
> My only thought is that when I am signed in as a SA, my account on the
> box is in the Admin group. When I sign in as a standard user, I am not
> sure what account it uses to hit the file system. I would assume it
> would use the xp_cmdshelluser account I have set up but I am not sure.
>
> Has anyone seen this before? It has me stumped.
>
> Any ideas??
>
> Thanks!
>
> Jim Youmans
> St Louis, Missouri
>
Navigation:
[Reply to this message]
|