Re: Security context for CmdExec step in SQL Server Agent job
- From: Erland Sommarskog <esquel@xxxxxxxxxxxxx>
- Date: Sat, 17 Nov 2007 16:56:31 +0000 (UTC)
Vlad (Vlad@xxxxxxxxxxxxxxxxxxxxxxxxx) writes:
I have a simple VBScript that makes Crystal Reports 8.5 calls to export
a report into PDF. This script is set up as CmcExec step for SQL Server
Agent job (SQL 2000). Here are the symtoms of the problem:
- When I execute the job it produces 0-length PDF file.
- When I change the export format to HTML it exports fine.
- When I log on to SQL Server under SQL Agent Service account credentials
and run the script myself it exports fine into both PDF and HTML
So there must be some differences in environment/security context
between when the process is executed manuall from command line vs. as
CmdExec step of SQL Job - even if same credentials are used.
Any suggestions/feedback is appreciated. I want to avoid drastic changes
if possible - this is mission-critical production environment and the
problem is not reproducable in other environments.
So there must be some difference in environment/security context between
when a process is executed
When you run this script successfully, does the PDF part has any interaction
with the desktop? That would be a great problem when run from Agent.
You could also try to make the job an Active-X job and run the VBscript
directly from Agent. Not that I think it helps, but it is worth trying.
--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.
- References:
- Prev by Date: Security context for CmdExec step in SQL Server Agent job
- Next by Date: Re: Security context for CmdExec step in SQL Server Agent job
- Previous by thread: Security context for CmdExec step in SQL Server Agent job
- Next by thread: Re: Security context for CmdExec step in SQL Server Agent job
- Index(es):
Relevant Pages
|
|
