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 |
|
emilywinters
Starting Member
2 Posts |
 Posted - 2006-05-22 : 12:43:03
|
| Hi all, I am very new to the world of the SQL Server. I recently took over a position that was empty for a year. I need help with a few things... here we go...Our database is set up with a access front end. There is a DTS that is designed to export the tables from the SQL database to the access version located on another server. It works fine when I manually execute the package, but when I schedule it as a job it fails. I thought it might be the windows authentification process, I figured that when it runs at midnight as scheduled, the SQL agent might not have the proper authentification to access the other server through the network. I tried changing the owner, but that did not work. I also tried to change the location of the connections in the package to UNC instead of mapped drives and that did not work either. I am not sure what to do next..... I probably left out a ton of informaiton so let me know what else might be needed to explain the situation.My other problem is a similar one. I have scheduled two different backups for the database. One backs up to the C:/ of the computer the server is one. It works fine. The second is set up to back up the database to another server. It is set up as a mapped drive connection as well. I am having the same proplem where it fails, but cause it does not have access or permission. Changing owners does nothing. I tried to go with a UNC but the job scheduler will not accept it. I am sure I am missing something obvious but I don't know what.Any help will be GREATLY appreciated, I have been trying to fix this for a month!Thanks! |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-05-22 : 12:50:09
|
| DTS is a client app.When you manually execute the package it will be running on your machine under your user id and with paths relative to your machine.When you schedule it it will be running on the server and (probably) as the sql server service account.Try logging on to the server as the sql server service account and try running it manually.similarly for the backup.The sql server service account needs to know about the mapped drive.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
emilywinters
Starting Member
2 Posts |
Posted - 2006-05-22 : 12:52:39
|
| This is going to sound silly, but how do I login as the sql server service account? |
|
|
|
|
|
|
Scheduled Job Failure