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 |
|
dirwin26
Yak Posting Veteran
81 Posts |
 Posted - 2007-03-23 : 12:59:05
|
| when I run a DTS package manually, it executes fine but when I schedule a package it craps out. Does anyone know how I synch up the security/permission on SQL server agent to be the same as wheatever security/permissions are letting me run the package manually? Thanks. |
|
|
MohammedU
Posting Yak Master
145 Posts |
Posted - 2007-03-23 : 15:19:13
|
| It is related to security issue...Under what account your sql agent is running? and what are you doing in dts package?MohammedU |
 |
|
|
dirwin26
Yak Posting Veteran
81 Posts |
Posted - 2007-03-23 : 16:49:55
|
| I am using the system account with windows authentication. Would setting up a domain account work? I am importing an excel file in SQL, which works fine with manual execution of DTS. |
|
|
|
readysetstop
Posting Yak Master
123 Posts |
Posted - 2007-03-26 : 08:45:43
|
| I would strongly recommend using a domain account, rather than local system. Check here for details on what permissions it needs. (It will also need permissions to your excel file, obviously...)http://msdn2.microsoft.com/en-us/library/ms191543.aspx |
|
|
|
dirwin26
Yak Posting Veteran
81 Posts |
Posted - 2007-03-26 : 09:40:07
|
| Hey, thanks for the article. I am getting the 'no mappings between account names and security id's was done'. Any ideas? |
|
|
|
readysetstop
Posting Yak Master
123 Posts |
Posted - 2007-03-27 : 07:06:24
|
| Where and when are you getting that error? |
|
|
|
|
|
|
sql server agent