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 |
|
dan_coder
Starting Member
20 Posts |
 Posted - 2006-07-18 : 09:32:45
|
| Hi GuysMy english is not very well, i'm an italian boy.I have a scheduled DTS that launch an executable file wrotten in VB.NET. If i launch this program using "My computer" it's ok, but if I use the DTS i have promblems with rights. Effectly, DTS is not eecuted by Administrator user. It is executed by "System" user. Is it possible set the windows user to use during DTS execution?Thanks |
|
|
timmy
Master Smack Fu Yak Hacker
1242 Posts |
Posted - 2006-07-18 : 18:52:33
|
| Dan, I'm pretty sure that a DTS task run manually via Enterprise Manager is run under whatever account is configured to run the SQLSERVER service under NT/2000/XP. If the DTS is executed via the SQL Server agent (i.e. scheduled), then it is run under whatever account is used for the SQL Server Agent service. What is different about your app that causes it problems when running under a system account? Perhaps if you explain what your VB app is trying to do we might be able to help.Timbtw - how's your diving?? |
 |
|
|
|
|
|
Set DTS execution user