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 |
|
JimEdwards
Starting Member
6 Posts |
 Posted - 2006-06-08 : 15:08:36
|
I have a DTS that we got from another company that imports data from an XML file to a SQL Database.This package was scheduling OK until the Server it was running on died and had to be rebuilt. Now, it can be executed from Enterprise Manager, but if you try to schedule it, it briefly shows up in Task Manager, then immediately dies.  The Windows account that stays logged on to this server is neither a local nor domain administrator, but the Enterprise Manager runs under SQL authentication as the SA (not to worry, the server sits behind a locked door).  I would like to have the DTS scheduled, rather than have to put a weekly reminder on my calendar to run it.  Any ideas?  |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-06-08 : 15:21:40
|
| Even if Emterprise Manager runs under SQL authentication, that doesn't mean that that's what is used in the job. Jobs run using the SQL service account. So you need to log into the database server using the same account as specified in the SQL services. Then run the package in Enterprise Manager from the DTS designer. What does it do there? Does it execute?If you are using the local system account for your services, then that's most likely the cause. The local system account probably doesn't have any access to the resources that the DTS package needs.Tara Kizeraka tduggan |
 |
|
|
JimEdwards
Starting Member
6 Posts |
Posted - 2006-06-14 : 09:06:02
|
quote:
Originally posted by tkizerIf you are using the local system account for your services, then that's most likely the cause. The local system account probably doesn't have any access to the resources that the DTS package needs.Tara Kizeraka tduggan
That was it.I changed it to run with a Domain Admin account, and it started working. Thanks!  -Jim |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-06-14 : 13:10:40
|
| You shouldn't be using a Domain Admin account for this. The account should be a Domain User but a member of the Local Administrations group on the database server.Tara Kizeraka tduggan |
|
|
|
JimEdwards
Starting Member
6 Posts |
Posted - 2006-06-16 : 15:56:02
|
quote:
Originally posted by tkizer
You shouldn't be using a Domain Admin account for this. The account should be a Domain User but a member of the Local Administrations group on the database server.Tara Kizeraka tduggan
Actually, it is a Domain User with Local Admin privileges, not one of the Domain Admin sign-ons (which, fortunately, I don't know). So don't get too worried. |
|
|
|
|
|
|
|
|
DTS will execute, but not schedule