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 - 2002-09-26 : 08:26:21
|
| mauricio writes "hi!...i hope you can help me. i had designed a DTS to export a view from SQL Server 2000 to a MS Access data base in other machine (web server) than SQL Server, the DTS run fine when i execute it manually, but all the schedulles i had did failed. i had read some info about this trouble and tryed to apply it but failures still happend. Please!, can you asist me in a step by step about the right autentication mode, i mean, i had read that it's meaningful who make the DTS, who make the job and who startup SQL Server Agent for scheduled DTS run fine.in advance, thanks.mauricio" |
|
|
M.E.
Aged Yak Warrior
539 Posts |
Posted - 2002-10-08 : 17:44:25
|
| bleh, 2 weeks late on a question... I wonder if he still needs this answered?oh well... les goUNfortunately I'm not sure whether your in win2k or winNT 4.0. In either case you'll need to get to services manager. From here you can change what account SQL Server Agent is running in. Create an account specifically for the server agent and start it up under this account. Give the sql server agent account appropriate permissions to run the DTS package. Then scheduale it (make a job).If you need any more email me or post up here-----------------------SQL isn't just a hobby, It's an addiction |
 |
|
|
|
|
|
scheduled exporting from SQL Server 2000 to MS Access does not run