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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-06-08 : 07:59:38
|
| Brian writes "I have read many threads on this issue & tried multiple solutions to no avail.Here's my environment: SQL 2000, Logged directly into server via VPN (so it should be like I am physically at the server).I've set up a DTS Package that executes an Access procedure. The package runs fine when I execute manually. When I execute via schedule, it fails on the error "ActiveX component can't create object: 'Access.Application'. The actual statement is:Set objDB = CreateObject("Access.Application")I know that Scheduled jobs default back to the SQL Agent permissions. I have reset SQL Agent to use my Windows NT account login so it should have the exact same permissions, etc. that I have when I execute manually?Any help will be GREATLY appreciated!!!Thanks mucho,Brian" |
|
|
graz
Chief SQLTeam Crack Dealer
4149 Posts |
Posted - 2004-06-08 : 07:59:38
|
| When you VPN in you aren't physically at the server. You're networked to it. When you manually run the DTS package it's running on your computer which has Access installed. When SQL Server Agent runs it it's running on the server which probably doesn't have access installed. Therefore, it can't instantiate the object. |
 |
|
|
|
|
|
Scheduled DTS Package failure