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 |
|
memarcie
Yak Posting Veteran
91 Posts |
 Posted - 2006-04-11 : 15:50:18
|
| I'm trying to schedule a DTS job through job scheduler in Enterprise manager and it fails. I've tried using different logons which I know have SA authority and authority to the foxpro database along with sql server authority. I can run the job manually with no problem, but when I try to schedule it, I cannot connect to the foxpro database and the job fails. It makes it to the point of deleting the records in the sql server table but cannot connect to the foxpro table. I have tried everything I can think of and everything that is suggested in books online without success. I've tried setting it up as an OLEDB connection and as an a ODBC connection. Both work manually, but neither work through the scheduler. What am I missing? This is driving me insane! Thanks for you help.Marcie |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-04-11 : 15:51:52
|
| The account that needs access is the account that runs the MSSQLSERVER service. Log into the database server as that user and try to get to the FoxPro database.Tara Kizeraka tduggan |
 |
|
|
memarcie
Yak Posting Veteran
91 Posts |
Posted - 2006-04-11 : 16:05:53
|
| Thanks! That worked!!! |
|
|
|
|
|
|
Connection error when scheduling DTS job