Permission Denied for CreateObject
From: Larry Charlton (LarryCharlton_at_discussions.microsoft.com)
Date: 07/09/04
- Next message: Darren Green: "Re: Permission Denied for CreateObject"
- Previous message: Darren Green: "Re: How can I get the DTS error when I code ASP page?"
- Next in thread: Darren Green: "Re: Permission Denied for CreateObject"
- Reply: Darren Green: "Re: Permission Denied for CreateObject"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 9 Jul 2004 03:46:02 -0700
I'm a bit lost.
When I execute a DTS package via the SQL Server Agent I get a Permission Denied for CreateObject after the job successfully creates an object.
Set cn = CreateObject("ADODB.Connection") works
... some code...
Set ftp = CreateObject("doFtp.Ftp") fails
When I log in as the the proxy account/job owner the DTS runs fine.
When I put the job and dll on a test server it runs with no problems as a scheduled job.
The Job executes as the service account. (At least thats the message in the job history)
I'm running Sql 2000 SP3
The dll is one I created in VB. Here's what I've done so far:
The service account the SQL Server Agent starts under and the Proxy Account are both System Administrators.
The owner of the job is the Proxy Account.
I've run dcomcnfg and specifically added the Service Account and Proxy Account.
I've validated that the Service Account and Proxy Account have access to HKLM\software\Microsoft\Ole
I've specifically granted permissions for the proxy account and service account to the directory and file containing the dll
I've stopped and restarted SQL Server Agent.
- Next message: Darren Green: "Re: Permission Denied for CreateObject"
- Previous message: Darren Green: "Re: How can I get the DTS error when I code ASP page?"
- Next in thread: Darren Green: "Re: Permission Denied for CreateObject"
- Reply: Darren Green: "Re: Permission Denied for CreateObject"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
