 | |
DATA Export
microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
DATA Export -
12-06-2005
, 03:41 AM
#2
| |||
| |||
|
|
Good morning, I have a 2003 AD domain with a SQL2000 dedicated machine (server). I try to export on a windows 2000 server (excel or txt files) from my sql db. As I am runing my DTS myself, everything is ok... If I use the SQL planer, it does not work giving me an error 80004005 with acces denied. I believe it is a security problem but I do not know where as manualy dts works fine... Thanking you in advance. Regards |
#3
| |||
| |||
|
|
Hi, When you run DTS package manually it runs in your security context. As you are probably sysadmin it runs just perfectly. But when you run it in a schedule it runs in a security context of a user you have set it up for running... Check the security settings in scheduling program. -- Danijel Novak MCP+I, MCSA, MCSE, MCDBA, MCT |
#4
| |||
| |||
|
|
Security seems to be ok because if I schedule the same task to extract the file directly on the SQL server, everything is ok but as soon as I am using a destination folder that is not on a 2003 server but on a 2000 server, it does not work anymore ! Regards "Danijel Novak" wrote: Hi, When you run DTS package manually it runs in your security context. As you are probably sysadmin it runs just perfectly. But when you run it in a schedule it runs in a security context of a user you have set it up for running... Check the security settings in scheduling program. -- Danijel Novak MCP+I, MCSA, MCSE, MCDBA, MCT |
#5
| |||
| |||
|
|
Hi, Is Windows 2000 machine in Windows 2003 AD? -- Danijel Novak MCP+I, MCSA, MCSE, MCDBA, MCT "Steve" <Steve (AT) discussions (DOT) microsoft.com> wrote in message news:32102AE1-FA5B-4DC7-812B-BDC9C858DC61 (AT) microsoft (DOT) com... Security seems to be ok because if I schedule the same task to extract the file directly on the SQL server, everything is ok but as soon as I am using a destination folder that is not on a 2003 server but on a 2000 server, it does not work anymore ! Regards "Danijel Novak" wrote: Hi, When you run DTS package manually it runs in your security context. As you are probably sysadmin it runs just perfectly. But when you run it in a schedule it runs in a security context of a user you have set it up for running... Check the security settings in scheduling program. -- Danijel Novak MCP+I, MCSA, MCSE, MCDBA, MCT |
#6
| |||
| |||
|
|
Good morning, Yes it is... It is a 2000 server machine under 2003AD...in the same domain under same PDC regards "Danijel Novak" wrote: Hi, Is Windows 2000 machine in Windows 2003 AD? -- Danijel Novak MCP+I, MCSA, MCSE, MCDBA, MCT "Steve" <Steve (AT) discussions (DOT) microsoft.com> wrote in message news:32102AE1-FA5B-4DC7-812B-BDC9C858DC61 (AT) microsoft (DOT) com... Security seems to be ok because if I schedule the same task to extract the file directly on the SQL server, everything is ok but as soon as I am using a destination folder that is not on a 2003 server but on a 2000 server, it does not work anymore ! Regards "Danijel Novak" wrote: Hi, When you run DTS package manually it runs in your security context. As you are probably sysadmin it runs just perfectly. But when you run it in a schedule it runs in a security context of a user you have set it up for running... Check the security settings in scheduling program. -- Danijel Novak MCP+I, MCSA, MCSE, MCDBA, MCT |
#7
| |||
| |||
|
|
Hi, I had some problems with this setup too, just vice versa. SQL was on Windows 2000 and AD was on Windows 2003. My solution was to upgrade Windows 2000 machine to Windows 2003. -- Danijel Novak MCP+I, MCSA, MCSE, MCDBA, MCT "Steve" <Steve (AT) discussions (DOT) microsoft.com> wrote in message news:93E84576-3FB6-4313-89C2-B8C739CF7827 (AT) microsoft (DOT) com... Good morning, Yes it is... It is a 2000 server machine under 2003AD...in the same domain under same PDC regards "Danijel Novak" wrote: Hi, Is Windows 2000 machine in Windows 2003 AD? -- Danijel Novak MCP+I, MCSA, MCSE, MCDBA, MCT "Steve" <Steve (AT) discussions (DOT) microsoft.com> wrote in message news:32102AE1-FA5B-4DC7-812B-BDC9C858DC61 (AT) microsoft (DOT) com... Security seems to be ok because if I schedule the same task to extract the file directly on the SQL server, everything is ok but as soon as I am using a destination folder that is not on a 2003 server but on a 2000 server, it does not work anymore ! Regards "Danijel Novak" wrote: Hi, When you run DTS package manually it runs in your security context. As you are probably sysadmin it runs just perfectly. But when you run it in a schedule it runs in a security context of a user you have set it up for running... Check the security settings in scheduling program. -- Danijel Novak MCP+I, MCSA, MCSE, MCDBA, MCT |
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.