| Author |
 Topic  |
|
|
oitsubob
Yak Posting Veteran
USA
70 Posts |
 Posted - 06/08/2004 : 16:59:26
|
Not sure what's going on here or why. Maybe someone could help explain?
Running SQLServer 2000 & Agent services as a domain account with the same level of access on the SQL server as well as our web server.
In the DTS package, we have an activeX task that performs a few actions in addition to trying to write out a couple files to our webserver.
The DTS package runs just fine as long as I am the one initiating it. As soon as I schedule the job and let the SQL Agent, the job fails and references permission denied errors on createobject().
Here is the text of the error:
Executed as user: MYCOMPANY\SQLACCOUNT. DTSRun: Loading... DTSRun: Executing... DTSRun OnStart: DTSStep_DTSActiveScriptTask_1 DTSRun OnError: DTSStep_DTSActiveScriptTask_1, Error = -2147220482 (800403FE) Error string: Error Code: 0 Error Source= Microsoft VBScript runtime error Error Description: Permission denied: 'createobject' Error on Line 2 Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts80.hlp Help context: 4500 Error Detail Records: Error: -2147220482 (800403FE); Provider Error: 0 (0) Error string: Error Code: 0 Error Source= Microsoft VBScript runtime error Error Description: Permission denied: 'createobject' Error on Line 2 Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts80.hlp Help context: 4500 DTSRun OnFinish: DTSStep_DTSActiveScriptTask_1 DTSRun: Package execution complete. Process Exit Code 1. The step failed.
Here's a snippet of code trying to be executed.
set oFSO = Server.CreateObject("Scripting.FileSystemObject")
set oFile = oFSO.OpenTextFile("e:\stock_close.js",2,true,0)
oFile.writeline("document.write('" & last_value & "')")
oFile.Close
Any help would be appreciated.
Thanks,
Bob |
|
|
tkizer
Almighty SQL Goddess
USA
35007 Posts |
Posted - 06/08/2004 : 17:02:55
|
Have you tried granting the service account local admin? That's the recommendation for the SQL service accounts anyway.
Where is E located? Local to the database server?
Tara |
 |
|
|
oitsubob
Yak Posting Veteran
USA
70 Posts |
Posted - 06/08/2004 : 17:05:57
|
Tara,
The account SQL is running as is a member of the Administrator's group. Sorry, forgot to mention that. :)
E:\ is a local to the server. I'd originally set it up to use the UNC path to a share on the web server, but when that failed, I thought I'd see if it could first write to the local machine before I start chasing down permissions issues on the other box.
Thanks,
Bob |
|
|
|
tkizer
Almighty SQL Goddess
USA
35007 Posts |
|
|
oitsubob
Yak Posting Veteran
USA
70 Posts |
Posted - 06/08/2004 : 17:10:56
|
Thanks, I'll give that a shot! :)
Bob |
|
|
|
oitsubob
Yak Posting Veteran
USA
70 Posts |
Posted - 06/10/2004 : 00:31:12
|
Wanted to let you know that your suggestion worked! Thanks for the help :)
Bob |
|
|
| |
Topic |
|
CreateObject() Permission Denied
