Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jonjsilver2
Starting Member
14 Posts |
 Posted - 2011-02-17 : 18:58:18
|
| I have Sql Server2008 on Windows Server Enterprise I created a job that executes a command line vbScript. The script reads an Excel spreadsheet and does some manipulation with it.I can execute the vb script from the command line just fine. However, when started from the job, I get a permission error on the createobject statement. I've read through lots of forums and have tried setting the dcom permissions for 'Network service', Everyone..but without any luck. I've tried changing the launch user to interactive, to admin, I've set it to no authentication. I've clicked on the properties of Excel application and changed the properties there.The job is started with Type=Operating System (SmcExec), Run as: SQL Server Agent Service Account cmd=CScript C:\myDir\js.vbsIn the history, I see "The job was invoked by user sa" "Executed as user WORKGROUP\myhostname$ and the permission error, js.vbs line 28 Permission Error CreateObjectAny ideas are gratefully appreciated and welcomed. thanks.jonathan |
|
|
|
|
|
Permission error CreateObject (Excel.Application)