Re: Permission Denied for CreateObject
From: Darren Green (darren.green_at_reply-to-newsgroup-sqldts.com)
Date: 07/09/04
- Next message: Goober at christianDOTnet: "Re: Question about sql job, SQL 7 versus upgrade to SQL 2000"
- Previous message: Larry Charlton: "Permission Denied for CreateObject"
- In reply to: Larry Charlton: "Permission Denied for CreateObject"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 9 Jul 2004 12:08:23 +0100
298725 - PRB: Scheduled DTS Package Fails With "Permission Denied:
CreateObject"
(http://support.microsoft.com/default.aspx?scid=kb;en-us;298725&Product=sql2
k)
-- Darren Green http://www.sqldts.com "Larry Charlton" <LarryCharlton@discussions.microsoft.com> wrote in message news:E4F052DF-387C-4C4F-87AF-DBD68D0B0BCE@microsoft.com... > 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: Goober at christianDOTnet: "Re: Question about sql job, SQL 7 versus upgrade to SQL 2000"
- Previous message: Larry Charlton: "Permission Denied for CreateObject"
- In reply to: Larry Charlton: "Permission Denied for CreateObject"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
